I need help moving data into a table and I'm going crazy because no matter what I try it doesn't give me my desire results.
I have 322 records in an Excel file and the records are currently sorted in Ascending order by a value called ComplexID. This ID matches a bunch of other...
I'm trying to automate a process I currently do manually and need some help.
For vending machines, we track all the money in/out of the machine. I am specifically looking for our "CHANGER" machines. These are the one-to-one coin machines that return money, example, something you...
Hi Everyone, I'm struggling with creating a string that's being used to create a query.
Couple of quick notes...
strList - data comes from earlier in the code.
SrchDate.Value exists and has been verified before the below code happens.
sDate1 and sDate2 have been previously defined in the code...
I have an unbound form that pulls up a list of vending machines. The user scrolls through the list of vending machines, or searches using a search box (search as you type), finds the machine(s) they want and then clicks on the button for Run Report. It took a while but I finally...
Wondering if anyone has any ideas on a couple of issues I'm having. First, I'm using Access 2000 so some of my functionality is not where the newer versions are at.
First, I created a simple Form using a combo box that asks a user to select a machine. The MachineID (autonumber)...
I am hoping this is a simple solution and it will be one of those DUH moments for me. (using Access 2000)
Here's what I have.
Query # 1
Finds information based on 3 different tables using MachineID
I have been manually adding MachineID then I save the query.
Query # 2
I'm not sure if this is possible, but I would appreciate insight into a problem I'm having.
Note, I'm using Access 2000.
Query # 1: qryProductsSoldExpired
This is a basic query that pulls information from two tables. The first table has all of the sales data (sold and expired products, etc)...
I've run into a couple of issues and from all my reading and watching of tutorials I'm guessing I need to write some code to get to where I want to go. I could really use some help. (note, I'm using Access 2000)
I have a simple unbound data entry form (FormA) that collects this...
Not sure if I did this correctly but I could really use some help ,thank you in advance! I apologize for writing a "book" but I think I need to explain what I'm doing in order for you to provide me with the help I need.
I am using access to try to automate a vending machine...
I am a new Access user, trying to learn the program via YouTube, Reading and Online Help.
I have dabbled in Access in the past but I'm now using it to try to "update" a company I started working for recently. They do everything using Excel spreadsheets and manual record...