Search results for query: *

I have a module of code that runs several make-table queries consecutively. They are querying from a very large database (several million records) that is linked to the Access db, and is located in another state. So I need to insert a pause between each query to allow the table to finish...

I'm working on a report that will show me the number of projects I have by phase. There are some phases that no projects are in, and I need to be able to display a zero count on the report for them. I've tried using Sum(IIf([ProjectStage],1,0)), but I still don't get any zero counts. Help!

I have a form to detect idle time and close a db after a certain amount of time has been reached. It is launched at startup and hidden from the user. In order to close the form the user must enter a password. If the user hits cancel on the password prompt, I want to close the password prompt...

I have a really dumb question, please forgive me if I'm in the wrong forum. I have a table where I store a list of contacts, including their email addresses. I'd like to be able to just click on the address and have a new email open with that address in the TO line. Is this something I can...

Hi there, I'm having issues using the Count function in a report. I have two totals in the report footer, one for the total number of records, and one for the total number of a certain type of record (special requests) and also a percentage of the total number of records based on the two...

Please bear with me, I'm still learning VBA. :) I have a form that allows a user to select how they want to view a report (Open items, closed items, on-hold items etc). In the "Open" category there are several statuses that need to be included on the "Open Items" report. I'm using a select...

I have a calendar button that the user can select to choose a date on several of my forms. I'm using VBA to tell the calendar form which date to default to, as well as whcih field to send the selected date to. It works perfectly in all spots except one, where the button is on a subform. I...

I'm fairly new to VBA, and I'm trying to do an If Then statement that will allow a button on my form to becaome enabled only when the form is in data entry mode, acFormAdd, but it doesn't seem to like what I'm doing. Is this even possible? Here's what I've tried: If...