Recent content by hardhitter06

  1. H

    Require OLE object on Input Form

    Ahhh perfect sneuberg!!! Thanks so much!
  2. H

    Require OLE object on Input Form

    Hi All, I'm trying to figure out how to require an OLE Object in the BeforeUpdate of my Access 2010 input form. The ole object is named ExecutedContract. I'm not sure how to integrate this piece of code with what I have so far. I'm also having trouble finding anything on the web. Private...
  3. H

    Export Excel file but first ask for date range

    Do you mean having fields to enter in dates and then hit the command button?
  4. H

    Export Excel file but first ask for date range

    Hi All, I've set up a command button to export my query to an excel file but I'm not sure how I can ask for the date range before the file is exported? I have this for code: Private Sub Command5_Click() DoCmd.OutputTo acOutputQuery, "QryMaster", acFormatXLS End Sub And I have this code for...
  5. H

    Trouble with onClick

    Thanks Bob for the link, here ya go.
  6. H

    Trouble with onClick

    Attached (if i did it right?) Also, Form B has a subform. Form A and Form B are seperate other than that sharing Contract No. Form B and SubFormB share a lot of fields hence why I created a subform there.
  7. H

    Trouble with onClick

    Hi All, I have a database with two tables and two forms. FormA arrives prior to a Contract. FormB arrives post Contract. FormA and FormB are actual names of forms in our office. ContractNo is the FK for both. On my dashboard, I have a search for FormA. When clicking the command button...
  8. H

    Want Form A field to flood into Form B Field

    Beautiful! That did it. Thanks Paul!
  9. H

    Want Form A field to flood into Form B Field

    Thanks Paul but it isn't working Private Sub Command56_Click() DoCmd.OpenForm "FormBSearch", OpenArgs:=Me.ContractNo End Sub Private Sub Form_Current() If Len(Me.OpenArgs & vbNullStirng) = 0 Then _ Me.ContractNo = Me.OpenArgs End Sub
  10. H

    Want Form A field to flood into Form B Field

    I just want the ContractNo from the first search on the first form to show up in the ContractNo field on the 2nd form from the 2nd search. Basically FormA's ContractNo to flood into FormB's ContractNo.
  11. H

    Want Form A field to flood into Form B Field

    Hi, I'm trying to flood the ContractNo from FormA into the ContractNo for FormB with an onclick command. My syntax is probably off and was wondering if someone could assit? stDocName = "FormBSearch" DoCmd.OpenForm stDocName, , , stLinkCriteria Forms!FormBSearch!Me.ContractNo =...
  12. H

    Can Access generate emails based on record's date

    Well I would want to send the data returned from 'qryMessagestoSend' which pulls from 'tblDept', 'tblContract', 'tblCategory'. The fields within this qry are: Account Number Vendor Total Amount Category Contract # Term Begins Term Ends Record Date Comments Term Ends has the where statement ...
  13. H

    Can Access generate emails based on record's date

    I just saw your response so let me explain in full again. I have a DB that stores Contracts with expiration dates. My boss wanted to be automatically emailed with the contracts expiring within a month from the "Today's Date" (whatever that day may be). Now its obvious that an email wouldnt...
  14. H

    Can Access generate emails based on record's date

    I am using jDraw's link that had this code within the database. Within my AutoExec, I have a OpenQuery "qryMessagesToSend" which really is a false name because this query gathers all records that are about to expire in a month and makes a table "tblContractExpiring" (Make Table qry)...
  15. H

    Can Access generate emails based on record's date

    PR2, That works, thanks! Now I just need to get my function to do what I want.
See more
Top Bottom