Recent content by psarros

Thanks for the suggestion. It turns out, that this "feature" would happen every time I made a change to the References in VBA

Hi: I have Access 2003, and I don't know what I did, but now the application automatically saves queries and tables . If I make a change it does not ask me if I want to save them. This happens in any database I open. Any Ideas ? Help, this is dangerous. Thanks

Thanks Dcount was all I needed!!!!

Yes, if my query returns no data, I want to Skip the code.

Hello I have some code that I run and I want to skip the code if the query [qryPopulateTempReport] is null. Thanks in Advance!!!

Thanks This works and will save me some headache. It is actually about 9 different fields so now I have one query in place of 9 update queries.

Hello I have a query that I need to run several times but one field, [FACTOR] needs to change every time the query is run. Is there a way to pass a variable into a query that will change the field it references. The first time I run it I want factor to be PE, the next time CF the next...

Hi I am looking at the different Runtime switches for Access 2000, what I am tring to do is run an Access macro from Excel. If possible I would like it to happen completely in the backround Thanks

Thanks that works great, but how would I do it without using SQL? Thanks

I have a query with user defined conditions, that I want to multiply one fields results for each record. I want to do this using code. qrytest fld1 fld2 a 1.02 b 0.97 c 1.21 What is the code that will calculate 1.02 * 0.97 *1.21 TIA

So then give him a Starrrr!!!!!!!!!!!

Use the function =now() That will give you seconds .... you will then need to copy and pastse special - choose values. You can write a macro that will do all this and assign a shortcut key..

I found the solution on Microsoft's website of all places.. http://support.microsoft.com/kb/180162 Use paste special to add or subtract 1462 Thanks

I need to combine two spreadsheets each with several worksheets. One was done with the 1904 System and the other without it... Any Ideas how to get around this? Thanks

Did you try importing tables forms modules etc... from corrupt DB to a new blank one?