Search results

Answered my own question! Thought I had tried this, but I guess not... I wound up using a DoCmd.OpenQuery on a make table query and everything worked out great. Here's the code now: Private Sub Command0_Click() Dim val As String Dim rec As DAO.Recordset Dim db As Database Dim rs As Variant...

Hello, I've got a problem with a query I'm trying to run. This is the abbreviated code: Private Sub Command0_Click() Dim val As String Dim rec As DAO.Recordset Dim db As Database Dim rs As Variant Dim rs1 As Variant Dim vCode5 As String ' string to contain list of stores Dim strSQL As String...

I just started having an issue with a mailmerge launching form in Access. A button I've set up, called "Order Form," uses the following code to launch Word, merge the data into the document, save the document, and close out the template. It's a large sample, and I think it may have come from...