Code:
'Clear listbox contents.
Me.lstOffices.RowSource = ""
If chkLA Then
strOffices = strOffices & ", 1"
End If
If ChkSF
Selesti
Last Activity: Oct 11 '06, 03:56 PM
Joined: Sep 6 '06
Location:
-
Never mind. I figured it out; I was making it way too complicated with the list box - I took it out and just added the numbers to the string. for anyone who is curious, here is my ending code.
... -
For Each in listbox not working
I've created a form dialog box with several checkboxes to determine which offices to include in a sales report. However, I'm getting an "Object doesn't support this property or method" error from MS Access, which isn't very helpful as it doesn't let me debug or pinpoint what's going wrong. I -think- it's at this line
For Each VarItem in Me.lstOffices
strOffices = strOffices & ",'" & Me.lstOffices.I temData(varItem )... -
You are my shining hero. I had tried extra quotation marks, but didn't realize there needed to be apostrophes. Thank you so much....Leave a comment:
-
My next test was to use
Set rs = db.OpenRecordse t("SELECT * FROM dbo_vwBookingIn fo WHERE BookingNumber=A MPASPUB00001")
Where AMPASPUB00001 was a booking number in the table... STILL same error!
I tried copying the contents of dbo_vwBookingIn fo into a new table, and using that table, and still no go as well.
Rawr, any help would be appreciated. I hope I'm not missing something...Leave a comment:
-
I tried this as well, and it did not work. I have searched through various websites and forums as well as the helpfiles and cannot seem to find the answer. I have double checked and rewritten the code as well... dbo_vwBookingIn fo exists, BookingNumber is the name of a field in that table, and JobNumber is a legitimate control on my form, but still the same run-time "Too few parameters" error....Leave a comment:
-
I have also tried explicitly defining Forms!PreJCEntr y!JobNumber ...instead of Me!JobNumber ... still no good.Leave a comment:
-
Rawr...
Now I'm getting a "Too few parameters. Expected 1." run-time error on this line
:( I tried addingCode:Set rs = db.OpenRecordset("SELECT * FROM dbo_vwBookingInfo WHERE [BookingNumber]=" & Me!JobNumber)
& ";"
at the end, and to no avail. Same error.Leave a comment:
-
Thanks so much!
Last question - if I wanted to add a MsgBox and end the process if that particular job number does not exist in the view (if they typed it in incorrectly, for example) how would I go about doing that?
Again, very much appreciated. :)Leave a comment:
-
Instead of using visual basic, I tried writing a query to search for the information I needed, and then using a macro to have the field on the form = the field on the query.
This is the error I am now getting:
...Leave a comment:
-
Using visual basic to populate fields of a form from another table?
I have written an Access database that our department uses to store and analyze information on particular jobs. Because our company runs on an enormous SQL DB, I thought it would save some time if the basic job details (name, location, salesperson, etc) which is already stored in the SQL DB could be loaded onto one of my forms at the click of a button. The form needs this information (and more that has to be manually entered) to be complete. I...
No activity results to display
Leave a comment: