Search results

Thanks for your ideas - I think I now have a workbable solution. Have a great weekend.

Forgive me, but I'm not exactly sure what you mean. I should have made clear that I don't want the users themselves to be able to alter what recordset they get - the front end is altered by their manager, who has no more skill than they do, so I don't want anything to appear on the users'...

Hi, thanks for the response. I am working with a group of fairly unskilled computer users and want them to be able to change a "parameter" in the simplest way possible to determine which set of records their queries find. I have 3 queries in each front end, each of which should find 100...

Does anyone know how to limit a table to a single record? I have a back-end/multiple front end database. In the front ends are several queries in which the parameters are dependent on a "user number". So my query has conditions like ID being >([UserT]![Field1]*300) And...

Anyone any ideas, please? I have a table of name and address data as a back end and have put a front end of each of 12 "user" computers on a workgroup-based small network. Each user can look at on twelfth of records, the range being specified in a query on each front end PC, which, of course...

I have a data source table with names, addresses and UK postcodes, and another table that has partial postcodes (the bit before the space) and I need to look up the local authority for each postcode. I created a front end that links to both tables and tried converting the full postcode in one...

I am using an Access Database to produce a report for a catalog of stage plays. One of the fields is a memo field which holds the synopsis of the play. Seemingly at random, the query (and hence the report) misses off part of the end of this field. There is no common feature about the records it...