Search results

Hey folks - Is there a way to open a different data base from within another? I would love to have a command button that closes the current database and opens a second. (My project is growing and it would make things much easier if the next several sections would be on their own - esspecially...

Hello, Please help me get my mind around this problem. Although I have read most posts in the forum over the past several months, I can't even understand how to search for this topic. I have two tables: Events and Payments. EVENTS Event_ID Event_Name PAYMENTS Payment_ID Event_ID...

I think that I read somewhere about a macro command that pauses and waits for an action, then resumes the macro. Now that I've gotten to the point where I need this function, I haven't been able to re-locate the post regarding it. Can anyone help? My goal is to open my "Current Event" form...

Hello folks, I am searching for a good method of creating automated backups of my DB. Is there a good method within Access for this or is it best to look for a seperate backup program? I am working with a small non-profit company and they do not wish to have the on-going expense (albeit small...

Hi folks, Thanks to the many of you who have helpped me get this far. I am finally ready to deploy my database! I would not have gotten this far in just a few months if it were not for your helpful advice. :D One of the final stages is to place the database on the organization's server and...

Is it possible to set up a IIF command to change the visible property of a report? I have a query that has mostly null entries and I would like to only print the fields that are not null. I figured the best way to do this would be to use Group Headers on each of the fields and then print those...

I'm just about done with my database and will be putting it on the user's computer shortly. How often, generally, should we compact and repair the DB? Is this something I should set as an event everytime the file is closed? Is there any disadvantage to doing it too often? Thanks, t

Please help prevent my laptop from being smashed against a wall numerous times and then being thrown out the window, after all, the wall is mostly innocent in this situation. I have read post upon post and other dim references to DLookup in the Access Help file, etc. I am generally a bright...

Hello All, I have a problem with a form that includes tabbed pages. When the user is finished tabbing from one page and hits the TAB key again, they are moved to the next record. I would like to NOT advance to that next record until they have had the oppurtunity to use the other tab pages...

I think I saw something on this board for how to make a control active or not based on criteria, but I have not been able to find that thread again. Here is my problem: I have a table with [Arrival_Date], [Arrival_Time],[Departure_Date], and [Departure_Time]. Groups may stay for several days...

REPOST from Design Area Hello all, I hope that the following explination of my problem in clear... I have a table with a series of dates in individual fields: Day1, Day2, etc. What I would like to do now is to combine those into another query/table where the dates are all in one field. ie...

Hello all, I hope that the following explination of my problem in clear... I have a table with a series of dates in individual fields: Day1, Day2, etc. What I would like to do now is to combine those into another query/table where the dates are all in one field. ie: Original Table [Day1]...

:confused: I have a table ClientInformation. One of the pieces of information is EmergencyContact. The EmergencyContact may be someone who is also listed as a Client. Some EmergencyContacts may be the contact for several people. Is there a way to gather infomormation from the current table...

Hello, I am trying to create my first "major" data base to be used as a reservation and service schedule for conference center and am stumpped. I would like to be able to enter a starting and ending date for an event, then have multiple records for each day between. I have a query that will...