Search results

I was hoping someone could explain exactly what is happening here with this procedure. Public Function OPEN_SESSION() As Boolean Dim objSession As Object Dim strServer As String Dim strMailFile As String 'Outlook must be open for module to work correctly If MsgBox("Do you have Outlook running?"...

so would this line of code be entered in the OnLoad event of the form?

I have not worked with other languages. My background is computer hardware and networking topologies but was put in charge of databases because I was the closest thing they had.... so these databases are already in existence and I am trying to catch up...

I am studying a book trying to learn vba and in the book it says, "To clear the text box of all contents, simply assign an empty string, also known as empty quotes, to the text box's Value property. Example: me.text1.value = "" My question is... where would I actually put this line of code...

A public function is available to be called by any module isnt it?

This is the code module associated with the entire form: Option Compare Database Option Explicit 'flag to signal that the form has just now opened Private Started As Boolean Private Sub Form_Activate() DoCmd.Maximize End Sub Private Sub Form_GotFocus() DoCmd.Maximize End Sub Private Sub...

my question to pr2-eugin is how would a person know that the me.reqpanel would refer to that report called RequisitionNotifySubmitted since the me. keyword in this instance is in the load property of the switchboard page?

The config.ispxmanager looks at the person logging into the db and determines if they are the px manager or not. If they are not then the report does not display for them.

When I click on the form this procedure is associated with I get my switchboard page that comes up but I also get a report called RequisitionNotifySubmitted that opens if someone has submitted a requisition that requires an approval.

I was wondering if someone could tell me exactly what this does: Private Sub Form_Load() Me.ReqPanel.Visible = Config.IsPxManager DoCmd.Maximize End Sub Also I understand what the Me. keyword does but where does the ReqPanel actually come from? I thought it was a property of the form...

Does anyone know what the actual command is in vb code that opens lotus notes? and what it would be for outlook 2010?

So is there like a default template of error trapping code that would be used for any vba module?

What is the purpose of error trapping?

There is a module in the Db called Lotus Email and here is that code: Option Compare Database Option Explicit Public mobjDB As Object Public Const Parters = 1 Public Const Approvers = 2 'this sub will: output a report as a file 'attach the file and add the predetermined subject and body...

I am actually in the United States in Arkansas. I have found code that is used to open outlook and so forth but I dont know vba well enough to know where the outlook code goes in place of the lotus notes code. We have order forms that have a rush check box and when checked... it emails the...

I have a current db that uses Lotus Notes to send out emails. We have recently changed over to outlook and are needing to change the vba code to reflect outlook instead of Lotus notes. I have tried for 3-4 weeks to understand it and do it myself but I am a network and pc guy not a programming...

Is there a great book or website that could teach the slowest person in the world (me) the easiest way to code vb script?

About a year ago I was moved into a position of administering these access databases and I didnt know anything about them. All the db's were already in place so it wasnt like learning from scratch. I have learned access for the most part but havent had to use much coding on the backside until now.

Actually, I am just trying to understand: Private Sub cmbProject_AfterUpdate() Me.RequisitionSubmitDetails.Form.Refresh 'save data back to database 'change project id for all lines in this requisition DoCmd.SetWarnings False DoCmd.RunSQL ("UPDATE RequisitionDetails SET...

What would be the purpose of using docmd.runsql statement then at all?