access

Im trying to find a way of exporting one row of data from a spreadsheet into a database in Access. I ideally don't want access to open in this process as it sometimes causes everything to not respond. I had though about a simply recording a macro to copy & paste one row into access but I think...

Hi, I am new to MS Access and have never used Class module in Excel VBA either. My question is more regarding Access, can anyone please help me understand what are class modules. How they are different from regular modules. What are the advantages of a class module or why and when should we...

I have been looking for my original post or the post that I think I thought was mine but was someone else's. Anyway, we have an access tool that someone else built. Each day I press a "Run All" button and 20 mins later I finishes and I continue. We are trying to have this run automatically a...

Thanks in advance for any help ! So I’m still learning VBA, using a combination of the macro recorder, this website, trial and error, and so on. I have a file, let’s call it “FILE A”, which has a number of worksheets. The file includes some code that pulls in data from a number of other...

I have an Access program file that manipulates files that are on my network/pc. When I work with an excel file for example, I want to have Access add that file to list of recent Items using VBA. That way, the file that I manipulated in Access is right there in my recent items list so I can...

When a Form is loaded is it also considered "On current" or does the user have to leave the form and come back to it to be on Current?

Greeting, I need to create a workbook which only has the first sheet visible to force the user to go through a process. On the first sheet I'm using the HYPERLINK function in conjunction with a VLOOKUP to create a variable hyperlink to multiple possible destination within the same workbook...

Let me start off by saying that I am very much a novice to VBA, Macros, Excel and Access. But here it goes. At work we have an Access database and an Excelmacro sheet. They work together and they were both built in a 32 bitsystem. They are upgrading us to Win 10 64bit and Office 2016...

Hi, I have below lines in my code. Dim MyOrig As Office.CommandBar Set MyOrig = CommandBars("Menu Bar") Dim MyMAIN As CommandBar Set MyMAIN = CommandBars.ActiveMenuBar What would be the alternative for 'Office.CommandBar' in Office 365 for MS Access. This code is written in older version of...

Is there a way to keep the navigation pane closed or keep users from accessing it without proper permissions?

I suppose this is the right forum for this topic, my apologies If I am mistaken. The story (introduction) Time came for some colleagues at work to get new computers. WinXP was obsolete by far. A new PC arrived with its own HDD and a not so old OS. The issue is: to transfer the files from the...

Hi I'm designing a database which has an Excel front-end and uses Access for data store. Each save from Excel to Access is a normalised table showing data for: A (one) Client which has 0 or more Jobs and where each Job has 0 or more Transactions If I need to reload previous saved states for a...

I have multiple excel files with several connections to a single Access database. The problem I have is that if more than one file is open at once no one can refresh the files to draw in the latest information from Access. Unfortunately, as these are used for forecasting the files there will...

How do I determine what is causing this error when I try to import into a brand new access db? It also occurs in other access db's as well. The file name is short and all together and the file size is small 120kb. Has no characters in the fil ename.

Hi, I am new to MS Access. I wanted to know, does Access support Pivot tables now. I am required to edit couple of existing macro. These macro has pivot tables in this. However, I guess, pivot tables are no longer available in Access. Please correct me if am wrong. How do I proceed if pivot is...

Hello everyone, Can you please tell me the best practice for importing SQLITE data into Excel? I want to create a pivot table for several users to access. I tried the get data from other source but doesn't seem to work

Hello, does anyone know if there is an easy way to import XML data and relationships into access? I am interested in working on a publicly available dataset (here: https://www.hesa.ac.uk/support/tools-and-downloads/unistats) but have only been able to import the xml tables - not the...

I have a database that prints out around 50 reports directly from my Access database. Just this week I've run into an issue with the printer settings. When I select Staple + Collate the settings will always automatically change to Staple + Group. I have the reports automatically printing, so I...

Can you close one form from another? I know you can close the form you're on by using DoCmd.Close , "". How do I close another form. I need to make sure its not open when I run code. Thanks

Hi, I have an Access Macro. In this macro, Microsoft Access 14.0 Object Library is ticked in Reference. I want to un-tick this reference. However while doing so I get pop-up as ‘Can’t remove control or reference; in use’. How do I find out what objects in my macro are related to this reference...