Search results

thanks. I found that I must insert the below line first in order to work. Set frmName = Screen.ActiveForm

I would like to write an event procedure that would apply to multiple forms? In this particular event, I'm going to assign a certain value to a variable, then afterwards, close the form if it's not a certain form. If a particular form activates this event procedure, I would like that form to...

thanks a lot. I got it working after I change to Public strCategory as String and changed the event procedure to Public sub cmdMenuCategory_Click()

This is what I got... Declaration Under Module... Dim strCategory As String the event procedure of the button... Private Sub cmdMenuCategory_Click() strCategory = "Chicken" End Sub The function... Public Function CategoryCall() CategoryCall = strCategory End Function In the...

Your suggestion sounds simple enough and I follow the logic, but somehow it's not working properly. In a form, I have a procedure that assigns the value to a pub variable. Then I have a function, as you suggested, with its name = to the variable. Then I inserted that function name in the...

I want to be able to, when a certain button is pushed, pass a variable to a query. These buttons would be utilized in several forms as subform so I can just code the event procedures once. I think storing a value to a public variable is fairly easy, but I’m not sure how, in a query, to call...

thanks all. I got it working.

The are not related at all. I'm sure there's a better way, but I'm just using the subform to dispay some information for the user to see.

I’m having problems getting a subform to reflect the current data. I would like to, in an event procedure, refresh the data in the subform that is in a form. The subform does not display current data unless I close and open the form or go to the design view and back to the form view manually...

Rich, I have a similar situation, except that I want to refresh a subform within a form. The data in the subform is updated through some event procedure. I know the subform, by itself, gets updated. However, the subform within a form is not updated. I tried refreshing the form containing...

woud you happen to know the exact syntax. Below is what I have but I get an error message saying it's too complex. When I take out the variable, [forms]![frmMain].[LstDeliveryTime], and substitute it with just "20", it works fine. Result: DateAdd("n",[forms]![frmMain].[LstDeliveryTime],Now())

I'm trying to add minutes to Now(). I was hoping to create a table that would feed to a list box. However, I'm not sure how to format the table so that the list box shows 15, 20, 25, 30..., and when I write an expression in a query of "=now() + [Forms]![FormName].[FieldName] would result the...

Thanks, when I copied your code, it works perfectly. Please just help me understand better. I didn't quite understand exactly what you said, but from looking at the difference between your code and mine is that the line, MsgBox ("You must select an Order Type First") is below the "Then" word...

I am having the toughest time with the if...then statement. It seems simple enough but I always get compiling error when I include "Else" in my statements and I don't understand why. Please help. What is wrong with the below statement? Private Sub CmdFinish_Click() If...

IMO, that looks amazing. It would answer what I wanted to do with my other question found in http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51033. However, I'm not savvy enough to understand your code or even how you created it in a form. I don't suppose you can...

Thanks. That is a great idea. Your recommendation will work well with my generic reports that have the same commands. Do you have other solutions for specific commands that are tied to specific reports?

Is there a way I can position a msgbox at certain location in the print preview mode of a report so that the user is able to see the whole report then he/she can select a command on the msgbox to proceed? Basically, I'd like to create a msgbox that would allow the user to either go back to a...

what if you want a msgbox to show up on a print preview mode of a report, and you would like the msgbox to be out of the way so the view can see the report then respond to the msgbox? can you use a customed msgbox in this case as well?