Search results

I have been very careless in ssending you a txxt ffile. I am resending it as an xls file, jcbhydro

CJ, I am attaching a txt screen print of my Waiting List Form, I hope that this iss satisfactory. As you will see the [Leader] field is empty for each record. The Combo Box [Group Name] is meant to retrieve [Group ID] and {Leader] from the [Groups] Table. It achieves the former but not the...

Hi, Many thanks for the further suggestion. However, the remaining problem is not what is displayed in the [Wait List] Table. If random names are entered by hand into the [Leader] Textbox in the [WaitList] Form they are correctly displayed in the Table. The question remains why is the...

Thank you for your continued interest. I will try to be more concise. The [Waiting List] Form contains 6 fields in total and 3 of them are retrieved from the [Groups] Table. The fields are; [Group ID], [Group Name] and [Leader]. The Group Name is entered by selection from a Combo Box which...

Many thanks for the rapid response. Column Count 3 did the trick, but I can't fathom the count number! Did you have any thoughts about the failure of the Form to pull in the [Leader] data from the same [Groups] table? jcbhydro

Good Evening, One of the Tables in my membership database is named [WaitList] and has a linked Form. The Form is configured to pull data from another Table named [Groups]. The fields are [Group ID], [Group name] and [Leader].plus others from a second Table. When the [Group name] is selected...

Thanks Minty, Silly me. I have done it previously and just forgot the solution. it's all down to 'Anno domino'. Regards, jcbhydro

Good Morning, I have been unable to find a simple way to copy a text entry from a Table Field and paste it to multiple records in Datasheet view. The Toolbar 'Paste' procedure copies to the selected record only and I am unaware of how to select multiple records, as per a spreadsheet procedure...

Thank you Shoji for your comments, No, I have not stated an intention to give 50 participants access to the database. My first posting on the subject sought advice in principle to the feasibility of access to password protected Forms. ie each participant would have access to a password...

Hi Shoji, Thank you for your interest. To respond to your quesstions; 1) The Group Leaders are not on a Network. ii) I don't understand 'front & back end'. The Database consists of 5 Tables, 6 Forms & sub-Forms, 25 Queries, about 10 Reports and a couplee of multi-Report generating Macros. All...

Many thanks Paul for your prompt and useful reply. I now have to decide whether it is worth proceeding with task, in view of the very lukewarm attitude of half of the 50 Group Leaders to any IT flavoured project. Regards, jcbhydro

Good Afternoon, I have had much valuable advice from many Forum members in building a very comprehensive Membership Management Database with extremely useful facilities initiated by some 20 or 25 Queries.. The database includes 5 Tables which store data relevant to members, another which stores...

Many thanks to all those who have made suggestions to solve this problem. As a result of these contributions, I have eventually achieved success. I have found that instead of defining the checkbox expression as [Mail List].[LifeMember], i have redefined it simply as [LifeMember] and then it...

The data type of the check box is defintely yes/No. I have just noticed that the format was True/False, but switching that to Yes/No also has no effect. The default value of the Currency field is most definitely zero (0) not Null. The record source for the Currency field in the Entry Form is...

I apologize for failing to answer your question, but I mistakenly thought that the element of the expression [Mail List].[LifeMember] pointed to [Mail List] being the table in which the field [LifeMember resides. The solution suggested by Gemma the Huskey ie [Checkbox]<>-1, doesn't work either...

Thanks, I haven't tried it yet as I am away from base for a day or so. However, I do see the logic of the code and will try it soonest. jcbhydro

Thank you for the suggestion, but it doesn;t solve the problem. My requirement is that when the [£Recd] field = 0 the background colour should be yellow, except when [LifeMember] is True. I cannot understand whu 'AND plus <>TRUE' doesn't work. In fact it turns off the conditional formatting in...

Sorry, I changed my file type. It's a jpg. jcbhydro

Yes, I am using the 'Expression is' option. I am attaching a Word file which shows the screen shot. regards, jcbhydro

Good Afternoon, I have some Conditional Formatting of a Currency Field in an Entry Form. The cell is conditionally formatted with a yellow background when the value is zero. I now wish to add an additional condition to the expression such that even if the value is zero it will not be formatted...