Recent content by jcbnc

I actually had to change it back to the After Update Event because the On Change event only accepted the first character and the scanner would not scan a one character bar code. But it does work now...thank you for your help.

That is the ticket. I had If statement in the AfterUpdate event rather than the OnChange event. It is now opening a form but not the right one so, I have to figure that out. I think this might work...thank you

My customer is a tool and die shop. They receive a router document from their customer with 3 bar codes on it for each part they receive. The guys in the shop will scan a bar code to associate a specific job number for the part along with the other three bar codes. All the bar codes are stored...

Thank you for your quick reply Alfisdad. The scanner I have actually has a batch function included (it has start batch and upload batch bar codes) that I have been able to get to work successfully in my form. The challenge I am having is trying to use a barcode to run the macro that I created...

Hello All, I have a bit of a challenge with my Access 2010 database. I have a form set up to read barcodes and it works brilliantly with the wireless USB barcode scanner we have. However, my customer does not want a computer out in the machine shop and only wants the workers to interact with the...

What I posted in my last entry was a copy of the macros that were associated with the drop down field. This is not a web application or on SharePoint. This database is for a small Tool company and it allows them to track their quotes and orders that they deliver to their customers. I have...

I'm not sure how to answer that question. It is Access 2010, if that is what you mean.

<?xml version="1.0" encoding="UTF-16" standalone="no"?> <UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application"><UserInterfaceMacro For="Company"...

Apparently I am not allowed to post links yet.

Oh yes, I looked in the Customer table and the Customer name is quite gone from there. It is an empty field.

I am working on updating several forms I have. One has a dropdown field that allows me to select the customer I want to see, however, when I select the customer from the dropdown field it seems to delete the customer name from the customer table, which is in another database. Please...

Hello. I am relatively new to the Access design world and can use some help. I have a quote form that is capturing all of the customer information for the quote and I want to be able to put a button on the quote form that allows me to create an order utilizing some of the same data fields...

Thank you for your response. I am very limited in my coding skills, though very much willing to learn. See the response to your line items, below: 1) This response will cover both 1) and 3)...All the quotes have at least 1 line item, however, when there is only 1 it is not numbered like the...

Most of the line items start with a number and then a ) (i.e. 1), 2)) Can you please provide me an example of how to use what you suggested above?

Hello. I am pretty new to Access and could really use some help. I am in the process of converting an old 2003 Database to a 2010 Database and making some major modifications. In the old Quote table there is a field (memo) that has multiple line items (i.e. 1)....2).....3)....etc) and I wanted...