Search results

Hi all, I have a table in Access 2016 with an array of fields, example Field1, Field2, Field3, etc. I need to update these fields with data from a form. The data is stored in an Array (FieldArray(5)). Each Field in the table needs to be updated with the corresponding data in the Array...

Hi, Is it possible to code the following line somewhere where it will be run only once and not everytime as currently in the loop. "Set img = Dialog1.ShowTransfer(Scanner.Items(1), wiaFormatJPEG, True)" The problem is that as the code in the loop is run every time that the above code...

Hi, Yes, the printer is installed and the WIA is in the references:

Hi, I have a module that scans documents into a database. I am using a local (USB Connected) rather old scanner from Fujitsu. The code works perfectly and all files are scanned and stored as it should. The customer has now requested that they want to scan across the network, not from a local...

Hi Mike. Thanks, yes it was a timing issue - all resolved. Thanks!!

Hi isladogs, I get your suggestion and under normal circumstances, it is the solution, but not in this case. Firstly, I cannot use a multiselect listbox as the students has not yet been captured. On my capture form, I capture new records. The user enters the course number and each course can...

Hi Gasman, Yes, printing while looping through the array is an option, but it is not what my customer wants. He wants all the reports to be opened in preview mode. They then decide which of the 50 reports they want to print. It seems the issue is because the reports are opened in preview...

Hi all, Let me explain: The user captures between 1 and 50 students at a time. The ID numbers are stored in an array as they capture the information as each report is based on the ID number. Once all the students are captured, they click on a button "Print all Documents". Then all the reports...

Hi, I have an Access 2016 Database where I am opening multiple instances of one report. Everything is running as it should and the multiple reports are opened (up to 50 at one time). In the report's Load event, there are code running that will retrieve data from the different tables with SQL...

Thanks - this seems to be working.

Hi all, I am trying to write files to the "%USERPROFILE%\AppData\Local\Temp" folder. It works fine as long as the code runs on the local machine. As soon as the application is run from the Terminal Server, the %USERPROFILE% variable is empty and the write action fails. I have read somewhere that...

Thanks a mill - this resolved the issue

Hi, I have a database that e-mails a report to users as soon as the report is created. I am using the "SendObject" method. I need to have the e-mail automatically be send, without the user having to click on "Send". Currently, Outlook opens with the report and the e-mail addresses, but pops up...

Yep, You are 100% correct. Outlook does not like the period as a list separator. After changing it to a comma, the problem disappeared. Thanks for the assistance. Greatly appreciated.

Hi, Just for information, I have changed my regional settings. The List Seperator = period and the Decimal separator = period. Maybe this has an influence?

The variables C1 and D1 contains the following values when debug.print: C1 = dirk.vdwest@senco.co.za D1 = cassie@cargon.co.za When Outlook opens the message to be send, the mail addresses are placed in the "To:" and "CC" fields, but it looks as follows: To: dirk;vdwest@senco;co;za Cc...

Hi all, I am experiencing a problem with Outlook. I have an application that mails a report as soon as the user clicks on save. The mailing happens without the user knowing it. The issue is when Outlook opens, the e-mail addresses has been changed by Outlook. EXAMPLE: In my code, I retrieve...

Thanks a million. The SQL statements now execute like they should and the correct SQL is executed according to the criteria. Once again, thank you very much.:D

Hi, I ran the SQL statement and printed to Immediate Window: UPDATE Tbl_SellingPrices SET SellingPrice = 15 WHERE SellingPriceStockCode = C002 AND SellingPriceDateTo = #31-07-2014#; This is for the first SQL statement when FirstGRV = "N" The following is the second SQL statement when...

Hi, I created the SELECT query and it returned the correct records.