You guys are genius!
OnFormat works and yes the controls are in the details section.
Thank You So Much!
I don't post a lot of questions on here as most are answered in forums; but MajP believe me, you have answered almost every question I have posted here in last 5 years; including some...
Yes.. What I meant is the field is dummy variable. It is actually a "Yes/No" field; I just have to display a different question next to Yes/No field depending on the area selected.
I have tried to run the code in every possible event on the report. What I need is for each record to run this...
In my main table, I have 10 variables with datatype "Yes/No".. each with a corresponding label "lblVar(i)" where i = 1-10. The same main table has a field called "Area". There is another table "tbQuestions" with two columns: "Question" and "Area".
On the main form, depending on which area is...
Yes the built-in keyboard is too small. I build these applications for use on toughbooks, used in very demanding conditions. So the buttons have to be large. I even use my own calendar form and can't use the in built date picker.
I actually found an easier way to pass the values.. but the...
Thanks to everyone for their inputs and prompt replies.
This is how I was able to resolve my issue.
On my "calling form" when a field that needs a numeric entry get's focus .. I use the following code -->
Private Sub Flow_GotFocus()
DoCmd.OpenForm "frmNumPad"
End Sub
Now the focus is on...
I have a Keyboard form for touchscreen application. I store the value of what the user types in txtPassingValue.
This form will be invoked each time the user clicks on any field requiring a keyboard entry on other forms. Once the keyboard form opens, the user will type in what they need to and...
Ok.. So after playing around for a while, I think I have a found a solution.
Everything with code is ok. What needs to be altered is the Excel file settings.
Open your Excel File.
Click on "Data" in the Ribbon
Click on "Edit Links"
Ensure Update is Automatic
Click on "Startup"
Ensure the "Don't...
I am having a very peculiar problem.
I am using the following code to open an Excel File from Access -->
// Code Starts //
DoCmd.OutputTo acOutputQuery, "qryOutputIncommingVsMeasuredToExcel", "*.xlsx", "Q:\Some Path\MeasuredVsIncommingRawData.xlsx"
Dim AppExcel As Object
Set AppExcel =...
strWhere = "TWONumber =" & Me.TWONumber
DoCmd.OpenForm "frmToolingWorkOrderDuplicate", , , strWhere
DoCmd.Close acForm, "frmCloseToolingWorkOrder"
Yes I had tried this above code. It did not work.
However,
strWhere = "TWONumber =" & Me.TWONumber...
I keep getting error.
TWONumber is an AutoNumber.
I have what you suggested in addition to this -->
strWhere = TWONumber.Value
DoCmd.OpenForm "frmToolingWorkOrderDuplicate", , , strWhere
It's not working. I get this error -->
"You can't reference a property or method for...
I have two forms, both connected to the same table.
On closing FormB, I would like to pass a field value as OpenArgs to FormA, and Open FormA
On Opening FormA, I would like to go to that record in FromA which as the FieldValue = OpenArgs, and directly display this specific record only, out of...
Oops.. Found it!
Here is how to fix it..
1.Right-click the form in the Navigation Pane, and then click Design View.
2.On the Design tab, in the Controls group, ensure that Use Control Wizards is selected.
I don't even know how to properly describe this, But I will try.
When I drop a combo box on my form, a scree used to pop up with 3 options, in which I can use the combo box. When I used to drop a subform, same thing, a "wizard" screen would automatically pop up and I would go thru the process...
I just used a child form to be displayed as datasheet, and some code to store values to be copied over in a temp variable, and copy those to the new field.
It works. I still want to try and learn more about continuous forms, but for now I can do without them.
Thank a lot guys for your inputs...
AceMan1,
That sounds like something which will work. I am travelling for work for next two days and won't get time to try it out till next week. But I will keep you posted on the progress I make.
Once again thanks to you and PWise for your inputs.. they are greatly appreciated.
This is a database for creating and storing Tooling Work Orders.
Another form creates a tooling work order. A button on that form directs a user to this continuous form.
The tooling work order number is passed as an OpenArgs. This number remains same for all subsequent entries related to the...
I am sorry, I was not specific; the values are entered by the user in the first row and then they are same for the rest of the rows.
So I can't use defaults. They are user inputted values, which are common during each seperate instance of the form being used.
I am using a continuous form. It has 10 fields in total, out of which certain are going to be common for all, depending on the situation. I was wondering if I can auto populate these common fields, each time a new row pops up on the continuous form.
I would like to know if there is a VBA code...
Hello Guys,
I have a database that is widely used in our company without issues. As an enhancement, I want to add a feature which allows the user to take a print - screen of the active screen (Snapshot of the active screen) on click and send the image via email to preset receipients.
I found...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.