Search results

  1. W

    Solved Append Table and Auto Number Help

    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...
  2. W

    Solved Add Data Based on "Start" date forward

    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...
  3. W

    Solved WHERE with multiple options

    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...
  4. W

    Solved Filter a List Box

    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...
  5. W

    Solved Query not accepting Form Value (multi Select List)

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

    Solved Form/Query/Subquery Not working

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

    Solved Crosstab Query with Form Input?

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

    Solved Form Validation and Form-to-Form data

    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...
  9. W

    Solved Yes/No in Tables and Option Group in Forms

    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...
  10. W

    Hello from Minnesota!

    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...
Top Bottom