Search results

  1. S

    Index in Report

    Place your index in the Report Header of your report. Set the page break to go to a new page after it prints the report header. That way it will only print on the first page.
  2. S

    Inefficiency at work

    I was called in on a consult. The database was on a server with no security. A couple of employees who thought they knew Access had been making changes and of course they messed it up. "How long will it take to fix it" asked the Manager. "I don't know" came my reply. "Why don't you know?"...
  3. S

    Unable to update field list in report

    With your subreport in design view, check the properties of the sub report. Find out the name of the table or query that runs the sub report. It sounds as though you may have missed updating the query that runs the subreport.
  4. S

    Customized control box

    These functions are available as macros. Create a minimize macro and a maximize macro, then put command buttons on the form set to run the appropriate macro.
  5. S

    Open Database without opening full program

    This is a unique question - Congratulations. Could you explain why you wish to do this as I don't see what the purpose would be.
  6. S

    Lunch thru USB port

    Are you sure this shouldn't be in GEEK TOYS?
  7. S

    Reports Help

    I do this frequently by way of a macro. In the query for your report enter in the criteria line for the field you wish to use on your form to generate the report: [Forms]![FormName]![textboxname] Where FormName is the name of the form you are using and textboxname is the name of the textbox on...
  8. S

    Tea?

    Rich: While your instructions for making tea are correct, try finding loose tea on this side of the pond.
  9. S

    Inefficiency at work

    Reminds me of an episode of Cheers when they got a big screen TV. The installation instructions were on a video tape. The regulars were making book on how long it would take the person installing it to realize they couldn't view the tape until the TV was installed.
  10. S

    Security??

    Wardy: You can learn just about everything in Access through trial and error EXCEPT SECURITY. Do not enter these deep waters and uncharted territories without a detailed step by step guide. I have been doing Access Security for 10 years and I still have my guide with me when I do it. May I...
  11. S

    Remove data from fields

    See...I told you someone would come up with something.
  12. S

    Tea?

    You could always leave the tea bag in a little longer.
  13. S

    Remove data from fields

    I recently had a similar problem. If you have the name of the horse and the country in the Name field, you can do this using an update query PROVIDING ALL OF THE COUNTRY CODES ARE 3 LETTERS. Do a search on the Right() function. This will allow you to transfer the three letter country code to a...
  14. S

    Open a form from a query

    Generally speak (but not absolute) in this situation you would have your customers in one table and your sales in another. When you wish to enter a sale you would use a combo or list box (the most popular method) to enter the customer info and then you would enter the sale info. While there...
  15. S

    minimizing security on DB ?

    It sounds like you are using the "runtime" version. Do you have the full version of Access on your computer?
  16. S

    query a date

    In the criteria of the date field enter: > [Enter Date] square brackets required. The query will prompt you for ENTER DATE Enter the date and any record with adate greater than the date you entered will be returned.
  17. S

    Inefficiency at work

    Rule when when pitching an idea to a superior. In their mind, if it is such a good idea, THEY would have thought of it.
  18. S

    Need help with patient database

    Is there any special reason why you are assigning your teams a number? I ask because you have already assigned them a colour. Likewise, the doctors have names, why use a number to identify them? 1. Set up your entry form with two combo boxes. The first selects the team. This will narrow down...
  19. S

    Users and Passwords

    Emma: DO NOT ENTER THE DARK WATERS AND UNCHARTED TERRITORY OF ACCESS SECURITY WITHOUT A DETAILED STEP BY STEP GUIDE. I have been doing Access security for almost 10 years and I still have my guide with me when I do security. I would recommend: http://www.geocities.com/jacksonmacd download...
  20. S

    Quick Question

    You would have to include the fields you wish to use in the calculation in the query. The source of the data would usually be the table although you could use another query as the source. This is called a sub query. I am attempting to tell you that you do not require the expression builder...
Back
Top Bottom