Recent content by Senerie

Jon K, Thanks! That works perfectly!

I have a table with a list of contacts. For each contact there are six yes/no options (e.g., member, donor, resident, etc.). I have a check box for each of these options. I want to be able to select certain criteria, and bring back all the members who satisfy those criteria. For example...

Two related questions: 1. I used the wizard to create a command button on an Access form that runs Excel. However, if Excel is already open, the command button opens another copy of Excel. Also, when I launch Excel from the command button, it doesn't load the files that are in my XLStart...

I tried your suggestion, and whatever the problem was got imported along with everything else. So instead I deleted the form and recreated it from scratch. Oh well... at least it was easier the second time around. Thanks anyway.

I have a form with various subforms, command buttons, and combo boxes. The VBA code for this form has suddenly disappeared. When I look at the properties of one of the command buttons, it still says [Event Procedure] after On Click, but when I click "..." to view the code, nothing happens. I...

I have two tables, Clients and Projects. I have a form based on Clients, with a sub form based on Projects. When I go to a record in the clients form, the projects subform shows the projects for that client. So far so good. But, I have some clients that don't have any projects associated...

Thanks! That's just what I was looking for!

I have several fields in a table that contain mostly sequential numbers. Auto number doesn't work for these fields, as the table contains imported data, and the numbers don't start at one, and there are a few gaps and repeats. Also, I need some flexibility in assigning the numbers. When I'm...