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

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

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

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

Hi all, I am trying to update and insert records with SQL statements. Below my code: Select Case FirstGRV Case "Y" sql = "UPDATE Tbl_SellingPrices " & _ "SET SellingPrice = " & Me!Text2 & ", SellingPriceDateFrom = date(), SellingPriceDateTo = #" &...

Is it possible to call the printing dialog box without the MS Common Dialogue ActiveX control? I tried to use this ActiveX control, but get an error message that I do not have the required licence to use the control. Can someone help? Thanks

I have just upgraded to Access 2010, but all users are still using Access 2003. Will the existing Access 2003 databases work correctly (if at all) if I remove the Access 2003 package from the user's computers and load only the Runtime version of Access 2010? As always, much appreciated. Deon

Hi, I have written a database in Access 2010 in 2003 format. When I run the DB with MS Acess 2003, I get messages of missing or broken references to the files "ACEDAO.DLL" and "APSVIEWPANES.DLL". I cannot detect (through the search of files) these two files on the 2010 machine. Does anybody know...