Search results for query: *

Well I tried that code and its not working This is what i have Private Sub SubmitSearchButton_Enter() On Error GoTo Err_Command11_Click Forms![Search].Recalc strCriteria1 = "[Social Security] Like '*" & [Forms]![Search]![Social Security] & "*' AND [Alt ID]=" & [Forms]![Search]![Alt...

Well i guess what i mean is on my search form in have 2 differnt boxes. One for alt ID and the other for SS. Now depending on when the started with us, we are using there SS or a Alt id. If i search with a SS and that person is not in there then i need i to pull up the new form. If i search...

Ok I more question If i wanted to add one more field to that code where would i put it. I tried a few different option and i get errors or it doesnt do what i want. I would like to add the feild Alt ID to it. So if you input info in either one of these fields, ss or alt id, it will pull the...

Yes that did work. Thanks all of you for you help.

Well I entered the code and when i try and run the search i get the following Syntax error (missing operator) in query expression 'social security = '*111-11-1111*'. This is the code that i used Private Sub SubmitSearchButton_Enter() On Error GoTo Err_Command11_Click Forms![Search].Recalc...

Ok Thanks i didnt know that there was a dedicated fourm for access. I have a query that has the statement Like "*" & [Forms]![Search]![Social Security] & "*" in the criteria field. I have this statement on 5 fields Then i have a search form with unbounded text that has this code attached to...

Hello, Have a question. I have a database that is setup for adress updates. What i was wondering is in my search form if i search for a person, and that person is not in the database yet, have it pull up a new user form instead of the search results form. If this makes since. I know there...

Yes it is check. I was only running it on low to see if that would get ride of the message. but it didnt so i change it back to med.sould this have something to do with VBA itself? if so how could i reinstall the VBA. i check under the add/remove and click on change for office 2003 and i didnt...

See i think that were this is all messed up. I tried running the macro security at low and i was still getting the message. it also happens when you open word not just a doc. So it seems like somthing in the startup or something. But i cant seem to find anything

i have a user that is getting the following error message when they open word 2003 The document contains macros.Macro language support for this application is disabled. Features requiring VBA are not available. Would you like to open this document read - only? I just installed word 2003 as that...

The pc is a dell optiplex gx280 with the a09 bios. XP Pro sp2 with all updates. Just a very basic PC Well I did open the pc their was some dust so I cleaned that out. I ran the Virus scan and It found nothing. The PC is on 24/7 as I am using it as a server for my alarm system. I have my clock...

I have a PC that will not keep the correct time. One day it will be fine and then in a couple of days it will be fast. Windows still says the correct time, it just the bios. I have replaced the CMOS battery and its still doing it. Does anyone have any clue on whats going on? Could this be an...