Search results for query: *

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

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

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

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

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

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

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

I have an Excel sheet with about 20 queries which point to the same file. I need to change the location of the file that the query looks at. Is there an easy way to change it? Thanks

Hello I have a list of Tickers and thier price on given dates, and I need to find the min and max and when the min and max occured. Is there a way to do a vlookup or Hlookup and find a number and return the column it is in? my data is in the following form Ticker date1 date2 date3 IBM...

Does anyone know of a function that will produce quintiles? The same way that the excel quartile function will work?

I have a user that is importing text files with extetions like FPA TDA XPL, and they keep getting an error. If I change the extension to TXT it works.... HELP!

For the past few weeks I have several users who keep getting the Security Settings changed every time they reboot. For some reson Downloads keeps changing to DISABLE. I have no idea why. Is there a registry hack we can do that will keep the Security Setings for Downloads ENABLEd? thanks

What is the code used to run a batch file from within excel? I have a buttin in a sheet and I want to run a BAT file when it is pressed. TIA

I have a form that has a button on it that performs a function. I need to know when that function was performed, so I have created another table. What is the code to add the date and time into that table

Is there a way to conditionaly format an entire recird on a report? Not just one field? Thanks

I have a database that has data from month ends. Some of the calculations I need to do involve multiple months. Is there a function that I can use that will calculate month ends? The DateAdd function works great for the begining of the month, not month ends..... thanks

What is the code to: Open a table, and then perform calculations on fields within the table? Thanks

I have a text file that I import into access using Import/Export Specifications. The Database was originally created in Access 97 and has been upgraded. When I try to add a field to the Specs, and press save, they get deleted. I can change the field names, but I cannot add a field. Any...

Over the last moth or so, I have been receiving SPAM, I trace the spam all back to raisin.propagation.net (63.249.167.1) How can I stop e-mail getting to my account if I find this address in the header? It seems these guys have some sort of mailing list that my address has become a part of...