Search results

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...