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 derfloh 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: martync
  • Content: Threads
  • Order by date
  1. martync

    Access 2000 Assigning ADODB.recordset to a report

    Hi All, I've searched most of the morning and still can't find an answer to this... I am generating an ADODB recordset using a form to gather info to generate required SQL during the report_open event. I want to assign the recovered rst to the report. Private Sub Report_Open(Cancel As Integer)...
  2. martync

    Combining Excel & ADODB.Recordsets

    I currently run a SQL query on an adodb recordset and return the data to an excel spreadsheet. What I would like to know is how I could enable the user to enter parameters into one of the excel worksheets and then suck this information into my adodb query? Writing the code to handle the action...
  3. martync

    Modal form error in MDE compiled version

    Can anyone help??? When I attempt to run a date form with the database in MDB format this works fine but when I try to run this in a MDE format file I get the the error: The expression OnClick you entered as the event property setting produced the following error: That command isn't available in...
  4. martync

    Putting User Types Into Collection Objects Error

    Hi, I have created a user type: Private Type SampleInfo SampleCode As String SampleID As Long SampleType As String ProductType As String End Type Dim Info as Type When I try to put Info into a collection object Dim colInfo As New Collection colInfo.Add Info I get the following...
  5. martync

    Split returned recordset into unique strings

    I have a returned recordset of the format: FieldName TableName A Z B Z C Z D Y E Y F Y etc What I want to do is create a list of fieldNames for a unique tableName ie "A,B,C" for "Z" "D,E,F" for...

Part and Inventory Search

Back
Top