Search results

I got it... And I figured out for the Macro, you do a .RunMacro("MacroName") Thank you very, very much for all your help and your quick response! :)

So do I use this code for the On_Click event? With DoCmd .SetWarnings False .OpenQuery "YourQueryHere" .SetWarnings True End With And one more thing...is this doable when you run a Macro as well?

Here is what I'm trying to turn off/code to yes - see attachment

Is there a way to code an answer “yes” on a delete/append query? I want to avoid a user having to push yes, yes, yes when I run one of my reports. There has to be a way to code around that, so all a user sees is a report once everything is done running. Thanks.

Never mind. I got it figured out... I added this line to the Click event on the main form rather than the load event on the frmDetailedProjectInfo: Forms!frmDetailedProjectInfo!ClientID = Me!Combo62 Thank you anyway.

I have a frmMain and a frmDetailedProjectInfo. There can be multiple projects tied to 1 client and I think I have that taken care of in my relationship. What I need is when a user clicks Add new project and selects a client out of the drop down box on the main form, I would like for client’s...

Thank you for replying... Never though it could be done like this. Thanks!

If I wanted to do a .visible on certain fields if a field was not cheked, how would I do that? I want to say if NotOnSite is checked, I don't want to display OnsiteAddress, Onsite City, Onsite State, Onsite Zip. Using the -1 it said that the object I'm trying to use has no value. Any help would...

Is there a way to make changes to the start up menu? I didn’t make a backup of the latest changes on my database, then played around with the start up menu and now, of course, I can’t get to the Design view or to the Database window and I still need to make changes to my form. I know this was...

Thank you that works!

Now it's saying that the format in which you are attempting to output the current object is not available. Am I doing something wrong? This is my code: Dim stDocName As String stDocName = "rptRequest" DoCmd.SendObject acReport, stDocName where do I put that , acFormatRTF at?

I'm wondering if I can set the "Rich Text Format" as an default when the "Mail report" button is pushed. Right now I need the user to pick RTF, is there a way to eliminate user interaction? Thanks.

That makes more sense, thanks.

Sorry to ask, but what does this mean? "so long as the recipient uses HTML to read their email" What do you mean by recipient uses HTML? I'm not sure. Thank you

I have a form where you click a button to send an e-mail with the information on that form. What I'm wondering if there is a way to use html tags for bolding and undelining things within vb code for sending that e-mail. Here is an example: EmailBody = EmailBody & "Desired Start Date: " &...

I will try and play around before I waste any more of your time. I will post again if I absolutely can't figure it out myself.

SELECT tblFunctionalAreas.FAID, tblFunctionalAreas.Functiona_Areas FROM tblFunctionalAreas ORDER BY tblFunctionalAreas.Functiona_Areas; This is what it has.

I already tried that as well. Now my combo box only displays the PK. I see both columns, but only the PK value stays... Any other ideas? Thanks.

I have a drop down box which I created from the drop down wizard. This drop down is based on a table Functional Areas which contains a primary key for each Functional Area and a name of the Functional Area. Right now on the screen in displays the name of the Functional area, but it stores the...

Problems with CRLF I have a buttom that sends an e-mail once clicked. The problem is that each line is supposed to start on a new line in a body of an e-mail. This is the code I used from this website and some of it works and some doesn't, meaning that the CRLF is not working and it's putting...