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 bkrike 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: DavidDF
  • Content: Threads
  • Order by date
  1. DavidDF

    Update Query

    I have an Access 2003 database of about 17,000 records. An online service is cleaning it up by matching with USPS Change of Address forms & taging Deceased entries. No data is actually changed. New info is added to end of each record. I want to compare the old data file with new data file...
  2. DavidDF

    Null Value and Primary Key

    I am using an Append Query to add records to a table. I have set three fields in the target table as the Primary Key: first,init & last. If there is always a value in at least one of the fields then the Primary Key is never a null. Access 2003, however, does not seem to see it this way. Does...
  3. DavidDF

    Hyperlink does not return to form

    I created a hyperlink field and placed it on a form. When I click on the field in the form it goes to the correct web address but when the web page is closed the form does not automatically reappear. I have to click on the minimized form to get back to form. How can I make the form view...
  4. DavidDF

    Security

    My Access 2000 database is set to the default security settings. When I log onto another workstation using the same Computer ID as on my workstation (where the database accessed by the other workstations is located - we have a small peer to peer network) I am not allowed to make any design...
  5. DavidDF

    OpenReport problem

    I am using OpenReport to pass values from a form. The primary AutoNumber field (CustomerNum) indicates that only the current record should be printed. Does CustomerNum have to be converted to a string value first? Example with no conversion: Dim strName as String Dim strWhere as String...
  6. DavidDF

    Filter records to be printed

    I wish to print part of the current record (not a print screen format) from an Access 2000 form. Here is part of the code: 1 Dim StrDocName As String 2 Dim StrWhere As String 3 StrDocName = "CurrentRecReport" ** the field CustomerNum is a numeric,AutoNumber field 4 StrWhere =...
  7. DavidDF

    Print current record in envelope format

    I want to use a command button to print the current record as a # 10 envelope (no return address). Before printing a message would be displayed saying "Continue / Cancel". Each record has a unique ID (CustNo) for focus. Thanks. David
  8. DavidDF

    print envelope from form

    I would like to print the current record in an envelope format when the user presses a "print env" button. It would be a # 10 envelope with no return address. Thanks. David

Part and Inventory Search

Back
Top