Search results
-
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
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
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
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... -
A
My first report....
Hi everybody - my first report and driving me nuts, but probably just plain ignorance and the expectation that Access will do what seems logical to me. I used the Report Wizard to create a report from a query, the query is based upon a parent and child table relationship. The parent and child... -
A
Can a form be "greyed out" or have a darker color layered over it?
Good Day All - I have a form (lets call it mainform) covering most part of the screen, and in which I have a button which opens a popup form. Is it possible to have mainform either grey out or have a layer of a darker color over the entire form, activated by the onclick event of the button... -
A
Solved Autofill a field
Hi All - I am new to the forum (and looking forward to being part of it), also a novice as far as Access is concerned, so please bear with me. I have looked at the responses to similar questions on this forum regarding auto-filling and don't find what I am looking for, hence this one. Let me...