Search results

Email Problem, HELP!!!!!!! Hi, I have a form that sends emails for various things, this was working for about 6-10 months, and recently it started not working for no reason that I could think of. When I run it, the first report gets sent and then it stops, it doesn't crash the program it just...

I'm sure you figure this out by now but for anyone interested Dim AppOutl As Outlook.Application Set AppOutl = GetObject(, "Outlook.Application") AppOutl.Quit Set AppOutl = Nothing

I have a split database, with the backend on a network drive. I'm havong two big issues, the first is with the speed of pulling up menus which are running locally, yet I see that access is pulling info from the network. Why does this happen???? Number 2 is when I edit over the network, it...

I have a table with fields repname, 1-24 I want to reference a column, i.e. 4, this number will be taken from a previous function. Dim Mon As Double Dim Yr As Double Dim Enddate As Date Dim Col As String Dim OD As Currency Enddate = Me.EndingDate Mon = Month(Enddate) Yr = Year(Enddate) Col =...

I have a form that runs on a timer that emails people automatically, the problem is that I have to press yes when that dialog box appears saying an email is being sent from your computer. Is there any way of having this done automatically?

Never Mind Never Mind...Sorry won't happen again

I have form with an acccount name combobox, if the account is not listed there is a button which opens a "pop-up" form to add a new account. After they close it they go back to the original field and select the newly added form. The problem is sometimes the new record is listed and sometimes it...

Thanks for responding, I'll try to be more clear. I have it now that in DB #1 once a button is clicked the necessary info gets appended into DB #2. What I want to do is after the info is append, DB #2 is then opened and a form in DB #2 is opened with particular info filled (strLinkCriteria)...

Help! I'm drowning in a sea of my ineptitude!!!!

I have two seperate databases with similar fields one has contact information the other is an order administrator. Is there a way to hit a button in one database that would then open another database, then open a specific form, then populate certain fields with the information from the first...

I have a question which I hope someone can help me with. I have a form which send E-mails when certain events have passed. I want to send the E-mail in a template with our company logo and with certain fields filled by fields in the form. I see at the end of the Docmd.sendobject there is a...

I have a form with command buttons, each button opens a specific agent's orders. Each Agent has an assigned territory. The orders are based on Name, because one can place an order for a territory other than their own. Here's the code I have, stLinkCriteria = "[RepName]= 'Agent's Name'"...