Recent content by Bobbinbobwhite

I finally decided to use a temp table to hold the results of the query and do a select statement on that table to make the mail merge code work.

Unfortunately all of the parameters are from queries not the form, should I still consider using Eval?

Not sure what you mean here....

I have tried to copy and "fix" the sql query to the vb code to use, but get errors there too!! I have attached the db for you to look at. The form that I am trying to use this code on is "qyrInvoices" sorry, I haven't renamed it yet... it has the same name as the query that I used the wizard to...

I know the query generates data because that is what opens the form the command button this code is the event onclick for. This is a query that I created using the Access query tool and have not converted to vba because it has several joins and parameters. As you may have guessed, I am in a...

I tried both of those..... get errors on both stating that the Sql is incorrect or no data was created. Error message is generated by the called code and states: No Data was created for this merge Make sure the sql is correct sql was "qyrInvoices" or sql was "select * from qryInvoices" The code...

Not an expert at either or Access or VBA, but attempting to learn as I go... I am using the Albert Kallal Word Mail Merge code and have gotten stuck. I am using a stored/saved query to open the form. The recordset that query creates is the one I need to use for the mail merge "ALL" records. I...

I was getting this error on one of my main forms too. I removed the audit tag from the Attachment field on that form and I no longer receive the error.

THANK YOU!!!! I knew it was something simple that I was missing, and no knowing enough to find it! It all seems to be working now, you are all AMAZING!!

How can the main form be the active form, when the data entry is done on the sub form? I am opening and looking at the table named tblAuditTrail after an entry to see if it recorded the activity in that table. On the form Bank Balance Entry, on the sub-form enter a new record. From the...

I changes one of the subforms to continuous and the event doesn't seem to trigger from the main form, but did trigger when I opened the subform independently.

I just realized my subforms are in datasheet view.... could this be part of the problem?

Sorry it has been a while, I got pulled into another project. I have made the suggested changes and still can't seem to get the subforms to run the events when they are embedded on a main form. The events all work when I open the subform independently. I attached a copy of the DB hoping that...

Thank you!! I will give it a try first thing tomorrow morning.

I don't have any code on main/parent form that references the sub-form, I am triggering everything from the sub-form. Event code on sub-form "Balances Bank Entry subform" Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then Call AuditChanges("Balance_ID", "NEW")...