Search results

The reason the VBscript is used is because it formats and saves the Excel sheets into xlsx before opening the Access. I'll try to comment and use the Quit command.

hmm. I am thinking to have an alternate way where in it opens the database. I will copy and paste the form event into a module and then a runcode command in a macro. The VBScript can open the form and have a DoCmd to run this macro. Is this the right approach?

No hanging instances of MsAccess.exe in Task Manager. I checked

I inherited this database and was also curious about ^{F4} command but the script opens the database and the runs the form event correctly. My issue is, at times, the script fails to open the database but does on repeated tries!

Hi, I have an VBscript which opens a Access db and loads the imported data from two excel sheets and runs few action queries in the frmDone event. The issue is when i run the script, it executes the excel actions but fails to open the database. But this is random since when i try to run the...

Hi All, I have this issue of Access database closing, when I try to delete a control or a subform from an existing Report, while trying to edit or modify. Recently the organization's name in header and the signee in the Detail section changed and needs to be modified in all the reports. The...

The backup is done in the scheduler everyday at 10.00 pm and there is no User in it. I'll try to just copy the database without opening it, as in below @echo off echo Copying Database..... pause Set NewDate=%date:/=% copy "C:\Dailyreport\CurrentDB.accdb"...

Hi, I am trying this batch file to backup my database but it is not creating the backup, when I tested it manually @echo off REM Set the path to your Access database set dbPath=C:\Dailyreport\CurrentDB.accdb REM Set the path to the backup folder set backupFolder=W:\common\Reports\dbbackup...

Hi, I have a job in Windows Task scheduler which opens a Access database, executes a FullRun macro and exports the reports to a folder. It runs once every 30 mins. It's all good. But since sending an email in Task Scheduler is now not available, what is the alternate way to generate a...

I do have Exit command at the end of my WinSCP script. I have the Download from WinSCP followed by the MoveFiles code. Is there a way to pause or delay the MoveFiles code by few seconds and trigger it after? Probably a Sleep or Wait code between WinScp and Move?

The last command in the macro is Application Quit

Hi All, I have an Access db, which has few modules. One of the module, Load Source Tables executes or calls other functions within such as, running the WinSCP and another function to imports those downloaded files from one of the folders, which is in the same directory as the WinSCP exe. I have...

Thank you all. I found what was causing the issue. It was a data corruption issue.

what is the equivalent of DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 in RunCommand method? I need the forma to open to in Edit mode I tried,DoCmd.RunCommand acCmdFind but still get the same error

Hi, I inherited a database. When I click Edit on this button, I am getting an error on this line, DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 I did a compact and repair assuming this fe was corrupted. But it did not resolve the issue. It has linked tables to the Access be. t...

let me first try with a single file and use get by passing the specific directory. I'll also try using mget as google suggested

Hi All, I do a download using WinSCP and it works fine. However, the script file and the folder to which the files are downloaded are in the same location as the winscp.exe. I later move the files to my working folder. When I use, mget *.ftprcv C:\Software\winscp\tccfiles\*.txt I have no...

I have created a batch job to be placed on the scheduler, which opens the DB and runs the macro, mcrFullrun. Currently, I am testing the code manually. While I have the DB open, I am running the macro That I created for the Full run. This macro, mcrFullrun has all the modules, queries...

Hi, I download files from a FTP server using WinSCP and it works well. The WinSCP code is triggered via Shell command from a Access module. The files are placed in the folder where the WinSCP exe is and then moved to another folder. The Move code works well during the first instance. But when i...

I mean I use mget. Currently, I download them all. but another code looks for the zip file by current date to extract the contents. I will check about constructing my script with suitable variables