If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
3 Questions
#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. |
#2
|
|||
|
|||
3 Questions
"scadav" wrote in message
oups.com... #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. 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. 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? I think you'd have to provide your own custom toolbar with those options included. Regards, Keith. www.keithwilby.com |
#3
|
|||
|
|||
3 Questions
Keith Wilby wrote: "scadav" wrote in message oups.com... #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. What problem, can you elaborate? You don't want users to be able to modify data and they can't - what am I missing? 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. 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. Have you considered the built-in "filter by form" feature? No. How do you get to this? #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? I think you'd have to provide your own custom toolbar with those options included. Regards, Keith. www.keithwilby.com |
#4
|
|||
|
|||
3 Questions
#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. "scadav" wrote in message oups.com... #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. |
#5
|
|||
|
|||
3 Questions
John Spencer wrote: #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. 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. #2. I have no answer for this one. #3. You can implement a custom menubar that contains only those items. "scadav" wrote in message oups.com... #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. |
#6
|
|||
|
|||
3 Questions
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. "scadav" wrote in message ups.com... John Spencer wrote: #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. 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. #2. I have no answer for this one. #3. You can implement a custom menubar that contains only those items. "scadav" wrote in message oups.com... #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. |
#7
|
|||
|
|||
3 Questions
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. -- HTH Mr B "scadav" wrote: #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. |
#8
|
|||
|
|||
3 Questions
"scadav" wrote in message
oups.com... 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. I think John's suggestion is a good one and easy to implement. Have you considered the built-in "filter by form" feature? No. How do you get to this? Search the help, it's all in there :-) Regards, Keith. www.keithwilby.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | New Users | 4 | June 28th, 2004 02:58 PM |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | Formatting Long Documents | 4 | June 28th, 2004 02:57 PM |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | Mailmerge | 6 | June 28th, 2004 02:57 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - May | Charles Kenyon | Mailmerge | 3 | May 24th, 2004 05:54 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - April | Charles Kenyon | Mailmerge | 0 | April 26th, 2004 03:33 PM |