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 Chris Miller 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
  • 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

    MajP, I have fixed the problem with a double click event that when I double click on the "CRR" Field in the Complaint Form it opens the ResearchForm. Is there a way (code/macro) to bring over the "CRR" number from the [ComplaintForm] to the [ResearchForm] on the double click event?
  3. jrmiv

    Synchronized Form

    More like an interactive report. I want to open a report and be able to click on an item in the report and have it open a form. Is this possible in Access?
  4. jrmiv

    Synchronized Form

    MajP, I think I may not have stated clearly my intentions and what I need help with. I want to be able to Open the report that I created "OpenComplaintForm" and be able to select a record based on my primary key field "CRR" which will open the form "ResearchDocumentForm" for entry.
  5. 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...
  6. jrmiv

    Auto Populate Form from Data in Table

    Remou, Do you mean have a combo box for the AcctNbr field and then create a subform (linked by AcctNbr) to pull in the other fields. (Whse, Address, Address2, Address3, City, State)
  7. 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...
  8. jrmiv

    Delete Records from Table then Append with Autonumber

    Thanks PHV! This code was great...jrmiv
  9. 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...
  10. jrmiv

    delete using variable table and column names

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

    Using Sendobject in Macro

    Is there a way to Reset the autonumber to 0 on Append Query without having to compact and repair the database? (I want to delete the previous records) Because of this I can NOT set up a macro to run. Any help would be greatly appreciated.
  12. jrmiv

    Using Sendobject in Macro

    The Module worked. Thanks
  13. jrmiv

    Using Sendobject in Macro

    I'm having the same problem with my Access macro using the sendobject in Lotus notes that "bdjb" was having. I have the edit message set to no. Any help would be greatly appreciated. Thanks.

Part and Inventory Search

Back
Top