Search results

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

That's ok--Actually I ended up integrating this with another function I found and it works out great. Here's a link to a question I had about that, and how I ended up solving it: http://www.access-programmers.co.uk/forums/showthread.php?t=159405

Well, I'm still tweaking it a little bit, but here's the general idea. First, I created a form and named it Pull Sheet. This Pull Sheet form will have 2 parts to it--one to find the part you want to ad, and one to show what you have already added. This form should be based off of the parts...

I actually figured out a way to make it work. Thanks!!

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

I'm not sure I followed that... Part 1 is one of the parameter query values I use. As in, that's the question that pops up in the parameter box. [Part] is one of the column names.

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

Well, it would be possible for me to put all of the data into one table, but I think my boss would be a little wary of doing so (he doesn't really understand normalization--he freaked out when I told him I'd split the original excel file up into several tables for the Access Database version)...

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

Yeah, that was a long day at work... =P I didn't explain it very well. Thanks for the tip, though! I've been looking at 3rd party apps and have been more or less unsuccessful (broken links, too expensive, doesn't work the way I think it will, etc...), but I'll keep looking. =)

*chuckle* I think we're on entirely different pages here. The thing with the scanner is this: I understand that the scanner will feed into the computer. The problem is that I need a customizable input for the scanner itself--one that can be customized for fields, procedures, etc, on the...

Hmmm. We don't need something that specific... We actually need something much more general, and preferably very customizable.

What kind of system and software are you using? And what for? Thanks! =)

Thanks for the response, but no, it doesn't. We've got an actual barcode scanner. The issue comes in where the scanner needs to be out and about in the warehouse, not hooked directly up to the computer. Then the scanner is used to gather information on parts in the warehouse, then brought...

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

*chuckle* Thanks! Actually, I've eeeeeeeever so slowly been learning SQL, so I solved this problem a while ago. ^_^

I tried using a macro for that, but for some reason it wasn't searching in the Inbound table. That's why I was hoping someone could help me with the SQL version. :rolleyes:

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

I realize that you can SET the number it pulls. What I'm wondering is whether you can have the user enter the number as a parameter. As in, when you run the query, it would say something like; Parameter: What part? _____________ Parameter: How many? _____________ And then it would return...