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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mcginnism

    Insert data to table with incremental key

    Can you explain how I would do it? I found this on the internet but I'm unsure about the values (9,0) what does the 9 and 0 refer to? alter table stores modify record_id numberic(9,0)
  2. mcginnism

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

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

    printing one record off of subform

    Well I looked around the forum and found some info on my problem. I know now that I have to create a report. But how do I get the report to show the info that I selected. This is how my database works. I have the following tables. Post inv, sign inv, work order. there is one post for...
  5. mcginnism

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

Part and Inventory Search

Back
Top