Access VBA

Resolved · Medium Priority · Version 2003

Tue 9 Jun 2009, 10:37 Delegate Helen said...

Helen has attended:
Access VBA course

Access VBA

When producing reports from our invoicing database - for some fields the output shows the primary key ID number rather than the contents of the TABLE/QUERY. This only happens when the item in the table is a lookup e.g. to lookup supplier names.
I got around this problem by deleting the ID column and changing the primary key in the relevant table to the field we wanted to show on the report e.g. the supplier name field.
I would like to know if it

Wed 10 Jun 2009, 11:17 Trainer Stephen said...

RE: Access VBA

Hi Helen

Thank you for your question

Ideally, the best solution is to display the relevant fields in a combo box on the form and hide the key column. This is done by specifying that the combo should show both the id filed and the supplier name field. Do this by setting the rowsource property to

"SELECT ID,Supplier Name FROM SupplierTable"

Then set the columncount property to 2, and the columnwidths property to "0cm;5cm". This will result in a combo box that just displays the supplier name.

Hope this helps

Regards

Stephen

Thu 18 Jun 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips