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

    Locked out of a table

    I have a database designed by a person who is now gone. They made the the front end integrated to the table so you can only access the table from the front end. If you try to open, query, or build forms on the table it gives the following message: you do not have the necessary permissions to...
  2. dmatlock

    database wont let me access table

    I inherited a database that was configured with nice forms. Now I need to get into the table to extract data in a new way. Any time I try to query or open it I get a message that says I don’t have access. I understand that it was build to be accessed only through the forms that are already...
  3. dmatlock

    totaling a calculated field on subform

    I have a subform (parts ordered) on the mainform (PO#). On the subform there is cost each and qty ordered. I have a unbound control (extended cost) with cost each*Qty ordered on the subform. Works great until I try to add all the extended costs together. I can sum the cost each or the...
  4. dmatlock

    emailing report

    I have a report (a quote, one record based on a query) that we need to email and/or print. Printing is fine, but when we email it we loose too much formating. The logo is lost as are the lines and boxes. The only options under "send to" are rtf, html, Snapshot, and text. Snap shot...
  5. dmatlock

    duplicate a record with few updated fields

    These things are so complicated that it is hard to get all the details in without writing a book. The subform is not a query, but a table linked to the main form by Order ID (or quote ID for the quote tables). When an order is pulled up, the parts that are associated with that order by order #...
  6. dmatlock

    duplicate a record with few updated fields

    I have a form "quote log" made on the "quote log" table. It is linked via 'quote number' field to "quoted parts" table and subsequently the subform displays quoted parts. If you manually enter the parts into the subform everything is wonderful. The intention is...
  7. dmatlock

    Finding a record that already exists

    I have a similar situation. It has the equivilant of your contributor linked in relationships. I have the contributor as a pulldown in the form. When the user selects the contributor it automatically updates a subform within the main form, pulling up that contributors information (information...

Part and Inventory Search

Back
Top