access & vba

I am trying to use list box (with multiple items) in excel user form to delete the record in access table. for example: I have selected multiple items in excel user form list box (Listbox1), let say Wk1 and Wk2 in access, I have a table called "Rawdata" and there is a column called "Weeks"...

I have the code below. which appends data to a table in Access. It also renames the file(adds "completed" to the front) and puts it in another folder. The issue is, it puts the renamed files in my "Documents" folder, when i want them to be placed in the following folder...

I'm sure the code to do this is online somewhere, but I can't find it. I want to make an Excel document which displays an Access table. When a user changes a value in the Excel document, it writes the change to the Access table. Additional features that would be great, but I will put these in...

Hi hopefully someone can help, I'm trying to Hide some fields on my form when I select option on my toggle box. I've tried doing it a few different ways but not sure as I'm very new to access. This is what I have... Private Sub Toggle10_KeyPress(KeyAscii As Integer) Me.Equipment_ID.Visible...

I am receiving a Type Mismatch error and cannot figure out why. I had a Dlookup with 1 criteria, which was working fine. I have been trying to 2 additional criteria which come from the same table to this dlookup, however I keep getting a type mismatch error. Here is my code: M_ID =...

Hi All This is a very basic question but I cant seem to get around it. I have a query that I am using multiple times so I have saved that query in a string variable. Now that query is using ID in the where clause which I need to update dynamically so I made an Int variable and concatenated that...

Hi I am trying to make a VBA module in Access to export a query from Access into an existing Excel file and worksheet. From looking around on Youtube I have found the code below. This works fine for queries where no input is required. However when I run my query a box pops up asking you to...

Hi, Is it possible to have a button that will clear the contents entered on to an access userform? Is there vba code that would sit behind the button? Many thanks

Greetings!! I am new to MS Access and have been trying to use VBA to import a specific worksheet called "Access" in an Excel file (from about 400 users) into a single table. I want the code to search through one folder and import the "Access" worksheet in each Excel workbook within that...

I please need some help. I have created a Access database (2013) and I have created another exactly same database in a different location. What i am trying to do is sync the the 2 database "Table3" with eachother after and update has been made. Thanks for any insight

Hi, I am using the function below to find the median value of records but the problem is that I am trying to group by multi-levels in a query. For example, I have three other fields "Account_Name", "Claim_Status", "Disease_Category" that I need to take into account when calculating median value...

I'm attempting to find a way for Excel to write to an Access database and for it to work on PCs that do not have Microsoft Access installed. I have found some code here and on other sites, however, it only works with older versions of Access and we use Office 2010. We currently have a CSV file...

I am trying to get a report to open into Preview mode with the latest record, but I am having trouble. I can't find anything online that will help me figure out why this issue is happening or how to fix it. When I open the report, it shows whatever the last record is (based on ID). In this case...

As part of a application I am developing, I added a command button on a form that will send the customers Name and Address to a word template letter that gets mailed to them. This is the code I am using for this part of the process: .ActiveDocument.Tables(2).Cell(1, 1).Select .Selection.Text =...

I am creating an Access database for the department I work in. When reviewing orders on a form, there are certain instances were we need to mail a letter out to the customer. I have a command button that opens up a word form and inserts address info from the customer table in access to the word...

I need to create some filters on my Access form and need some help. I have done a ton of research and due to my experience being little, I need some help with this. I want to create a Combo Box on a form that will apply a filter to view a selection of records. One of the fields on the form is...

I have a VBA macro in Access for importing text files into the database. I would like to use this macro to import Excel files. The VBA Macro performs the following: - There is a form button attached to the macro to import the text file - A Temporary table is created to import the data - The...

<tbody> MERCHANT NAME ACCOUNT NUMBER CARDHOLDER NAME CARDHOLDER ADDRESS DATE AMOUNT ----CITY----COUNTRY---- MCC DECISION NOTES <tbody> 983764398764327 </tbody> <tbody> Doe, John L </tbody> <tbody> 123 Street Name </tbody> <tbody> 05/03/05 </tbody>...

Hello I am new with Access and VBA, My purpose is to export Queries in one workbook but different worksheets. I am working with Access 2007. When I add an Ouput file for the Queries to go in a specific workbook I get a compiling error stating: "Compile error.in query expression...

Hello there, first of all please do not judge my English because it is not my native language. The following is my dilema: I have a Excel template in which I insert data from Access. First i make a copy of my Excel tamplate and then insert the data in that copy of the template. The next step...