Search results

Not in the UK. The administrative unit below District (or County where the county is a unitary authority and therefore has no Districts) is Civil Parish. As these have defined boundaries, in formal contexts, such as my own former work in environmental planning, these are used rather than...

Thanks. The_Doc_Man has now put the cat amongst the pigeons though, by pointing out that in the USA a city could be in more than one state. I'll need to revisit my demo to see how that can be handled using correlated combo boxes. As well as the CityID the Contacts table will need to include a...

As a city in the USA can apparently be in more than one county, a Locations table should include CityID and CountyID foreign key columns referencing the composite primary key of a CountyCities table which models the binary relationship type between Cities and Counties. A Counties table would...

As you are inserting values into multiple columns over multiple rows, would it not be simpler to build and execute a single INSERT INTO statement? The rows inserted would be derived from the same SELECT statement as the list box's RowSource property, and its WHERE clause would restrict the...

Absolutely, the same had occurred to me. If large numbers of documents are being stored as attachments, then it's not surprising they have problems. Storing the documents in a folder and using the database as the means of retrieval by storing the paths as text would be the obvious solution if...

Moving rows to a separate file should only be a method of last resort. If the size of the back end is pushing the limits of Access, it's time to move to SQL server or another client server database as the back end.

If you want to see all the data for a work ticket, along with all of its related detail records when you close the work ticket, then I'd suggest having a WorkTickets form in which a WorkTicketDetails subform is embedded. To close the work ticket and generate a delivery note add a command button...

I don't see any duplication of data by the use of a separate Deliveries table as suggested by arnelgp, provided that the Deliveries table does not repeat any data from the WorkTickets table apart from the WOTicket foreign key. However, you could simply add DeliveryNoteNumber(Indexed uniquely)...

As KitaYama has pointed out, there is no need to move the rows to another table. The value of an Historicized column of Boolean (Yes/No) data type could be set to True. In its normal day to day operations the database would then use those rows WHERE NOT Historicized. The attached little demo...

Doh! I should have looked before I jumped.

The attached file is primarily intended for printing simple unformatted ad hoc single labels, but it also allows each label to be saved to a table. A saved label can be selected from a list box and one or more of that label can be printed, starting at a selected position on the sheet. It works...

The attached file uses a similar method to that used by Duane Hookom, but in my case partitions the table into five subsets of 38 rows each using the following query: SELECT (DCOUNT ( "*", "Parishes", "Parish <= """ & Parishes.Parish & """" )-1)\38 AS Partition...

Or do they mean the Form Template property?

The problem with that on its own is that the user could insert a last name, and then try to move focus to the subform without inserting data into other Required controls in the parent form. As the code in the parent form's Current event procedure disables the subform when you move to an empty...

If the total number of rows is finite, you could use a query like the following to return Partition values from zero upwards, and then base four side-by-side subforms each restricted to a partition value. In this case the maximum number of rows per subform would be 50, so the maximum total...

That property refers to the Page Header and Footer, not the Form Header and Footer.

In my demo put the following in the Current event procedure of the frmStudents_3 form: Me.fsubStudentCourses.Enabled = Not Me.NewRecord and the following in the same form's AfterInsert event procedure: Me.fsubStudentCourses.Enabled = True

To delete a category in the subform you need to delete the row, not just the value in the combo box. Click on the record selector to the left of the row, and press the Del key. You should then be prompted to confirm the deletion. This will delete the member's association with the category...

Open the subform independently of the parent form in design view. Then select the Form object by clicking on the little square at the top left corner, at the intersection of the vertical and horizontal ruler bars. In the form's properties sheet's Format tab set the Default View property to...

The ControlSource should be CategoryTypeID. The Category Type column should be deleted from tblContact_Categories, as you identified yourself in your initial post. The combo box's ColumnWidths property should be 0 (Access will enter whatever unit of measurement you are using automatically)...