Search results

Hello Everyone, I'm struggling with duplicate items in a query and completely stumped as to why it's happening. I have walked away from this issue for a week and came back to it yesterday and today and I'm still as frustrated as last week. We have a vending business and track a lot of...

I've never had to do this before and my brain is not processing how to get this to work. I have a query that pulls information based on criteria from several tables. Then I have a simple report that populates a list of information from the query. Now I have to change the report slightly and...

Hi Everyone, 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...

Hi Everyone, 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...

Hello Everyone, 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...

Hi Everyone, 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)...

Hello Everyone, 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 Based on...

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)...

Hello Everyone. 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...

Hi Everyone, 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...

Hello Everyone, 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...