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!

Recent content by 92hilux

  1. 92hilux

    How to Create a Help File

    Thanks Jim.. much appreciated.
  2. 92hilux

    How to Create a Help File

    I require a Help file similar to the ones found in the sample databases. They seem to be similar to the Form media.. but seem to resemble html as well? I looked through the directory in Access to see if files were attached.. but didn't notice any?? does anyone know how these files are...
  3. 92hilux

    VARIABLE display area

    Thanks man.. that worked out pretty nicely!
  4. 92hilux

    VARIABLE display area

    i have a Library directory of sorts.. it has two fields, title, and Description that are of variable length (cant' seem to get a average to work) so.. i was wondering.. when it gets to my report. Is there a way to have a field display according to the data in it? ie. if the title is very long...
  5. 92hilux

    Variable Display areas for REPORTS

    i have a Library directory of sorts.. it has two fields, title, and Description that are of variable length (cant' seem to get a average to work) so.. i was wondering.. when it gets to my report. Is there a way to have a field display according to the data in it? ie. if the title is very long...
  6. 92hilux

    Searching records

    maybe in your query... under criteria: >>Like *&[txtYourWord]&* That is wat i used to search for any part of a word or description. Good luck
  7. 92hilux

    Make the Form close after One use.

    Why won't this work? >> Private Sub Command2_Click() DoCmd.OpenForm "frmSearchTitle", , , , , acDialog DoCmd.Close End Sub >> i want the form to close at the same time as it brings up the report. Or at least just after (either way, without user input).
  8. 92hilux

    Make the Form close after One use.

    I have a Search form, that is opened via a menu form button. I would like the search form to only work once, then close. IE.. after the user clicks "search", the form will open a Report, and then close itself. Is this possible? PS the report and all of the minor details is done. i...
  9. 92hilux

    Form works once, but not again?

    qrySelection1 is utilized to filter the data table with the Catagorie* = yes. for example if the user checks (on the form) CatagoryCodes, and CatagoryElectrical... they are both returned to the query as equal to YES The query then filters the table of data for any records that match these...
  10. 92hilux

    Form works once, but not again?

    This is the code behind the SEARCH button on my form. the WHERE field contains all the optional query variables. Each catagorie is represented by a check box in the Form. >> Private Sub Command18_Click() DoCmd.OpenReport "rptSelection1", acViewPreview, qrySelection1...
  11. 92hilux

    Form works once, but not again?

    AJDESALVO: I checked the Form props.. and.. it is not bound, nor are the check boxes. code i used was.. [Forms]![catagorie]![checkBoxName] in the OR Criteria fields in the query. Again to all.. any help is greatly appreciated.
  12. 92hilux

    Form works once, but not again?

    I hate to ask a stupid question... BUT./. how do you run the debugger?
  13. 92hilux

    Form works once, but not again?

    I have created a Form, with 8 check boxes that create a dynamic query that will allow the user to search a table for matching records. The search works Wonderfully the first try... BUT... any additional search is returned with additional results (not correct). If i close the form and open it...
  14. 92hilux

    Possible to Merge Reports? to make SUPER REPORT?

    is it possible to compile a single report with the entities found in two different reports? also only include entities once in the final if they are found in both reports?
  15. 92hilux

    Compliling a report with Two Queries?

    I want to complile a report with the results of TWO different queries? Is this possible? haha OF COURSE! but how do I do it!? haha the deal is.. my query1 is using a variable search criteria. and.. i want this search criteria to be searching two fields. But i don't want it to Require both...
See more

Part and Inventory Search

Back
Top