Search results

This database concept is giving me way more trouble than I thought it would, so any help you guys can offer would be most welcome. Overall concept: We're creating a database that will allow our sales team to select the options specific to a product they are trying to sell and have the database...

I have a table with a date field that I'm building a query for. It has dates in this format: 4/17/2009 10:40:03 AM 4/17/2009 1:25:37 PM (m/dd/yyyy h:mm:ss AM/PM, I think) I would like the query to ask for a date and have the query show all records from that date. However, because of the...

I have this line: [HP] = Int(([HD] * Rnd) + 1) It creates a random number between 1 and the number in text box [HD] and puts that number in text box [HP]. I created another box, [LvlChar], and would like it to add as many instances of code together as is the number in [LvlChar]. IE, if the...

I have a database that holds all of the product in our warehouse. What I'm working on right now is how to, using one form, log a location change from one location to another. I haven't solidified exactly how this part of my database is going to function, so I'm open to all suggestions. I'll...

I have a form with a bunch of text fields that the user fills in information for. Now, depending on the company the user has selected on the splash page, certain fields are supposed to be disabled. I have a dlookup on the onCurrent event and it all works just fine, EXCEPT! There are like 4...

I have a database I'm setting up with two main functions--Entering new receipts, and entering new shipments. For the new receipts, I need a way to be able to enter new parts. For both new receipts and new shipments, I need a way to be able to enter a new order number and a new truck number...

I'm aware that there is already a looooooong thread about creating an audit trail. Here's why I'm posting this new thread. First of all, the audit trail I have set up (yes, from the thread mentioned above) is only saving the first couple of lines of data--244 characters worth, I think, in the...

I'm not even sure this is possible. I have a query that, assuming the needed data is there, finds the highest number from a list. Easy. Here's the hard part. I can't figure out how to set an automatic first number, just in case there isn't one already there. I THINK I need to use an IIF()...

I have a table with the following information on it: ID Number; Part Department; Truck Number Each ID has one of 3 Part Departments, E, P, or H. There are several ID numbers associated with each Truck number. Here's a sample of my data: The pink and purple shaded areas are both from...

Okay, so here's a monument to my naivety with SQL. What I'm trying to do is a little complicated, but I'll try my best to explain. Upon filling in an ID number in a form, I want two pieces of data to automatically update: The Part Name associated with given ID, and the quantity remaining for...

I'm building a form to enter new receipts. In order to normalize all the data, each line in the Inbound table is linked to a separate line in the Trucks table by a truck number. When I open the receipts form, I want a message box to pop up asking if this will be a new truck number. If the...

I know this forum is for access, but my boss wants us to keep using our excel spreadsheet for our inventory until the database I'm building is totally done and error proof... He wants to try and create a way to track when product gets moved, so he made a sheet in the excel database to log moves...

I have an inventory database that has a whooooole lot of part numbers. Every day, we get orders for particular parts. Originally, we would create the pull sheet by using a query based on the inventory, and then a report based on that query to make it look nice. The user would type in the...

Okay, so here's what I'm going for. I have an inventory database that has a whooooole lot of part numbers. Every day, we get orders for particular parts. We create a pull sheet by using a query based on the inventory, and then a report based on that query to make it look nice. The query...

I've got several different inventories broken down into several tables for normalization reasons. I was working on making a separate database for each--just copying all the queries, forms, reports, etc... and then importing the data for that customer from its original excel file. The thing is...

I'm having some trouble with this, and I figured maybe someone can help me out if they have something similar already. We have several custom-built access databases for our warehouse's inventory, one for each customer. My boss wants me to figure out a way to get the barcode scanner he bought...

I've got a report that uses a user-entered parameter value to bring up a report on an OUTBOUND truck. It works just fine for outbound trucks--the thing is, the truck numbers vary between inbound and outbound, and there's no pattern to it. What I would like to be able to do is this: On NoData...

Alright, first off, I'm not even sure this is possible. I'm working with Access 2007, too. I have a report that is based off of a very simple query that requests a part number. I know you can select a particular amount of records to be returned in a query (All, 5, 25, 100, 5%, 25%). What I'm...

I have a query that, for the most part, sums the data for any given Job Number. My problem is that 9 out of 10 of the job numbers are the same--9 pallets all with the exact same parts with the exact same quantities... And then the 10th is an oddball. So when I run my query, I get a summary of...

I have several macros in a database I was creating with Access 2003. My boss switched us all over to the 2007 version, and now I guess you can't use the SetValue macro option in the same way. I was using it to set a field in one form to match what was in a field on another open form. Now it...