Recent content by stazza18

Gotcha, I moved it move next outside of the loop but now I have a bunch of other problems. Thanks for all the help, I appreciate it.

Have a new problem, maybe someone can help. The query we pull for the emails has the email address and the number needed to be sent. Because we have multiple numbers per address I am just trying to get the test function to do the following. Take the email and loop through the recordset...

Thanks alot it is a great start.

Thanks, we were trying to send out an automated email through lotus notus based on results of a query we built in Access. As of now, when we run the query we have to go and email the appropriate people individually in response to each record pulled by the query. This is what we were hoping to...

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...

That worked perfectly. I kept running into problems getting that too work. Thanks a bunch.

This is the function I use. I run this code when the one date field loses focus, but I wasn't sure if you can call a function in a query. Public Function Work_Days(BegDate As Variant, EndDate As Variant) As Integer ' Note that this function does not account for holidays. Dim WholeWeeks As...

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 actually backup the system every night, so we are just going to have to do some of teh entry work over again. Thanks for the help.

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 was trying to do that but I can't seem to get the autonumber field to work with the temporary table. I keep getting errors when I append the temporary table to the permanent table that has the autonumber field.

I was doing it was a transfer spreadsheet macro into a table.

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...

Thanks for the help. I actually voiced alot of my concerns about the product from the day I walked in the door but I have no power whatsoever so it didn't do any good. I have to try to come up with the fixes myself and this one is turning out to be a huge headache. Too bad upper management...