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: *

  1. Mary01

    Checkbox group validation

    Thank you Kaht I think what I was doing wrong was checking for the value of the checkbox and comparing it to null. Thank you again,
  2. Mary01

    Checkbox group validation

    Hi, I want to make sure they are all checked. Thank you!
  3. Mary01

    Checkbox group validation

    Hi, I'm trying to validate a group of checkboxes(for as many records as my query returns). can somebody help me with that please? Thank you
  4. Mary01

    Help with passing parameters

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

    exporting data from listbox

    what happens if I don't set qDef and db to Nothing?
  6. Mary01

    exporting data from listbox

    Thank you so much Randy, it worked!
  7. Mary01

    exporting data from listbox

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

    exporting data from listbox

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

    exporting data from listbox

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

    Help please Access Search forms

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

    Help please Access Search forms

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

    Help please Access Search forms

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

Part and Inventory Search

Back
Top