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 Mike Lewis 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: wfairbanks
  • Order by date
  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
  16. wfairbanks

    Trying to Create a Data Dictionary for SQL tables

    Rudy, Sorry such a late response but could you please send me your tables/queries. Thanks, Wendy
  17. wfairbanks

    DTS Invalid Pointer Error

    I have searched everywhere to find what an invalid pointer means exactly. I have a DTS package in which I have several databases that I am pulling through Winlink into SQL. When the package is executed an error is given when the data is being copied from one server to SQL Server. Any Ideas? I...
  18. wfairbanks

    Date Format

    I am importing data into my SQL db. It is pulling the date in the format of yyyy-mm-dd. I would like for it to be dd-mm-yyyy or dd/mm/yyyy. Can anyone help me with this? Thanks in advance for your expertise! Wendy
  19. wfairbanks

    Microsoft SQL Server Driver Timeout Expired

    Sorry I am really new at SQL. Where would I check to see if the table is locked.j
  20. wfairbanks

    Microsoft SQL Server Driver Timeout Expired

    I am querying a table in EM. I am wanting to put the result in a table using a create table query. I get a timeout error. It is a large amount of data but I checked my timeout settings and it is set to &quot;0&quot; meaning unlimited.

Part and Inventory Search

Back
Top