I'm new to coldfusion and fuseboxes and appreciate any help.
I have a stored procedure that accepts two In-parameters and I'm supposed to pass them through a form. The submit is supposed to fire the query called qry_ReassignRequest. Here's what I have in dsp_reassign page, the switch file is at...
I should mention something here, when I say myquery, I mean a sql that I have built up in the module, not a
separate object, which I think is probably the problem because I keep getting an error that tells me Object "myquery" is not found.
Thanks again
Thank you guys for both responses. I didn't got a new
assignment and didn't get a chance to try your tips until
this morning. I tried this
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel5, "MyTableName", "C:\FileNameIs.xls", True
and it works but since I don't want to transfer the...
Hi everybody,
I have a search form that produces the results of the search in a listbox. My customers want to be able to
export the data from the listbox to an excel file. I'm new to access but this job's been assigned to me. Does anybody
know how to do this or at least how I can change the...
Hi everybody,
I found the problem and now my list box is showing results.
I did not have the list box RowSource property.
Me.Results.RowSource = sSQL & sWhereClause
Thanks
Thank you so much both for your replies.I used both your advice and this is what I came up with.
Private Sub CmdSearch_Click_Click()
On Error Resume Next
Dim ctl As Control
Dim sSQL As String
Dim sWhereClause As String
Dim objConn
'Initialize the Where Clause...
I need to create a form that searches based on two
criteria.It's supposed to display a list of the found
records at the bottom of the form (and my supervisor is
insisting that he wants the results to appear on the
form.Please if anybody can help me with this, I have a
deadline to meet and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.