Search results

In our quest to update/improve our current database I am looking for thoughts on best practice please. We break things into three different categories: Machine, Property, or Management Company, and I track everything in one table (below) tblService. The reason it was set up this was because...

The company I work for is in the midst of a sale and the new owner wants to utilize the Access database I've created. However, as part of the purchase agreement, he only gets access to some of the records. With this in mind, I'm creating a new database, a large project but also a great chance...

I am doing some database updates and would appreciate guidance from others. We have a table that records basic details (id, name, address, city, etc..) about a location (tblProperties). Within this table we have a field called PropertyName - this field can represent an apartment complex name...

Hello Everyone, I have a database used in a vending machine business. If I'm told about a location's attributes I put the information in notes field associated with the property. Unfortunately this is not a very useful way of doing things. I cannot easily find data on the 250+ different...

Hello Everyone, I'm struggling with duplicate items in a query and completely stumped as to why it's happening. I have walked away from this issue for a week and came back to it yesterday and today and I'm still as frustrated as last week. We have a vending business and track a lot of...

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

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

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

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

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

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

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

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