Search results for query: *

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)...

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...

Thanks, your email flagged the problem - it was actually my trying to edit a report I open based on the user returned information. Trying to edit a report is a no,no in an MDE. Once again thanks for your help, I have taken on your suggestions regarding the form settings.

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...

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...

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...

I have a similar problem. The values I want to plug into some unbound text boxes are actually present in my VBA code but when I attempt to insert them into the fields I get no response on the open report. The only options I see at present are to create a form with some text fields, hide it at...