Search results for query: *

We have a small network. Several users are able to update the Access 2000 db from their workstations because I've shared the folder in which the db is saved. They have complete access to do changes to the design of the db as well as update data. Because the db size was getting excessive I...

We have a small network. Several users are able to update the db from their workstations because I've shared the folder in which the db is saved. They have complete access to do changes to the design of the db as well as update data. Because the db size was getting excessive I compacted the...

We have a table with a column labeled "Model". In many of the records the "Model" contains a "-" (ie: -345). I need to change every model that is proceeded with a dash to that model followed with "-REPAIR". In other words if the record shows the data as "-345" I'd like to update it to show as...

I run reports based on a table. I use a query to present the appropriate data when the user chooses to run the report. The report has a column titled "Manufacturer" which corresponds to a column in the table the report data is based on. In the query the criteria for the Manufacturer column...

I have a table with the following fields: [date], [first name], [last name], [address], [city], [state] and [zip]. I want to select only records that have data in the [first name] and [last name] fields, to eliminate duplicates based only on the [address] field and also eliminate any records...

In the old flat data base we were using (Q & A) we had a screen in which we could input the "retrieve" specs to specify the data we wanted to retrieve. Then we could select an additional screen into which we could enter sorting order on multiple fields. In the first "sort&quot...

When choosing "Filter by Form" you are presented with a blank form (ala "grid") into which you can enter "search specs". I would like to open a form, have it automatically enter a "Filter by Form" mode with a 'cleared grid' ready for the user to input the...

I've created a custom tool bar that contains "A-Z sort", "Z-A sort", "Filter by Form" and "Apply Filter" buttons. When I click the "Filter by Form" button the form/sort tool bar comes up and I've eliminated all buttons except the...

MS Word does a terrible job with Mailing Labels Using Mail Merge (Leaves Multiple minimized versions of Access open, etc). In Access, with a table open, there's a menu Selection: Tools/Office Links/MS Word that allows me to dump the data into the pre-defined Word Document to print labels. How...

How can I close a form by pressing the Esc key?