Search results for query: *

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?

Hi Does anyone know of a way to calculate Percentiles within access? Given a list of numbers, I want to be able to rank them... Thanks

Appstaff .... the erronious data.... is erronious. I don't want it

Thanks Spyder... this at least stops the warnings from poping up. I will try to import everything as Text, and maybe that will stop the _ImportError files from generating. AppStaff - A spec will not hep me because some of the records have - (dashes) or other erronious data in them. Thanks

Here is the code: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "TempImport", "G:\capscreen\Russell2000.xls", False, "Auto Transportation!A5:AE300" TempImport - is the table name G:\capscreen\Russell2000.xls, - is the excel file name "Auto Transportation!A5:AE300" - sheet and...

I am importing data from an Excel Worksheet into Access. Thre are 15 worksheets that I import. When I do the import I generate some import errors because some of the data has "wierd" values. I cannot control the Excel sheet and I don't care that there are errors. Is there a way to suppress the...