Search results

i have a table with the following fields. Customer Rig Vessel0 Vessel0serial Vessel1 Vessel1serial How can i do a search for a particular vessel when every customer will have two of them? Thanks, Tim

Can i show and hide fields on a selection in a combo box. I have a combo box with four selections, iDirect,Microwave,DRT,Globalstar. All these selections have text boxes for serial number of the equipment. when a user selects Microwave, i need to show two fields for microwave and not just one...

How can i use a check box to show or hide a field on a form? Thanks, Tim

Archive records Hi Wayne! Thanks for your input. I do have an archive table. when i say i dont want it to show in the active table, i dont want it to show up on my form. My tables are set up as tblrent and tblarchive. thanks, Tim

Happy New Year everyone! I would like to archive a record from a form with a button. With this same button, i would also like to have code to some how flag the record so it does not show back up in the active table. How can I accomplish this? Thanks, Tim

insert into another table Excuse my question, i am new to access. what is the bookmark method? Thanks, Tim

insert into another table I will be using table1 as a reference table only. My form will use this table just to pull up the customers with a combo box. Thanks, Tim

i have 2 tables ?(table1 and table2) In table1 i have Customer,Contact,address etc. in table2 i have the same fields with an additional field called rig. I want to use a form with a combo box to autofill the customer info and on that same form have the additional field (rig) manual input. then...

Works great Thank you for the information, but it does not store the information from the customer. how do i do that?

Hi Everyone! i have a database which i have uploaded a copy of. i have a form to enter customers and a main form with a subform. In the subform i have a combo box, but it does not fill the contact field. can someone tell me what is wrong? Thanks, Tim

I have uploaded a small db. I would like to setup a form with a combo box on the field Name. From this combo box i would like to have the other fields autofill. Thanks, Tim

Sorry here is my file, please tell me what is wrong Please look at the file and tell me what is wrong

I cant get my form to autofill. can someone check my file and see what the problem is?

Hi Everyone! I have a database with 2 tables. One table is Contacts and the other is rent. I would like to build a form and have a Combo box to select the Customers and auto fill their information. On that same form I would like to also have the fields to be manually filled for the rental...

i have a database i called rent. It has one field in the table called rentnumber. i have made a form called rent with a button to insert the next rental number. this is my code to generate the next number. Private Sub Command4_Click() Me![rentnumber] = DMax("[rentnumber]", "[tblrent]") + 1 End...

i need to generate a rental number Thanks for the reply, but i have read about duplicate numbers being genrated that way. This is going to be a multiuser database and i fear 2 people generating the same number. Thanks Tim

Hi, I have a db and it contains one table and one form in a multi user enviroment. I need to generate an incrementing number to be used as a rental number without having duplicates. Could anyone suggest the best way to do this? Thanks, Tim

one tabel many forms Yes, one company can rent several pieces of equipment. Any help would be greatly appreciated. Thanks, Tim

one table many forms We rent radio equipment to petroleum companies. all i need is a single table, but i want to use a form for boats, one for the shorebase and one for the rig. there will be more than one user for the database. i will call the table (rent) and the create the forms from it

I am setting up a database with one table and 4 forms. This database will be a multi user database. I would like to know the best way to generate an incrementing rental number. How can i set it up so users dont access the rental number at the same time? Thanks, Tim