J
John
I have developed a form to where i scan my pictures
in a file and then they are displayed onto my access 2002
form. They were in .bmp format but the pics were very
distorted so I changed them to .jpg know they look fine..
1.Which format is best ?
2.Why did the pictures change because I changed the
format?
3.How do I connect the right picture with the current
record
that I will be entering?
4.Also since I changed the file ext. to .jpg the import
picture box flashes up when I scroll through the pictures
i have in there,
5. How do I get this not to show up on the screen when
scrolling through the Pics??
6.Also I want to add knew records with pics and delete do
I do a cmd box for this procedure if so do you know of
any code examples for this?? or how I can achieve this on
my form?
7. Can you use autonumber for primary key?
8. I have 5 tables from this database project one table
is the focus can I put the primary key of that central
table into the other 4 tables ? if how do i do it ... i
want a one to many relationship.. meaning one from the
centrral table to many for the other 4 tables.....??
9. The last question is one of the 5 tables when you go
to enter information from the form there is maybe
information to enter into this table every once in a
while should, I make the table a n/a automatic come up
and then if information needs to be entered in by the
user then give them the option..if so how?? If i
understand correctly I dont need to have a empty table
with only a few entries...example if I have 50 records
entered into my other tables and only 2 out of the 50
requires info in the one table then do i make the rest of
the 48 entries n/a?? Hope this makes sense? I posted this
on the site and have gotten no response's
in a file and then they are displayed onto my access 2002
form. They were in .bmp format but the pics were very
distorted so I changed them to .jpg know they look fine..
1.Which format is best ?
2.Why did the pictures change because I changed the
format?
3.How do I connect the right picture with the current
record
that I will be entering?
4.Also since I changed the file ext. to .jpg the import
picture box flashes up when I scroll through the pictures
i have in there,
5. How do I get this not to show up on the screen when
scrolling through the Pics??
6.Also I want to add knew records with pics and delete do
I do a cmd box for this procedure if so do you know of
any code examples for this?? or how I can achieve this on
my form?
7. Can you use autonumber for primary key?
8. I have 5 tables from this database project one table
is the focus can I put the primary key of that central
table into the other 4 tables ? if how do i do it ... i
want a one to many relationship.. meaning one from the
centrral table to many for the other 4 tables.....??
9. The last question is one of the 5 tables when you go
to enter information from the form there is maybe
information to enter into this table every once in a
while should, I make the table a n/a automatic come up
and then if information needs to be entered in by the
user then give them the option..if so how?? If i
understand correctly I dont need to have a empty table
with only a few entries...example if I have 50 records
entered into my other tables and only 2 out of the 50
requires info in the one table then do i make the rest of
the 48 entries n/a?? Hope this makes sense? I posted this
on the site and have gotten no response's