Recent content by dalesellers

I found this nice fix for the Access Mouse Wheel issue that many people don’t see to like. http://www.access-programmers.co.uk/forums/showthread.php?t=74920&highlight=mouse+wheel I just can’t figure out how to enter the code into the forms module. I’m not real good with VBA – would I enter...

I am definitely going to build a form that has multiple tables after the advice received here. It makes much more sense, although it will take me a while because of the info that I have to record. In the meantime, I’d like to keep using the current form. I really like the code that boblarson...

Is there a good program (and affordable) that uses MS Access as complete customer management software? I like Outlook, but Access seems to have more flexibility and behind the scene access (tables, etc). I’m sure there has to be something out there made in Access (which comes as customizable)...

The duplicate record is one of the Command Button options available in the menu. I have my invoices set up where all customer info and the order can be filled in all at once, instead of in two steps as in Northwind. It’s probably a barbaric way of doing things, so I’ll check into designing the...

John A - I looked and looked but couldn't find a "duplicate record" used in the Northwind Ex. Any other ideas where I might find out how to do this? Thanks, Dale

boblarson - thank you for taking the time to get it working. I checked it out and it functions perfectly. Just like you said, the search works fine with this coding method. I’m still looking through the code and trying to figure out where I goofed. For Bob or anyone else – Since we are on...

Although I got the form cleaned up, the only code I seem to be able to get to work is from GaryPanic. The records seem to lock just fine. Only issue is I seemed to have lost the ability to use the “find record” button that installed from Command Button option. Any ideas on how to keep this...

I have the tag on all of the controls throughout the form (except checkbox and navigation controls). Fortunately, there are no subforms so I don't have to mess with that aspect of coding. Here is a link to the database if you want to take a look. I upoladed it to a directory on our site. The...

Ok, I got this in there: Private Sub check1_Click() For Each ctl In Me.Controls If ctl.Tag = "checktag" Then ctl.Locked = Not ctl.Locked End If Next ctl End Sub And this: Private Sub Form_Current() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag =...

I finally found the On Current event for the form. Although I still seem to have a problem. In the On Current event for the form, here's what I have now: Private Sub Form_Current() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "checktag" ctl.Locked = True End If...

John – I did in and for some reason it's not showing up. Here's the list: On Click On Dbl Click On Mouse Down On Mouse Move ON Mouse Up That’s it – any ideas on what might be going on? Thanks- Dale

I’ve done some minor coding in VB, but I’m just a newbie. Just a couple basic questions - I have Access XP. On the event tab of the property boxes for all of my controls, I can’t seem to find “On Current” event anywhere. I only see Before Update, After Update, On Enter, etc. I have one db record...

Thanks - I'll try it out and see how it works

I’m new to access but I have created a table with a form linked to it. It shows one record per page. I just want to be able to lock and unlock individual records in the form by using a checkbox. This will prevent me from accidently making a change to an old record. For example, when the...

I thought I understood but I'm not sure what code "to munipulate data" goes into Visal Basic for this particular kind of button. Anybody have any ideas or know where I might be able to get this?