Search:

Very good, Hans. I'll do just that, and thank you again for all your help! Much appreciated!...Mary

So sorry, Hans, I didn't make myself clear. The BillingPercentage is fine as an unbound control for us to monitor on the form; however for Scenario #1, we wanted the sum of the two fields to appear...

Oh, Hans, the expression you gave me works perfect, but I just noticed that the sum results are not being populated in the underlying table for the revised field. Is there something special I have to...

Makes sense, Hans...Many, many thanks for all your help. I'm sure once I get the "real" subform in place, there won't be the problems. Until next time...Mary

Hans, could my problem be that the form was created with AutoForm, so there is no separate subform, it's inserted as the table itself? Will I need to create separate main and subforms to replace the...

Hi again, Hans,
No, sorry, I must be doing something wrong. I have a subform on the main form. I tried but I can't get an unbound field in the subform, so I tried putting it on the main form but it...

Oh, man! I can't believe I've been working on this expression for an hour and it's so simple. Thank you, Hans! You're always my hero!

I have two scenarios on a form with a subform that I'm having trouble getting right.

1. I have a table with a "ProjectAmount" field and a "ChangeOrderAmount" field. There is a third "bound"...

Thanks, Hans...I'm afraid that the database is huge!

Before I got your response, I made a copy of the old table and ran a "delete" query on it with opposite criteria, which worked fine and gave...

Hans, I just removed the only validation rule on one of the fields and there was no general validation rule for the table itself. I copied the structure of the table after I removed the validation...

Many thanks, Steve...sometimes I can't think when I'm stressed! Your suggestion, of course, works like a dream! Appreciate your quick response, too!...Mary

Thank you, Hans! Nothing's ever easy, is it? I appreciate the advice, as I didn't have a clue what was wrong and where to begin to correct it. Wish me luck! Always appreciate your quick responses to...

Yes, Hans, that is a possibility, as the records start four years ago and I'm sure the table/form has been adjusted since then. Does this mean I'm not going to be able to append the records? :-( I'd...

Can someone help me with a macro script that will add "1-" in front of values in a "Telephone Number" column that currently reads like the following:
Currently:
212-222-2222
413-555-1212...

Can someone please help me understand why, when I copied a current table's structure in a database and pasted the new table in the same database and then go to append records from the old table that...

Many thanks, Hans! Brilliant! Works great! There were a couple of names in my sample list that had quote marks in the column for full name (indicating a nick name, I guess), which caused an error...

Many thanks, Hans! I had almost forgotten how to remove formulas and leave values. Appreciate your quick attention to my needs! Until next time...Mary

Wow! Hans, thank you so much! The formulas are great! I'm wondering, though, do you think having an underlying formula in the fields might interfere with software programs that are to run on the...

Could someone please point me to a script that I seem to remember seeing quite awhile ago but can't find now, where running the script will take a column of full names like this:

Mary Zarrelli...

Many thanks, Hans. I'll run this macro after I finish all cleanup. I appreciate your help more than you know! All good wishes...Mary

I think Column C (Last Name) would be the safest, Hans, so if there is no data in Column C, the row can be deleted.

I guess I was thinking that a row could be read in entireity and then if all...

Hooray! It now works just like I wanted it to. Thank you so much!

Would it be too much to ask you for a little macro that will delete all blank rows between records after I finish cleaning up this...

Oh, Hans, thank you, I was hoping you were online! I tried running the macro, but I get a "complie error - syntax error" on the following line:
For r = m - 2 To 1 Step -3
You are right, my...

Edited by HansV to present data in table format

I have just copied data (thousands of contacts/records) from an internet site into an Excel spreadsheet, most of which (not all records) now looks...

Thank you, thank you, thank you! I know so little about functions, I'm ashamed to say I didn't know there was a DSum! :-( The expression you sent me works great! I appreciate it very much.