Search results

I may need a cascading combo box after all hi wayne, I may need to use a cascading combo box. I read my two Access manuals and examined this web site but didn't find anything I could understand. I even downloaded an example you provided another user. No luck. But, I could probably meet my...

sorry for the silence again Please ignore this inquiry (except for the expression of thanks). I found out how to control what displays when a database opens. Hi Wayne, The voter.mdb application you created works perfectly. Thanks very much. When I open the database, the voter file...

sorry for the silence i just got caught up on sleep after the election. tomorrow i'll check out the last solution you sent. thanks very much for your help. larry

thanks for letting me know Hi Wayne, I opened the file on another computer but I don't know which issue you intended it to adddress. Does it show an example of how to return to the txtSearch field immediately after scannind in a voter_id value? Take care, Larry

problem with zip file Hello Wayne, The computer I'm using won't let me unzip this file. I get an error message that it's corrupt. Could you send it again. I know about the problem with the msiing records. Deleting the precincts table is fine. Does the file yo sent address my need to return...

display problem Hello Wayne, Please address the following before moving on to the display problem. As soon as I scan in a voter id number, I want to immediately return to that field and scan in another voter-id number (or use the mouse or keyboard to navigate to another field to edit it). I...

thanks for responding Hello Wayne, Those of us who rely on your help appreciate your long weekend's effort. If the search works OK, is it possible that you have the form's DataEntry property set to "YES'? In that case, anything that you do would result in a new record. I had the DataEntry...

real progress! hi wayne, I got everyting working! Thanks so much for your help. One glitch however. When the form opens, it somehow populates the voter_id field with a bogus but unique value not stored in the table. After entering a valid voter-id number in the txtSearch field, editing...

that triggered another error hi wayne, Sorry this has turn into a nightmare. I'm really trying to follow your directions carefully. When I enter the code for the OnCurrent event I cannot open or close the form with getting run-time error 3314 "The field CD36PhaseTwoVoterFile.voter_id cannot...

i attached the database Hello Wayne, I added the brackets to Me.[Pres Pref] = 1 Me.[Assmbly Pref] = 1 That resulted in a run time error 2465 "Microsoft Access can't fine the field "|" referred to in your expression." I noticed that spaces in field names can make VBA unhappy so I removed the...

no luck hi wayne, thanks for getting back to me. i tried your solution... Me.Pres Pref=1 Me.Assmbly Pref=1 and got a compile error message - "Method or data member not found" where did i go wrong this time? no, we do not try to sway voters. we simply identify supporters and try to turn...

hi wayne, thanks for the help with the search issue. we always know the voter id number so a progressive query isn't needed. we just scan in the value from a form. but, could i please ask another question? as soon as we scan in the voter id number i would like the value of the Pres Pref and...

may now need a cascading combo box hi wayne, I may need to use a cascading combo box. I read my two Access manuals and examined this web site but didn't find anything I could understand. I even downloaded an example you provided another user. No luck. But, I could probably meet my need with a...

txtSearch hello again, i removed the text box. the form is quite incomplete. no reason to finish it if i cannot select records the way i need to. thanks, larry

attached Hello Wayne, Thanks for getting back to me. What happens if you remove the criteria from the query? Do you get all records? Yes. Do you have any masks on your table? No. Can you post a database here with only a couple of records? If so, make sure to Tools --> Compact/Repair...

thanks but... thanks jon. i appreciate your time and trouble but i do not understand VBA code. i don't need complex layers of filtering. i want to scan in a unique primary key value to select a record. seems pretty simple. i did it once before but i do not remember how. if you think of...

i'm trying but... hi wayne, added an unbound text box named txtSearch with default value equal to a valid id number. changed criteria of the id number of the query to Forms![VoterFileMaintenanceFormCOPY]![txtSearch] now the query returns no records. added to the after update event of the...

Could I trouble you again? Hi Wayne, Thanks for your suggestions. Looking in the Databases section for “search database” returned only four examples. None proved useful. So I scoured the Forms section and found many examples but no solution. Selecting records from a drop down list won’t...

My form gets its data from a query with two tables. One table, a voter file, includes a unique voter id number – the primary key. I want users to find records by entering or scanning the voter id number into a control without using a command button or dialogue box. I know Access supports this...