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!

Search results for query: *

  • Users: wfairbanks
  • Content: Threads
  • 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 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.
  11. 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.
  12. 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...
  13. 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
  14. wfairbanks

    Microsoft SQL Server Driver Timeout Expired

    I have read several threads on this but I have not found anything that works. Could someone please enlighten me on something to fix this? I am trying to do a Create table query and I keep getting a Timeout Expired Error. Any help would be greatly appreciated.
  15. wfairbanks

    Trying to Create a Data Dictionary for SQL tables

    I need to develop a data dictionary for my database users. I need to have the dictionary consist of data type, column width, and whether it is a primary key. Any help would be greatly appreciated. Thanks in advance, Wendy:-)
  16. wfairbanks

    Compressing a database

    How do I compress a large db?
  17. wfairbanks

    Transaction Log issues

    Other than letting the tranaction log file continuously grow in order for my db to update properly. Is there any other way I can prevent my log file from growing too large and preventing the update? Thanks in advance
  18. wfairbanks

    Appending option in transformation

    Will appending duplicate the existing rows or will it just add the rows that have been changed? Thanks:-)
  19. wfairbanks

    Schedule Job executes 5 times then fails

    I have several jobs schedule and they execute at different times. They execute successfully 5 different nights but then fails on the 6th night.
  20. wfairbanks

    Winlink Connection Failure when Scheduling a package

    I am receiving a Winlink Connection Failure(Winlink is the method I am using to pull my data from one server into my SQL Server). Has anyone ever had this problem and if so I would greatly appreciate any input. Thanks in advance, :-)

Part and Inventory Search

Back
Top