Adding ODBC Connection to a Form
Is there a way I can add the ODBC data source selection to a form? Or better yet specify it as the label format is opened?
I have a client with a different Access database for each area manager. The structure of each Access database is the same. The structure of the label formats is the same apart from the database connection. The current solution is to have the same designs repeated for each database. Messy and any design change has to be duplicated 6 times.
-
I think this will work. If you make the Database a Named Database (all with the same name) then on each machine you can go into the Administration Console and edit the Named Database location on each PC from the Database Connections option
0 -
Thank you, Peter I have already suggested that but the way they have the database all in the same folder and won't move from that. So I do need to allow the user to select the Access database they work with.
0 -
Cheat!
Create a label for each area linked to the specific database and save them in a folder.
Create a new label, that will not print, but just has an area selection option on a Data Entry Form and a print button on it. Use an Action on this form to open just that specific label and print that
0 -
Alternatively
- create extra identical templates into the label
- add each database to the database connection setup and form a join between them
- add a Data Entry Form option where the users select the area they are in (I would suggest populating this from either a simple CSV file or an embedded list both in a Drop Down List entry box)
- configure each template to use the data from a different database and on the Properties of each template adjust the Print When to be when the value in the Data Entry Form box equals the specific area that the database data comes from
0 -
My goal was to avoid having label sets for each database, which means you Cheat! suggestion, if I understood it correctly, will be a non-starter. However, your Alternative solution looks to be the way to go. Thank You.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
5 Kommentare