Search results

Is there any way to put a shortcut on someone's desktop that will open a specific report in an Access database? I'm thinking back to the days of DOS when one simply added an argument to the command. I don't want to put it in startup and have it always go to that report. I just want non-Access...

I have a report built on a query that allows the user to put in a two digit indication of the year, e.g., “95” for 1995. The query then looks at the first two digits of the project numbers in a field in a table and displays only those project numbers and names where the first two digits in the...

Is there any way to have an append query take the records and append them to a table in another Access Database file? I'd like to have only current records in the main database but keep the others in an archive database. :)

I copied did a Microsoft Access file and then did a Compact and Repair on it to see what would happen since I'd never done this before. It went from 20,116 KB to 1,988 KB. Is this right? It looks like everything is still in there but I'm hesitant to rename the copy to the original. Thanks.

Is there any way I can have a default value in a table set to the value in a field in another table? I have a table that has event information including the number of the event, e.g., this year is the 51st one. This event information table only has one line because after the event I'm going to...

I have building a database that records information on participants in an activity our group puts on. To participate in the activity, you have to pay a certain amount of money. When you apply to get into the activity and are approved, you indicate whether or not you’ll make 1 or 2 payments...