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