Search results

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...

Thanks that worked well. The only problem I have now is that when I open my "Current Jobs" it is automatically at the most recent job and not in a "new entry." It therefore overwrites whatever is the most current job which is where the curser is. So do you have any ideas of how to add to...

Is it possible to transfer data from one or more cells of a record in one form to another existing form, simply by checking a yes or no toggle box that relates to the record that will be transfered or copied? For Example: I have to forms Upcoming Jobs and Current Jobs. When the upcoming job...

I have two forms in a database which share three similar fields, "bid name" "bid location" and "bid date". They are designed to display jobs to be bid, and jobs that are currently bid and waiting results. The "to be bid" form is based on a query and has a yes or no toggle to indicate if the...

I have a form that acts as a switchboard. In the onclick property of each button I have two actions: 1) Openform in the view (form, datasheet, etc.) I want and mode (add, edit, etc.). 2) Maximize Eveything seems to work normally and when I click on a button it will open the correct form...

I have a switchboard which links to several forms in my database. I would like to be able to control the way each form opens. For example on a form called 'orders' I would like to have it open in datasheet view and be as large as it can be. I changed the 'orders' form default view to...