access & vba

Hello I am trying to open and modify an Excel 2016 file using VBA in Access 2016. I pieced together the code below, but I keep getting "Compile Error: Sub or Function not defined" at the bolded section of the code below. Does anyone know how to correct this error or if there is a better code to...

Greetings, I'm not sure exactly where to start, but I have an idea of what I'm trying to do. I tried to think of a way to import all these excel files into an Access Database.. but I am not very skilled, I can use the out of the box stuff for Access, but can't seem to get it to do what I'm...

I have two tables in an Access database, a parent and child. I have a connection, and two ADO recordsets, one each for the parent and child tables. They're both opened with a string of SQL, adOpenDynamic, adLockOptimistic, adCmdText. The logic is to see if something specified in the spreadsheet...

Still learning Ms Access vba but learning fast. I am not understanding fully and I am stumped on just on two things of which I am sure solve one, the other will also be solved. Spent the last 2 days with no progress. :( I have a button on my form opening my excel spreadsheet (template)...

Hi, Working on a VBA code to allow me open a folder which was created a day before. Path and the partial folder name is static. The one thing that is variable is the end of folder name which would have a random date stamp. Example: Reporting_Extracts_14112017_82404 VBA so far: Private Sub...

Hi, I have an Access DB that has 4 queries and one form. Depending on what the user does in the form will determine which query is run. This is controlled by a macro that looks at the state of three tick boxes and runs a query accordingly. My query for the forum is, can I have a single button...

I am not a VBA expert. What I would like to do, is to append those csv files to my table in Access. It's an ongoing process, so those CSV files keep coming in to my folder every day. I don't want to copy the headers though since I already have the headers in my Access table that i created. (I...

I have several CSV files in one folder. All files have the same format. I created an empty table in Access that has the same headers as the CSV files. What I would like to do, is to append those csv files to my table in Access. It's an ongoing process, so those CSV files keep coming in to my...

Hello Does anyone have any code where I can import excel sheets into Access from Subfolders? Many thanks

Heya, I'm totally lost here and tried numerous options to achieve this with no success... So basically I have a button on my Access dashboard that imports EXCEL sheet in the database. I want this "import" action to be performed automatically without someone pushing a button. I have tried the...

Hi, Apologies - I'm unsure how to post code into the forum. There is an issue with InputPath. It does not like the network/server name. It will work fine when it is local (my documents) I've also tried using the drive mapping letter. Any suggestions at all? Here's my code: Public Function...

Is there any way to merge/combine data from multiple unsaved excel documents so its neatly in one document? Essentially I have lots of excel tabs open (all unsaved) and want to take columns A1-A20 and B1-B20 of all excels and place into one main document going downwards. SO rather than have...

Hi Friends, I'm using below code to get count of records in access table which has been updated through sql server through ADODB connection (lcnn). SQL1 = "INSERT INTO [Users] " & _ "Select DISTINCT USER_ID " & _ "FROM " & _ "[ODBC;Driver=SQL Server; " &...

Is there anyway I can restrict user to edit only the last day data in the user form, and disable editing for all other dates. Please note that there are several data in same date. Thanks in advance

What is the behavior of using this method to export data to excel from access. This works fine, if I make 2 more Dim j and Dim k and use those for the 2nd and 3rd loops. I have to do this about 6 times more. But when the excel file opens the cells that the data goes into is all over the place...

I have a database tracking whether employees attend their meetings. For every meeting they attend they get paid. The attendance sheets get submitted by an upload form into my database as a Form with checkboxes for each employee. Now I want my VBA code to see that if the "AttndMeeting1" value is...

Hello there, I'm having a problem with inputting dates via SQL commands to my access database as they are getting changed to peculiar values. Background: The tool is a counter for the amount of work a person has done, each time the button is clicked the updated values are sent over to the...

I have a subform which shows the list of record .primary key is not assigned.i want to select a record from subform and want to click on a button called edit.it should open the form with the selected details.thanks in advance . suppose the subform name is" portdetails subform" and filed are l2...

Hi All, I am trying to Accomplish the following: Create a form that has a search function to search an item list but allow the user to also search through the item list using a bar to move up and down through the list. allow the user to edit only 1 column in the list (qty) list is stored...

Hi, I have two fields in my table if both of these fields values are "0" I don't want the record to show in my form but if it happens to be any other combination I do want it to show. I'm figuring it needs to be some sort of If statement but I'm not sure how to get this to reflect in my form...