Search results

  1. S

    toolbar

    I am using access 2000 and had read a "tip" where you can open a database object and drag the icon of the object to the top of the menu bar so that you have immediate access without minimizing any windows... It works fine but now I want to remove a few and can't figure out how Can you help
  2. S

    "Analyze in Excel")

    Thanks so much...it was making me crazy because I couldn't remember
  3. S

    "Analyze in Excel")

    how do you analyze a report in excel I had found the command onec and noe can't fint it again
  4. S

    report

    Thanks I need to group like how many between the ages of 6-10m, 11 -14,15-18 also, how many from Nassau County, Suffolk County etc. I'm not sure if I should do it off a query
  5. S

    report

    I have to do an annual report on my cases I have a field [county] another field [age] etc How can I have these calculations come right into the report For example there are 60 cases to calculate the 2 counties the kids come from or their ages Thanks
  6. S

    query

    sorry, I just realized I left out the word like and now it works I feel so dumb
  7. S

    query

    I have a field in a query [next review date] which is based on my field [date]+365 The query looks good When I enter the criteria under next review date I enter is nopt null and [please enter month followed by /*/*] so I can easily pull up all the reviews due in a particular month I t works...
  8. S

    combo box

    I did the query and put in [forms]![my frmname]![my combo box name] in the criteria of the category field. I based a report on the query When I go to open the report, I get the combo box but then I must enter the category from the drop down box Is there q way to get the report to open from...
  9. S

    combo box

    did as you suggested I now have a combo box on my form but can't get it on my query or to open the parameter on my report or query
  10. S

    combo box

    I put a combo box in my form on my field called categories How can I get a parameter box to open and be the combo box when I do a query or report For example, instead of entering the category, have the combo box pop up in case one doesn't know the categories...
  11. S

    report from subform

    Thanks...I don't know why I didn't think of that
  12. S

    report from subform

    I have a form and in it is a sub form called event where I can keep entering new things that happen to the client i.e. admission to a residential placement, withdrawn from placement etc.) When I enter the info the most recent event is last in the list. I have made a query and report and the most...
  13. S

    percent

    I have formatted a field for "percent" (how much of a raise the employee got) I formatted it in the table >number.percent It keeps coming up with 4 digits...for example if I wan to put in 5% it comes up 5000.oo percent I've tried changing the decimals but nothing works Can you help
  14. S

    sum

    I have a field with length of stay for clients in a residence How can I get the average of the field either in a report or the query
  15. S

    text box

    thanks...that's what I was looking for
  16. S

    text box

    but then will I still get the data I need
  17. S

    text box

    Is it possible to separate a text box from its label on a form and if so how...I just want to do it for design purposes
  18. S

    running count

    I had given items autonumbers and now that I found out that if I delete one item so goes the number. So How can I have a running count of items
  19. S

    autonumber

    Why is it that when a record is deleted, the Autonumber doesn't reset to reflect an accurate number of entries in the database
  20. S

    save template

    Can I save a certain style of a report as a template for further reports? Eve ry time I need to create a new report, I have to start from scratch, with changing the paper size to legal, adding thecompanylogos, adjusting the Label field sizes and font sizes and styles, etc.
Back
Top Bottom