Recent content by Morgandy

I've tried out several of her examples. They are good but I can never get them to work since I run 2007 and don't know enough about programing to make the adjustment. Like reading through one of your examples: I don't understand where the file is grabbing the image I want. The only file was the...

Well here is the code. Messier then all get out but I'm just now learning VB so getting scraps from here and there. Private Sub Form_Load() 'Lock All Data Controls except SearchBox Dim ctl As Control For Each ctl In Me.Controls If ctl.Name <> "SearchBox" Then If TypeOf ctl Is TextBox Or...

Just a way to eliminate the flashing. Every time I move the mouse a little bit all the rollovers twitch or flash as if getting ready to be pressed. It's livable but distracting. I've been told it's related to the MouseMove function. /shrug. Just looking for alternative I guess. Boss wanted the...

No really. I'm already using a command button, changing it's image and then using the MouseMove function to change the picture. I think all the code for the rollovers is making the program twitch. I was thinking if there is a way to import a premade button-something that has the code compacted...

Ok I have to ask. I've been using Mouse Move to create the rollover button effect. It makes my form flash and spaz out a lot. Is there a way to create a custom made button and import it in to Access? or am I stuck with MouseMove function.

Thanks for your help! ...again hehe

OOh that is a good idea...can I have the code in both spots so the option is there to click ok? or does that mess it up?

Ok but I did that and it had no effect. I still have to click the search button for it to run.

Awesome! Works! Do you have a way to program it so that when I hit Enter after typing in the code it knows to press the SearchButton? I can't remember if that is VB or and Access function.

Is that code adding or replacing the one you gave me earlier? (first time) Private Sub SearchButton_Click() Dim rs As Object If Not IsNull(Me.SearchBox) Then Set rs = Me.Recordset.Clone rs.FindFirst "[CustomerID] = '" & Me![SearchBox] & "'" If Not rs.EOF Then Me.Bookmark =...

hum it's not liking this line...what is the NName supposed to be? rs.FindFirst "[NName] = '" & Me![SearchBox] & "'

Awesome! That worked great. Is there a way to make it so once I've typed in the ID number and hit enter it does the search? I'll also need a way to have it error when you do a search for a record that doesn't exist. Is that possible?

I want a way to type in the customer ID number into a enabled textbox and pull up the corresponding customer file that does not have any enabled boxes. Is this possible?

Thank you so much! I'll give it a shot :)

I know it would be more work, but I'm just starting to learn VB. Would you be willing to put the parts I'm supposed to edit in italics or something? It would help me read the code.