views:

22

answers:

1

Hello all,

The company I work for have an access database that is linked to a sql server table. The database is on a shared network location so it is used by lots of people in the company (with the annoying problem that only one person can use it at a time).
There are several forms that are used as a front end for the data and on one particular form there are combo boxes that are linked to other tables.
When a report is generated on the form the ID of the combobx is on the form (a GUID) and not the bound item of the combobox.

How can I get the bound items to appear on the form itself? The solution needs to be easy to do or something i can produce that can be regenerated as its used by non technical people. I'm useless outside of Visual Studio so I need some help please.

Thanks in advance to all who contribute!

+2  A: 

In order to make the database usable by many, simply give each user a copy of the front-end.

Forms should almost never be used for reports, the best thing to do is to build a query (the query design window will help) that references each of the relevant tables, for example, if the combobox contained a reference to person type and you might build a query like this for your report:

SELECT a.ID, a.SName, a.MainAddress, c.PersonType 
FROM Addresses a
INNER JOIN PersonTypes c     ''Or LEFT JOIN if data is missing
ON a.PersonTypeKey = c.PersonTypeKey

If this is not possible, perhaps you could explain in more detail exactly how the report is generated from the form.

Remou
At the minute all they are doing is clicking "Create Report" on the form and deleting the columns they don't want. Ill give your idea a go and come back. Thanks for your speedy reply!
Chiefy
Many thanks on the query guide. All sorted now.
Chiefy
Forms are not reports. Reports are reports.
David-W-Fenton