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: *

  • Users: Bill0722
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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.
  5. 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.
  6. 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...
  7. 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...
  8. 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...
  9. 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,
  10. 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
  11. 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...
  12. 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...
  13. 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
  14. Bill0722

    Run querry from form

    I have a form of Customers. I want to put a button on the form and run a querry from that form, but I'd like the querry to use the current record in the form as the criteria for the querry. Is this possible? Thanks
  15. Bill0722

    Combo box update

    I have a farily simple form of customers. I use a combo box to select the record I want by picking the names of customers. I also have a button that allows me to add a new record. However, when I add the record, it seems that I have to exit and re-enter the form to get the list of customer names...
  16. Bill0722

    Form and subform

    I an pretty new to all this and a bit confused, so any help would be great. I have two tables, a customer table, with ID, Name, address, etc. and a work performed table, with task ID, task, etc. I want to create a Form that I can select the customer ID with a lookup table, and then have all the...
  17. Bill0722

    Using lookup to fill in form

    This is probably too elementary for you, but it has me stumped. Here's what I want to do. I have two tables -- Customers and Orders I want to have a form which is basically based on the Orders table. I want it to open on a Customer Number field, which would be a lookup field. I want to select...

Part and Inventory Search

Back
Top