Code:
Public Function WhichLocationsAreChecked(Location_str As String, Target As
WindowsAndDoors
Last Activity: Jan 5 '07, 05:49 PM
Joined: Oct 26 '06
Location: Wisconsin
-
Sometimes it just takes posting a question and then a good walk. As I was looking over some documentation for a good rodeo clown college I said just take it back to basics...a function should only return 1 thing so I changed the code and ran the function from each checkbox control on the "on open" event and it works like a charm. Here is the code:
... -
Access Report displaying pieces from a String
I have been racking my brain for a week now and if you don't mind I would like to throw it to the group to see what the folks think.
I have a database that holds100 records, there are multiple fields in each record but there is one in particular that is defined as a string and contains numbers that are deliminated by commas,(ie:"1,2 ,3,6,8,9"). Now the version of Access allows me to do a split with no problem and I have successfully... -
Thanks PEB works like a charmLeave a comment:
-
VBA Report Recordsource problem
Hey,
I'm trying to assign to a report recordsource a variable name but I keep getting a message that the database isn't recognizing the control name.
The name of the report is BusinessUnitPro ductMeeting and this is how I'm referencing it in my VBA code in a Report_open procedure:
Reports!Busines sUnitProductMee ting!Controls!R ecordsource = rpt_recordsourc e
What is wrong with the way I have...
No activity results to display
Leave a comment: