|
| 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
February 16th, 2007, 12:00 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Show N/A like default in combo box
Is it possible when opening an order entry form, to to show 'N/A" as a
default in the combo boxes? I didn't see that option in the properties box. Thanks Ron 
|
|
#2
February 16th, 2007, 12:59 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
Ron
Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#3
February 16th, 2007, 01:28 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
I want it to show up on a report just in case nothing is entered or it's
missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#4
February 16th, 2007, 03:24 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
I got it! For some reason Default Value wasn't showing. I closed the program
and re-opened it and there it was? [ComboBoxName].[ItemData](RowNumber) Thanks Ron "Ron Weaver" wrote: I want it to show up on a report just in case nothing is entered or it's missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#5
February 16th, 2007, 05:59 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
Ron
A combobox on a report?! Combobox implies a choice, reports are printed ... your user/reader may be confused! You could use a text control to display the value selected (or N/A). Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... I want it to show up on a report just in case nothing is entered or it's missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#6
February 16th, 2007, 06:33 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
Jeff
The combo box is in a subform on the 'Orders' form, and has multible selections with the subform set to Continuous Forms. With this subform on the report, the multi selected items are displayed. Is there a way to use code, so the combo box will show "N/A" when there are no selections made? This would automatically show that nothing was needed from that catagory. There are three catagories (combo boxes) to choose from. I hope this makes better sense to you. Ron "Jeff Boyce" wrote: Ron A combobox on a report?! Combobox implies a choice, reports are printed ... your user/reader may be confused! You could use a text control to display the value selected (or N/A). Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... I want it to show up on a report just in case nothing is entered or it's missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#7
February 16th, 2007, 06:43 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
Ron
From your description, you've had Access create a report directly from your form (e.g., "this subform on the report"). I'd recommend that you treat forms (and sub-forms) as on-screen displays, and reports as to-be-printed displays. Were I faced with your situation, I'd create a report "from scratch". This would give me considerably more control over the appearance of data (or N/As) on the report. Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Jeff The combo box is in a subform on the 'Orders' form, and has multible selections with the subform set to Continuous Forms. With this subform on the report, the multi selected items are displayed. Is there a way to use code, so the combo box will show "N/A" when there are no selections made? This would automatically show that nothing was needed from that catagory. There are three catagories (combo boxes) to choose from. I hope this makes better sense to you. Ron "Jeff Boyce" wrote: Ron A combobox on a report?! Combobox implies a choice, reports are printed ... your user/reader may be confused! You could use a text control to display the value selected (or N/A). Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... I want it to show up on a report just in case nothing is entered or it's missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#8
February 16th, 2007, 07:52 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
Sorry Jeff'
I guess I'm just having trouble explaining it to you. The report was created from scratch and was based on tables in the database. All of the fields, customer information, dates and times, rooms, etc. were created from related tables. The combo boxes are on subforms in the 'Orders' form. The combo box forms, one for each catagory, which include two fields each are dragged into the report. One of these, for example, will show three different pieces of equipment with quanity and number of days needed for each piece. When the report is previewed or printed, it will show the three pieces of equipment, quanity, and number of days needed for each catagory. Three different catagories, three different forms, dragged to the report and previewed, printed, and emailed to the customer as an Order Confirmation. I hope this gives you a better idea of what I'm doing. Thanks Ron "Jeff Boyce" wrote: Ron From your description, you've had Access create a report directly from your form (e.g., "this subform on the report"). I'd recommend that you treat forms (and sub-forms) as on-screen displays, and reports as to-be-printed displays. Were I faced with your situation, I'd create a report "from scratch". This would give me considerably more control over the appearance of data (or N/As) on the report. Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Jeff The combo box is in a subform on the 'Orders' form, and has multible selections with the subform set to Continuous Forms. With this subform on the report, the multi selected items are displayed. Is there a way to use code, so the combo box will show "N/A" when there are no selections made? This would automatically show that nothing was needed from that catagory. There are three catagories (combo boxes) to choose from. I hope this makes better sense to you. Ron "Jeff Boyce" wrote: Ron A combobox on a report?! Combobox implies a choice, reports are printed ... your user/reader may be confused! You could use a text control to display the value selected (or N/A). Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... I want it to show up on a report just in case nothing is entered or it's missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#9
February 16th, 2007, 09:09 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
Ron
Are you saying that your underlying tables have "combobox" fields? Created using the lookup wizard? If so, this may be adding to the confusion. Could you explain a bit more what you mean by "The combo box forms, one for each category, ... are dragged onto the report."? A more common (and flexible, and powerful) way to create a report is to first create a query, then base the report on the query, not directly on the underlying table. Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Sorry Jeff' I guess I'm just having trouble explaining it to you. The report was created from scratch and was based on tables in the database. All of the fields, customer information, dates and times, rooms, etc. were created from related tables. The combo boxes are on subforms in the 'Orders' form. The combo box forms, one for each catagory, which include two fields each are dragged into the report. One of these, for example, will show three different pieces of equipment with quanity and number of days needed for each piece. When the report is previewed or printed, it will show the three pieces of equipment, quanity, and number of days needed for each catagory. Three different catagories, three different forms, dragged to the report and previewed, printed, and emailed to the customer as an Order Confirmation. I hope this gives you a better idea of what I'm doing. Thanks Ron "Jeff Boyce" wrote: Ron From your description, you've had Access create a report directly from your form (e.g., "this subform on the report"). I'd recommend that you treat forms (and sub-forms) as on-screen displays, and reports as to-be-printed displays. Were I faced with your situation, I'd create a report "from scratch". This would give me considerably more control over the appearance of data (or N/As) on the report. Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Jeff The combo box is in a subform on the 'Orders' form, and has multible selections with the subform set to Continuous Forms. With this subform on the report, the multi selected items are displayed. Is there a way to use code, so the combo box will show "N/A" when there are no selections made? This would automatically show that nothing was needed from that catagory. There are three catagories (combo boxes) to choose from. I hope this makes better sense to you. Ron "Jeff Boyce" wrote: Ron A combobox on a report?! Combobox implies a choice, reports are printed ... your user/reader may be confused! You could use a text control to display the value selected (or N/A). Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... I want it to show up on a report just in case nothing is entered or it's missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
#10
February 16th, 2007, 09:52 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Show N/A like default in combo box
Jeff
My report is based on the Northwind database. Besides a 'Customers' table I have three tables set up just like the 'Products' table. These three many to many tables go thru junction tables, like 'Product Details'. These three tables each have their own subform on the 'Orders' form. Setting these three forms to Continuous Forms, I am able to select multiple records using a combo box on each form. This database is used to book meetings. Each meeting can require multiple Equipment Items, a variety of Food and Beverages, and a variety of Room Set-Ups. This why I need three many to many tables, three subforms for my 'Orders' form and report. My report is based on a query. My combo boxes are on forms-Not in the tables. "Jeff Boyce" wrote: Ron Are you saying that your underlying tables have "combobox" fields? Created using the lookup wizard? If so, this may be adding to the confusion. Could you explain a bit more what you mean by "The combo box forms, one for each category, ... are dragged onto the report."? A more common (and flexible, and powerful) way to create a report is to first create a query, then base the report on the query, not directly on the underlying table. Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Sorry Jeff' I guess I'm just having trouble explaining it to you. The report was created from scratch and was based on tables in the database. All of the fields, customer information, dates and times, rooms, etc. were created from related tables. The combo boxes are on subforms in the 'Orders' form. The combo box forms, one for each catagory, which include two fields each are dragged into the report. One of these, for example, will show three different pieces of equipment with quanity and number of days needed for each piece. When the report is previewed or printed, it will show the three pieces of equipment, quanity, and number of days needed for each catagory. Three different catagories, three different forms, dragged to the report and previewed, printed, and emailed to the customer as an Order Confirmation. I hope this gives you a better idea of what I'm doing. Thanks Ron "Jeff Boyce" wrote: Ron From your description, you've had Access create a report directly from your form (e.g., "this subform on the report"). I'd recommend that you treat forms (and sub-forms) as on-screen displays, and reports as to-be-printed displays. Were I faced with your situation, I'd create a report "from scratch". This would give me considerably more control over the appearance of data (or N/As) on the report. Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Jeff The combo box is in a subform on the 'Orders' form, and has multible selections with the subform set to Continuous Forms. With this subform on the report, the multi selected items are displayed. Is there a way to use code, so the combo box will show "N/A" when there are no selections made? This would automatically show that nothing was needed from that catagory. There are three catagories (combo boxes) to choose from. I hope this makes better sense to you. Ron "Jeff Boyce" wrote: Ron A combobox on a report?! Combobox implies a choice, reports are printed ... your user/reader may be confused! You could use a text control to display the value selected (or N/A). Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... I want it to show up on a report just in case nothing is entered or it's missed in the order entry process. "Jeff Boyce" wrote: Ron Why do you want to show something (additional) in a combo box? Would it be sufficient to just disable (i.e., "gray-out") the combo box so it cannot be used? This is a fairly commonly-used user interface practice, leaving a grayed-out control to show that it is available, but N/A in the current situation... Regards Jeff Boyce Microsoft Office/Access MVP "Ron Weaver" wrote in message ... Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
