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!

  • Congratulations strongm 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: GerryGoldberg
  • Order by date
  1. GerryGoldberg

    Receiving all messages in HTML format

    The "Read all standard e-mails in plain text" option is NOT checked. Any other suggestions?
  2. GerryGoldberg

    Receiving all messages in HTML format

    Somehow my copy of Microsoft Outlook 2003 has gotten set to convert all received e-mails in plain text format. How can I change it so that all received e-mails are converted to HTML format? Thanks, Gerry Goldberg
  3. GerryGoldberg

    Can't add e-mail address

    I did as you said and displayed the Contacts folder. The name I just added IS NOT there, but all of my other e-mail records are. Is there some other Contacts folder I should be looking in? Thanks, Gerry Goldberg
  4. GerryGoldberg

    Can't add e-mail address

    Ok, I think I understand the basics that you outlined. Now I have a new contact entered but when I try to include it in an already existing e-mail group, it isn't listed as an entry in Contacts. My address book is empty. Where is my new contact? Thanks, Gerry
  5. GerryGoldberg

    Can't add e-mail address

    When I converted from Microsoft Outlook Express to Microsoft Outlook 2003 all of my address book was converted to contacts. This seems to work fine for sending e-mail. However, when I try to add a new e-mail address to my Address book, Outlook tells me that I can't add to the Address Book. It...
  6. GerryGoldberg

    Move a database to new hard drive

    I have SQL Server 2000 installed on the C:\ drive of my desktop that I use as a test platform for a number of applications that I maintain. This installation contains several databases, one of which has grown substantially and is threatening to take over my hard disk. Is it possible to move this...
  7. GerryGoldberg

    Parameter query to set value of IN clause

    My query is: SELECT * FROM tblA WHERE billMonth IN ('JAN-03','FEB-03','MAR-03') I would like to be able to use a parameter query to replace the contents of the IN clause, but everything I try results in either an error, or selects no records. I have tried: SELECT * FROM tblA WHERE billMonth...
  8. GerryGoldberg

    Can't update a bound form

    I am creating an Access 97 form (running under Windows XP) that contains fields bound to an underlying table. When I modify any field on the form, I get this WRITE CONFLICT error: This record has been changed by another user since you started editing it. If you save the record, you will...
  9. GerryGoldberg

    Installing SQL Server 2000

    I have a Pentium 4 running Windows XP and need to install SQL Server 2000 on it to use it as a testing platform for applications prior to installing them on our production SQL 2000 Server. This would require that both SQL Server 2000 and SQL Client 2000 reside on my test machine. What software...
  10. GerryGoldberg

    Display a year

    I have a form that is based on a table that contains a numeric field that represents a year value. I would like the user to be able to enter two OR four digits for the year but have the form always display a four digit year. I have tried various combinations for Format and Input Mask but can't...
  11. GerryGoldberg

    mail merge using text file

    I have a large text data file that contains names and addresses that I want to merge into a document. Each record consists of three lines (name, address, city-state-zip). The data file was created in label format with WP 9.0 but contains no merge codes. Is there any way I can automatically...
  12. GerryGoldberg

    deleting a subform record

    I want to delete a record on a subform where the user has omitted one or more important fields. I think that I should do this in the "AfterInsert" event, but I'm not sure of the VB code to use. Thanks
  13. GerryGoldberg

    how to sort a table frame by iser selected column

    I have a table frame that contains records filtered by a date range. I would like to be able to select a sort sequence for these records by simply clicking on the header of the column on which to sort. Do I need a secondary index on each of the displayed columns or is there some other way to do...
  14. GerryGoldberg

    I would like to import Paradox tabl

    I would like to import Paradox tables into my A97 database. However, the "file types" dropdown on the import screen does not list Paradox (although my system at work shows Paradox). How can I update this list to include Paradox? Thank you, Gerry Goldberg
  15. GerryGoldberg

    Setting a unique field in a linked table

    Using DAO, I am creating a secondary database where I would like to create a table which I can link to. Everything works fine except that Access asks me for the "Unique" field for this table. How can I set a field as "unique" when I am creating it in the secondary database...
  16. GerryGoldberg

    Creating temporary tables

    Using VBA, how can I create a temporary table that I can fill using VBA code. I would like the table to be deleted when my form closes. I don't want my database to be updated to reflect this table so that the size of the database will not continue to grow as this table is created and then...
  17. GerryGoldberg

    TransferText error

    I am trying to import a text file into an existing empty A97 table and continue to get an error. The VB code is: docmd.TransferText acImportDelim,,"tblA","c:\txt\tblA.txt",false The error I get is: "Field F1 doesn't exist in destination table tblA" This is true...
  18. GerryGoldberg

    Update SQL from standalone laptops

    I have 25 users running an A97 application that uses a SQL 7 database. This application tracks many aspects of patient visits to various health care clinics, including medical test results, medication and supplies inventory and case management referrals. The SQL side of the application uses a...
  19. GerryGoldberg

    Separating data groups on report

    Perfect! Thanks for your help. Gerry Goldberg
  20. GerryGoldberg

    Separating data groups on report

    I would like to create a report that shows multiple visit records for each patient. I would like the patient name to show as the first field on the first record for each patient's group of detail records but not on any of the other records for the patient For example Name Visit date...

Part and Inventory Search

Back
Top