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