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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by wfairbanks

  1. wfairbanks

    Drop down box in Word form

    I created a word form with a few drop-down fields. In word it is fine and if I print it, it is fine. But when I send it as an e-mail the fields do not show up. Does anyone know why this is happening? Thanks in advance for your help!!!!!
  2. wfairbanks

    Import Text Wizard in Access 2003 SP2

    When clicking the advanced button. I receive the following message, "Method 'AccessUserDataDir' of object'_WizHook failed. Any help would be greatly appreciated.
  3. wfairbanks

    Compulation error

    When compiling data in Excel the attached error message comes up: Compile error: Can't find project or library What does this mean? Am I missing an add-in and if so which one?
  4. wfairbanks

    Could not load object library error in .xls file

    Here it the code I am having problems with. Could someone tell me why it is giving me this error message. Public Sub CmdbarDeinit() On Error Resume Next Set CmdBar = GetCommandBar If Not CmdBar Is Nothing Then CmdBar.Delete Set CmdBar = Nothing End If End Sub...
  5. wfairbanks

    Compile Error

    Can't find object of library in Visual Basic code in Excel
  6. wfairbanks

    Expression contains invalid syntax

    I am getting an error when opening a database. It states, "The expression you entered contains invalid syntax. You may have entered a comma without a preceding value or idenifier". The application opens. I enter my user name. No password and hit enter. Then the error appears. I am able to...
  7. wfairbanks

    Average a date range

    How do I average a date range of 12 months when my date format is mm/dd/yyyy? I would like to pull dates between 05/01/2003 and 05/01/2004 and take the average usage for those months.
  8. wfairbanks

    File is already in use

    I have a db that is shared and I am able to open it on both workstations but a different user is unable to open it. Any ideas!!!1
  9. wfairbanks

    Text box to move with the scroll bar (up and down)

    I have a text box I would like to be viewable as the user scrolls down the worksheet.
  10. wfairbanks

    Searching in a table or form

    I am trying to pull a record itself to modify it. I have several to update information on and I wanted a quick way to pull each record up one at a time and make the necessary changes.
  11. wfairbanks

    Searching in a table or form

    Access 97!
  12. wfairbanks

    Searching in a table or form

    I have an access form that populates a table. I would like to be able to search that table for a specific record. I am not sure how I need to do this.
  13. wfairbanks

    IF Statement Help

    I have an IF statement to compare one column in an Access db to another column in the same Access db. Please tell me what I am doing wrong! IIF([tabname.informix_pubtablesd17]<>[tabname.informix_pubtablesd]),1,0) IF tabname is not equal to tabname give me a 1 else give me a 0.
  14. wfairbanks

    Microsoft SQL Server Driver Timeout Expired

    You may want your timeout to be at 0 = infinite.
  15. wfairbanks

    Trying to Create a Data Dictionary for SQL tables

    Thats OK. I am trying to compare the data in one SQL database against the data in another SQL database. Thanks, Wendy

Part and Inventory Search

Back
Top