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 Chriss Miller 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. summitx

    Creating CSV to pass to a stored procedure

    this is mostly a question to those of you with plenty of experience. I have a form with a listbox(listbox2) that is populated based on single or multi select items from another listbox(listbox1). It seems the thought online is the build a UDF, creating a table parssing the values into a...
  2. summitx

    Converting date to char

    Thanks for all of your replies. The consensus is to keep the date as is in the adp file ie. 38740 to easily perform all date calulations and necessary sprocs. When needed, the app will do literal translations ( split the date into MM dd yyyy)and recombine as a string in the procedures (or...
  3. summitx

    Converting date to char

    Thanks for the lesson, however my question revoles around converting the string mmddyyyy in a char as is requested by a client. This is a contraint of their parent database. I Dont know why they want this but all the same, without doing an update on the record after it is inserted is there a...
  4. summitx

    Converting date to char

    I am having a bit of difficulty converting a date field into a char (8) within a access project. I can make the conversion work and the field populates within the table, however in format mmddyyyy if the month is January thru Sep the record will drop the first zero in the string. I use...
  5. summitx

    Explorer 6 will not execute but Explorer 5 will

    The code for my program is as follows : Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long)...
  6. summitx

    Executing Explorer 6

    The code for my program is as follows : Private Sub cmdAgree_Click() MsgBox "Thank you, have fun, and please call us with any questions" Dim ret As Long ret = ShellExecute(0&, vbNullString, "\cdcatalogue\index.htm", vbNullString, vbNullString, vbNormal) End End Sub...
  7. summitx

    Executing Explorer

    The code for my program is as follows : Private Sub cmdAgree_Click() MsgBox "Thank you, have fun, and please call us with any questions" Dim ret As Long ret = ShellExecute(0&, vbNullString, "\cdcatalogue\index.htm", vbNullString, vbNullString, vbNormal) End End Sub...

Part and Inventory Search

Back
Top