Search results

HI, I have a tab controlled main form and a tab controlled sub-form. While the controls in pages, HV, Major and Appellate work without issues in standalone form mode, the sub form controls are inactive when included inside the main tab controlled form under Page, BiasReportsByRegion. Is it any...

Hi, I have a Main form within which I have a tab control. When in form view the tab control shifts up and the and the page controls are not visible. I have to scroll up to see these controls. It has to be like this in the form view but It comes up as below with BiasReportByRegion and...

Hi, I get this error sporadically. This is a button on my Access application which creates and sends a pdf through Outlook. What is this Outlook error due to? we have Office 365 and not a older Office version. Is it because of a slow PC? How to fix this? TIA

Hi, I have a field in Access table with values such as 1. abc 2. efg ....... 10. ijk It has two spaces between the numbers and the string, which is uniform. I want to eliminate the numbering and just retain characters. How to identify the space between the single digit numbers and the...

Hi, One of the Access DB I inherited has a code which drops a temp table, runs a make table query, which queries all the fields of a linked table and creates the temp table. The query uses fields from only the linked table and not other data sources. This is fine and no issues. Can I rather...

Hi, In my access app, I receive data through text files everyday. These text files have one entry each and I receive close to 200 of these each day. Due to an error in the upstream module, we did not receive these files for few days. After finding out the error, the upstream team sent the data...

Hi, I import XML attachments everyday from Outlook emails to an attachment folder in C. When I run the Rules in Outlook, which executes the Outlook macro to download the attachments, It comes in as Proc_ID_1111-Pam_WALT-11-18-24_13-41-15. I mimicked the same code in Access button action and it...

Hello, I have an application where data is appended to two tables everyday. Every month, on the first working day a automated job runs at 10.00 pm to create a MTD report using the data from these two tables. How do I identify the first working day of the month so that I can write a module to...

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

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

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

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

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

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 download from a ftp server using winSCP, zip files into my local folder, which works fine. get *.zip C:\backupshare\2024\Reports\TCC\tcc\ The issue is the remote Archive folder has daily files zipped at the end of the day and named as 20240729, 20240730 ..... Currently it downloads all the...

Hi, I have a string which reads the date as 20240730 "C\backup\LReports" & "\Output\" & sFolderLocation & "\" & "Report_" & sDateTimeStamp & ".xlsm" sFolderLocation = CStr(Year(Now())) & Pad(CStr(Month(Now())), 2) sDateTimeStamp = CStr(Year(Now())) & _...

Hi, I am trying to extract the contents of a zip file into another folder while saving them as .txt files. But where the code is bold, it says "the Zip file could not not be opened." Function ExtractZipAndSaveAsTxt(zipFilePath As String, destinationFolder As String) Dim shellApp As...

Hi, I get a file loaded everyday into a folder in C named as in stock_distribution_20240726.xlsx. The format is stock_distribution_yyyymmdd.xlsx. I need to rename this file as stock_distribution.xlsx by stripping off the date before linking it to my table. Using FileSystemObject and...