Recent content by tjr222

Thanks I appreciate the help, I got it working now!:)

Is there anyway to make an autonumber field begin at say 3000 instead of 1? I have tried searching for the answer in this forum, but no luck yet. Any responses would be appreciated. - T.

Thanks for your response, but my I think I already do have it related in that manner. I have three tables, 'Company' with CName as the key and fields address, city, state, zip, etc. Table two is called 'Invoice' with INum as key Cname as foreign key - related to company in a many to 1. Then...

Sorry I accidently hit submit before I was finished. I did post the completed version in forms and queries b/c I'm not sure where it goes. Thanks again for any responses.

Heres what I have: cboCompany - combo box that contains 1 thru any number of 4 - digit Invoice Numbers. (This depends on what is selected in another combo box) A subform that shows pricing information and is linked by the 4- digit Invoice Number...

Heres what I have: cboCompany - combo box that contains 1 thru any number of 4 - digit Invoice Numbers. (This depends on what is selected in another combo box) A subform that shows pricing information and is linked by the 4- digit Invoice Number...

Heres what I have: cboCompany - combo box that contains 1 thru any number of

I have two tables: - one is called invoice with fields, INum(key), IName, IDate, ICompany, IPONum, and ITotal. - The second table is called product with fields, PNum(related to INum many to 1), PDescription, PPrice. Since the tables are related on a many to 1, each invoince can have...

Yes I would Like to display the results just as another string. The string will read "contract awarded", and it should go in a field 'notes' on the subform. So, on the main form, after the user clicks in a checkbox, I would like the code to go to the subform (with same id only) and search the...

I have a main form and subform connected by the field 'ID'. I would like to run code that looks at a field 'Company' with the ID the same as the record that the user is on the main form. In otherwords sometimes the subform has 1 entry sometimes it has 20 entries, I would like to know if...

I have a form 'frmCurrentBid' and a subform 'frmSubCurrentBid', the forms are based on tables with a one to many relationship. The ID is the primary key in the main table and foreign key in the sub table. In the form 'frmCurrentBid' I have some general descriptive fields and a toggle box. In...

Is there any way to multiply two fields a number and a currency and have the answer be rounded up to the nearest 5. For example $41.50 would be $45.00 and $46.00 would become $50.00, etc. Any ideas on how to accomplish this would be appreciated.

Thanks for the response, however, I don't think I was clear enough on my problem. When the user enters a material that is not in the combo box (which is looked up from the material table) instead of saying that there is a conflict and this cannot happen, I would like for the new material to be...

Thanks for the response, however, I don't think I was clear enough on my problem. When the user enters a material that is not in the combo box (which is looked up from the material table) instead of saying that there is a conflict and this cannot happen, I would like for the new material to be...

I have tables called "Orders", "Inventory", "Materials" and the three are related with Inventory being the joing table of a many to many relationship. The database is used to keep track of orders and I have a material lookup so the user can easily select from what has been ordered. The problem...