Search results for query: *

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

It's a typo it should read "is not the same" When I drag a field from the file list onto the form, the label is blank, it does not contain the name of the field as the text box contains the field name. It's really weird to drag a field onto the form and the label box is blank. Thanks for your...

I'm having trouble displaying a date on a form that cannot be edited. I used the "=" function to do this for other fields that are displayed at the top of each page, such as, lastname, firstname middlename, etc. When I use "=datefield" #Error is displayed in the Form View, likewise # Error...

Thanks for the question. I edited the properties as you requested and changes in the fore and background colors were reflected on the form but the caption still did not appear. The fore color on all label controls is the same as is the background color. It's really weird. It's not just a...

I've lost the ability to enter text into label fields associated with control boxes when I drop a field onto a page in a form, the label box is blank. Likewise, if I create a label from the toolbox, the label back color or background is the page back color of background and when I click on the...

I've created a form and somehow I changed a setting so that the Vertical Scroll Bar for the form on the right is no longer displayed in Form View. Amazing the problems one can make for oneself without trying. What did I do wrong or how did I f...? Any suggestions would be appreciated...