Display multiple records on a single form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have an access/vba application I'm trying to extend. I'd like to create a
new form in which several records are displayed, followed by an edit and
delete button. A textual representation of what I'd like is as follows:

Person ID - 123456
Order ID - Product ID - Quantity
ord123 - prod123 - 4 [EDIT BUTTON] [DELETE BUTTON]
ord234 - prod234 - 3 [EDIT BUTTON] [DELETE BUTTON]
ord345 - prod345 - 5 [EDIT BUTTON] [DELETE BUTTON]
....

The number of records will be dynamic because each individual will
potentially have any number of records which I'd like to display on a single
page. Can anyone provide me with some tips as to the best way to implement
this type of form and possibly some sample code (or a URL to some sample
code)? I'm relatively new to access development, so I'm not even sure what
controls I'd need to use to facilitate this functionality, so any advice
would really be appreciated. Alternatively, if someone has another
suggestion regarding how I can go about implementing this functionality I'm
all ears.

Thanks a lot,

Melissa
 
Sorry about that. I just didn't know which newsgroup to post in. I'll stick
to just one in the future.

--
Melissa


Rick B said:
Melissa:

Please stick to one post.

http://www.mvps.org/access/netiquette.htm


--
Rick B



Melissa said:
Hello,

I have an access/vba application I'm trying to extend. I'd like to create
a
new form in which several records are displayed, followed by an edit and
delete button. A textual representation of what I'd like is as follows:

Person ID - 123456
Order ID - Product ID - Quantity
ord123 - prod123 - 4 [EDIT BUTTON] [DELETE BUTTON]
ord234 - prod234 - 3 [EDIT BUTTON] [DELETE BUTTON]
ord345 - prod345 - 5 [EDIT BUTTON] [DELETE BUTTON]
...

The number of records will be dynamic because each individual will
potentially have any number of records which I'd like to display on a
single
page. Can anyone provide me with some tips as to the best way to
implement
this type of form and possibly some sample code (or a URL to some sample
code)? I'm relatively new to access development, so I'm not even sure
what
controls I'd need to use to facilitate this functionality, so any advice
would really be appreciated. Alternatively, if someone has another
suggestion regarding how I can go about implementing this functionality
I'm
all ears.

Thanks a lot,

Melissa
 
If you feel you need to post to more than one group (HINT: it's seldom
necessary), you should cross-post (send the one message to all groups at
once), rather than multi-post (send individual messages to each group). In
this way, all responses to your post will be available together, regardless
of what group the responder was in, and the rest of us won't have to read
your post multiple times. (It also uses fewer server resources)

You appear to be using Microsoft's web interface to post. You should see an
"Advanced Options" link at the bottom of the page. You can type the names of
the various groups into the Newsgroup box, separating each newsgroup name
with a semicolon.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Melissa said:
Sorry about that. I just didn't know which newsgroup to post in. I'll stick
to just one in the future.

--
Melissa


Rick B said:
Melissa:

Please stick to one post.

http://www.mvps.org/access/netiquette.htm


--
Rick B



Melissa said:
Hello,

I have an access/vba application I'm trying to extend. I'd like to create
a
new form in which several records are displayed, followed by an edit and
delete button. A textual representation of what I'd like is as follows:

Person ID - 123456
Order ID - Product ID - Quantity
ord123 - prod123 - 4 [EDIT BUTTON] [DELETE BUTTON]
ord234 - prod234 - 3 [EDIT BUTTON] [DELETE BUTTON]
ord345 - prod345 - 5 [EDIT BUTTON] [DELETE BUTTON]
...

The number of records will be dynamic because each individual will
potentially have any number of records which I'd like to display on a
single
page. Can anyone provide me with some tips as to the best way to
implement
this type of form and possibly some sample code (or a URL to some sample
code)? I'm relatively new to access development, so I'm not even sure
what
controls I'd need to use to facilitate this functionality, so any advice
would really be appreciated. Alternatively, if someone has another
suggestion regarding how I can go about implementing this functionality
I'm
all ears.

Thanks a lot,

Melissa
 
Back
Top