access

Is there any way to see who may have accessed your spreadsheet? (Tracking not turned on). Someone may have messed with it.

i tried my hand at access, i have "0" experience with it, but tried nonetheless.... i have a database set up but it doesn't do what i thought it would. is there a way i can upload it somewhere and request help fixing it?

I have an Access DB that can (in Windows10) get data from a GPS receiver assigned to a com port. The organization has decided to upgrade our computers to Windows 11, now Access/VBA no longer understands the data coming from the GPS receiver. I am adding an image showing the "data" Access sees...

I have an Excel Sheet that holds a Table (Table named "PST_2" ) that I need to append to an Access Database (DB named "STATS.accdb"). I need to do this while the user has Excel open, and without opening the Access application, as some users may not have it. I know how to initiate appending...

I want to make a program that tracks which station each of my projects is at using barcode scanners. My small business deals with putting certain lots through certain stations, kind of like an assembly line but the line is a snake that wraps around it self a couple times over and ties itself in...

Hi, Firstly, thanks for taking the time. I am extremely new to Access, so hopefully this makes some sense. I have a table with some address details and I want to generate a Unique ID (either in the ID field or a new field) which relates back to the initials entered into the "State" field...

Hi everyone, Just wondering if anyone can help me out here, I'm thinking of ways to make an inventory system for our machines in warehouse. To be specific, inventory system for our consumable parts for our plasma cutters like, nozzles, caps, etc.. Would it be easier to use excel VBA for this...

Hello, Mr. Excel users! Excel w/ VBA are such a great duo when used in tandem. It seems one is able to lock out all use of Excel via VBA events and also use Auto_Open() to bypass the application.enableevents if it set to false. However, the one issue I am running into time and time again is that...

I am very curious in comparison between Access and Excel the security differences in each. Without the advent of quantum computing, I understand getting into a binary excel file that has a 255 character password is nearly impossible. However, in contrast, ACCDB is clearly not binary format - nor...

I have a form which is used to add measurements taken from various instruments. Because some instruments have different parameters and even a different number of parameters, I figured a subform was the way to go. As the parameters are specific, it is important to ensure that these are entered...

Hello Team, I've been struggling with this all week, and am running up against a deadline to make this work for my team. Here are the essentials: The MS 2021 Access DB sits on a SharePoint Server; The SharePoint permissions have been granted to Everyone; The code updates with a new record...

Hello. I am trying to automate the following. I need to update Query 1, 2, 3, and 4 with a dealership ID #. So instead of opening up each query and entering the dealership ID #, I was wondering if there is an easier way of automating this. I used to use [Forms]![Form1]![dealerno] but this is not...

I am trying to connect to Microsoft Access using ADODB.Recordset in VBA, but apparently it seems to only accept alphanumeric table name. Changing table name manually in Access is just additional work (and I need to teach it) for the macro user, so it would be great if it can work without doing...

Hello friendly helpers, I have run into a problem when looping through Access queries via VBA. I have multiple levels that I am looping through; the first table (query) consists of unique project leaders, I then loop through these to find associated projects, after which i loop through the...

Hi all Situation: I'm extracting an Access query to Excel with VBA. In this excel, I let VBA do a few things like formatting the cells. I made the code work and the sheet looks good, but I'm not sure if it's all versions proove. For my code I have put a check in the references at 'Microsoft...

Hello, I've built this query on Access, there's about 13 tables linked. The total size of the db is only 2.3mb. The largest table has 14k rows and 70 columns (but not all of them are being used). So it's not huge and mostly runs pretty quickly when i run the query, but then when i add 3 more...

Hello, I have Excel spreadsheets linked to my Access and I'm using DCount formulas in a query. When i run the query it takes like 5+min for the query to finish and Access is completely unresponsive during this time. Is this typical for Access? Is there a way to make this faster? Thank you.

hello. I am trying to do the following. Within Access using VB to.... 1. open up an excel file 2. copy and paste special (the exact same data to the exact same tab) ... just removing the formulas 3. save the file with the same name (skipping / don't want the excel prompts to display....etc...

Hey guys, I have the following codes in a database but some of them have been inputted lowercase and not in uppercase, so wondering how do I make a query to display only rows where the codes are lowercase? Help with example code would be appreciated.

I'm in need of a report that can show info from multiple unrelated tables, basically I need to combine all sales with the pickups and payments for a person I select and be able to print it all off, all my information is stored where it has a buyers name column I should be able to use, but I'm...