Search results

Ahhh perfect sneuberg!!! Thanks so much!

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

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

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

Thanks Bob for the link, here ya go.

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.

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

Beautiful! That did it. Thanks Paul!

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

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.

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

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

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

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

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

PR2, I went into the Create tab and choose "Module". (As oppose to "Class Module"). I added this function into this module: Private Function cmdSend() Dim strReportName As String Dim rsMail As New ADODB.Recordset Dim strMsgText As String Dim strSubject As...

How would I add this piece of code to run in an AutoExec? Private Sub cmdSend_Click() Dim strReportName As String Dim rsMail As New ADODB.Recordset Dim strMsgText As String Dim strSubject As String Dim strTo As String Dim strCC As String Dim...

Jdraw, I didn't see your link. I think that's a start. I'll follow up on Monday letting you know if I've made any progress.

Thanks for the quick response. Yeah gathering the information of the records/contracts that are soon to expire isn't the issue. It's more so figuring out how this can be automatically emailed with an attached report or just the information in the body of an email. Or maybe as simple as if he...

Hi All, Using Access and Outlook 2010. Not sure if this should have been posted in 'Queries' or 'Modules/VBA' so I apologize if it's in the wrong spot. I have a database that tracks Contracts for our University. One of the fields it tracks is Expiration Date. Is there a way to have...