Recent content by jimb51

TheAceMan1: I'll experiment with that as well. I played around with putting a DateField.SetFocus command following the VBA which opens the Calendar form in Command Button event procedure. That worked as well. I'm always looking for ways to streamline code. Thanks for the quick response!

I have a form with 3 date fields. I'd like to put command buttons next to each field which, when selected, will pop up the ActiveX calendar and fill in the field with the selected date. I can create the command buttons and the calendar form but I'm not sure how to reference that particular...

jaco8867 -- Yep, that was my problem! Thanks!

Not so fast! My global fields idea actually did not work. I'm back to my original question.

Figured it out! Just created a couple of global date fields (StartDate and EndDate). Then, instead of Pausing on my Find layout, I did a SetField with the concatenation StartDate...EndDate. Works great.

I use a Date Range Find on one of my reports. Is there anyway to have that range displayed on the report itself?

I have 3 files; A,B,C I created a calculated field in B based on a Sum of fields in A. I use this as a flag which I concatenate with another field in B to create a relationship between C and B. Currently this concatenated field (ID) is a Number with a calculated auto-entry. When I create a...

Tim -- Okay, got it to work! Created new field in Debtor file (key)_1. Created balance flag field in Accounts file and created new field (key from Debtors)_(balance flag). Created new relationship from Debtors to Accounts based on new fields. Reassigned the fields in the old portal to the...

Tim -- Need some amplification. I miss spoke on the file names I have. They are Accounts and Debtors. The rest remains same. I created new flag field in Debtors file called BalFlag. Created new calc field in Debtors file concatenating #Debtor and BalFlag. Created new field in Accounts file...

I have two files; Accounts and Payments. Accounts records Debtors and the amount owed to Merchants. Payments records multiple payments by multiple Debtors to multiple Merchants. I created a layout which displays for each Debtor a portal to Payments which summerizes his balance due to each...

Perfect!!

For JeanW: I tried your suggestion but can not quite get it to come out the way I want. Here were my steps: -Made a new calculated field as you suggested. Viewing it separately and it looks okay. -Placed a new field over PhoneNum field, assigned it the new calculated field, and made it...

Thanks!

Maybe someone can tell me why an autoentry works in one case and not another. I have 2 files, ACCOUNTS and PAYMENTS. One account can have many payments. ACCOUNTS have an autoentry, serial number assigned named #Accounts. PAYMENTS has a field named Accounts_ID defined only as a number, no...

I have 3 files: ACCOUNTS,DEBTORS,MERCHANTS. Each file has an auto generated serial number assigned (Debtors#, Merchant#, Account#). ACCOUNTS has many Debtors and many Merchants. To establish an efficient link between files, I thought to create Debtor_ID and Merchant_ID fields in ACCOUNTS and...