Recent content by MW

I've got a form where users are required to enter data in certain fields (name, location, etc.). The "required" property on this field in the table is set to "yes" However, in the form, if the user does not put data in it, there is no message telling them that they must put something in there...

I have an Access 2000 database running over a LAN. Today the LAN connection dropped while someone had the database open. Now, when trying to close a form in the database, we get the following message: “Search key was not found in any record Error 3709” Any suggestions what causes this? Thanks

I need to read data from an electronic card reader into an Access database. Employees scan their card on arriving/leaving the building. This currently feeds into a 3rd party database which is old and fairly useless. I want to make a new Access database, but don't know how to make the data...

I have records of daily meter readings for water use. I need to calculate "daily reading" value in record 2 from the "daily reading" value in record 1 to determine net use for day 2, etc. Seems simple and is a breeze in Excel, but I need help in doing it in Access. Any suggestions? Thanks

I've got a form with tab controls on it. When I do EDIT, FIND, LOOK IN is set to ENTIRE FORM, it doesn't find records with the specified text. This worked on the form before I put control tabs in. Any idea why the tabs would cause it to not find anymore, and how to fix it? Thanks

I've got a form with tab controls on it. When I do EDIT, FIND, LOOK IN is set to ENTIRE FORM, it doesn't find records with the specified text. This worked on the form before I put control tabs in. Any idea why the tabs would cause it to not find anymore, and how to fix it? Thanks

How can I change the background color/style on the tab pages of a multiple page form? It defaults to the usual drab gray, and there's nothing on the properties page to change it for the tab page, just for the background on the main form. Thanks

I've tried doing this. I got it to display the data from the correct field, but I wanted it to save that data into a corresponding field in another table, but couldn't figure out how to get it bound to another field if it's already referencing the field in the combo box. Any suggestions? Thanks

I have an OLE object field where we put product photos--someone does a copy and paste from web sites into this field. It works fine on some PCs and not at all on others (can't see the pictures). All users are using Access 2000. Thanks for any help.

In the table design, select "hyperlink" for the data type. This makes the data a hyperlink to the URL.

I've got a table with several forms used to fill it in. I have a button on form 1 for the user to go to form 2, etc. When they enter data on record #6 in form 1, for example, I want it to open up to record #6 when they open form 2, form 3 etc, rather than make them search for the right record...

I have a combo box that displays four fields of information and want those fields to fill in four fields on another table. Is it possible to bind mutliple columns to multiple fields in one combo box? If not, how can I do that without having to do four separate combo boxes, one for each field...

This expression from the query for the start date: expr1: [Enter First Date]; this for the end date: expr2: [Enter 2nd Date] Thanks for your help.

I have a report that makes a pie chart of errors over a specific period of time (user specifies these dates in the parameters when opening the report). The pie chart shows up correctly in the report, but when I add the fields for the start date and end date, they just show up as #Name? on the...