Recent content by AC-Dev

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 =...