Hi Steve. I’m not sure about a couple things in your code. First, where you have “stDocName” should be your table name. Is that “QU-CompleteResourses”? I’m not sure about this, but I wouldn’t Dim it. Second, I’m not familiar with the “%”. It may be ok, but I normally use Chr(34)?
Perhaps...
This may not work completely how you want it to, but it may provide a good start.
I set up a text box to type a keyword (txtFind) and a listbox to return records with this keyword (lstQuery). The following is the vb code.
******************Code Starts Here******************
Private Sub...
Thank you for you help so far, Ken. I figured that I could give you a star. I fixed the “ctl” statement and it seemed to work.
Now, the Debug is taking me to the “Set Rs = CurDB.OpenRecordset(SQLStmt, dbOpenDynaset)” line. When I drag the cursor over the “SQLStmt” portion of the statement...
I’m using Access 2000. That seemed to work for the “Rs.Edit” problem. However, I’m seeing another error with the “Set ctl = Me![ID]” line. “ID” is the unique primary key in tblData. How should I define what has been selected in the listbox, which is named “lstPostTrx”? The following is the...
It sounds like you need an event procedure that is triggered after you update the first combo box ("Subjects"). I'm not sure how your tables are setup or what the field names are, but I'm assuming that you have a field for teacher names and a field for subject in the table named...
Thanks Ken. I revised my code to look like the following but I’m still getting the same error. Could the Dim variables be incorrectly defined? When type “Rs.”, the auto drop-down list doesn’t contain “Edit”. Does that matter?
John
Private Sub cmdPost_Click()
Dim CurDB As Database, Rs As...
My MS Access form contains the following items:
· An unbound listbox with the Multi Select property set to “Extended” that queries unposted transactions (PostingStatus = “Open”) from a table named “tblData”
· A command button named “cmdPost”
I would like to select various records from the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.