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 Chriss Miller 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. 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...
  16. 92hilux

    Opening a Report from A Form

    YEAH!!! i did it!! only pulled out half my hair! the code was as follows if you care to know: >>DoCmd.OpenReport "rptResults", acViewPreview, qryTotal, Title = txtSearchTitle
  17. 92hilux

    How to Alter a text Variable?

    Well thats not quite wat i was lookin for i don't think. but i managed to work it out. my code was like [txtSearch] and.. i changed it to like *&[txtSearch]&* Thanks for your assistance tho! hope this might help others too!!
  18. 92hilux

    How to Alter a text Variable?

    I want to search a table for a variable, but.. i want to search it with the addition of wild cards For example. if the user inputs "AND" i want the variable to be saved as "*AND*" i am thinking this is easy, But. i have no experience with Access and am having an absolutely...
  19. 92hilux

    Opening a Report from A Form

    oh one more thing.. How do you transfer a text variable from the form to the report/querry?
  20. 92hilux

    Opening a Report from A Form

    I have a report that must be opened via the form. The report itself works perfectly, asking for a parameter to querry the data with. The code i presently have.. to open the report, causes it to open empty everytime, regardless of the parameter value. Is there a simple code that i'm missing?

Part and Inventory Search

Back
Top