Search results

Hi all, I am designing a database for users with little to no knowledge of Access. Therefore, I would like to lock/disable the design view for my queries to prevent them from inadvertently making any changes to my query criteria. Is there a way to accomplish this? Thanks.

Hi all, I have 2 tables, Event and Person Particulars. In an event, groups of 2-5 persons may be tagged to this event by a randomly generated number (using autonumber). Let's say Tom (social security number: 12345X) is tagged to events 2, 5 & 6. There are of course other persons together...

Hi all, Is there a copy and replace existing records function in access? I.e. I would want to copy records from one table to another (with same structure) and replace similar records with in original table in the new records (which have minor ammendments made). Thanks.

Hi guys, I have 2 identical database in terms of structure but it differs in data. Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records. I have used the "link to datasource method" through importing the tables to have the...

Hi guys, I have 2 databases which are exactly the same in its structure but differs in its content/records. I would like to append data from 3 tables from database A to the same 3 tables in database B on a weekly basis without the duplicates. Each of these 3 tables contain the same unique...

Hi, I have a report that is generated from a search form, the report displays images and a few fields such as employee ID, address, etc. However, when I right click on the image in the report, the option of copying the image is greyed out. How do I "enable" the copying option if there is...

Hi, I have a form displaying images as well as some fields such as Employee ID, Address etc. Only employee ID field is enabled, while the other fields are disabled (greyed out). When in form view, I am unable to right click on the image and copy the image. How do I "enable" the image so...

Hi, How do I go about implementing a date field with a date picker option in a search form? I can only manage to get the date picker option if i create a form directly from a table where the date field is in the date/time format. I am unable to create a search form from scratch and have a...

Hi, I am having some problems querying using wildcard search through a search form. E.g. I am querying addresses containing the word "Jacksons" in the address: Addresses are among the few fields that I have, e.g. Address, Name, Date of birth, Age etc. So my usual query would be to *jackson*...