Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ojasg
  • Order by date
  1. ojasg

    Dynamic Name Change of Report Fields

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

    Dynamic Name Change of Report Fields

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

    Dynamic Name Change of Report Fields

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

    Passing value of Keyboard form to calling form

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

    Passing value of Keyboard form to calling form

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

    Passing value of Keyboard form to calling form

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

    Opening an Excel File from Acess and Updating the Links in the Excel File

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

    Opening an Excel File from Acess and Updating the Links in the Excel File

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

    Opening an Excel File from Acess and Updating the Links in the Excel File

    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 =...
  10. ojasg

    Open a specific Record using OpenArgs

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

    Open a specific Record using OpenArgs

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

    Open a specific Record using OpenArgs

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

    MS Access Acting Strange!`

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

    MS Access Acting Strange!`

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

    Copy certain fields from one row of continuous form to another

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

    Copy certain fields from one row of continuous form to another

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

    Copy certain fields from one row of continuous form to another

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

    Copy certain fields from one row of continuous form to another

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

    Copy certain fields from one row of continuous form to another

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

    Take a Print Screen of Active Screen and Email as a picture to admin

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

Part and Inventory Search

Back
Top