By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,200 Members | 1,568 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,200 IT Pros & Developers. It's quick & easy.

New Access User Having Trouble With A Few Things

P: 1

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.
Jul 25 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.