Search results for query: *

Does anyone know what "Row Level Tracking" is under table properties? When would you want to turn this feature on?

I have a database that works on a fiscal year basis. At the end of each fiscal year I close out the database and transfer any carryover data to a new database for the next fiscal year. One table I have in the database tracks data within the FY on a daily basis. It has 365 records starting...

I have a database that needs to be closed out on a fiscal year basis (FY2004.mdb). What I want to do is create a function that will copy my database (structure only) to a new file called FY2005.mdb Once that is complete I can fill the new database with the information that is carried over...

Is it possible to put a button on a form that would force my access 2000 database to complete a compress and repair? I know I can set access to perform this option when the database closes, but I dont want it to run everytime, and I really dont want to have to explain to people at work how to...

I have an access database that is located on a network drive that is accessed by 2-3 users at a time. When compressed the database is only 9mb but can grow to 40-50mb in a session. When I run the database on the local hard drive it runs fairly fast, but doggs down on the network w/multiple...

I have a personnel database that produces an end of month report with different lists such as Evaluations Due, and Sick Days Taken. It is based of specific queries that I have written. All the lists are subreports linked to the main report. The problem I have is when the queries return no...

I want to create a button to backup tables in my database to floppy. I have three tables [Personnel], [Flight Data], [Training Data]. I am capable of using macros or inserting VBA code. I also need to check to make sure that the floppy has enough room before I copy the file.

I have a table that has a drop down list that is linked to another table. I have three fields in that first table that need to be pulled from the second table based on the value of the drop down list, and I am having trouble making it work.

I have a database that is used for testing purposes. What I want to do is create a select query that would pick 100 questions at random from a table of about 400 records. However, I have been unable to find any function withing Access for selecting random records. Any Ideas?

I have a macro that outputs reports to a floppy disk, however I want to check to see if the disk is empty before I do this, and if it is not, erase the contents of the disk. I tried using RunApp, but have had limited success. I think the solution is probably found in a vba function, but that...

I have a query that totals data on a daily basis, but on days when do data is calculated, the query shows no results which leaves blanks in my related report. Is there anyway to make the query show "0" or "No Events For Today" is it returns no results?

I have a main report that is a running summary of operations at my work. In that main report there are three subreports that us the value [Report Date] as the query criteria. So if I want to create a report for "2/3/2002" I can get the Main Report to work fine, however, access asks...