Logo in report on user level

[Lasse T]

Hi !
I have a database that is used by 20 different users in 20 different places.
Hopefully more in the future. Some of this users want their logotype on some
of the reports. Today there is a text box on each report showing the company
name. How do I let the user add a logo to the report? Of course I can put
the image control in the reports an tell the users to put their logo i a
specific folder but in that case the users MUST use a logo. Some of the
users had also asked me for small design changes like removing or add a
line. I spend alot of time as it is and I constantly work on the db to make
it better and add new funktions. To make every uses db unique would be to
much work.

The dream would be to find a way to let the users change the report design
by themselves, but sins I´m giving them a MDE frontend that is probably
impossible. I thought I could use linked reports and send them a MDB with
only the reports but that did not work. Then I thought of sending them a MDB
with the reports and let them import their reports into the MDE when they
had changed them but I´m afraid it will be to difficult for the users.

I would highly appreciate any ideas on how to solve this.

I have one more question. The path to the BE are not the same depending on
if the users runs it on a network och locally. Today i create two different
MDE, one to run on a network an one to run locally. It would be nice if the
user could get a question then browse to the BE the first time he starts the
FE. In that case I could use the same FE to all users. Is this possible
without to much trouble?

Lasse T
------------

 

[Rick Brandt]

Hi !
I have a database that is used by 20 different users in 20 different
places. Hopefully more in the future. Some of this users want their
logotype on some of the reports. Today there is a text box on each
report showing the company name. How do I let the user add a logo to
the report? Of course I can put the image control in the reports an
tell the users to put their logo i a specific folder but in that case
the users MUST use a logo. Some of the users had also asked me for
small design changes like removing or add a line. I spend alot of
time as it is and I constantly work on the db to make it better and
add new funktions. To make every uses db unique would be to much work.

The dream would be to find a way to let the users change the report
design by themselves, but sins I´m giving them a MDE frontend that is
probably impossible. I thought I could use linked reports and send
them a MDB with only the reports but that did not work. Then I
thought of sending them a MDB with the reports and let them import
their reports into the MDE when they had changed them but I´m afraid
it will be to difficult for the users.
I would highly appreciate any ideas on how to solve this.

I have one more question. The path to the BE are not the same
depending on if the users runs it on a network och locally. Today i
create two different MDE, one to run on a network an one to run
locally. It would be nice if the user could get a question then
browse to the BE the first time he starts the FE. In that case I
could use the same FE to all users. Is this possible without to much
trouble?

You could have a table for user-preferences. This will come in handy for lots
of stuff down the road. I would use a structure of two fields [PreferenceName]
and [PreferenceEntry]. In your case they could either make an entry of...

[PreferenceName] [PreferenceEntry]
ReportHeaderText "My report header Text"

or

[PreferenceName] [PreferenceEntry]
ReportHeaderLogo "PathToMyLogoImage"

Your Report could use code that tested for the presence of a ReportHeaderLogo
preference. When not found set the image control to Visible = False. It could
perform a similar test for ReportHeaderText. I would create a user defined
function specifically for retrieving preferences and use that in all my code.

The way I do this is that I (the developer) add entries to the preferences table
since I have to create code that will use them, but I expose a form to the user
for setting the "Entry" value. As appropriate, some entries would be assigned
default values by the developer.

 

[Lasse T]

Hi !
I have a database that is used by 20 different users in 20 different
places. Hopefully more in the future. Some of this users want their
logotype on some of the reports. Today there is a text box on each
report showing the company name. How do I let the user add a logo to
the report? Of course I can put the image control in the reports an
tell the users to put their logo i a specific folder but in that case
the users MUST use a logo. Some of the users had also asked me for
small design changes like removing or add a line. I spend alot of
time as it is and I constantly work on the db to make it better and
add new funktions. To make every uses db unique would be to much work.

The dream would be to find a way to let the users change the report
design by themselves, but sins I´m giving them a MDE frontend that is
probably impossible. I thought I could use linked reports and send
them a MDB with only the reports but that did not work. Then I
thought of sending them a MDB with the reports and let them import
their reports into the MDE when they had changed them but I´m afraid
it will be to difficult for the users.
I would highly appreciate any ideas on how to solve this.

I have one more question. The path to the BE are not the same
depending on if the users runs it on a network och locally. Today i
create two different MDE, one to run on a network an one to run
locally. It would be nice if the user could get a question then
browse to the BE the first time he starts the FE. In that case I
could use the same FE to all users. Is this possible without to much
trouble?

You could have a table for user-preferences. This will come in handy for
lots of stuff down the road. I would use a structure of two fields
[PreferenceName] and [PreferenceEntry]. In your case they could either
make an entry of...

[PreferenceName] [PreferenceEntry]
ReportHeaderText "My report header Text"

or

[PreferenceName] [PreferenceEntry]
ReportHeaderLogo "PathToMyLogoImage"

Your Report could use code that tested for the presence of a
ReportHeaderLogo preference. When not found set the image control to
Visible = False. It could perform a similar test for ReportHeaderText. I
would create a user defined function specifically for retrieving
preferences and use that in all my code.

The way I do this is that I (the developer) add entries to the preferences
table since I have to create code that will use them, but I expose a form
to the user for setting the "Entry" value. As appropriate, some entries
would be assigned default values by the developer.

Thank you very much. I must edmit i did not understand fully but this is
what I´m trying now.

I have a table with some fields that has not been used. I´m using one of
those fields so that I dont need to update the users BE. In one of these
fields I input a "1". In the open event of the report I use an if-then-else
statement who check the table field if it is "1". If it is "1" then the
image control visibility is true else it is false.
The only problem is that i can not get the info from the table. I don´t know
how to write the code. programinstallningar is the table and
nummerserierFakturar is the field.

Private Sub Report_Open(Cancel As Integer)
If Table![programinstallningar]![nummerserierFakturor] = 1 Then
Me![logo].Visible = True
Else
Me![logo].Visible = False
End If

End Sub

Thanks in advance
Lasse T
------------

 

[Rick Brandt]

Thank you very much. I must edmit i did not understand fully but this
is what I´m trying now.

I have a table with some fields that has not been used. I´m using one
of those fields so that I dont need to update the users BE. In one of
these fields I input a "1". In the open event of the report I use an
if-then-else statement who check the table field if it is "1". If it
is "1" then the image control visibility is true else it is false.
The only problem is that i can not get the info from the table. I
don´t know how to write the code. programinstallningar is the table
and nummerserierFakturar is the field.

Private Sub Report_Open(Cancel As Integer)
If Table![programinstallningar]![nummerserierFakturor] = 1 Then
Me![logo].Visible = True
Else
Me![logo].Visible = False
End If

End Sub

Use DLookup()

Private Sub Report_Open(Cancel As Integer)
If DLookup("nummerserierFakturor", "programinstallningar") = 1 Then
Me![logo].Visible = True
Else
Me![logo].Visible = False
End If
End Sub

 

[Lasse T]

Thank you very much. I must edmit i did not understand fully but this
is what I´m trying now.

I have a table with some fields that has not been used. I´m using one
of those fields so that I dont need to update the users BE. In one of
these fields I input a "1". In the open event of the report I use an
if-then-else statement who check the table field if it is "1". If it
is "1" then the image control visibility is true else it is false.
The only problem is that i can not get the info from the table. I
don´t know how to write the code. programinstallningar is the table
and nummerserierFakturar is the field.

Private Sub Report_Open(Cancel As Integer)
If Table![programinstallningar]![nummerserierFakturor] = 1 Then
Me![logo].Visible = True
Else
Me![logo].Visible = False
End If

End Sub

Use DLookup()

Private Sub Report_Open(Cancel As Integer)
If DLookup("nummerserierFakturor", "programinstallningar") = 1 Then
Me![logo].Visible = True
Else
Me![logo].Visible = False
End If
End Sub

Thanks. That did the trick.

Lasse T
-----------