Search results for query: *

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...

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...

If you're attempting to run this report from various subforms that are open when you run it, make sure that your variable is named the same in each subform and make the criteria: [Me]!IntfID T-T-F-N

I think I understand what you are trying to accomplish, but your intended approach may be difficult. Would you consider adding a "PrintFlag" column to your table with the customer information on it? When you want to print the report, first have it open a small form that lists all...

Hey...I was trying to solve another problem of mine and came across SQL Union function. I did the following: SELECT ALL [Finan1ID], [Amount1] from FinanceBaseQuery UNION ALL SELECT [Finan2ID], [Amount2] from FinanceBaseQuery UNION ALL SELECT [Finan3ID], [Amount3] from FinanceBaseQuery UNION...

YOU'RE THE MAN!!!!!! That was the function I was looking for but didn't know about.