Search results

Hi Guys, I got bookmark added on word template where I want to display data from MS access query. The following code is written in Access but it doesn't populate any data in word document. I tried to run the query and it works fine but bk.range gives me null value in the following code: With...

Hi Guys, I am using Access frontend and sql server backend . There is a select query built on the frontend which is giving me "ODBC - call failed The text, ntext, and image data > types cannot be compared or sorted, except when using IS NULL or LIKE > operator" error message . Below is my query...

Hi Guys, I have created a new table which has replaced the old tables due to business needs. Now my report is not pulling through the historical data as it's pointing to the new table. How can I change my query so it will check reference number in old table and if it's there then pull through...

So what's happening is that it gives me the right reference in 'FormRef' in the subform but as the subform is continuous so when the focus is moved to the next record then 'FormRef' in the first record goes disappeared.

It's already set to Yes.

I have defined master child relationship but it's still showing 0 value for each 'FormRef'. My subform is bound and linked to a table 'tblQARemedial' but my form is unbound so when the user selects 1st control then data gets saved down in master table and it gives unique reference number (this...

Hi guys, I have been trying to resolve the issue but no luck . I have a form and there is a sunform within it . So I want to store the value of ‘DocCheckId’ text box from the form to ‘FormRef’ within subform. It is storing 0 for each entry in the sub form at the moment . Any help will be...

Made it to work. Just add the following line of code instead of the message box: KeyAscii = 0

Hi guys, The following code checks if any alphabets are entered in the textbox and display an error message if the user is typing any alphabet. I want to amend this so that no error message displays on the screen but if the user types alphabet then just ignore the alphabet (textbox must not...

Also guys at the moment when the code merges email message and attachments into pdf then in the pdf file attachments appear first and then at the bottom email message appear . I want it done the other way so email message on the top and then attachments at the bottom.

Hi guys, Also the code ignores pdf attachments and doesn't save them on the shared folder. Any help will be much appreciated . Thanks

I tried that but it didn't merge excel workbook attachment at all. :( It just converted email body to PDF and saved it down but ignored excel attachment .

Thanks Gasman, Another thing here is the code works fine if there are word document attachments but when there are excel attachments then it will only look for the selected sheet in the attachments and then merge into one PDF. I want the code to look for all the sheets in the excel workbook and...

I just got rid of GetSaveAsFileName function and it didn't display the dialog box. Please see below the amended code. It works perfectly fine but I think there is unnecessary code in there and I am not sure why we are using both excel and word document to perform conversion and merging ???? Can...

My objective is to merge email body and attachments of the selected email into one PDF and save it down on shared drive. It does work but just opens up the dialog box so I need to click save manually. I want this to be automated . I think its a matter of replacing the function...

Also not sure why xExcel object is being used in the code? Why do we need to open excel to merge email and attachments into one PDF ? Public Sub MergeMailAndAttachsToPDF_New() 'Update by Extendoffice 2018/3/5 Dim xSelMails As MailItem Dim xFSysObj As FileSystemObject Dim xOverwriteBln As...

Hi Gasman, They can only select one email at a time. So basically instead of opening that saveas dialog window , I just want it to be saved down automatically. Thanks

Hi Guys, The following code opens up a dialog window before emails and attachments get saved down on the network. I want this to be automated so that no dialog save as window will open up and the emails and attachments will be saved down on the network automatically. Any help will be much...

Hi Guys, Is it possible to write vba code that will clear data from the memo fields from all the tables in the database. One way will be writing queries for each table and updating memo fields to null. But this way if I have 50 tables in the database then I will need to write down 50 queries...

Hi guys, I am trying to delete rolling 12 months records from the table. Can you please amend the query accordingly? Dim sSql As String sSql = "delete from tblReturntowork where Datecreated=#" & Format(Date, "mm/dd/yyyy") & "#" MsgBox sSql Thanks