Search results

i have a rental database. i would like to make a form, which would ask the user for a date. After the date is entered have a button which would run a query and then print a report. How can this be accomplished? Thanks in advance! Tim

I have a 2 identical databases. One named customerrent and the other customerhistory. Both databases contain related tables. tblcustomer tblrent What i would like is a button on my form to archive the current record, to the customerhistory database then delete that same record from the...

I have 2 databases which are mirror images of each other. one db is named rent and the other is named renthistory. in the db i have 2 tables, tblcustomer and tblradio. i would like a button on my form to append the current record to the renthistory db and then delete the current record. how can...

I have a database with several tables and relationships are set. Example tblcustomer tblradio i also have a history tables setup historycustomer historyradio i would like a button on my form to perform an append query to the history tables and then delete the records in the active tables...

I have a search form based on a query. the form works. i would like the form to be empty when i open it, how can this be done? Thanks in advance! Tim

i have set up a rental program with several tables. i would like to make duplicate tables to copy the data to and use them as a history table. after the data has been copied to the tables i would then like to delete the records in the main data base. how can this be done?

i have a db with several tables. tblcustomer CustomerID=PK tblshorebase ShorebaseID=PK and CustomerID as FK tblportable ShorebaseID=FK i built a form using the tblcustomer. i then built a tab form using tblshorebase and saved it. i then opened the customer form and inserted the tblshorebase...

I would like to have a button on a form to print the current form. Is that possible? how can this be done? Thanks in advance! Tim

I have uploaded my DB. Can someone please check it out and give any pros and cons on it. The company i work for rents equipment to its customers. On Rig rentals we use lots of equipment, so would using popup forms be better or Linked forms?

I have 2 tables. tblcontact and tblboat. tblcontact CustomerID-PK Customer Contact tblboat CustomerID-FK boat Serial i have made a form to enter the data, all works ok. I built a form to search by customer and it works fine. I can not find a way to build a form to search by boat name or...

i have 2 tables, table1 and table2. table1 CustomerID Customer Contact table2 BoatID CustomerID Boat Serial I made a form to input the data, all works ok. i also made a form to search by customer, this works ok. I i make a form to search by serial or Boat, it does not work. I have a...

I work for a communications company. We rent comm equipment to customers in the offshore oil field. Some of our customers want there rentals under one RentalNumber. Most of the customers want different RentalNumbers for each rental. The Rental locations are Rig, Shorebase, Liftboat and Boat...

I have 2 tables Table1 and Table2 Table1 CustomerID-PK Customer Contact Table2 BoatID-PK CustomerID SerialNumber i have the relation setup with CustomerID one to many. i can setup a query and with a combo box on a form select by CustomerID and all works fine. How can i setup to select by...

I have 2 tables tblcontact and tblinfo. tblcontact contactID-PK Customer Contact tblinfo infoID-PK PONumber location I want to build a form and have a combo box autofill these fields on the form. how can i do this? Thanks, Tim

i have a table with the following fields. customerid-PK Customer vessel1 radio1model radio1serial vessel2 vessel2model vessel2serial how can i build a form to do a search on an individual vessel? can someone give me an example? Thanks in advance! Tim

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

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

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