Search results

You should design the subform separately from the parent form, and include the combo box in it. The subform can then be embedded in the parent form by dragging it from the navigation pane and dropping it into the parent from in form design view. The LinkMasterFields and LinkChildFields...

That's overcome easily enough. You just need to base the subforms on a query which sequentially numbers each row, and then restrict each subform to where the serial number = 1, 2, 3...16. The following is an example of such a query: SELECT COUNT(*) AS RowNumber, T1.TransactionDate...

Let's assume that, in a table in which the DateTimeStamp column is assigned its value by its DefaultValue property, user A navigates to an empty new record in a bound form, but doesn't begin to insert a row. User B then navigates to a new record and inserts a credit transaction. User C then...

My demo doesn't include a due date. The clinical query on the other hand is from a file which does include a DateScheduled column, but it's not used by the query. That's based solely on the DateAdministered column, so a Null in that column means the patient is still awaiting treatment. This...

The query I posted in post #10 provides a model for handling that. In your case customers are analogous to patients, orders to patient treatments, order lines to patient treatment programme rows, and products to treatments. The nested subqueries determine whether a row is the latest in date...

If the aim is to track payments for goods or services ordered then you might find the attached little demo file of interest. It enables line items from multiple orders by a customer to be consolidated into a single invoice as and when the goods/services are supplied. The demo also includes an...

I'm a strong supporter of having a DateTimeStamp column in a table, but assigning the return value of the Now() function to the DefaultValue property is not in itself sufficient. While it's fine if a row is being inserted by means of an INSERT INTO statement or by code into a recordset, in a...

The following query is from a clinical database in which the PatientTreatmentProgramme table includes a DateAdministered column. The query is analogous to what you are attempting in that, for each treatment per patient it returns a row where the date administered is the latest date and there...

In the UK we have what is known as Received English. When I was young it was called Queen's English. This was the standard for broadcasting agencies like the BBC in the days when radio announcers wore dinner jackets (I kid you not!), and was English as spoken by middle or upper class people in...

There are parts of Liverpool where even I have difficulty understanding people!

Cockneys come from the east end of London, scousers from Liverpool. The word scouser is derived from lobscouse. It's OED definition is: In Liverpool we call it scouse. My great grandfather probably cooked a lot of it, as he was a ship's cook. He moved his family to Boston, Massachusetts...

I'm not doubting you. I used the word rhetorically.

So they did. Unbelievable!

The attached zip file contains a number of files illustrating how to associate images with records in a table. In the basic Images.accdb file multiple images are associated with each record and displayed in a subform in continuous forms view. One or more images can be selected in the subform...

With a bound control Access will, by default, give a control the same name as the column to which it's bound when a control is added from a form's field list or by means of the form wizard. With an unbound control its Name property will default to the format you describe. Unbound controls...

Coming from Liverpool I had the same problem learning German. My tutor despaired at my pronunciation of Goethe's name. My Chicago born partner still finds my scouse accent an endless source of amusement. French is not a problem, however. If anything the Liverpool accent helps.

I have a dictionary of quotations which includes a section on telegrams. My favourite relates to a request by a journalist who was writing an article on Cary Grant and wished to include the actor's age, so he sent a cable to Grant: HOW OLD CARY GRANT? Grant replied: OLD CARY GRANT FINE. HOW YOU?

Interesting. I've not come across that before. The OED gives the phrase as an example of this meaning. It also gives the following definition of the word prove as an intransitive verb in the context of baking:

A frequently misused saying is 'The exception proves the rule', which is often taken to mean an exception confirms the validity of the rule. However, proves in this case is used not in it's common current meaning, but in its original meaning of to test, derived from the Latin verb probare...

Don't try to translate it, it's completely meaningless. The trick is to say it out loud, but it's important that the French pronunciation is absolutely correct. Here's a Latin one. This is easier because Latin pronunciation is phonetic. Caesar adsum jam forte Brutus ad erat Caesar sic in...