Search results

Thanks for the help on that.... However, For some reason, it doesn't bring up the Word Document unless I click the button twice (the code is in the "On Click" portion). Also, the fields aren't populating with the data. Any idea why?

Hello, I have a two part question.. I am trying to create reports using the Word Application vs. using Access reports. I grabbed some code off the internet and placed it on the "on click" command of a button, but received a "user not defined" error pointing to the "Dim appWord As...

Ok, I figured it out: FollowHyperlink "mailto: me@myemail.com?subject=Tasker&body=hello%0Ahow are you?"

ok, I figured part of it out... FollowHyperlink "mailto: me@myemail.com?subject=Tasker" But I can't figure out how to fill the body with the email message. Can someone help?

How do I create a button that, when clicked, opens an email with the to: field, subject line, and body filled with text... I.E. To: me@myemail.com subject: New Task Body: This is an automatically genereated email to notify you that a new tasker has been generated for action. Please...

Thanks Bob!

Dumb question...in 2000, how do I get my main form to open automatically when I click on the Access database?

I created a new query and linked my report to it, but it isn't working. Here is a jist of what I have In the report: tblA.fldA tblA.fldB tblA.fldC tblA.fldD tblB.fldA tblB.fldB Common Thread between tblA and tblB: tblA.fldE tblB.fldC The query I generated has the fields from both tables...

dumb question...where's the query builder? using 2003

Hello, Is there a way to take the data compiled into a report and send it as the text in an email rather than as an attachment?

Hello, I have a comments report that is bound to tblComments. I have 2 textboxes I need to add to the report that need to be bound their respective fields in tblMain. Both Tables have a fldTaskNumber. How do I associate those two textboxes to tblMain so that the record in tblComments and...

Hello, I actually have a 2 part question... How do I cause a report button on my form to open a report of the current record only? And how can I have the report automatically be converted/saved/displayed in .pdf rather than displaying in Access format?

Hello, I actually have a 2 part question... How do I cause a report button on my form to open a report of the current record only? And how can I have the report automatically be converted/saved/displayed in .pdf rather than displaying in Access format?

I used the code below for my database, and I get a compile error. What am I doing wrong? DoCmd.OpenReport (rptMemo,acViewPreview,,[fldTaskNumber] = Forms![frmMain]![fldTaskNumber],,)

Hello, I want to have a textbox provide a count of records matching certain parameters. I have a general idea of how to write the code, but can't make it work... Basically, I want the textbox to display the count of all records that match fldA (reference number) and fldB (project type)...

Of Course I figured it out as soon as I asked. sorry (It's the AfterUpdate for the textbox..right?)

Of Course I figured it out as soon as I asked. sorry (It's the AfterUpdate for the textbox..right?)

Hey RuralGuy: Awesome! You are King. Just one more question. Is there a On??? where it makes the change as soon as data is entered?

I tried developing a new code: If Me![OverallClassification].value = "" Then Me![OverallClassification].BackColor = vbWhite Else: Me![OverallClassification].BackColor = vbYellow End IF I got an "Else without If" error. It doesn't see my If statement at the beginning?

What exactly am I looking for in the VBA Help System? A little more detail --> the error message is "Compile Error: End If without Block If". I'm not sure why this error is coming up if I have an If statement before End If.