Search results for query: *

We currently run monthly reports generated by a query we have in our system. The bosses want us to find a way to automatically email specific people in direct correlation to the results in our query. I have enabled the users to open our Lotus Notes application, but I wasn't sure if there was a...

I have a piece of code that I use to get the turnaround time from when a problem is received to when it is completed. The code works fine in a form, but I can't translate it into just a query. Does anyone have any suggestions?

We have multiple systems using tables from a SQL Server. Every morning we update the the standalones that are used throughout these systems so the information in the tables is current. We had a situation where one user had to update the tables later in the day, as one of the other users was...

I am currently trying to import an excel spreadsheet into my database. The problem is that I need primary key that is made up on an autonumber along with the imported information. Any ideas on how I can get this done? The import function keeps telling me I have to keep the table the same as...

I need to run a process where I am updating Access tables in 3 different databases to information from a live SQL server. We need them in 3 different databases because of the amount of information stored in each table. Is it possible to update all the tables from a couple of buttons on a type...

Our company bought a software solution specific to a portion of our industry. We are having some problems with the software the way it is, but the company we bought the solution from cannot deal with our specific needs. It is not a totally custom application. The front end and back end are...

We have a system that runs a process our company does. During this process, an excel file is transferred to an flat file. We never had a problem until today. Now when the code runs and it gets to the Docmd. transferspreadsheet portion, it is giving me this error: 'Runtime error 3027: Can't...

I have a piece of code for a checkbox on a form that disables certain fields when checked. The problem I am having is that when I click on the check box and disable these fields, when I go to the next record the boxes are already disabled. I can't figure out how to set the boxes to enabled...

I have a form with 5 subforms on the main form. My problem is that the users seem to want to go to the subform 1st before any information that will allow the autonumber feature to populate my primary key. Is there any way to populate the key when you go to the new record? When they are going...

Our company has various accounts for our customers. We have to run a process where we must pull all of these accounts into a single table and perform the calculations we need. For example one table has a customer account 1, customer account 2, and customer account 3. We must pull all of these...