Search results for query: *

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

Hi, What books on Access are recommended for a person new to database design and who wants to become proficient as quickly as possible? I'm an accountant trying to develop a database for my employer's use. I'm currently using Access 2000. I've taken an introductory course about two years ago...

I copied the query and ran it. I received the same result; i.e. Dialog box asking me to Enter Parameter Value" Employee.Emp Hrs. I opened the query in design mode and found the following: Column 1 Field: Employee Initials Column 1 Table: Employee Column 2 Field: Expr1: [Employee].[Emp...

Before I do that, would you explain what the "Me" is supposed to represent? Was I supposed to replace "Me" with the name of a table?

Bob, Thanks for your patience. I'm not sure what I'm doing incorrectly. I posted: Me![Wages]=Me![Emp Hrs]*Me![cboEmployeeSelect].Column(1) In the AfterUpdate field in the Hours Worked control. Is there something I missed? Darrel

I entered the code as directed. Now when I click on the employee box, I received the prompt to "enter parameter value" for employee hours. I just entered a number and pressed enter, and then the list of employees appears. I chose an employee and entered a value in the employee hours...