We have a rather large database -- 600 forms in total. I am looking to improve the documentation of the database, and one of the steps is determining which forms link to eachother. I am looking for anyway to speed up the process of determining this. We use only VBA -- no macros are in this project. I...

I'm currently working on a reservation system for a campground. What I need to be able to do is be able to determine the number of campers in the campground on any given day. I have a query that will accomplish this based on a date entered into a text field of a form. What I was hoping to do is be...

Hi, I have an Access macro that runs both queries and other macros. I used action "Openquery" for queries and "RunMacro" for macros. I have used "SetWarnings" No for the very first action and "SetWarnings" Yes for the last action. I do not expect to see any of...

I have a couple of terminal servers that I allow users to run applications such as Microsoft Office on. I have just upgraded them to Office 2007. Everything is fine except that the databases are acting like they are not shared. I got out my old laptop that runs Office 2003 and sure enough, they open...

I am currently managing a very small call center at my company and have designed a Microsoft Access 2007 front/back end to handle all the call information. There are 3 call center reps total, each with their own computer and IP phone. The front end is a set of forms that connects to a back end Access...

I'd like to add a Save button to the footer of my main form. My main form has a tab control on it, with four tabs. Each tab has a subform. How I'd like the save button to operate: when the main form opens I have the save button disabled. The save button should become enabled as soon as I make...

Hello, I'm developing a camping reservation database. One of the requirements the user has is the ability to determine the cost of the reservation. The challenge I have with this is they have seasonal passes and daily passes. I have a query that determines the total cost, but doesn't take into...

Here are the relevent fields from my table: SELECT Rating.fy, Rating.board, Rating.app_ssn, Rating.R_TOT FROM Rating WHERE (((Rating.fy)="2010") AND ((Rating.board)="E6")) ORDER BY Rating.app_ssn; This produces three records for each app_ssn (3 different R_TOT integers for each)....

Hello - I have an application that I wrote for a client in Access 2007. The application is used semi-annually for employee performance evaluations. There's nothing all that fancy about the app: basic run-time (accdr) front-end on the users' computers linked to a back-end on a server. The biggest...

All, I am creating a quotation system within Access 2007 and wish to create a report to print the quote in PDF format. I need the report to be about 3 A4 pages long to enable a cover page, details page and a costings page. having started to create the report, I have come across the 22 inch limit. Can...