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 SkipVought 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. AlanHawkins

    Fatal exception: DW crashes after IE7 upgrade

    After accepting the MS Auto update of IE6 to IE7 I had "Fatal exception error - DW is terminating" even when clicking on Help. Errors included "Browse_back enabled in toolbars.xml" and "get CurrentValue in AddressURL.htm" when trying to switch between loaded pages. I tried re-installing...
  2. AlanHawkins

    Unable to store paper selection using HP printer

    Using an HP3175 multi-function laser printer I am unable to store the correct paper size (DL envelope) in an Access 2000 report (since changing to Windows 2000). The paper size reverts to B6 or A4 even if you change the paper settings in the Windows printer driver (latest version). HP say they...
  3. AlanHawkins

    Word/Access mail-merge only returns 1st 5 records

    Using Access 2000 mdb front end with SQL back end, a query finds 200 records but when a mailmerge is created in Word 2000 only 5 records are retrieved. If you select "Edit Source" in the "mail merge helper" all 200 records are displayed. No other filters appear to be in use...
  4. AlanHawkins

    Sharing Access adp front end on SQL

    Please advise how to share the asp file. I am having to have a separate copy on each workstation otherwise I get a sharing error message. Presumably workgroup security files are inappropriate when not using an mdb database?
  5. AlanHawkins

    Problem editing SQL data from Access Form

    I have be advised that I should be using Nvarchar, and it now works fine!
  6. AlanHawkins

    Problem editing SQL data from Access Form

    I have, for the first time, created an Access 2000 Project and used SQL server 7 as the "back-end" to store the tables. I can create a new record in an Access Form but when I try to amend the data an existing record I cannot add more text to a field. If I highlight the existing text I...
  7. AlanHawkins

    Date and Time - Need Some Expert Advice

    Just add a yes/no field called &quot;Done?&quot; and click it when you have viewed/actioned the record. Create a query with all records and under the criteria for the &quot;Done&quot; field insert &quot;<> yes&quot; (no quotes) and you can use this query as the control source for the form or...
  8. AlanHawkins

    How do i check to see if any records in a subform

    An easy way is to add a calculated field to the form footer of the sub-form with the control source as &quot;=count([keysubfieldname])&quot;. You can then check whether this is >0 with an If statement. If you add =nz([fieldname])>0 to your if statement this will convert null to 0 as the two are...
  9. AlanHawkins

    Access Database file keeps corrupting?

    I have a customer using NT server and NT workstations that has had this problem and I have been unable to get any help from Microsoft or anyone. It's not even mentioned on their Knowledgbase. I re-wrote the database from scratch in case there was any old code in it (using Version 2000) but the...

Part and Inventory Search

Back
Top