Search results for query: *

I have an existing database that we are using to collect truck weights. We now have a truck scale that is capable of sending the weight electronically through the com port. Right now it is setup to send a continuous data stream on Com1. I want to display this data in a text box on a form and...

Thank you for the reply. The first solution did work, but I will give this one a try also. Thanks for taking time to reply

Thank you for the help. I will give that a try.

I need to fill in with lead zero's if the number is not 6 digits long. I am having trouble with doing this. SERIAL is the query field I want to have 6 digits. Below is the code to generate the correct numbers, just no leading zeros if less than 6 digits. SELECT tblProductTicket.ProductCode...

What is the best way to do barcodes in Access? I am currently testing BarCodeWiz ActiveX. Any other suggestions?

Thanks GOLOM

Thank you for your quick response. That will only produce one pallet number. I need to group the serial numbers also. The example I gave should produce four groups of serial numbers and 1 - 4 on pallet numbers. Thanks

I am pretty new to Access and I need some assistance. Here is my problem. I know what my beginning and ending serial numbers are, and I know how many cases per pallet. What I need to do is group my serial numbers by pallet number. Example. ProductCode is the relationship link between all...

Thanks for all your suggestions. This solution is closer. Here is a sample of the table the last solution generated. I cleared the table before I ran it. The starting values were: Product Code 1015020 BSerial: 890362 ESerial: 890475 This excerpt is from the middle of the table. It starts...

SELECT M.ProductCode, ( "A" & I.N+BSerial) AS Serial INTO tblSerialNumbers FROM tblIntegers3 AS I, tblProductTicket AS M WHERE (((I.N+[BSerial])<=M.ESerial)) UNION ALL SELECT M.ProductCode, ( "B" & I.N+BSerial) AS Serial INTO tblSerialNumbers FROM tblIntegers3 AS I, tblProductTicket AS M...

That doesn't work. It says Action-Query can't be used as a row source. But I does work if you leave of the Union and second select statement. It does add and A to the front of the number. I could create two queries and run them together in a macro. I think I can make that work. Thanks for...

I will probably have a few instances where there will be more than 100. Let me add something to this. Let's say I want to have an "A" and "B" serial number. Example A89330 B89330 A89331 B89331 A89332 B89332 How much trouble is it to add this as a prefix. It can actually be another...

I don't exactly understand how this works but it does pretty much what I wanted. I will work with it some more. Thanks for you help.

I have a table of product codes. I have another table that is populated by user input through a form. The user enters the product code, beginning serial number and ending serial number. I want to take that info and create another table with all of the entries. Example of user input: Product...

Good Tip, I will give that a shot. Thanks for the Help.

I am new to Access and need some advice. I have a database with product codes and other info in it. I have another db that I am populating everytime the user wants to print labels. The user is prompted for product code (this is my relationship field) and enters a starting and ending serial...