list box selections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Access Users.

I've been setting up list boxes for a while now (enough knowledge to
be dangerous I guess).

Why does my list box selection (once it is already selected on the form),
print out with a black background? I ensured the properties on the form
for all list box fields print without a background color, using standard text.

What am I doing wrong?

Thanks in advance for your help!!

kalyhan
(Please respond to this post)
 
Why are you printing a FORM? Reports are designed for printing (and
normally would not have any list boxes on them since they are not really
printed types of controls.

Build a report and use appropriate controls. Print that, not the form.


Rick B
 
Thanks for the reply. Most databases I set up for my employer allows
users to enter data in a form and click on a "print form" key - embedded
in the form itself. This saves the users, many of which are unfamiliar
with Access features, from having to go into the print menu. In any event,
it keeps users from printing the entire database contents.

This particular database, users enter inspection data directly into a form.
If everything inspects good, then the user simply moves on to a new record
for the
next inspection job they do. If parts are bad however, the user clicks on
the embedded "print form" key, and a rejection report prints out, which gets
attached to the parts.

I find embedding everything on the form itself, keeps users in one screen -
all day - there is no jumping from entry screen or database to reports -
just to print one page - they create a great deal of records in a day.

kalyhan
 
Why not code a button to print the report mentioned? Use a link on your
form (some key number) to have the report only print the curretn record.

I just posted an example earlier today...


Private Sub Print_Button_Click()

If (IsNull([UserID])) Then

' Verify the key field (UserID) has a selection

Exit Sub

End If

DoCmd.OpenReport "SomeReportName", acViewNormal, "","[UserID] =
Forms![frmSomeFormName]![UserID]"

End Sub



This could not be simpler for the user. You would need to save the record
before printing. You could do this in the code, or require the user to save
the record. To do so in the code, I think you would insert a line in the
code just before yur DoCmd.OpenReport... line. To save, I think you put the
following...

Me.dirty=false.



Hope that helps,

Rick B
 
Thanks Rick. I might give that a try. I meant to ask you if that was
possible.

I've done these list boxes several times though - the background of the
selection has never been in black. I must have done something wrong.
Having users enter data into a form and print without leaving that form is
critical
when making their jobs easier and reduces the chances of human error -
a little anyway.

Thanks again, I will try the code tomorrow.

kalyhan

Rick B said:
Why not code a button to print the report mentioned? Use a link on your
form (some key number) to have the report only print the curretn record.

I just posted an example earlier today...


Private Sub Print_Button_Click()

If (IsNull([UserID])) Then

' Verify the key field (UserID) has a selection

Exit Sub

End If

DoCmd.OpenReport "SomeReportName", acViewNormal, "","[UserID] =
Forms![frmSomeFormName]![UserID]"

End Sub



This could not be simpler for the user. You would need to save the record
before printing. You could do this in the code, or require the user to save
the record. To do so in the code, I think you would insert a line in the
code just before yur DoCmd.OpenReport... line. To save, I think you put the
following...

Me.dirty=false.



Hope that helps,

Rick B





kalyhan said:
Thanks for the reply. Most databases I set up for my employer allows
users to enter data in a form and click on a "print form" key - embedded
in the form itself. This saves the users, many of which are unfamiliar
with Access features, from having to go into the print menu. In any event,
it keeps users from printing the entire database contents.

This particular database, users enter inspection data directly into a form.
If everything inspects good, then the user simply moves on to a new record
for the
next inspection job they do. If parts are bad however, the user clicks on
the embedded "print form" key, and a rejection report prints out, which gets
attached to the parts.

I find embedding everything on the form itself, keeps users in one screen -
all day - there is no jumping from entry screen or database to reports -
just to print one page - they create a great deal of records in a day.

kalyhan
Click to expand...
Click to expand...
 
Rick,
I was trying to code as you suggested, but I was doing something wrong.
While coding a new print button, to print a report, I realized that my
list boxes, should be combo boxes - problem fixed. This might
be an easier solution for my users anyway - they don't need to save
anything, they remain in one screen and it's less coding to worry about.

Thanks for your input!

kalyhan said:
Thanks Rick. I might give that a try. I meant to ask you if that was
possible.

I've done these list boxes several times though - the background of the
selection has never been in black. I must have done something wrong.
Having users enter data into a form and print without leaving that form is
critical
when making their jobs easier and reduces the chances of human error -
a little anyway.

Thanks again, I will try the code tomorrow.

kalyhan

Rick B said:
Why not code a button to print the report mentioned? Use a link on your
form (some key number) to have the report only print the curretn record.

I just posted an example earlier today...


Private Sub Print_Button_Click()

If (IsNull([UserID])) Then

' Verify the key field (UserID) has a selection

Exit Sub

End If

DoCmd.OpenReport "SomeReportName", acViewNormal, "","[UserID] =
Forms![frmSomeFormName]![UserID]"

End Sub



This could not be simpler for the user. You would need to save the record
before printing. You could do this in the code, or require the user to save
the record. To do so in the code, I think you would insert a line in the
code just before yur DoCmd.OpenReport... line. To save, I think you put the
following...

Me.dirty=false.



Hope that helps,

Rick B





kalyhan said:
Thanks for the reply. Most databases I set up for my employer allows
users to enter data in a form and click on a "print form" key - embedded
in the form itself. This saves the users, many of which are unfamiliar
with Access features, from having to go into the print menu. In any event,
it keeps users from printing the entire database contents.

This particular database, users enter inspection data directly into a form.
If everything inspects good, then the user simply moves on to a new record
for the
next inspection job they do. If parts are bad however, the user clicks on
the embedded "print form" key, and a rejection report prints out, which gets
attached to the parts.

I find embedding everything on the form itself, keeps users in one screen -
all day - there is no jumping from entry screen or database to reports -
just to print one page - they create a great deal of records in a day.

kalyhan

:

Why are you printing a FORM? Reports are designed for printing (and
normally would not have any list boxes on them since they are not really
printed types of controls.

Build a report and use appropriate controls. Print that, not the form.


Rick B



Hello Access Users.

I've been setting up list boxes for a while now (enough knowledge to
be dangerous I guess).

Why does my list box selection (once it is already selected on the form),
print out with a black background? I ensured the properties on the form
for all list box fields print without a background color, using standard
text.

What am I doing wrong?

Thanks in advance for your help!!

kalyhan
(Please respond to this post)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top