I need to create a continuous form. One of the fields identifies the asset being considered and so what I would like is to have the first time a new asset appears in the list to have it highlight (different colour, non-blank, whatever) and all the records below it associated with that asset to be a different fromat. I know I can do it easily with a report but this needs to be a form view because the user needs to be able to select a record and I don't think you can detect which record has been selected on a report.
The form's data source is a Union query that knocks out duplicate records automatically. The first component of my union query will always contain the first record in the list to be displayed but if I include an indicator field in that query then the union will not automatically exclude duplicate records because the indicator field in the first query will make the record no longer a duplicate.
I don't think it is going to be possible to do what I am asking but I have to ask in case.
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…