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

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

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

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.

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

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

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

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

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

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