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

Filling forms on-the-fly and saving to another table

P: n/a
Hello all,

I'm not an Access expert, so I'll try to explain the problem the
best I can, and please try to answer so that a layman can understand
it =)

I have a database with several tables, but lets say I have just two:

Table1: ID, Name, Surname, Division, Image
Table2: ID, Name, Surname, Division, Image, Code

I want to create a form that does the following:

1) I input the ID
2) All the other fields, except Code, are filled on-the-fly (as soon
as I enter the ID) according to the data in Table1.
3) An image is retrieved on-the-fly from a source like
http://server/folder/<Image>.jpg and displayed in the form.
4) I can make any necessary modifications to the fields and add the
Code.
5) The data is saved to Table2.

Is it possible? Thanks in advance!

Diego
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I may be daft, but why not just have the one table, and set a flag whether
that person is relevant or not. All queries, forms etc would be based on
Relevant = True. You could have a List box on the form that shows everyone
and "Add" a new relevant person by selecting them from the list box

Phil

"ironcito" <co****@ironcito.com> wrote in message
news:e7**************************@posting.google.c om...
Hello all,

I'm not an Access expert, so I'll try to explain the problem the
best I can, and please try to answer so that a layman can understand
it =)

I have a database with several tables, but lets say I have just two:

Table1: ID, Name, Surname, Division, Image
Table2: ID, Name, Surname, Division, Image, Code

I want to create a form that does the following:

1) I input the ID
2) All the other fields, except Code, are filled on-the-fly (as soon
as I enter the ID) according to the data in Table1.
3) An image is retrieved on-the-fly from a source like
http://server/folder/<Image>.jpg and displayed in the form.
4) I can make any necessary modifications to the fields and add the
Code.
5) The data is saved to Table2.

Is it possible? Thanks in advance!

Diego

Nov 13 '05 #2

P: n/a
ironcito wrote:
Hello all,

I'm not an Access expert, so I'll try to explain the problem the
best I can, and please try to answer so that a layman can understand
it =)

I have a database with several tables, but lets say I have just two:

Table1: ID, Name, Surname, Division, Image
Table2: ID, Name, Surname, Division, Image, Code

I want to create a form that does the following:

1) I input the ID
2) All the other fields, except Code, are filled on-the-fly (as soon
as I enter the ID) according to the data in Table1.
In the AfterUpdate event of ID, enter some code to find the record in
Table1. Look at FindFirst in help and the code examples.
3) An image is retrieved on-the-fly from a source like
http://server/folder/<Image>.jpg and displayed in the form.
If the picture is displayed in an image control, you can change that. Ex:
Me.Image0.Picture = "C:\Pictures\Pic1.jpg"
You would put this in the AfterUpdate event once you found the record in
step 2.
4) I can make any necessary modifications to the fields and add the
Code.
5) The data is saved to Table2.
In your AfterUpdate event of the record you would either add or update
the record. Look at Edit, AddNew, and FindNext, OpenRecordset, Update,
NoMatch in help.

Is it possible? Thanks in advance!

Diego


Nov 13 '05 #3

P: n/a
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<41*********************@mercury.nildram.net> ...
I may be daft, but why not just have the one table, and set a flag whether
that person is relevant or not. All queries, forms etc would be based on
Relevant = True. You could have a List box on the form that shows everyone
and "Add" a new relevant person by selecting them from the list box

Phil


Basically because the data in both tables can be different, and there
will be records in Table2 that are not in Table1. Also, the tables I
described were an example, in reality its a bit more complex.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.