Search results

I think this is the solution: http://msdn.microsoft.com/en-us/library/dd671279.aspx You need to create a PUBLIC function(say getVal) in a STanDARD MODULE that will return the value of the variable that will filter your SELECT query. In the QUERY designer, you will put : =getVal() against the...

Dear All I inherited an ACCESS application that has a SELECT query with hard-coded parameters. i.e where (((TABLE.YEAR=2007))) By going to the Query Designer, I have added a criteria [What YEAR] that prompts for year when the query is opened. To do this in VBA, I did the following to pass...

Thank you!!

Hello all I guess I have multiple questions. Rather than receive multiple conflicting answers I have decided to put it in one thread. I have set Access to display a Form when the user opens the database. I want to read all the values in an INI file. To do this, I want to read all values in the...

I think I found out what the problem is: while executing SQL statements using CurrentDB.execute "<your sql stmt>" DO NOT terminate it with a ';'. i.e use "DELETE * FROM TEST" and not "DELETE * FROM TEST;" Cheers...!

Thanks for the response. I tried the DoCMD and it worked. I do not know why my code did not work though. dropping and recreating the table is not an option because: a. the table has many columns b. I am still struggling to get comfortable with DAO and ADO. Thanks again, but I would appreciate...

Hello all As a one time VB programmer, I have been out of touch with VB and need to complete a project using VBa and access. I need to delete a table "MDP". The problem is that after i do an EXECUTE on the currentDB, the rowsaffected property is = 0? But I have 6 rows in the table!! Please help...