# Search:

Type: Posts; User: mjairix; Keyword(s):

Page 1 of 8 1

1. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Re: Calculation Fields - Bound and Unbound (Access 2000)

Very good, Hans. I'll do just that, and thank you again for all your help! Much appreciated!...Mary
2. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Re: Calculation Fields - Bound and Unbound (Access 2000)

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...
3. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Re: Calculation Fields - Bound and Unbound (Access 2000)

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...
4. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Re: Calculation Fields - Bound and Unbound (Access 2000)

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
5. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Re: Calculation Fields - Bound and Unbound (Access 2000)

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...
6. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Re: Calculation Fields - Bound and Unbound (Access 2000)

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...
7. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Re: Calculation Fields - Bound and Unbound (Access 2000)

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!
8. ## Thread: Calculation Fields - Bound and Unbound (Access 2000)

by mjairix
Replies
13
Views
1,336

### Calculation Fields - Bound and Unbound (Access 2000)

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"...
9. ## Thread: Append Query (2000)

by mjairix
Replies
9
Views
426

### Re: Append Query (2000)

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...
10. ## Thread: Append Query (2000)

by mjairix
Replies
9
Views
426

### Re: Append Query (2000)

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...
11. ## Thread: Adding 1- at the beginning of telephone numbers (2003)

by mjairix
Replies
2
Views
417

### Re: Adding 1- at the beginning of telephone numbers (2003)

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
12. ## Thread: Append Query (2000)

by mjairix
Replies
9
Views
426

### Re: Append Query (2000)

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...
13. ## Thread: Append Query (2000)

by mjairix
Replies
9
Views
426

### Re: Append Query (2000)

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...
14. ## Thread: Adding 1- at the beginning of telephone numbers (2003)

by mjairix
Replies
2
Views
417

### Adding 1- at the beginning of telephone numbers (2003)

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...
15. ## Thread: Append Query (2000)

by mjairix
Replies
9
Views
426

### Append Query (2000)

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...
16. ## Thread: Full Name Column to To Two Columns (2003)

by mjairix
Replies
11
Views
493

### Re: Full Name Column to To Two Columns (2003)

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...
17. ## Thread: Full Name Column to To Two Columns (2003)

by mjairix
Replies
11
Views
493

### Re: Full Name Column to To Two Columns (2003)

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
18. ## Thread: Full Name Column to To Two Columns (2003)

by mjairix
Replies
11
Views
493

### Re: Full Name Column to To Two Columns (2003)

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...
19. ## Thread: Full Name Column to To Two Columns (2003)

by mjairix
Replies
11
Views
493

### Full Name Column to To Two Columns (2003)

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...
20. ## Thread: Macro-making relative rather than absolute (2003)

by mjairix
Replies
8
Views
604

### Re: Macro-making relative rather than absolute (2003)

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
21. ## Thread: Macro-making relative rather than absolute (2003)

by mjairix
Replies
8
Views
604

### Re: Macro-making relative rather than absolute (2003)

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...
22. ## Thread: Macro-making relative rather than absolute (2003)

by mjairix
Replies
8
Views
604

### Re: Macro-making relative rather than absolute (2003)

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...
23. ## Thread: Macro-making relative rather than absolute (2003)

by mjairix
Replies
8
Views
604

### Re: Macro-making relative rather than absolute (2003)

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...
24. ## Thread: Macro-making relative rather than absolute (2003)

by mjairix
Replies
8
Views
604

### Macro-making relative rather than absolute (2003)

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...
25. ## Thread: DCount for restricted dates (Access 2000)

by mjairix
Replies
6
Views
640

### Re: DCount for restricted dates (Access 2000)

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.
Results 1 to 25 of 187
Page 1 of 8 1