Recent content by Edy

Can you please expand on the explanation? Sorry, I'm an Access/VBA/SQL novice. The form is unbound to let the INSERT command handle all the data entry? Is the INSERT command an SQL command or is it built into VBA? Thanks.

Maybe my concept for this table is incorrect, so I am open to suggestions. I am making something like an asset tracking database. The table is an inventory of items, each with a unique auto-generated serial number so they can be checked in and out of storage. I am populating that table with a...

I have a form that fills in information in a table. It currently creates one record at a time. Is it possible to have the form create multiple duplicate records in the table based on a quantity input? The primary key would, of course, be different for each new record.

Thanks plog, that worked well. I ended up having to use auto number for this because it was the easiest way to auto-generate a unique serial number for each entry.

Technically, It's not spitting out the correct value, ABC0000123. It just looks like it is. The number being spit out is 123, Access just formats it to look like ABC0000123. Unfortunately, the program I am trying to send this number to doesn't read the formatting and only receives the 123...

I have an AutoNumber that is formatted as "ABC"0000000. If that auto number is the number 123. It displays as ABC0000123. However, the actual value stored in that field is 123. How do I get that field to actually be ABC0000123? Or is there a way to export it as such? I am trying to link it...