Search results

Thanks All. This is the error message I am getting. Object does not contain the automation object 'Me' I am trying to learn Macros because they are cool and easy for some occasions. I want to be well rounded. Macro have saved me lots of time in the past.

Good Day all. I am trying to use a macro to popup a message box with the name of the item selected in a listbox. I do not want to use VBA code This is what I tried: Temp = List2.ListIndex MsgBox Me.List2.Column(1, Me.List2.ListIndex) Can anyone assist

Thanks to all of you for your help. It seems I may need a lesson in the use of function However the question I would ask is can a variable of reccordset type be passed a parameter? Here are my procedures: Public Sub GetSalesAccounts() Dim curDatabase As Database Dim...

Thanks. I am using your suggestion but it's not what I want. I want to pass a recordset variable to collect data to take to a calling module

My error message says simply "Argument not optional"

Good Day All, I am passing a recordset variable as a byref parameter and it would not work. Is there a special way to accomplish this objective? Here is my code: Public Sub SumSalesAccounts(ByRef rst As Recordset) Dim curDatabase As Database Dim strSql As String Dim Number As...

Thanks for the help. The problem is that I was missing the = sign in the message box

Thanks for the explanations. They work fine.

Good Day All, I want to reference an empty listbox. I tried "" and Null but none of them works. The code is below. Both are ignored when this code is applied as an event and the listbox is empty. An error message comes up suggesting "invalid use of null" Can this please be explained and...

Thanks. None of the explanations work. I do use VBA and it works fine; however, I want to learn to use Macros because they have potential and can possibly significantly reduce coding.

I apologize for my breach of the forum rules and would avoid such action in the future.

I understand and appreciate your admonition. I will avoid it in the future.

Good Day, Can anyone show me how to the value of the tempVar to display its value rather than its name string. I have a control 'text1' on a form when a button 'go' on the said form is press the macro assignes SetTempVar the of 'test1' Then the next action is for a message box to display the...

I am using the Sample Northwind Database which uses the tempvar variable. My problem is that using the action field in the macro to select the message box command the output from the variable is the tempvar name rather than its value. I want to learn how to state the tempvar in the macro

Good Day All, In my macro my setTempVar variable = CurrentUserID The expression = [cboCurrentUserID] The message box field = "you Entered " & [TempVars]![CurrentUserID] When a button is clicked the value of the variable is not displayed. This is displayed :"you Entered " &...

Good Day All, Can anyone show how to write a macro to hide ribbon?

Good Day All, I am using the sample Northwind Database and referring to the creation of an order, the section dealing with the creation of a new order number. Can anyone explain the following function of one of the controls : =Replace("Order #|","|",Nz([Order ID]," (New)")) Particularly...

Thanks! paul / Baldy. it worked like magic

Good Day All, I have combo box "Combo60" whose record source is a table "Products" with fields "Product name" and "Product code". The combo box selects the product name only. When I click button "Code" I want it to launch a message box displaying the "Product Code" which corresponds to...

Good Day All, I have a control on my form called cboCurrentEmployee which I want to delete. When deleted and I move from design to form view a dialog box pops up with the notice: "Enter Parameter value" I searched for likely events to trigger this notice but in vain. I can't find a macro or...