Search results

i am copying that into my code and attempting to make the adjustments. thank you both for your help so far.

checking now

well even if i can get it to search through one table will be excelent. My problem is trying to find a way to search based on criteria (user input) and go through the entire table, not just one field like a dlookup function. I have created a for loop (Thanks to pbaldy) that goes through each...

yes it does and that is essentially what i want to do - just for everything. Is there a way to view the code for that or call it when i need it? unless someone has a better idea to search an entire database?

The search box in the navigation in any form does exactly what i want to do, however i want to do it through every table. is there any way to call that function and that way i can manipulate it to work the way i want it to?

I want to create a way to search through the entire database for records that have all or part of the keyword that the user enters in ANY field of ANY table. i have a DCount() function in there as well to show the user how many records are in each table. from there they would click a button...

im not sure um using the DCount() formula correctly. here is my code Private Sub btnSearch_Click() Dim db As DAO.Database Dim tdf As DAO.TableDef Dim varRecordCount(1, 44) As Variant Dim i As Integer Set db = CurrentDb() For Each tdf In...

I had a new thought to anyone who would like to join in here :) is there a way (in vba code) to search through an entire table? similar to the navigation bar's search method in a form? i am doing something that i believe there is an easier way to do but i have no idea how to do it yet. can...

alright, no idea what to do. hour and a half later and im still confused my new error is: Runtime error 3075: Syntax error (missing operator) in query expression '20 WHERE ([Item]='200')' s = "INSERT INTO [China Ops] ([Amendment Number]) SELECT " & Me.txtAmdNum & " WHERE ([Item]='" &...

ahhhhhhh ic my error. i have to declare it as a variable and then execute it. i got another error when i do this but i am going to attempt and troubleshoot it first cause i feel like im being a pest :)

ohhhh so i have to make this in a function and then execute it from there?

correct - amdnum is a variable okay i made the adjustments (aka copy and paste) and im getting another compile error Expected: line number or label or statement or end of statement doesnt make sense to me :s

thanks for the reply, just have one more giving me a similar error INSERT INTO [China Ops] [Amendment Number] VALUES (andnum) WHERE "Item='" & glb_CHIITEM & "'" compile error: expected: end of statement

Good Morning/Afternoon/Night (wherever you are) I am getting this error when i attempt to run this code and i am not sure what is happening????? i dont see any errors with this. Dim txtAcc As String txtAcc = SELECT Employees.Access_Level FROM Employees WHERE Employee_ID = XXXXXXXX)help please:)

oki doki. ill give it a try

so in your example, will this return the number of results along with the table name? or would i have to connect the two together myself?

not exactly. i searched the forms and came up short. off to google!

GENIOUS! Thanks :)

Thanks pbaldy. can you post a small sample for me please?

Good day Developers! - again lol Question: is there anyway to create a form that will search EVERY table in my database and return the amount of records in whichever table it was in? if that is possible i want to create that and then have a way to direct the user to one of those selections.