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 Wanet Telecoms Ltd 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: *

  • Users: jrmiv
  • Content: Threads
  • Order by date
  1. jrmiv

    Field with both Text and Number

    I have a query pulling results from an ODBC table where the field has both numeric and text fields. I want to exclude the text lines. (not like a number) because my next query links by this field to another table which is a numeric field. i.e. line 1 = IPP (want to exclude this line from...
  2. jrmiv

    Synchronized Form

    I have a data entry form (primary key is CRR which is an autonumber) which is fed into a table called ComplaintDocument. This information is then researched and entered into another form called ResearchDocument (which references the CRR Number from the ComplaintDocument). I have a query that...
  3. jrmiv

    Auto Populate Form from Data in Table

    I am new to dealing with forms and need some help to autopopulate the form based on a table. -CRR Number is an autonumber. -Date submitted is today’s date. -AcctNbr, Submitted By, Invoice Nbr, Invoice Date, Order Number, Comments_Complaints are Input Fields -Order Type and Line Type are...
  4. jrmiv

    Delete Records from Table then Append with Autonumber

    I need to delete the records from a table before appending the new results. The table has an autonumber which also needs to be reset. I am currently having to manually delete the records and then compacting and repairing the database to reset the autonumber. Any help would be greatly...

Part and Inventory Search

Back
Top