Recent content by neileg

Essentially, bar codes are just Fonts and if you print your labels with the right font set for the relevant data, it will print as a bar code. There are different bar code standards so make sure that you get the right one. Some bar code standards may require particular data formats and...

Append the User IDs from the fresh data to the Username file one field at a time. Either make the User ID field your PK or set it as index, no duplicates so that any existing User IDs are not repeated. Then look for fields with nulls in the UserName field.

Create a query with the two tables and join the tables on venueID and FacilityID. This will enable you to retrieve the price. If you want to store this in your events table then convert the query to an update query.

Still don't understand. You're using Nz so any nulls will be converted to zero. Do you want to check if any field is null or indentify which field is null and what do you want to happen if there is a null?

Dunno what you're trying to do. You seem to have double Nz functions in two places both of which are missing a closing parenthesis. The additions inside the parentheses will return a null if any of the values are null, so I don't think your formula is going to give you what you want. You may...

Why not buy a scanner that populates the keyboard buffer (this one might do this)? Whatever software you use, including Excel or Access will see the data as if it was typed in.

Some general advice: When you want to sum any values there are two common things that go wrong - you have a text datatype in one or more of your fields or you have a null value. Val() turns text into numeric and Nz() turns nulls into zeros. That's why they've been suggested. There is an...

Why do you want to store the max? You can calculate it any time you want with your query.

Why not install a pdf printer driver, CutePDF or similar? This would work with any version of Access.

There's a possibility that the sales rep is linked to the region and all the other geographical characteristics are derived from the region. I don't think we have enough info to judge this.

I would do this in a form. You can't do it with table level validation.

vbaInet, I think it's easier to use a parameter query than VBA to filter the list.

Sorry, I don't do A2007! Stock management, inventory, call it what you like, it is a deceptively complex area.

Ok, let’s have a look. A couple of questions first. If you have a range of standard papers then you should have a table that identifies these. Is that the case? Does it really matter which PO relates to the paper where you use it? I suspect not if your paper is standard then one batch will be...

Although a purist may hold the VAT rate with its effective dates and do the calculation on the fly, pragmatists will store the amount of the VAT with the transaction so that historic data doesn't change.