ms access vba

Hello. I have the following script that is working. A ID table is opened, txtDist= ID command pulls one ID at a time. Query output is named output and then transfered to a output tab in a output.xls file Renames the file and then loops again until it finishes the entire ID table. I want to...

hello. i've been using a vb script that uses an access table, queries a cloudera linked table and returns the results. ie.. access table could have some member ids, loops thru the table, one record at a time, returns the result, exports to excel and off to the next record, etc.. now the source...

Hello. The following command in an older version of Access used to work: RetVal = Shell("cmd /c copy /y C:\users\abc\desktop\output.xls C:\users\abc\desktop\split files" & txtDist & ".xls", vbHide) Copy an output file from access which is working and then moves it to the split file folder and...

Hi Community, Hoping you can assist with helping me understand what i'm doing wrong with code I found from another post for querying an Microsoft Access Database to retrieve records WHERE a Column value = GetUserName(). When i run the code I either get an error, OR i don't get an error and it...

I am working on a split form in ms access. I would like my form to not add a record if the Sending_Category = Contractors or Salaries & Benefits, and the Sending_FTE is blank. I have tried this as an on click event for the "Add Record" Macro, and on the form as a before update event. My "add...

For example, I’m trying to write: Dim rec1 As Recordset Set rec1 = CurrentDb.OpenRecordset("MySchedulewXdept1") ‘This query (MySchedulewXdept1) is filtered based on the date that I have on another open form. I get a Run-time error '3061': Too few parameters. Expected 1. My main objective is...

Hi all I am new in this grout i have a query regarding the sub report. i have an parent report in which sub report is placed. when i manually open the parent report then sub report binds with one record in multi pal times like record 1 record 1 record 1 ..... , and when i manually open the...

Current process is selecting individuals manually to send e-mail. I'd like to use Access to somewhat automate the process to send static e-mail (except for date update) to different individuals. I have 4 tables set up: tblDate - contains calendar thru 12/31/2025 tblEmail - would contain...

Hi, I want to search occurences of string "zeeshan" in a range in MS Excel through VBA from MS Access button click. Below is my code ... I am getting compile error : "method or member not found". With this error below line gets selected wordCount =...

Hi Guys, I have a written a code for a button in a form to import text files with the following field names in the text file. Title LastName Firstname Address City State Please see the below code and help me in finding the issue with the code. Private Sub...

Hi I have two functiions, Cheque() whic simple check the reorcd in the table , whic reports need to sent email, The 2nd function GenerateEmail() which giving me the error. "Method or Data Member not found. I though the reference library missing but I already added the following library...