Search results

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.

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

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.

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

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

I used a date and time picker control in a form in MS access. It is used as a drop down calendar for a date field. The problem is that this dropdown calendar does not show up at all in the datasheet view. It works fine in the form view, but when I switch to datasheet it disapears. Please...

I am using the MS date and time picker control to get a drop down calendar for a date field within a form. When I look at the date field in form view everything is correct and works normally. However, when I change to datasheet view the date and time picker control does not show up. Is there...

I am running Office 2000 professional on three computers connected to a LAN. In access I inserted the Microsoft Date and Time Picker Control, Version 6.0 for a few date fields on a database that keeps track of orders made from suppliers. The problem I have is that one of the three computers...

I am trying to get a calendar drop down box to connect to three date fields that I have in a form. When I am in form design view I can insert an AxDate Control with the drop down calendar. The thing I can't figure out is how to connect it to my three date fields, "order date","ship date" and...

I am trying to link two different fields in a table called 'Customers'. The first field is a zip code and the second is a city name. I have a list of cities and corresponding zip codes in another table which I have linked to each of the two fields in the 'Customers' table. What I would like...