Recent content by ojasg

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...

Thanks.. Will try that forum.. If I find the solution.. Will post it here.

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...