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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mcginnism

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

Part and Inventory Search

Back
Top