Search results

Hi all, I've hit a bit of a wall with a current project. I have a Access 2010 32-bit database that is linked via ODBC to an IBM iSeries. This application runs various checks and needs to update a table. It works fine when I use it on my PC with a System DSN connection. However, this is...

Ok, in a nutshell: tblCustomers has a one to many to tblJobHead (referential integrity) tblCustomers PK = RepNum tblJobHead FK = RepNum Within a navigation form, I have a form that contains the tblCustomer info in the header section and the tblJobHead in the detail. I also have a button...

Hi all, I'm using Access 2010 and need to update a sub form in a form that is within a navigation form. So it goes: Navigation Form > Main Form > Subform How do I do this? I've attatched the following to a click event of a cmd button but I just can't get it to work...

Hello, I am trying to create a DSN less connection from Access 2010 (32 bit) to an IBM iSeries. The below thread shows the coding: http://www.connectionstrings.com/ibm-iseries-access-odbc-driver/ But I am a little stuck. How do I incorporate this into my database? Do I create a module and...

I have a Word 2010 document linked to an Access 2010 data source. When a user clicks a button in Access, the Word document loads and performs a email merge using the below VBA code: Private Sub Document_Open() With ActiveDocument.MailMerge .Destination = wdSendToEmail...

Hello, I am using Access 2010 32-bit and I have placed an embedded image (Image146) in the detail section of a report, and then set the Visible property to No. There is a Text box (field1) also in the detail section. When the value of the Textbox = "ABC" I want the image to display...