Search results

Thanks, Guys :) Off to do some more reading...

I understood from the error that there was a problem with a variable. I assumed it was in the 'to' code, so I tried just a single email address there instead of the qry reference, but still get the same error. If you will give me a little more of a hint I will go read some more to fix the...

This isn't that kind of error- no yellow hightlight where it errs out- I just know the code runs fine until the email creation gets to where the recipients are definedw [or NOT, in this case] Dave

I am generating an email that I want to send to all the folks in the Query results from qrySelectForEmail. I keep getting an error: Object variable or With block not defined Dim db As Database Dim strSQL As String Dim rst1 As Recordset strSQL = "SELECT eMail, FROM qrySurveyors WHERE...

I know this is an old thread but is is exactly what I am trying to do, using Access 2007. I used Bob's code [changed the False to No] bit it only clears one checkbox on the form and doesn't change any others??? Here is the code... Private Sub Command7_Click() On Error GoTo Err_Command7_Click...

Private Sub Command879_Click() On Error GoTo Err_Command879_Click 'Isolate the correct Survey, by Survey Number DoCmd.ApplyFilter , "SurveyNumber = " & Forms!frmTabSurvey!SurveyNumber Pause (5) 'Kill screen updates Call acbShowUpdates(False) Pause (1) 'Convert each of the 4 form pages to four...

That was in my first few lines of code- Now I am at the end of my code and it hates my syntax again- Trying to send an email to the email address on the forrm.... myItem.to = Forms!frmTabSurvey![Employer E-Email] Thanks, Dave

That works- thank you very much :) Back to work, Dave

I am trying to select one specific record from an open form and use that single value as the basis for running more code against only that single record. I keep getting a "Data type mismatch in criteria expression" error- anyone see a problem with this? DoCmd.ApplyFilter , "SurveyNumber =...

I am using this function to start/stop screen activity- I works on everytning EXCEPT the print notifications... Option Compare Database Option Explicit Private Declare Function LockWindowUpdate Lib "user32" _ (ByVal hwndLock As Long) As Long Sub acbShowUpdates(blnShow As Boolean) If...

Hi Mike Boy, you have done a ton of work on this- thank you! When you ran the 6 itterations did you end up with a single Word document that had all the info? Thanks, Dave

Can someone get me started in opening a Word document and copying 4 separate PDF files into that doc and then saving it? Thanks, Dave

I want to copy a form with 4 tabs to a Word document with the formatting- kinda like a print screen... When I push a command button :) I went through all the docmd functions, CopyObject, OutPutTo, SendObject, TransferText... None would transfer the formatting with the data- Help, please...

One of my applications contains a large table that houses all of the records for identical surveys for many customers. That data is collected via a form. The users needed a way to select a single form to print. This code accomplished that and still works fine. ****************** DoCmd.Echo...

This works after a few adjustments. Thanks for all the help and input. Dave

As DK mentioned, there is only an oldvalue for bound controls, and the tab numbers are unbound, so will never have an oldvalue- it will always be null. I have been working with the info in post 20 and am finding that to work really well. When I finish up I will make another post of the finished...

"Me.txtControlName" Not sure what field this is?

The tab control [tabctl0 in this instance] is a numeric field, starting at 0 and incrementing by 1 for each tab. This is a true value and can be seen using tabctl0.value, which will return the tabs value. My problem, trying to see what page they came from, is that when the form is opened there...

It will read the value of the previous tab- Because of the problems getting this to function I added a 'check data' button at the end of the last tab that only fires when the user clicks on it. They have been using it for the last few days and seem happy with it. It just makes me crazy when I...

There are 4 tabs, 0,1,2,3. There is an error checking routine on tab2. When they leave tab2 I want the routine to run. If there are errors on tab2 I want to take them back to tab2 and display a form so they can correct the bad entries. Since this will run ONLY when they think they are done on...