Search results

Good Afternoon, I have a simple Query which very satisfactorily exports data to a Tab Delimited Text File to upload to a website. The field titles are dictated by the Table Field Names but I would like to modify these for the export. Is there a simple criteria code by which this can be...

Paul, You were correct the column count was increased to 3 and then the update functions for the second condition. However the outcome is weird, instead of producing a 'Leader's' name, it produces a Member ID, which is obviously being picked from the main table [Mail List] vis the [Groups]...

Paul, I need to bother you again with a supplementary but related question. Is it possible to add a second line of code in an afterupdate event procedure to display and save data to a second text box. My first line reads; Me.[Group ID]=Me.[Group Name].Column(1) and that works, but I wish to...

Many thanks Paul, That works beautifully! You have been extremely patient & helpful. Things are so much simpler when you know what you are doing, or more precisely when one is led by the hand. I am puzzled as to why others on the forum have emphatically stated that such a procedure should not...

Nothing wrong with your eyes as I will explain. The problem relates to the [Group Members Entry Form]. The #Name error occurred when I was applying your non-saving option of autofill. This occurs when the control source of the [Group ID] text box is written as [Group Name].Column(0). The #Name...

Paul, I hope that I have managed the upload correctly this time. jcbhydro

Sorry Paul, As the suggested solution failed I removed it. I will reinstate it and do another upload tomorrow. I apologize for wasting your time. jcbhydro

Paul, as requested, attached please find the db file. I have reduced all but 75 of the records and have done some severe editing for reasons of security. This should't affect the structure or coding of the databas. I confidently predict that you will note many aspects of the database which are...

Paul, I have been looking for a protocol for posting a cutdown database, but haven;t found one. Obviously, I need to delete the bulf of the records and modify those that remain, for security reasons. Where should I look for guidancee. jcbhydro

Paul, Thanks again. Yes I had included an = sign. However, I have concluded that your alternative solution might be more appropriate to my needs. I detail below my interpretation of your suggested coding; Property Sheet [Group ID] Text Box {NB Group Members is the table associated to form}...

Many thanks for your response. I have read and attempted to apply the principles you outline in your htm file, but without success. The code which I listed previously is intalled in the 'row source' for the [Group Name] field. The control source for the [Group ID] text box previously contained...

Good Evening, I have an entry form for a table named [Group Members]. The form has several fields deriving data from 2 other tables [Mail List] and [Groups] I wish to automatically display a Group ID when the relevant Group Name is selected from a drop down list. The Row Source Code is as...

Thank you Namliam, I eventually gathered what you were telling me and it worked well. Your efforts are much appreeciated. jcbhydro

I am obviously doing something incorrwctly as I cannot get the suggested criteria to function; If I detail the structure of my query perhaps you could suggest where I am going wrong' The 6 columns of my query are: E-Mail, First name, Last Name:Surname, eNewsletter:e-NEWS List, SO:Subs SO...

Namliam, I now recognize the IIF function and the logic of the suggested expression. I assumed that I should incorporate the expression IIF([eNewsletterr],"Y","N") as a 'criteria' in an additional column in the Query Design View, but what do I use as a column heading? Also, do I need a...

Namliam, Thank you for your rapid response to my query. Sadly, I don't have the faintest idea of the meaning of your suggestion! I have never come across the term 'lif' previously. I assume that it is an abbreviation for some procedure implemented in building the query. Any further comment...

Good Morning Folks, I am able to successfully export data from an Access 2010 Query to a Tab Delimited Text file without difficulty. My problem is that the Query includes several 'tick boxes'. The resulting text file shows the text boxes as 1 or 0 as appropriate. What I actually require is a...

Rebecca, The code I used in the Default Value of the Property Sheet is; =DMax("[Member ID]","[Mail List]")+1 'Member ID' is my numbered Primary Key field and 'Mail List' is the database name. regards, jcbhydro

Paul, I have revisited this problem and used the =DMax proposal again and amazingly it now works perfectly. I am pretty certain that I am not doing anything differently this time but in any case it works. Thank you once again for the considerable effort you have expended on my behalf. jcbhydro

The [Group Members] table was built, on advice from this Forum, because it will eventually incorporate data other than that copied from the other 2 tables. It would be inappropriate to clutter these 2 tables with unrelated data. Hence my need for autofill of the current fields is still...