The project Im redesigning is a relatively simple accounting program with a few special requirements; the accounts are in different countries/currencies and the accounts are in different companies with a number of accounts types in the same company. All the tables have the same structure and field names. I use a Object Naming Structure that Identifies the County, Company, Account Number, Account Name and Object Type in the object name. All the objects base numbers are stored in a helper table, Accts_HT. [IDA], [AccountName], [Obj]. It is very easy to develop a new account, tables, forms, queries, and reports. All I need to do to add the account, is copy the table, form, query, report and change its target source and name. I spend a lot of time making the Forms and Reports correct before implementing the other accounts. Designing the NDTSB1_F form, I use the Accts_HT data to Display the [AccountName] field with a combo and hopefully identify the [Obj] field but the combo changes to the [AccountName]. I want to use the second column not the first. Ive been reviewing Richards videos trying to find how to do this. I think I remember him indicating how to do this but I cant seem to find it. The person using the database is not very computer literate, so the requirement is buttons for everything. The NDTSB1_F form use two buttons, RegRptButton and ReturnButton. Right now, the use a macro to open the Report and close the form Window. Is there a way to use the [Obj] field to implement VBA to open the report and close a window? That would make coping the form/reports easy. Again only changing the record source and object name.
William Kennedy 5 months ago
William Kennedy 5 months ago
William Kennedy 5 months ago
William Kennedy 5 months ago
William Kennedy 5 months ago
William Kennedy 5 months ago
Sorry, I need to clarify. The person using the database is not very computer literate, so the requirement is buttons for everything. The NDTSB1_F form use two buttons, RegRptButton and ReturnButton. Right now, they use a macro to open the Report and the other button to close the form Window. Is there a way to use the [Obj] field to implement VBA to open the report and the ReturnButton to close a window? That would make coping the form/reports easy. Again only changing the record source and object name.
