Search results

  1. W

    Solved Append Table and Auto Number Help

    Thank you DBguy, it finally worked. No idea why it was being so darn stubborn but I duplicated the column as you suggested and it finally all went in correctly. I appreciate your insight.
  2. 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...
  3. W

    Solved Add Data Based on "Start" date forward

    Thanks Doc Man for your reply. Yes, you are correct. Each CollectionID and CollectionDate coincides with paper-money in or coins-out. I think I understand what you're saying, but I'm not sure we could dump the old records. It's certainly something I had never thought about, I'll ask our owner...
  4. W

    Solved Add Data Based on "Start" date forward

    plog THANK YOU! This worked perfect. I greatly appreciate your help. Now to work on creating the rest of the queries I need based on other tables that have this same type of START indicator.
  5. 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...
  6. W

    Solved WHERE with multiple options

    So I deleted everything and retyped it, must have been missing something, not sure. This now works with the dates changed to strings. Thanks everyone for your help! strWhere = "WHERE qProducts_MachineCheck.MachineID IN (" & strList & ") AND qProducts_MachineCheck.FillWeek Between #" & sDate1 &...
  7. W

    Solved WHERE with multiple options

    Micron, they either have to select one machine or several machines for the query, we have over 700 machines so we don't want the report for all of them. We are trying to narrow down the data to only what is currently needed.
  8. W

    Solved WHERE with multiple options

    CJ_London, thank you for your reply. I think this might be the issue. Here's the code I'm using to get the dates. I'm not great at VBA so this may not be correct, but it does give me the dates I need. I used a MSGBox to review the WHERE code for my string and it "appears" correct but it's not...
  9. W

    Solved WHERE with multiple options

    Thank you Plog for your reply. That was a typo on my part, the Select is FROM qProducts_MachineCheck.
  10. W

    Solved WHERE with multiple options

    Micron, thanks for the reply. I do need the IN because it's possible to have multiple machines I'm searching for. I will try your code and see if it works, thanks.
  11. 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...
  12. W

    Solved Filter a List Box

    Thanks for your reply. I'm trying to normalize my database as much as possible and avoid redundancies, so I was hoping to just filter the one query I have. I appreciate the feedback and will look into this option. I suppose it wouldn't be too difficult to rewrite the code I have to work this in.
  13. W

    Solved Filter a List Box

    Thank you, I'll have to look into that. I've not thought about it. Will it allow me to make selections of machines to run the report I need is the question. Sometimes I'm choosing one machine, but often it's several.
  14. 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...
  15. W

    Solved Query not accepting Form Value (multi Select List)

    Thanks Bastanu and Arnelgp. I am looking into both solutions. I appreciate your assistance. I don't know if it's because I'm using Access 2000, but DAO.QueryDef and QueryDef is not coming up as a valid in my VBA code during compile. I'm going to see if I can figure this part out.
  16. W

    Solved Query not accepting Form Value (multi Select List)

    Thanks for the reply's. At this point I'm only opening the query to test the functionality and make sure it works. When I know it works then I'll take the time to create the reports that the end-user will see. Right now I'm in the testing phase. When I do the single machine using a combo box...
  17. 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)...
  18. W

    Solved Form/Query/Subquery Not working

    Well, I figured out the problem. Query 2 is a crosstab query and I didn't have the parameters set, I added the following to both queries and now it works. Thanks for your replies...looking at my SQL helped! PARAMETERS [Forms]![frmMachineProductTotals]![MachineID] Short;
  19. 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...
  20. 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)...
Top Bottom