Recent content by Nano

Yes I have, and there are nearly 1,500 records/ items labeled with them. The "vertical lines" as you say are interpreted by a barcode scanner into a set of numbers and/or letters on a computer. I have programed my barcode printer to print them in these formats (BC-SD###) or (BC-R####). If you...

Hello, I am seeking a tip on how to add a function to my database. Currently I have a database to track materials for manufacturing. One table holds the raw materials and a different table holds the finished goods. Each has a different barcode indicator for example raw materials would look like...

I have it working now, I used the idea above. Thank you for the help

pbaldy I tried your code, but it still didn't work. So I am going with my back up plan, as I don't have much more time to work on this. Yes I know this is bad coding, but I created a few different queries with the filter for each possible outcome of filling out the combo boxes. I have tested...

Here is the full SQL code: (Note: I have changed the names of the fields to protect the data) SELECT [Product Table].[Product ID], [Product Table].Barcode, [Product Types].Model, [Product Types].[Color Group], [Product Types].Size, [Product Table].[%], [Product Table].Solution, [Product...

No I can't, it is for my job and has too much private information to wipe. I am sure I can figure it out with iif statements eventually. Although it would be a whole lot simpler this way. Thank you for trying.

No sadly it is still not working. I might have to try something else like an iif statement.

Yes the form is open when running this query. Ok, I will fix that part, that is likely my problem.

Ok here is the code I pasted in in the SQL view to replace the old "Where" however now it is prompting me for it type of data rather then looking at the form. Do you see a problem with my code? WHERE ([Forms]![Imput CSG]![ModelCB] = ModelCB OR ModelCB Is Null) AND ([Forms]![Imput...

Well maybe not, now it brings back all of the records even if it doesn't meet the other criteria

Thanks works great!

Hello, I am working on a query that uses 3 combo boxes in a form to use as criteria in a query. As it is private data let’s say the combo boxes are “Model”, “color” and “size”. So far I have been about to query data if all three combo boxes are filled out correctly and matches a record. However...

Thanks I think, I appreciate your advice but you don't have to say it so rudely. :( I know I am a novice when it comes to Access which is why I ask for help here.

I guess something like this. Unless you have a better idea on how to store the DOI codes. (This is just a sample, I am not using this table for the finished product.)

Sorry, I am sure that I am breaking some of the rules for database design. The table I am using was made when I imported the data from a excel document someone else created. I have attached a picture of some of the Authors and DOI (I hid the other fields for now as I don't need them.)...