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!

Register Log in
  • 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: *

  1. TheComputerDude

    Date function returns null

    I just encountered a problem where the built in date function in VBA shows that DATE is NULL when in debug mode. The NOW function still works however. Does anyone have an idea what might be causing this? I've never had this problem with the DATE function before. My thought is that it might...
  2. TheComputerDude

    Text To Columns

    I need to dynamically convert parts of a spreadsheet to columns. I used a macro to get the following syntax: Selection.TextToColumns Destination:=Range("A7"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(11, 1), Array(24, 1), Array(37, 1), Array(50, 1), _...
  3. TheComputerDude

    Referencing a query in code

    I prefer to write my queries in code, but I am not sure how to reference them from another query. I know FoxPro supports cursors, but Is this possible in Access?
  4. TheComputerDude

    Tables disappear

    I have an application that pulls data (1 table) from an SQL server. The problem is that occasionally the tables disappear. I mean both the linked table and all local tables disappear. Closing and re-opening the database corrects the problem, but I need this program to stay up and running...
  5. TheComputerDude

    Control Arrays -- passing controls as a variable

    I have 3 control arrays (text box, list box, and combo box)and would like to populate a form in 3 columns. I have never tried to use a control variable before and I am have a problem trying to get it to work. My code is below, if you have any suggestions, please let me know. Private Sub...

Part and Inventory Search

Back
Top