Search results

How about this: Private Sub optbox_AfterUpdate() If Me.optbox.Value = 1 Then Me.cboRecycle.Enabled = False Me.cboRecycle.Locked = False Else If Me.optbox.Value = 2 Then Me.cboRecycle.Enabled = True Me.cboRecycle.Locked = False End If End Sub

Hi, I have a database that is tracking customer details. There is a form with summary customer information (split form with only the datasheet view visible) and double-clicking on their ID brings you into a detail page with generic information on the form and then a Navigation Control that...

Sorry jdraw, I probably should have said above that when I click on the the dropdown I do get the correct values in the dropdown itself. That part is not a problem. I also realised my code was wrong in the OP. It should be: Private Sub ComboBox1_AfterUpdate() ' This code will search the...

Further to that here's the code you would need (assuming you have Access 2007): '----------------------------------------------------------------------------------------------- ' Go through the e-mail accounts set up on Outlook and select the relevant one...

Hi all, I'm having a very strange issue with populating a combobox in access. It's a fairly straight forward scenario. I have a form with a number of fields on it. When I select a value from a combobox I want it to update a number of other fields, specifically 2 other combobox's and a text...

Will give it a go David. Thanks, John.

I noticed it first last week based on some of the dates I was entering, but I just don't know why it would happen. I set up a msgbox earlier today to print the dates in the code above with the dd-mmmm-yyyy format and they came up correctly, i.e. 01/07/2009 was appearing as 01st July 2009...

Hello all, me again! Got a very strange error today when trying to filter on a form that maybe someone has seen before. I have a form that displays a list of outstanding work items for a user. They have the ability to filter these items based on, among other things, the date that they came...

Hi all, thanks for the replies. Decided not to bother in the end. It was a nice idea, but I'd end up spending far too long trying to implement it. I've decided to just create the menus as a set of hidden buttons - so when you click on File a row of buttons appears beneath it with the New...

Hi all, I think I'm just trying to be a bit too smart for my own good! I have set up a call tracking db and have the forms set up to have drop-down menus (File menu, Edit menu etc). I have the drop downs working as a seperate form and the only thing that is missing is closing the forms (i.e...

Hi all, I have a pop-up form that I want to be able to close by clicking outside of it. It is not modal, but I have no idea how to identify whether the mouse click is inside or outside the form. Anyone any ideas? Thanks, John.

D'uh....can't believe I didn't even try that! :o Thanks khawar.

Hi, I'm fairly new to VBA and have a db that tracks incoming queries. I have a log on form that checks the username selected from a drop down and the password entered. This all works ok. However when the user logs on and goes into the form to enter the query details I want their username to...