Recent content by jcbhydro

Thank you Minty & CJ_London, I have no problem in displaying the Search Box on the Navigation Bar, but I was hoping to find a method of making the Search Box the default cursor location on opening the form. Your comments have convinced me that this is not possible. Thanks again for your...

Thanks Minty, I had erroneously assumed that First Control and Search Control were defined code words. Does the inbuilt search facility have such a defined code term? Regards, jcbhydro

I have used the suggested piece of code as an addition to some existing ID Number generating code, but without success. The code entry now reads; Private Sub Form_Load() If Me.NewRecord Then Me.[Member ID] = Nz(DMax("[Member ID]", "[Mail List]"), 0) + 1 End Sub Private Sub Form_Current() If...

Thank you CJ London, Minty & Missinglinq for your comments and suggestions. The suggestion of making the 'search control' the first Tab Stop is very appealing, but I have failed to find a way to achieve it. The Tab Control dialogue box gives me access only to the Form Header, Detail and Form...

Good Afternoon, I have several Entry Forms for inputting data into an Access 2010 Database. On opening each of the forms, the cursor defaults to the first field in the Tab sequence. This is fine for a new record, but can lead to inadvertent inputting errors in existing records. Is it feasible...

Thank you plog & stormin for your comments. Unfortunately, I have inherited a 'poorly structured' database as you describe it and have to live with what I've got. There is no possibility of rebuilding the database with a more ideal structure, so your, no doubt, entirely valid suggestions are...

Good evening, I have an Append Query which appends personal details from a Mail List Table to a Leavers Table when members Leave the organisation. The coding used to achieve this is as follows; INSERT INTO Leavers ( [Member ID], Surname, [First Name], [Address 1], [Address 2], Town, PostCode...

Many thanks for rapid response to my query. You have confirmed what I imagined to be the reason. I can live with that outcome. Regards, Jcbhydro

Good Evening, I have several reports which use Conditional Formatting to highlight certain limited conditions in various fields, eg where a subscription is outstanding. The highlight feature functions as expected when the file is printed from a Print Preview selection. However, if I select Word...

Thank you for your prompt response, However, I am really not very keen on going on the VBA route. I was looking for a simpler solution to the problem. Regards, jcbhydro

Good Evening, I have two macros which produce multiple file outputs of database group data, one file for the data from each of about 30 groups. Currently the output is configured to produce files in pdf format. I wish to modify this to produce files in rtf format. However, the traditional...

Thank you both for your suggestions and comment. If I can't attach VBA code to a Query, I shall need to consider a Macro alternative. Regards, jcbhydro

Good afternoon, I have a number of Active Queries in my membership database which operate to modify multiple records in the database, eg resetting subscription data for a new financial year.Other examples include multiple deletions of records from several tables under certain circumstances. My...

I have done a few more tests with equally negative results. If the 'OR' Statement is included at the beginning or middle of the 'HAVING' line of code the 'OR' statement has no effect whatsoever. If it is incorporated after the 'AND' statement it causes the Query to find no records at all. What...

Hi Arnelgo, Thanks for your suggestion. I had tried that location for the 'OR' statement but it merely causes the Query to ignore the single Addtress feature. Would it be more appropriate to put the 'OR' expression after the 'AND' statement in the 'HAVING' line of code. Regards, jcbhydro