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

    Clickable text box on subform not displaying data

    Within a customer browse form, I have a sub-form which displays brief summary records linked to the customer. One of the fields on the subform can be double-clicked to open a detail form for that specific record. This has worked fine for 3 - 4 months. In the last week on the networked version...
  2. SteveCop

    Outlook 2003 will not send my e-mails unless I forward

    Using Outlook 2003, WinXP SP2, ADSL connection. Recently Outlook has refused to send my e-mails after creation. They are listed in the outbox but not in italics (ready to send) and have "none" in the sent date column. The only way to send the message is to select each one and "forward" the...
  3. SteveCop

    Problem opening Mail Merged documents

    I have a system for mail merging documents monthly to 200 people The data comes from Excel and the document from Word. Some of the recipients are having problems opening the documents, getting the message : "Word experienced an error trying to open this file. Try these sugesstions: a.. Check...
  4. SteveCop

    How to conditionally lock a series of fields

    One of the forms on my database contains a five tab page. There are around 20 fields on each page and each page is pretty well a mirror of the others, the data fields on page 1 being identified with trailers of _1, on page 2 _2 etc. For each page there is a database field called IsLocked. When...
  5. SteveCop

    How to display a public variable in a form

    I have a form for which the data source is a query on two databases. Elsewhere in the system, a public variable is set when the system starts running with a user ID name (No fancy code, the public variable is declared in a dedicated module simply as PUBLIC PubUserName as String) On my form I...
  6. SteveCop

    How to e-mail an excel worksheet automatially

    I have a very large Excel workbook which produces a complex "profile" worksheet containing not only data but mini-charts. Entering a subject name on the profile sheet updates the sheet to show that subject's information from the data sources elsewhere in the workbook. I need to make the...
  7. SteveCop

    How to use the contents of an unbound form field in a report

    I have an unbound field on a print control form and I require the contents of this field to print on a report. I don't know how to refer to the form field from within the report. Might I have to create a temporary table to hold the text so as to be accessible to both the field and report or is...
  8. SteveCop

    DATABASE DOCUMENTATION

    I need a documenter which will show the relations between the tables, queries and other objects in my database (for example, which screens and reports relay on a particular query). It would also be helpful if it were possible to list all fields referenced (for example) by a particular form or...
  9. SteveCop

    Visio 2002 keeps crashing my system

    I have just installed Visio 2002 SR1 on my system, running Win 98SE. Major problem 1: Many of the modules crash my system - no error message, just everything (including mouse) refuses to work. This happens 1) when double clicking an item to edit it's text and 2) when dragging certain graphics...
  10. SteveCop

    Visio keeps crashing my system

    I have just installed Visio 2002 SR1 on my system, running Win 98SE. Major problem 1: Many of the modules crash my system - no error message, just everything (including mouse) refuses to work. This happens 1) when double clicking an item to edit it's text and 2) when dragging certain graphics...
  11. SteveCop

    Pre-populating a new column in Access

    Does anyone know if it is possible, when adding a new column to an existing Access table, to pre-fill all the records in that column with some pre-determined data? I appreciate you can pre-fill new records one by one but we need to pre-fill even the existing records. Many thanks in anticipation....
  12. SteveCop

    Record locking query - how to lock one table but not another

    I have a multi-user database in Access 2000. The system is set up for pessimistic record locking for security. There are two key groups of users: - Finance - Helpdesk Each of these have their own tables with their own dedicated fields but there is a third table with information common to both...
  13. SteveCop

    Not enough memory to open form - first time only

    From my main menu I can access a number of detailed forms and sub-menus. Once of the forms is relatively large (200 odd controls on 6 sub pages) but has recently been reduced in size from before. If this form is the first item selected after starting Access I get the error "Microsoft...
  14. SteveCop

    Using Visual Basic to indirectly access a database field

    I have a table containing fields Sales1 through Sales12 Using a For-Next loop I want to address the fields sequentially and have established a routine which, on each pass through, sets the contents of a variable at Sales1, Sales2 etc. The variable is called cField Problem is, how do I address...
  15. SteveCop

    HELP! Conversion from Clipper to XBASE++

    Please forgive what (hopefully) is a fairly basic question from a newbie! I want to migrate my Clipper apps to XBASE++ but have a big problem. All my printing is processed using ESCAPE - a library I bought years ago which enables me to control HP printers with simple commands. For example...

Part and Inventory Search

Back
Top