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 strongm 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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 =...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. ojasg

    Lock one field based on selection in another field

    I am building a database that has two fields (amongst many other) 1 - Location 2 - Reason There are like 100 reasons, but for a certain location there are only a few. I want to lock the list displayed by reason field to show only specific reasons based on users selection of the location. This...
  9. ojasg

    Developing an Access Program for Touchscreen

    I am in process of completing a program for use on a touchscreen computer (It will not have a keyboard or Mouse). I created buttons that act as keyboard on some forms which work fine. What I am Struggling With - I have 3 different fields on my form named frmSc. The fields are - FSc, MSc, OSc...
  10. ojasg

    Use a passed value (from previous form) to populate a new form

    I have multiple forms. They need to be seperate. - The first form asks the user to eneter an order number in a combo box and populates relevant info on the form from the table. On this form user is just selecting an order number to look at. - The user then presses a button that closes the...

Part and Inventory Search

Back
Top