Search results

Paul, Despite your considerable efforts, I fear the end result is not achieved. The code has been modified as suggested and when run does not produce any error message, but on selecting to input a new record, the Member ID Field has not incremented as intended. I am at a loss as to how to...

Pauk, Thank you for your continued assistance. The single line of code is; If Me.NewRecord Then Me.max[Member ID]TxtBox=Nz(DMax("[Member ID]", "[Mail List]"), 0) + 1 This preceded by the Private SubForm statement and followed by the endsub statement, both of which are automatically generated...

Paul, I was confident that your 'new record' addition was going to do the trick. Sadly not so! I have corrected the ID to [Member ID] but I am now receiving a 'syntax' error. Having added an 'If' statement should I not need an 'endif' statement also. jcbhydro

Thanks again Paul, However, there is still a problem. I followed your detailed procedured but I now get a compling error. With maxIDTxtBox highlighter the error is "Method or Data Member Not Found". I found that this is a specific error in Access 2010. Is the reference ID in the Code something...

Paul, Thanks for the VBA alternative suggestion. Sadly, I have no experience of VBA and wouldn't know where to start. I tried to make a 'module' incorporating the code you suggested but I suspect that that is not what is required. It certainly didn't work. Your further assistance would be...

Paul, Thank you for your rapid response to my problem. I have incorporated the modified code in the 'Default Value', but the result is still #Error. There must be something else preventing activation. Any other thoughts? jcbhydro

Good Afternoon from West Sussex, UK, I have a Primary Key field named Member ID(Number format) in a Table named Mail List. The field is populated with existing ID numbers and my need is to use my Member Entry Form to increment by 1 from the last entry. I have gleaned from other references that...

Pat H, I have repeated in 3 separate posts that I was looking for a method to input free text into a 'Member Name' field, NOT repeat NOT into a 'Member ID' field. jcbhydro.

Response to Pat H. You are misunderstanding. Member ID is a foreign key in the relevant table and does contain valid data. As I have stated previously, I am using a drop down list sourced from Table 1 to select a Member Name. Occasionally, a non member joins a Group and it is their name which I...

Nigel, Thank you for your considerable effort. I think that I twig how it works and will try to reproduce the technique in my daatabase. However, am I correct in assuming that it will be necessary to introduce a single record entitled 'other' into my Member name list? I also noticed that...

Pat H. You have been incredibly patient with my inexperienced efforts to solve this problem. Could I try your patience further by asking for a methodology to set up your suggested unbound combo and bound text field as I don't have a clue as to how to go about it. On the subject of the Row...

As mentioned I had run a second query. Thank you for your contribution. jcbhydro

Are their any suggestions as to how to obviate the 'Limit to List/No' error mentioned in my previous post? Regards, jcbhyddro

Thank you Cronk, The second query produces the analysis I was looking for. Returning to the first query, I attempted to import the occurrences for individuals back into the main Mail List Table, but it didn't work, probably because such a procedure is tanatamount to picking oneself up by ones...

Thank you for the 'Totals' suggestion. I have created a query which does it perfectly. However, I did have a supplementary question as to interrogating the results to count the numbers of 7, 6, 5, etc in the results column. Can such a routine be incorporated into the same query? jcbhydro.

Hi, I am attaching a pdf of the very simple relationship of my Membership Database. jcbhydro

Good Afternoon from the UK, I am having difficulty in solving a problem in Access 2010 which was a doddle in the Excel version of my database. Table1 (MailList) has a field 'Member Name' and a new field 'NumberGroups'. Table 3 (GroupMembers) is a junction table and also has a field 'Member...

Thanks again and I'm sorry to be a pain, but I have already mentioned that with Limit to List at No, I get the column width/Bound Width disparity error. The column width is currently 0cm,2.54cm,2.54cm (probably a 1" default value) but I don't know which other width to change. There is no Bound...

Good Morning again, As a relatively new Access user I confess that I am somewhat confused! In the Form Property Sheet the following settings apply; Control Source Name Row Source SELECT[Table1][Name] Row Source Type Table/Query Bound Column 1 Limit to List Yes This arrangement gives me the...

Changing the 'Limit to List' property to 'No' produces the column width/bound column error. My values are Column Width 0cm. 2.54 cm, 2.54 cm & Bound Column 1. Which values should be adjusted? Regards, jcbhydro