Search results

Hi, I need your assistance. I have built a form to use to edit one data field in my tables. If the data has been changed, before moving to the next record or closing the form, the user gets a Yes/No message box asking them to confirm whether they like to make the change. If Yes is chosen...

john471, Thank you very much for your guidance and the other members who contibuted in the link you provided - invaluable!! Square.

I have a table that stores different visits to clients and the key fields in this table are the ClientName and VisitDate. I am trying to design a query that extracts from the above table only the latest visit to each client where there is more than one visit found and if there is only one in...

The Utmost/Rich, Thanks for your help so far ...however, I'm still confused about how to filter the query for the report directly from Visual Basic Code. Could you provide some pointers please? Many thanks.

I am building a series of reports based on different filter settings of the same query. Rather than save several versions of the query and base each report on its query, I thought I could have a single instance of the query, but then run each report based on VB code that includes the required...

Thanks Pat, I'm creating the additional tbls as recommended and I'll see how far I can go with it.

I have designed a report to assess the risk of a project based on defined project elements. The project elements are set up as fields in a table and projects as records. After each project element is assessed, a score (from 1 to 5) is awarded and at the end of the day all the project element...