Search results

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

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

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;

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 been working on my database (a lot of cleanup and fixing things to get everything normalized and now I'm back to working on things I need to get up and running. So I am creating a data-entry form for end-users to input the money collected from vending machines. The company...

Okay, I have made progress but still need a little bit of help. 1. I was able to get the validation to work, thank you missinglinq. 2. I was able to get the OpenArgs with the Split function to pass the data from the first form to the second form. I no longer open the Query - things are working...

Thank you missinglinq and sneuberg for the information. I am uploading the test database I use before implementing things in my working database. It gives a small sample of what I'm working with. Validation Code I added the validation code to my form but something is not working. I get a...

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

The_Doc_Man, I was able to get this to work. Thank you for your suggestions. Now on to more tasks. Baby Steps!

The_Doc_Man, thank you for your reply. I actually started this project about nine months ago. It's a new industry for me and I realized very quickly I was going to have to work slowly on this project. I started with one table to solve one issue; how the company identifies the machines they own...

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