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!

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

Recent content by FabHead

  1. FabHead

    Main Form - Sub Form Challenge

    Robert, That did the trick. Should fine tune it in the next day or so....I'll post code so others can see. Really strange you have to use DAO to get it to work. Thanks for the help! Rick
  2. FabHead

    Main Form - Sub Form Challenge

    Robert, I was hoping to just use ADO throughout my database. I'll set a reference to "Microsoft DAO 3.6 Object library" and give it a try later tonight....gotta go earn a paycheck. Rick
  3. FabHead

    Main Form - Sub Form Challenge

    Robert, Luck would have it I got the old 'Type Mismatch' error at the: Set objRSet = Forms!MaintAction!MaintPartsUsed.Form.Recordset This is really turning out to be way harder then it should be. I'll keep trying different things, thanks for any idea's Here is my unworking code. Dim...
  4. FabHead

    Main Form - Sub Form Challenge

    Thanks Robert, That recordset for the Sub Form was kicking my A$$. I'll work on what you suggested and let you know. Rick
  5. FabHead

    Main Form - Sub Form Challenge

    This has been a problem for me for quite a while, but I'm sure someone has done something similar before. I have frmMaintAction (Main form) and subfrmMaintPartsUsed (Sub Form). The forms are Linked by a field called MaintID. The Sub Form is in Continuous Forms view (It is all the Maintenance...
  6. FabHead

    Get Field Data from Sub-Form in Continuous Form View

    Thanks, for the help. I've been working on it off and on with no luck. I did create and SQL string that uses the link field (MaintID) but I am unable to access the subform. I'm a bit weak in the use of recordset. MaintPartsUsed_Query is the Record Source of the Subform I want to get the...
  7. FabHead

    Get Field Data from Sub-Form in Continuous Form View

    I have a sub-form called MaintPartsUsed that is displayed in continuous form format. The sub-form may have from 1 to many records associated to the record in the main (parent) form. I would like to be able to access each record in the sub-form. Then copy certain fields to an excel template...
  8. FabHead

    Copy Access Form Control Values to Excel File Cells

    Public Sub ExcelFSR() Dim FSENameXL as string 'Example data transfer Dim MyXL As Object ' Variable to hold reference to Microsoft Excel. Dim sheet As Excel.Worksheet Dim cell As Excel.Range 'Set the object variable to reference the file you want to see. Set MyXL =...
  9. FabHead

    Copy Access Form Control Values to Excel File Cells

    Ace, That was a very good start....in the right direction. I was able to save the info I wanted to the excel file (cell) I wanted. Just had to figure out how to open excel and make it visible so the user can view and print, which I believe I can get working very soon. I'll post my final code...
  10. FabHead

    Copy Access Form Control Values to Excel File Cells

    I have a form called "MaintAction" and on the form is a command button called "Create FSR" (Field Service Report). With the form opened to the desired record, I want to be able to click "Create FSR" then an Excel file called FRS.xls would open. Then the values of a...
  11. FabHead

    Unbound TextBox and Report Criteria

    Problem with using a combo or list box is it alows me only one selection. I want to use 1,2,3 or all 4 possibilities to filter the records I want. The unbound textbox is called WBT.
  12. FabHead

    Unbound TextBox and Report Criteria

    I have a query built and a field named WaferType. WaferType consists of four possible entries called: WarmUP, Product, Monitor, and Maintenance. Now if I enter in the criteria box of the query under WaferType the following: "WarmUP" Or "Product" Or "Monitor" Or...
  13. FabHead

    Edit Graphic Image with MSpaint

    I have an graphic Image called "ImageWafer" in a form called BrokenWafer. I work in the semiconductor industry and want to track broken wafers. What I would like to do is have a command button in the form to open MSpaint and edit the graphic. I want to draw lines on it to show how...
  14. FabHead

    Combo Box will not Record Selection to Table

    dz, I tried what you suggested and I believe you are in the right area, but I must have another problem. Before changing anything I checked and had a null value on both sides of the expression: recset!SubSystemID = Subsystem.Column(1) I then changed this to: recset!SubSystemID =...
  15. FabHead

    Combo Box will not Record Selection to Table

    FoxPro, I have not done a very good job of explaining what I have, I guess it's hard to see what someone else is doing. I have a form called Maintenance and it's RecordSource is tblMaintenance (where all the selections are stored). tblMaintenance has: Field Name Data Type...
See more

Part and Inventory Search

Back
Top