Data Access Page - the basics?, Creating new table entries when grouping data Options

[herrbbiiee]

Hi all,

to start off, I know sql to a reasonable level (probably beginners level compared to you lot), and am wanting to find an easy way for an end user to update/insert new data.

I have found the facility in access - data access page that will pull info down, let the user modify certain fields and push back. I can also create new record entries from scratch without problems.

The difficulty I am having is when I apply a "group" to help display the data better. I want to give the user to add extra lines in that group (keeping the group values). As soon as I do this, the "new" option does nothing.

This looks like a simple question, but none the less I am stumped!

For example,
if i look at customer, product, sale price - I can enter details without problems
if i group by customer, then want to enter product and sale price, it spits its dummy out.

Any help would be appreciated.

[Brian Chandler]

As it stands, I'm afraid your question is hopelessly vague on details. What is "access - data access page" for example? It sounds like part of some system written by someone, but without being able to see the source of the program, it's impossible to make any comment really.

[herrbbiiee]

Hi there and thanks for the reply.
Within MS Access 2003, I go to file and new, and have the option of creating a "blank data access page". then select the connection type (sql) and from there the table(s) I want to access.
Hope this makes it a little clearer

[Brian Chandler]

Oh. sorry - this "access" is M$ Access? I don't know anything about that. Try Microsoft support...

[herrbbiiee]

ok cheers anyway.