Recent content by sunwindandsea

We are in the pharmaceutical industry and are modifying our Lot Control Numbering Convention. One of our questions is variable versus fixed segment length. For example, the first segment of our Lot number will be four characters wide, the year and month of manufacture (0804, 0901, 1112, etc.) ...

Thank it wasn't the spelling, it just started working yesterday as it should, the only change was I rebooted. ????? I have no clue.

I have form that many displays the e-mails of as a many as five different people on three different pages. Page 1 has the name of 1 person with their e-mail address. Pages 2 and 3 each have the names of 2 people, 2 different e-mail address. For the first two individuals clicking on the email...

This line in the Record Source for the Form solved the problem: SELECT Fellows.*, Fellows_Contacts.* FROM Fellows INNER JOIN Fellows_Contacts ON Fellows.MemberNumber=Fellows_Contacts.MemberNumber; I want to thank everyone who replied especially fneily who very patient while becoming very...

Essentially, what these fields have come to be are two fields where any bit of information vaguely relating to pledges or missions is to be entered. There was a discussion about having more fields and separate table but by the time everyone had their say, I surrendered. I can't help it. I'm...

This is the code that's working. I cannot edit the field so I can't update the table. =DLookup("MissionHistory","CongregantPrivate","CongregantNum = " & Forms![Members]!CongregantNum)

Update I now have DLookup displaying the contents of a fields from the private table. Now how can I update the record with any changes? I'm working on that any suggestion? You have really stuck with this, fneily. An I thank you from the every field in both tables. Ed

Can't find MemberNumber you mentioned, in the tables. Maybe you meant CongregantNum. Sorry MemberNumber was in an earlier version. Don't know what you mean by: LifetimeTotal YearToDate MonthToDate MissionaryLifetime MissionaryYearToDate...

I created a relationship between the 2 tables based upon MemberNumber Form name: Members tblCongregantPrivate CongregantNum Primary Key Long Integer PledgeHistory Memo MissionaryHistory Memo LifetimeTotal Integer (Auto) YearToDate Integer (Auto) MonthToDate Integer (Auto)...

Oops, I forgot to ask is the problem caused by no MemberNumber beging specified in the Query from the form?

First, thank you for such a prompt response. No, each member has 5 text and 2 memo fields in the confidential table. I've made CongregantNum the Primary/Key for each table. I assume each field is a separate query. I've been unable to create a query that works to display any of field from...

I tried that before I created this thread. The text in th caption does not appear in design or form view. I just will have to create the form from scratch. UGH. Thanks for your patience and help Duane.

We have a database of church members. It’s on the Internet so that church members can contact one another. All changes to the database are made online by church members. Once a month we download mychucch.mdb to update our database. We want to add several confidential text and memo fields...

The only setting I can find in table design is a field to enter a Caption other than the default caption for the label. I cannot find any setting that setting for the caption length of a label. NOTE: The problems appears when I create a label. If the is a label setting in table design where...

First, Duane thanks you for sticking with me on this. I cannot find a property that sets caption length. I've looked for that since Saturday. If i create a new form in the same database, the problems does not appear. Likewise a new table a new form, the problem does not appear. If a copy this...