(Keep in mind my questions come from someone with little to no practice of VisualBasic. I understand basically how it works, and have taken one class on it; but am nowhere near fluent in it.)
1. How do you go about having a text field on a form set up so that right when user gets to the form, a Message Box or Input Box (with accompanying space for user to type) appears saying "Enter Date", so that whatever user enters into that message box is entered into the text field? I'd want to set it up this way so that a user (who will be inputting more data on the form associated with that date) gets prompted for it immediately when going to the form. Then after putting it in, it just sticks there and stays around, because there's two more subforms within this main form that are linked to the various data that's input to the form--such as the date--and that repeat the data.
(just btw, "Week Ending" is the one I want the prompt for, "Developer" is just something that'll be passed through each time, and "Project ID" is a primary key that'll be passed through each time.)
Quote from other topic:
2. In this same form I am asking about, like I said, it is a main form with two subforms. This is regarding the first of two subforms: Is it possible, when making a subform and linking various fields to the main form (so that whatever user inputs to one field on one form is automatically passed to the given field in the subform), to do this with more than three fields per subform? The create subform wizard only lets me choose three fields to do this with. And when I try to edit in Design view via the "Link Child Fields" and "Link Master Fields" in the Properties for the subform by putting another semi-colon and enter more field(s), it seems to throw the whole set-up off.
3. In this same form I am asking about, like I said, it is a main form with two subforms. This is regarding the second of two subforms: The second subform displays some of the fields that have been entered in by the above two forms in Datasheet view. So
(just btw, "Week Ending" is the one I want the prompt for, "Developer" is just something that'll be passed through each time, and "Project ID" is a primary key that'll be passed through each time.)
1. How do you go about having a text field on a form set up so that right when user gets to the form, a Message Box or Input Box (with accompanying space for user to type) appears saying "Enter Date", so that whatever user enters into that message box is entered into the text field? I'd want to set it up this way so that a user (who will be inputting more data on the form associated with that date) gets prompted for it immediately when going to the form. Then after putting it in, it just sticks there and stays around, because there's two more subforms within this main form that are linked to the various data that's input to the form--such as the date--and that repeat the data.
(just btw, "Week Ending" is the one I want the prompt for, "Developer" is just something that'll be passed through each time, and "Project ID" is a primary key that'll be passed through each time.)
Quote from other topic:
By InputBox, do you mean TextBox? I know they're not the same, but I'm not seeing an InputBox on the toolbox of all the form tools (like with TextBox, Label, ComboBox, etc.) And the only help topic in my Help files having to do with "InputBox Function" links me to a Japanese MSDN site. I'm aware of making the "Insert Parameter Value" prompt show up on a query by placing a [statement enclosed in brackets] in the "criteria" section of a given field. However, I do not know where to enclose [a statement in brackets] that triggers an "Enter Parameter Value" pop-up for a text-box on a form. I've tried inserting [Enter Date] in the control source, in the "Build" areas, as simply the name of the text-box, and I just can't seem to get any sort of prompt for user to enter value to pop up like I used to could in the query I was working with. I tried writing a module in VB for an InputBox. But I'm pretty sure my syntax was wrong or I'm not doing something basic, because in the Expression builder, the name of my Module shows up, but I can't seem to select anything out of it.MsgBox is good. But it won't let the user type anything. InputBox will, but not MsgBox.
You can also [ask a Question in square brackets] in a form / report or query. Doing that prompts the user for Enter Parameter Value and that value is returned to the object that has the question in brackets.
2. In this same form I am asking about, like I said, it is a main form with two subforms. This is regarding the first of two subforms: Is it possible, when making a subform and linking various fields to the main form (so that whatever user inputs to one field on one form is automatically passed to the given field in the subform), to do this with more than three fields per subform? The create subform wizard only lets me choose three fields to do this with. And when I try to edit in Design view via the "Link Child Fields" and "Link Master Fields" in the Properties for the subform by putting another semi-colon and enter more field(s), it seems to throw the whole set-up off.
3. In this same form I am asking about, like I said, it is a main form with two subforms. This is regarding the second of two subforms: The second subform displays some of the fields that have been entered in by the above two forms in Datasheet view. So
- the main form at the top's got three fields users put stuff in
- the second one, the subform, has got a few fields users put stuff in
- the third one is datasheet-view, and it displays the different fields (but also lets user change it from down there if necessary)
(just btw, "Week Ending" is the one I want the prompt for, "Developer" is just something that'll be passed through each time, and "Project ID" is a primary key that'll be passed through each time.)
Last edited: