Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: aman
Forum: Modules & VBA 04-26-2019, 02:49 AM
Replies: 3
Views: 121
Posted By aman
Bookmark on word document

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...
Forum: Modules & VBA 04-24-2019, 06:41 AM
Replies: 1
Views: 101
Posted By aman
ODBC - Call failed error message

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...
Forum: Modules & VBA 03-27-2019, 08:11 AM
Replies: 3
Views: 121
Posted By aman
Query to check data in old and new tables

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...
Forum: Modules & VBA 03-15-2019, 06:58 AM
Replies: 7
Views: 142
Posted By aman
Re: Sub form to store value from the form

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...
Forum: Modules & VBA 03-15-2019, 06:47 AM
Replies: 7
Views: 142
Posted By aman
Forum: Modules & VBA 03-15-2019, 06:28 AM
Replies: 7
Views: 142
Posted By aman
Re: Sub form to store value from the form

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...
Forum: Modules & VBA 03-15-2019, 05:51 AM
Replies: 7
Views: 142
Posted By aman
Sub form to store value from the form

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’...
Forum: Modules & VBA 03-07-2019, 05:14 AM
Replies: 5
Views: 195
Posted By aman
Re: Validation on textbox not to accept any alphabets

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

KeyAscii = 0
Forum: Modules & VBA 03-07-2019, 05:11 AM
Replies: 5
Views: 195
Posted By aman
Validation on textbox not to accept any alphabets

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...
Forum: Modules & VBA 02-26-2019, 04:56 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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...
Forum: Modules & VBA 02-26-2019, 01:27 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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

Thanks
Forum: Modules & VBA 02-22-2019, 05:14 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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 .
Forum: Modules & VBA 02-22-2019, 02:54 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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...
Forum: Modules & VBA 02-21-2019, 05:19 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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...
Forum: Modules & VBA 02-21-2019, 03:33 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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...
Forum: Modules & VBA 02-21-2019, 03:19 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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...
Forum: Modules & VBA 02-21-2019, 03:17 AM
Replies: 14
Views: 376
Posted By aman
Re: Outlook VBA code to save email in the shared drive

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
Forum: Modules & VBA 02-20-2019, 03:33 AM
Replies: 14
Views: 376
Posted By aman
Outlook VBA code to save email in the shared drive

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...
Forum: Modules & VBA 02-12-2019, 05:25 AM
Replies: 5
Views: 161
Posted By aman
VBA code to check memo fields in all tables

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...
Forum: Modules & VBA 02-08-2019, 02:52 AM
Replies: 3
Views: 94
Posted By aman
Delete rolling 12 months records

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...
Forum: Modules & VBA 12-17-2018, 04:53 AM
Replies: 3
Views: 145
Posted By aman
Re: Using Ini files to create text file (with various sections on it ) to store value

Thanks Arnelp, I tried it but nothing got populated in the listbox.

When I step through the code then I can see the values get stored in variable 'v' but nothing shows in the listbox :

Public...
Forum: Modules & VBA 12-17-2018, 03:23 AM
Replies: 3
Views: 145
Posted By aman
Using Ini files to create text file (with various sections on it ) to store values

Hi Guys,

I am trying to use ini files which will act as a mini database for outlook. So Outlook/VBA code will create a text file (ini file) and data is stored in a text file so everytime you need...
Forum: Modules & VBA 12-03-2018, 03:05 AM
Replies: 5
Views: 394
Posted By aman
Re: Store data in multicolumn listbox from a text file

This is for outlook . The form is designed in outlook VBA .

In order to make it dynamic , I want to store data in a notepad and the listbox will get populated with the data stored in notepad.
Forum: Modules & VBA 11-30-2018, 01:40 PM
Replies: 5
Views: 394
Posted By aman
Re: Store data in multicolumn listbox from a text file

How can we do the same thing if the data is stored in excel spreadsheet . I have to write outlook vba code as the form is in outlook .
Forum: Modules & VBA 11-30-2018, 08:10 AM
Replies: 5
Views: 394
Posted By aman
Store data in multicolumn listbox from a text file

Hi guys,

My code is written in outlook vba and I am trying to figure out the issue with storing different data each time in the listbox based on the relevant option selected on the form.

So,...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 01:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World