Recent content by gsgriffin

Don't you hate it when the only posts on a thread are the person who asked the question in the first place. Bugs me! After using my code, I realize that the lostfocus event does not have an opposite. Made it work by adding a public variable and call the function when selectionchange occurs on...

Well, this is what I've come up with. I think the problem I was having was that the EnableEvents needed to be turned off or else the event kept being triggered over and over. I've added a nice touch of removing the backslash when entering a cell so the text editing is clean and normal. When...

It's been a long time since I've been in VBA. Working on a page that creates SQL code for me. Because of that, I would like to have the cells with field values I'm inputting automatically add backslashes before single quotes. I've worked on some code that does a simple replace of ' with \'...

Its been a couple years since I put an Access database together, and am working on a very simple one right now. This is super easy, but something is stopping the calendar from working at all. With a textbox of StartDate and Calendar control of Calendar1, this is the simple code: Private Sub...

Thanks. I think that was what I'm looking for. When trying to work it into a table formula, I happened across the "Insert Word Field" function of Merge in 2003. It provided a fill-in-the-blank function that did this. Thanks, GG

I'm having difficulties changing the input of a merged document. I have a form in MS Word 2003 that is connected to an Excel DB. A field in Excel is "True" or "False". When I merge this document into the Word table, I would like for a formula to indentify this value and present either an "X"...

I'm wondering the same thing. Doesn't anyone out there know how to do this? This is over 1 month old! Thanks, GG

I was having trouble finding the last row in my sheet. It kept giving a row around 8000 when I had only 600. I used the Geoff's techniques, and none of them work in my situation. The BitDoctors solution got it the first time. Thanks BD

I think I see what your saying, but where does this function reside? In the default value for the text box? Do I need to have code that put this sum function into the value of the textbox. I believe you that the function works, I just don't know how to apply this to the text box. Thanks...

The subform values and the textbox on the master form are not in a one-to-one relationship. The subform is a datasheet that displays several values. When one of these values is changed, I would like to have the sum of all the values in subform presented on the master form. I made a query...

I imagine this is as simple a question as it gets, but since I've never had any formal training, I don't know how to do this. I have a query called "AmountDue". It has only one result in a field called "Total". The query is designed to sum up all values involved in a...

I've recorded a sort into a macro and then placed into code so as to allow me to easily perform a sort and then an "un-sort". When I perform the sort manually, everything works great. When the sort is repeated by the macro, I get a "Z" in the top-left cell of the sort...

Bowers74...Thank you. I posted the same question to the VBA forum and got basically same function rolled up into single output. I then split apart the function to be nearly identical to yours. You got it exactly right!! Thanks!!! gsgriffin

THIS IS PERFECT. WITH ONLY A COUPLE EASY ADDS, THIS WILL DO EXACTLY WHAT I NEED!!!!!!! AWESOME!!!!! THANKS SOOOOO MUCH!!!!! G. Griffin

Here's a question that I could REALLY use help with... I have a matrix with about 20 columns and 500 rows. The values inside the matrix has been given different background colors to provide a visual indicator as to what type of value they are. I have Red, Yellow, and Green cells. Problem...