Recent content by Egad

This thread looks like it might help me out but I don't see the attachment that Ansentry referred to. What do I look for?

Duh. Why is it we think Access is so complicated that we always overlook the obvious. Thank you. It works!

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

Thanks so much, Sam. I'll try this.

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

Thanks Thanks, Travis. I've only been working with Access for a few years and just off and on so I try to be careful when I try new things. I've noticed that a database I did two years ago now looks cluttered and inept to me. I've got to say that I've learned so much from this forum and...

Thanks. It works! That takes care of a big problem for me.

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.

Thanks, Pat. I'll give this a try.

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