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

append and delete Thanks for the information, but how do i set my code to append the current record? Thanks in Advance! Tim

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

Form Help!!!! Thanks for the information Steve! Will this work on one record at a time, that is what i want.

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

Search form help i set the data entry to yes, then my form does not work. When i select the name in the search my form does not fill the fields with data.

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?

Sorry but i do have a PK in tblboats, i forgot to list it. my tables are as follows. tblcontact CustomerID-PK Customer Contact tblboat BoatID-PK CustomerID-FK boat Serial when i use a form with a combo box to fill the fields by selecting a customer all works fine. Can you please tell me how i...

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

Search or find what do you mean by normalize? Thanks, Tim