Hello-
I'm fairly new at using Microsoft Access and I'm having trouble getting a couple of things to work in my database.
The first is that I have yet to find a way to get an append query to add only new records and not all the records. As an example, this query filters a list of property owners for duplicates and then appends to a table where they are assigned autonumer IDs. The problem is that I'm constantly entering new owners in and when I go to append, it assigns them all new ID numbers.
My second problem lies with data access pages, which I've created to allow our office to update the database without going through me. I want to the following things but am completely lost and can't find any help on microsoft's site.
1. Set permissions by broker. Each owner is assigned a broker in the owner table and then that data is sent to a select query where it is combined with the property information. From that query I am able to group the entries by broker but I want to create a popup box where the broker types his/her name and it automatically filters for that persons's name. Which leads to problem number 2.
2. Filtering is not working at this moment. When I click the filter button it tells me that: "arguments are of wrong type, out of range, or in conflict with each other." i am not a programmer, and have 0 idea how to fix this one.
3. Finally, when I group by broker, the data in the property section becomes uneditable. The properties are all set to "true" in the design view yet I still am unable to get it to work.
Any help would be greatly appreciated.