Recent content by Abes
-
A
Aligning output using spaces
I have the following expression in a query from which my report gets its data. Left([points].[member] & Space(30),30) & [initials] The intention is for the concatenated field to appear on the report as follows: Smith AB Jones PJ Nicholson BR The initials are... -
A
Solved Concatenation producing weird result
Followed the advice given by Minty and "make the look values and table relationships yourself and remove the lookups", this after having read the article you pointed me to regarding the evils of lookups in tables. -
A
Solved Concatenation producing weird result
Thanks all, sorted, without your assistance I would probably still be clicking around aimlessly. -
A
Solved Concatenation producing weird result
Will look at whats going to to work for me, thanks. -
A
Solved Concatenation producing weird result
Thanks for the bad news - lol. That is clearly where my problems are coming from, some serious work waiting for me to fix that lot up................ -
A
Solved Concatenation producing weird result
Need some know how here please. I have created a query from a single table and have several columns which amongst others includes one for "surname" and one for "initials". When I run the query the surnames and initials show up, no problem there. When I however try to concatenate the two fields... -
A
Screen Flashes, Flickers and Form Refreshes
It's been a long time since the last post on this thread so I am wondering whether somebody has come upon a solution for the screen flicker issue. It still persists in Access 2016, or at least it does with me. I have tried all of the above suggestions, without success, and here I am talking... -
A
Solved Child table not inheriting parent primary key autonumber value
@The_Doc_Man - thanks for the link, got me sorted out. Much appreciated -
A
Solved Child table not inheriting parent primary key autonumber value
I have a Parent- Child table relationship using a parent form and a child subform. The parent table has a autonumber field as primary key and this is linked to the same foreign key in the child table. I can enter a new record in the parent form and the parent table saves it, no problem there... -
A
Form changes position when I click inside it
Found it! I have been looking at the form's click event which has nothing in it, but the detail section had a click event which had movesize code in it, taking the form to a position which I must have entered during the initial stages of fiddling with it whilst trying to position it correctly... -
A
Form changes position when I click inside it
Good Day All - I have got a parent-child form setup.The parent form is positioned above the child form by calling a macro with a "MoveSize" in the on load event of this form. When viewing the form it is positioned correctly at the top left as per the "MoveSize" position. If I click anywhere...