Recent content by darrelhawes

Thanks so much for both posts! Very helpful as I am still learning the basics.

I am designing a simple database to track equipment usage information. We maintain a fleet of construction equipment that is charged out to construction projects based upon hours used, subject to a minimum amount of hours. The minimum amount of hours is different for each piece of equipment. I...

It worked! Thanks so much! Darrel

I tried your instructions...I received the error message: "Run-time error '450': Wrong number of arguments or invalid property assignment" By the way, why do you suppose that my other attempt did not work, namely putting the reference to the combo box in the default value setting in...

Following the example of the "Time and Billing" sample database that comes with Access 2000, I tried to achieve the same result by referring to the combo box (as stated above) in the Default Value property of my Rate text box. Still, nothing happens. If I copy the code to the control...

Two questions: 1. Are you saying that I should put the following in the AfterUpdate property of my employee field: Me.[Ratetextbox].Value = [Forms]![YourForm].[ComboBoxName].[Column](index) I tried this and nothing happened. I did notice that the system added an equals sign at the beginning...

I have a form that contains a combo box with employee data. The form is tied to a transaction table. I choose the employee's initials (small organization :) ). The combo box is tied to another small table with initials, employee name, and employee wage rate. All three appear on the combo box...

Which property needs to have the expression me.fieldname=value?

I have a form with a calculated field. I want to populate a specific field in the underlying record with the results of the calculation. What is the best way to do this? Darrel Hawes

It worked! Thanks very much. Darrel

I looked at the properties for the command box and can't figure out where to add the statement me.combobox0.requery. I have discovered that if the user selects Records-Refresh it will update the list but I would like it to be an automatic process.

Where do I enter the requery command?

I'm working on a data-entry form which has several combo boxes linked to tables. In most cases, I have restricted data entry to the lists in the combo boxes (pulled of course from the underlying tables). I have set up command buttons next to some of the combo boxes in order to add new records...

Bob, For some reason, my version of Access (2000) did not know what to do with the "Me" shorthand. I must have done something else wrong. It kept adding the equal sign in the beginning of the statement. However, by studying one of Microsoft's sample databases, I was able to finally...

OK, I made that correction on the SQL statement. Now I am able to select the employee from the combo box, and enter the number of hours. When I tab out of the hours field, I receive the following error message: "The expression AfterUpdate you entered as the event property setting produced...