ms access

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 have a vb script in Access. Its been working fine for years. Basically the script uses a bunch of OpenQuery & TransferSpreadsheet Export commands. DoCmd.OpenQuery "Sample Query1" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Sample Query1 Export", "c:\text..xls", True...

Hello, can someone help me how to make this in MS access VBA code to read from .txt file the colors Example: Let's say my file name is called "Colors.txt" Inside of it i have this information: "W" = RGB(255,255,255) "B" = RGB(0,0,0) and so one.. And inside my access file i have table where it...

Hello. I currently have some vb code in Access that is working. The code looks at a table in access. Lets say it has 400 line items of information. The script will take the first record, run a few queries, export each table to an excel file (template). Let's say the template is called test.xls...

Hi Forum. I just signed up. Looking for a solution to the following problem: I have a partially completed query called 'qNew_Prods' and a static table 'tbVendorColors'. I need to populate a field called 'color' for my final query using the tbVendorColors table. 95% of our vendors are...

Hi I am new to MS Access and looking to edit data from an Access DB in Excel. I loaded the table into excel and deleted some data in one of the columns. After I have refreshed it, the data pops back up in excel like I never deleted it. Is there something I am doing wrong here??

Hi. I am running the following vb command from access 2013. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "123", "c:\test\test.xls", True Access 2013 - Excel 2013 The table 123 is created but the external table is not in the expected format appears and when I click on debug...

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 Gurus - Thank you for looking into my problem. Below query works when i execute in MS Access. Its a standard query which i plan to call in Excel using ADO. select * from qryForwardRecon; When the above query is called using ADO in Excel VBA , i get zero records. Not sure what could be...

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

Here is my struggles. I had macros in my excel document which everything was working fine. We kept coming up with the problem that in order for someone to use it and they worked from home they had to vpn in. Next thing was if someone has to use it and make a change and another user has it open...

A simple fuzzymatch logic that can be placed in an access module. This is a UDF(User Defined Function), and can be called from a query to retrieve suitable results. Variations can involve replacing special characters, vowels before matching so as to customise as per requirements. Function...

Dear Community, I am in the process of building my first database for all kinds of lubricants that my employer sells. However, I am now stuck trying to figure out how I can import the data from excell into a dropdown list with 7 values total. These values are: Can, Spray Can, Pail, Drum, Drum...

Hi, I am using below code to export table from access 2016 to excel but getting error saying: Run time error 31532: Microsoft Access cannot export the data Public Function ExportToexcel_DD() Dim output_fl As String stName = "\PRO" output_fl = CurrentProject.Path & stName &...

Hi All, Thanks for putting in time for viewing my post. I am stuck with a runtime issue, the bit of code that seems to be causing an issue is the text below in bold "DoCmd.SetWarnings True strFile = arwGetPersonalFolder & "\BromptonLungFunction.xls" ' &...

Hi Im trying run the below code that is connected to a ms access database... if i run the code based on any criteria apart from date it seems to work, however every time I use date as a criteria it fails with error 1004 "Application-defined or object-defined error" CommandText = Array( _...

Hi. While I've been writing Oracle SQL queries for a few years now, I'm relatively new to MS Access SQL. There are surprisingly few resources available online (via Google) for MS Access SQL. Given that, I'm having difficulty figuring out how to format a field which is text as a number (or vice...

Hi, I have a team of 40 associates and currently, we have one excel based file with multiple columns to capture the data on a daily basis. These columns are bifurcated into Four parts: The first part, basic details: First 12 columns: Date, Month, Week #, Unique ID ( Aklphanumeric), Tracker...

Hello, I have a problem with importing data from ms access to excel with <acronym title="visual basic for applications">VBA</acronym>. I use "ADO Connection" to connect excel with acces. I have 2 tables in ms access. I want to get the newest comment from table p_comment for products. I...

Hi All I am curently updateing my "Excel Database" to a MS Access Database. when you open the Excel Workbook all the data is copied from the database into the Excel workbook. All new records into the database is via a Excel Form as below. <code class="bbcode_code"> Sub...