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

    Finding Null of zero length strings

    I have a table of about 15000 records. I need to replace some values in a fiew fields that were left blank. I was trying to search for them with the find and replace. Entering two double quotes in the find field returns nothing. Is there some other way to use find and replace to search for blank...
  2. Bill0722

    Auto close parameter querry form

    Thanks so much. Excellent tip, works great. Bill
  3. Bill0722

    Auto close parameter querry form

    When I run a report off my switchboard, the command first runs a small form to imput the date range, and then when I exit that form, it runs the report. I'd like to be able to automatically close the parameter querry form, as it remains open. If I put a Close.form command in the event procedure...
  4. Bill0722

    Can't group dates in report

    I've done that. The problem, the date field is still in the reporting line, so I get procedures with unique dates. I can't seem to be able to fix this.
  5. Bill0722

    Can't group dates in report

    OK, I have a query that reports the following fields> Date, Procedure Number, Procedure name, Procedure count days, procedure count nights. When I try to create a report with this query, I can group the data by month, which is what I want, yet the individual dates still print, and I can't seem...
  6. Bill0722

    Backing up secured database

    Actually, I'm not doing anything yet. I'm just finishing up my first project and am looking for the best way to back it up. I was just going to use the backup command under the file menu, but will this also back up my security file. And if my original database gets trashed, how would I restore...
  7. Bill0722

    Backing up secured database

    If I back up a secured database, with user level security, how do I restore and use it if my original database became trashed. As always, thanks.
  8. Bill0722

    tab order question

    Not exactly sure what you mean here, but I don't think so.
  9. Bill0722

    Back up secured database

    What's the best practice for backing up a database with user level security for getting a copy on another drive that's ready to run with just one click.
  10. Bill0722

    tab order question

    I have a form with several fields which also has a subform connected to it. I have the tab order on the main form set up so the tab jumps from the first field of the main form to the subform, and I have the tab order of the subform set to move through the fields in the order I wish. However...
  11. Bill0722

    Security and views

    Is it possible to adjust who sees the main database window by their login..So that regular users would only see the switchboard and the forms they open, but admins could see the main database window and toolbars. And if that is not possible, if I turn off the toolbars and main database windows...
  12. Bill0722

    Security with login

    I'm trying to protect my new database. All my users use the same XP account when using the computer, but I want each to be able to log into the database separately. Is this possible. When I run the wizard and set the passwords, including one for myself, the next message I get says I don't have...
  13. Bill0722

    limit combo box to unique values

    I have a combo box that looks up the date a table entry was created. Of course several entries could all have the same date. I want to limit the combo box to showing only one of each date In table 7/1/2006 7/1/2006 7/2/2006 7/2/2006 I want the combo box to only show 7/1/2006 7/2/2006 Thanks,
  14. Bill0722

    increment and decrement date field

    Is there anyway I can format the date field on a form to increment and decrement using the + and - keys. Thanks, Bill
  15. Bill0722

    Combo Box Contents in Report

    I have a list of patient procedures. I want to report these out based on a location. In my table, I have a combo box which lets me pick from one of five locations. I can get the report I want, nicely subdivided by location, but the thing that prints on the report is the 1, 2, 3,4, or 5 which is...
  16. Bill0722

    Security Log On

    After all my hard work, I want to protect the database and be able to track who enters what. I ran the security wizard, yet it still does not prompt for an individual user and password when I open the protected database. Where I work, almost everyone uses the same XP logon account. I want to...
  17. Bill0722

    Run querry from form

    Fantastic. Works pefectly. Thanks Randy Bill
  18. Bill0722

    Run querry from form

    Thanks. This works great, and returns the proper value to the query that it creates. However, what I want to do is run a query I have already created. Any ideas would be appreciated. The name of my query is tblProcedureDetail Query
  19. Bill0722

    Auditing tool

    Will this enter the Windows username or the Access username? Thanks, Bill
  20. Bill0722

    Auditing tool

    Is there a way to put a field into a form or table that automatically captures the login ID of the person entering the record. Thanks again, Bill

Part and Inventory Search

Back
Top