Recent content by jerseyboy

Sorry, I was distracted and missed finishing my thought.. I do not know EXCEL (more of an Access VBA person) but I think the basic syntax would go like this: Public Sub ONCHANGE(CellName) SheetName!IncrementCellName = SheetName!IncrementCellName + 1 End Sub Perhaps one of the more adept office...

Are you saying you want to keep track of how many time the number was updated? <or> are you saying you want a number to cascade to another sheet as an equal? Example of Incrementing Number Sheet1!A1 = 4, Sheet2!A1 = 4, Sheet2,B1 =1 Change Sheet1!A1 to equal 20 ... Sheet1!A1 = 20, Sheet2!A1 =...

This is a bug from MS. I had it on one my students PC's. The only problem is that I cannot remember what the solution was. Seem to remember it had something to do with the install of office on that particular machine. Perhaps it was an update from a beta version of office or something like...

I recently imported my spouses birthdays to our home calendar. What I realized is that she has all of the reminders set to 15 minutes. This is not very good lead time if you know what I mean! Is it possible to update all 47 records that match my birthday search? I was going to export them as...

Thank you, I will look into your suggestions. JerseyBoy Remember: self-praise is no recommendation

I love a clever solution! :-) This really works well! Enjoy your star, Thanks! JerseyBoy Remember: self-praise is no recommendation

What I have found is a very complicated way around it... Using for loops I dynamically sized the controls base on this: len(controlname) * x amount of twips per character (90-105 in my case for basic font size 12 font with & without italics) After that, dynamically placed them next to each...

Sure should have been covered here, but I can't find it... I have to create a menu 'report' Multiple parts to the line item... Item | Description | What come with it...| Price| Add On | Additional Price...(whatever else they dream up to make it more complicated than it already is... What I...

I know what it does, but I haven't a clue to go about implementing it. I have a backup routine that copies the folder (where the database resides) to another location naming it with a NOW() type naming convention. That all works, but I would like to display a progress bar on how the copying...

I have a friend that is trying to install a Sony Printer on his XP system... Sony IJP-V100 &quot;all in one&quot; He cannot find the correct drivers.. Called Sony and they referred him to a lame website that has a bogus driver... He has researched and found a post that indicates that there is...

Thank you both, I did get it to work.. Here is the final statement for those who may follow this thread: strSQL = &quot;INSERT INTO tblTEMPEventAttendees ([EventID],[ContactNumber]) VALUES (&quot; & &quot;'&quot; & strEventID & &quot;'&quot; & &quot; , &quot; & &quot;'&quot; & intContactID &...

I can't see the forest for the trees! I am in VB trying to execute a [DoCmd.RunSQL strSQL] statement Here is the code and the resulting msgbox: _____________________________________ Private Sub cmdAddOne_Click() Dim strSQL As String Dim intContactID As Integer Dim intEventID As Integer...

It is so simple stupid, I wonder why I didn't think of it. All I would have to do is put an event in the setfocus trigger that sets the timerinterval to a value. It sounds much more reliable and much less prone to 'fat finger syndrome' I still would like to challenge the community to see if...

Chris, First, thanks for your response. Let me clarify my intent a little further... I usually place in the forms header section an unbound control or a label and manipulate the value of that control to display the status bar text. Your idea is good, but I already use the Form.Caption to...

I have tried many methods to increase the direction set that the users see. The small status bar text tucked neatly in the lower right corner is so out of site, that many users don't even know it exists unless you point it out. In the past I have included [Event Procedures] in the Got_Focus and...