Search results for query: *

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

Thanks so much. Excellent tip, works great. Bill

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

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.

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

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

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.

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

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.

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

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

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

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,

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

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

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

Fantastic. Works pefectly. Thanks Randy Bill

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

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

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