Search results

Still Doesn't Work Hi Wayne, This is what I tried and it still doesn't seem to work. I put the "Event Procedure" at the "On Timer" and I set the "Time Interval" at 3000. Private Sub Form_Timer() Dim MsgTime MsgTime = Time If (MsgTime = #4:05:00 PM#) Then DoCmd.RunMacro "Macro1" End If End...

Hi, I'm trying to create in VB Code where a subform is set 'Visible' = False and at a specific time change that 'Visible' setting to True. Here is what I wrote but it doesn't seem to work. I've put this VB Code in the "On Open" Event Action of the main form. Private Sub Form_Open(Cancel As...

Hi, I don't really know where to start with this. I'm trying to make a pop up message appear on the Database at 10:00 am asking all users to exist the database so I can run my updates. How would I create the Macro/VBCode to do so? Thanks in Advance! Todd

Set Timed Pop Up Message Hi, I don't really know where to start with this. I'm trying to make a pop up message appear on the Database at 10:00 am asking all users to exist the database so I can run my updates. How would I create the Macro/VBCode to do so? Thanks in Advance! Todd

Help. I've created an Unbound Checkbox that I would liked to be checked when another textbox within the report has a value greater then 30. For example: IIf([Text101]>30, True,False) This is what I've tried putting in the control source of the unbound check box and it gives me errors...

I set my form as a Popup Form but how do I position the Popup Form so it's centered within the current form? The Popup Form is poping up always on the top left corner. My assumption is that's it's default position. Thanks in advance!

Fantastic!!! Thanks David! I added the "If, Then Statements" to the VB Code and after a bit of debugging it works! Wow this is a powerful tool for users. I'm sure they'll love it once I'm done with it. Thanks again for all your help!

Try going to the Property window of the combo box. Click on the Data Tab and look down at the property called "Limit to List." If the "Limit to List" property is set to "Yes" then you will not be able to add any new entries to your combo box. You will need to change this property to "No."...

More Question David, You answered my question about what code I would need to generate a report based on two multiselect listbox. But you have to select at least an item in each of the list box otherwise an error would come up. What would the VB Code be if the user still had the same form...

Need Example Travis, Can you please provide an example of the Looping Code and Concatenation? I'm not very familiar with VB code so if you could write the code "step by step" that would greatly be appreciated! Thanks!

Here is the VB Code to open a report based on ONE multiselect listbox. Private Sub Command4_Click() For Each varItem In Me![List0].ItemsSelected StrWhere = StrWhere & "Spt_Fac =" _ & Chr(39) & Me![List0].Column(0, varItem) & Chr(39) & " Or " Next varItem Next varItem StrWhere = Left(StrWhere...

What I've done: I've created a list box and have changed it's MultiSelect property from "None" to "Simple." I'm trying to allow users to select more then one item in the listbox. Then I created a query and assigned the listbox to the criteria section of the query. So now what ever the user...