Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Insert data to table with incremental key
I have a two tables one with 4265 records and another with 670 records that are setup identically but with different data. The first table has a primary key. So when I try to copy the data from one table to the other I get a duplicate key error. So I'm trying to do an insert statement that...- mcginnism
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Report based on subform
I have a form with a subform. In the subform is a work order number. I would like to use the work order number in the criteria for a query. That way I can tell it to print a report in the form and it will print the report that goes with the form currently being viewed. I can get the report...- mcginnism
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
-
printing one record off of subform
I have a main form with pulls information about signs. Then I have a sub form that contains the work order information for those signs. I want to be able to print the form but only the current record. I tried print current record but what it does is it prints the current record of the main...- mcginnism
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
