Search results

wow...i feel like an idiot lol always helps to have a second pair of eyes. THANKS DJ!

so as soon as i think i was finished with my database, im going through some final testing and i got an error with less than 24 hours to finish. the error is on the highlighted line...HELP!! the set warnings command works on every other form that i use it on but not here for some reason...

lol my appologiez. They are reports that wont open.

i have multiple reports that just wont open. i have tried calling them from a form, calling them from a switchboard, not even clicking on them in the navigation pane works. the only way i can get them to open is going into design view and then switching to report view. MESSED UP!!

got it. i did docmd.requery for some reason it didnt open before

yes the data does get deleted. On search_Click() the data in the search table (which holds the table name and amount of 'hits' for whatever table gets returned) gets cleared and repopulated based on the new criteria. i would just like the form to represent those changes when the data in the...

Hello all, I have a form that is directly connected to a table. The form is used to search and gets populated with two values (table_name, _number_of_records). Basically, when the user searches in this form, i search the entire database for relevant data and return what table and how many...

SUCCESS!!:D it is complete. and once again thank you all for your help. you have saved me alot of headache and time on this.

Alright folks - he is back with his final task. this is a simple one, yet i cannot seem to do it no matter how many google searches i do. Dim empCount As Integer Dim sqlresults As String 'count tables empCount = DCount("*", "Employees_search") 'display tables If empCount > 0 Then MsgBox...

ahaha good one :). for those still following this epic journey (or who even care), i shall relay the rest of the mission with you. (which i should be able to do myself) next, i am going to attempt to disclude (not a word) any of the 'search' tables from this search becuase once the search...

...can someone pass me the dunce cap please? thanks Paul (assuming that is your name. if not, can i call you Paul anyway? lol)

the sql is as follows: sql = "INSERT INTO appendTableName" sql = sql & " SELECT * from tableName" sql = sql & " WHERE wherestr" the debug.print line results in this: INSERT INTO appendTableName SELECT * from tableName WHERE wherestr

Completed - still get the exact same error.

dim sql AS String dim appendTableName AS String appendTableName = tableName & "_search" sql = "INSERT INTO appendTableName SELECT * from tablename WHERE wherestr" DoCmd.RunSQL sql that is what i have and it is giving me an error which basically says it cannot find the input table or query...

i have a problem with this statement everytime i try to implement it anywhere, as soon as i get to the next line to add "select", it gives me the error: Compile error Expected: end of statement am i missing something here? or am i supposed to format it like this: dim s as string s =...

SUCCESS!! I have 2 last questions for you if you wouldnt mind. i searched the code to try and find it but cant seem to determine where/what to put... First off - right now, the code only returns a 'found' statement if the WHOLE of that the person put in is found. ex. user inputs: "test" - the...

yes, the explination from the website states that it only searches text fields and excludes all others. attempting to add 'OR' now. standby

so i just did a little test and added a field into my first table. simple text field and every record is just one random word - no characters other than letters. previously, this table had one field and it searched it no problem. When i run the code, i get the same error. my thoughts are - this...

ok so when running that code the result is: (Aircraft like 'test') (Item like 'test')('Section like 'test') So i checked the second table(where it seems to stop) and i cant find any field with those characters. So i am not sure of the problem.

So, for all of those kind enough to continue on my journey of success, i have another problem for you. I took the code and configured it to fit my needs and came up with the following: Private Sub btnSearch2_Click() clearResults DoCmd.Hourglass True Dim myDb As DAO.Database Dim i As...