3 Questions

  • Thread starter Thread starter scadav
  • Start date Start date
S

scadav

#1
Assume I want to have a continuous form and want to populate it with a
bunch of fields that I do not want the user to edit. Basically a
read-only view (They will have to drill down into the details of the
record in order to change it). When I create the continuous form, I am
locking all the controls so the user cannot change them from this view.
If a certain field uses a combo box to populate it, the drop down
arrow appears in the form giving the user the impression that they can
change this field, but obviously they can't because it is lock.. To
get around this problem, I end up creating a bunch of dlookups to
unbound text boxes, but this just seam so inefficient. Can anyone
suggest a better way? For multiple reasons, I do not want to use
datasheet view in this "read-only" view.

#2
Is there a way to implement some type of grid control into access? I
was hoping for some type of sorting capabilities in the grid. I am
pretty new to access, so I was hoping the grid technology would be very
easy and cheap.

#3
This seams to be a very simple problem, but I can't solve it. I am
preventing a user from seeing all of the toolbars that access displays
(form view, formatting, etc) via the startup configuration screen. I
only have one exception to this which is the print preview toolbar when
someone is previewing a report that I have run. That tool bar contains
a print icon, a "close" button, a % increase option, etc. Is there a
way to just keep that toolbar?

Thanks in advance.
 
scadav said:
#1
Assume I want to have a continuous form and want to populate it with a
bunch of fields that I do not want the user to edit. Basically a
read-only view (They will have to drill down into the details of the
record in order to change it). When I create the continuous form, I am
locking all the controls so the user cannot change them from this view.
If a certain field uses a combo box to populate it, the drop down
arrow appears in the form giving the user the impression that they can
change this field, but obviously they can't because it is lock.. To
get around this problem, I end up creating a bunch of dlookups to
unbound text boxes, but this just seam so inefficient.
Click to expand...

What problem, can you elaborate? You don't want users to be able to modify
data and they can't - what am I missing?
Can anyone
suggest a better way? For multiple reasons, I do not want to use
datasheet view in this "read-only" view.

#2
Is there a way to implement some type of grid control into access? I
was hoping for some type of sorting capabilities in the grid. I am
pretty new to access, so I was hoping the grid technology would be very
easy and cheap.
Click to expand...

Have you considered the built-in "filter by form" feature?
#3
This seams to be a very simple problem, but I can't solve it. I am
preventing a user from seeing all of the toolbars that access displays
(form view, formatting, etc) via the startup configuration screen. I
only have one exception to this which is the print preview toolbar when
someone is previewing a report that I have run. That tool bar contains
a print icon, a "close" button, a % increase option, etc. Is there a
way to just keep that toolbar?
Click to expand...

I think you'd have to provide your own custom toolbar with those options
included.

Regards,
Keith.
www.keithwilby.com
 
Keith said:
What problem, can you elaborate? You don't want users to be able to modify
data and they can't - what am I missing?
Click to expand...

Just the fact that the user can see a drop down selection and click the
drop down and see all the values, but they can't select any value. I
would rather the user just see a text box so they do not get confused
and think they can edit the form from this view. I am trying to make
it look more like a grid.
Have you considered the built-in "filter by form" feature?
Click to expand...

No. How do you get to this?
 
#1. If you want the user to drill down into the details, does this mean you
want them to double click anywhere on the line and have another form open?
If so, you can handle this in a variety of ways. One method is to put
***one*** large transparent button on TOP of all controls and use its
double-click event to do what you wish. The button should me as tall as the
detail section and as wide as the detail section.

#2. I have no answer for this one.

#3. You can implement a custom menubar that contains only those items.
 
John said:
#1. If you want the user to drill down into the details, does this mean you
want them to double click anywhere on the line and have another form open?
If so, you can handle this in a variety of ways. One method is to put
***one*** large transparent button on TOP of all controls and use its
double-click event to do what you wish. The button should me as tall as the
detail section and as wide as the detail section.
Click to expand...
Sorry I am not being clear. I have a way for them to drill down into
the details of the line item, that is not what I am looking for
assistance on.

My problem is that for items that automatically get a combo box, when
you drag them onto the form from the field list, I wish to represent
those items on the continuos form as a standard text box. Why?
because the users are complaing that a locked combo box is confusing.
So to get around this problem, I just create a bunch of unbound text
boxes and use dlookups on all of them. I didn't think that that was a
very good way of doing that and I wanted to see if someone had another
suggestion.
 
Ok. I understood you. What I was saying is that if you have a transparent
button over the top of the controls, then the users can never click on the
comboboxes, so they can't do a drop down. I actually think that using a
query and linking to the tables with the data in them would be more
efficient than using a DLookup function for each field.
 
If your continuous form where the combo boxes are is not the form where your
users are completing data entry, then simply right click on the combo box
control and change it to a text box control. It will remain linked to the
correct field and display the current value in each record.

As for sorting capabilities, you can change the sort order and the fields
being sorted on programatically using your current continuous form. You can
use either different buttons that will reset the Order by property of your
form, or you and use a group control with mulitple options and let this
method change the Order by Property.

As for toolbars, you would need to create a custom toolbar and have it
linked to your report.
 
scadav said:
Just the fact that the user can see a drop down selection and click the
drop down and see all the values, but they can't select any value. I
would rather the user just see a text box so they do not get confused
and think they can edit the form from this view. I am trying to make
it look more like a grid.
Click to expand...

I think John's suggestion is a good one and easy to implement.
No. How do you get to this?
Click to expand...

Search the help, it's all in there :-)

Regards,
Keith.
www.keithwilby.com
 
Back
Top