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...

I got this to work. If anyone is interested, to requery a subform when used in a form that is in a navigation form use: Forms("ActualNameOfMainNavigationSubform").Form("NavigationSubform").Form.whateveryouaretryingtoaccess Credit to the person who solved it...

its ok I solved it. Just added: DoCmd.RefreshRecord to the button used to open the search items form.

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...

When I use the expression builder and drill down loaded forms etc, it just displays a blank window in Expression Categories.

Ah yes, but you can't access the expression builder from VBA in Access 2010

I've tried this: Forms!frmMain!NavigationSubform.Form!frmJobHeadsubform.Form.Requery But it says it cannot find 'frmJobHeadsubform' Check spelling and it is correct...

Hi Paul, It is located on another pop up form. Regards, Michael

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...

I have a working access db sending emails via the CDO Object Library. I sends email based on a txt file template that has dynamic fields e.g. name, order number etc. For the actual send mail bit, use this: Function SendMail(strTo, strFrom, strSubject, strBody, msgType) Set objCDOConf =...

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...

Thanks for getting back to me. I managed to resolve this though.

Its ok, I finally got it working, here is the code: Private Sub Document_Open() Dim intSourceRecord Dim objMerge As Word.MailMerge Dim bTerminateMerge As Boolean ' If no data source has been defined, do it here using OpenDataSource. ' But if it is already defined in the document, you should...

Hello, Thank you for this. I need to send from email addresses contained in an Access 2010 database and the mails need to appear as if they are only being sent to the sender and no one else. How would I configure the below code to do this? Regards, Michael

Thanks for the reply - yes I have access to an Exchange server. What is CDO?

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 .SuppressBlankLines = True...

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...

Field 1 is a textbox.

Hey Paul, I got this to work but it's not ideal. Basically if I add another text box in the detail section then for it's control source state if Field1 = "ABC" then YES else NO, then in the Detail On Format enter the following: Private Sub Detail_Format(Cancel As Integer, FormatCount As...

Apologies Paul, Yes I tried this in the On Current event of the report and got nothing, but if I put the code into the Detail On Format event, I do get the pop up, so it must be something specific about the image properties... Regards, Michael