Search results

Hello: What you want to do is put the additional code to re-enable the boxes on the OnCurrent event of your form. Then as you go from record to record, the boxes will enable and un-enable as you like. Regards Mark

Hello: Your welcome, and good luck with this. Regards Mark

Hello: Below would be an example using a criteria that is on a form: SELECT tblStaff.StaffID, tblStaff.FirstName, tblStaff.LastName, tblStaff.Address, tblStaff.City, tblStaff.State FROM tblStaff WHERE (((tblStaff.State)=[Forms]![frmForm1]![txtState])); Please see my example db enclosed below...

Hello: Yes: Text boxes handle SQL statements. You want to place the statement in the "ControlSource" property of your text box. Regards Mark

Many thanks: Mark

Hello: The enclosed link below has a complete data model for churches. It even includes the offerings portion. You can modify this to your needs http://www.databaseanswers.org/data_models/church_members/index.htm Regards Mark

Hello: All that is needed is set the "Default Value" in the properties section for your combo box. Regards Mark

Hello The enclosed link below tells how to accomplish that. Regards Mark http://support.microsoft.com/kb/210060/en-us

Hello The enclosed link below tells how to accomplish that. Regards Mark

One more: http://office.microsoft.com/en-us/access/HP051875641033.aspx

Hello: Please see the enclosed link. http://support.microsoft.com/kb/209479/en-us Regards Mark

Hello: Put your form into "Design Mode" then on the menu select: View, Field List. From the field list merely drag your field down to the form and place it. Regards Mark

Hello: One way would be to drop a combo box on your form and follow the wizard instructions. You want to select the first item, "Lookup items in table or query" Upon completion, this should house all your items you need looked up. Regards Mark

Hello You want use the "DSUM" function. It allows criteria to used to ferret out specific items. Regards Mark

Hello I glad that helped. Good luck with this! Regards Mark

Hello I have enclosed an example db of an example of this procedure. Regards Mark

Hello One way would be to do this using a "Totals" query and base your report on this query. Place your key field and the field you want counted in a query. Then on the tool bar press the "Summation" symbol and in the group by field for the key field, select count. Then run the query. This...

http://support.microsoft.com/kb/231851/en-us

Hello Here are some good examples of report examples. Regards Mark

Hello: The Environ function may help you with this task: Such as =Environ("USERPROFILE") =Environ("windir") Put these examples in the control source of a text box There are about 50 different constants depending on your Access version. Search Environ in help for the complete list. Regards Mark