Creating database in Access

drexax · May 22nd, 2015, 12:24 PM

Hi all,

I'm trying to create my own database in Access for my naughty books collection.
Adding pictures inside the database makes it way too big, so I'm trying to just put a link to it, and keep the JPG outside of the database.

At one time this worked, but now I messed up apparently, cause it isn't working anymore... Have to look into that...

But... it's a rough solution that I have, I have to manually put in all the links (\Pictures\picture-001.jpg) for each magazine.
It would be very neat, to have an imagebox, which you can click, after which there's a little browser... pick out the picture you want, and it inserts the picturelink rightaway into the right table, and is visible within the form...

As I understand you need vbasic for this, and as I'm just a beginner... I'm getting frustrated ALOT! Been trying for weeks now... First had a 64 bits version, which wasn't the way to go, then I installed a 32 bits version, but still can't get it to work..

Anyone knows any Access? Programming skills? Can help me out?

Would really appreciate it!

Drexax

**9876543210** · May 24th, 2015, 12:59 AM

Drexax,

Used to know a bit about Access years ago but haven't used it in quite a while. But, it occurs to me there are programs out there which already do what you propose. Sorry, don't know their names but someone else might.

Might want to look into that as it could save you one heck of a lot of time. Unless, of course, you really want to learn VB programming. If you do then just go for it.

drexax · May 24th, 2015, 05:48 AM

Well, in the first place it's fun to learn something new and I've got the database running in a rough state... I can ad magazines in a form, can check whether they're complete, in posession, etc, etc.
Photo (cover) can be added, but have to be typed in ... It would be nice to have some vb-script for that so you can browse to the image... But... it works! And that is what matters most. Thought occured to me, that though this isn't neat, this might be faster than browsing to images... Now I only have to type in xxxxx.jpg and the picture appears in the right frame :-)

I've tried another piece of software (forgot the name) but that was even trickier than Access... But I'm getting there ... someday ;-)

**DB83** · May 24th, 2015, 05:40 PM

I did something similar many years back with vb.

The problem with any external links is that if you change your HDDs you have to alter all the links.

These days I simply code with MySQL,PHP and an Apache server running on your PC. So your end-result is your very own personal website.

drexax · May 25th, 2015, 06:40 AM

True, I put the pictures into a folder, inside the mainfolder of the database, something like this:
C:\Database\Pictures
In access I give these links: '\pictures\'
This way, I can move the mainfolder (including files and subfolders) around at any HDD, and it will still be found. Only thing is to keep them where they are... and that's no problem.

Thanks for your thoughts!

**DB83** · May 25th, 2015, 10:35 AM

A wee suggestion that might help.

How about creating a .txt file of the folder(s) contents using the dos command of dir > file.txt. Might need some work on that line.

Then import that text file into access and manipulate it from there.

Could save a lot of typing

drexax · May 25th, 2015, 11:10 AM

That's an excellent idea! Thanks!

May 22nd, 2015, 12:24 PM	#1
drexax Member Join Date: Jul 2012 Location: Netherlands Posts: 57 Thanks: 70,113 Thanked 1,022 Times in 48 Posts	Creating database in Access Hi all, I'm trying to create my own database in Access for my naughty books collection. Adding pictures inside the database makes it way too big, so I'm trying to just put a link to it, and keep the JPG outside of the database. At one time this worked, but now I messed up apparently, cause it isn't working anymore... Have to look into that... But... it's a rough solution that I have, I have to manually put in all the links (\Pictures\picture-001.jpg) for each magazine. It would be very neat, to have an imagebox, which you can click, after which there's a little browser... pick out the picture you want, and it inserts the picturelink rightaway into the right table, and is visible within the form... As I understand you need vbasic for this, and as I'm just a beginner... I'm getting frustrated ALOT! Been trying for weeks now... First had a 64 bits version, which wasn't the way to go, then I installed a 32 bits version, but still can't get it to work.. Anyone knows any Access? Programming skills? Can help me out? Would really appreciate it! Drexax Last edited by drexax; May 22nd, 2015 at 03:52 PM..

May 24th, 2015, 12:59 AM	#2
9876543210 Veteran Member Join Date: Nov 2007 Posts: 4,044 Thanks: 24,638 Thanked 34,288 Times in 4,008 Posts	Drexax, Used to know a bit about Access years ago but haven't used it in quite a while. But, it occurs to me there are programs out there which already do what you propose. Sorry, don't know their names but someone else might. Might want to look into that as it could save you one heck of a lot of time. Unless, of course, you really want to learn VB programming. If you do then just go for it.

May 24th, 2015, 05:48 AM	#3
drexax Member Join Date: Jul 2012 Location: Netherlands Posts: 57 Thanks: 70,113 Thanked 1,022 Times in 48 Posts	Well, in the first place it's fun to learn something new and I've got the database running in a rough state... I can ad magazines in a form, can check whether they're complete, in posession, etc, etc. Photo (cover) can be added, but have to be typed in ... It would be nice to have some vb-script for that so you can browse to the image... But... it works! And that is what matters most. Thought occured to me, that though this isn't neat, this might be faster than browsing to images... Now I only have to type in xxxxx.jpg and the picture appears in the right frame :-) I've tried another piece of software (forgot the name) but that was even trickier than Access... But I'm getting there ... someday ;-)

May 24th, 2015, 05:40 PM	#4
DB83 Vintage Member Join Date: Sep 2008 Posts: 1,472 Thanks: 1,948 Thanked 12,019 Times in 1,458 Posts	I did something similar many years back with vb. The problem with any external links is that if you change your HDDs you have to alter all the links. These days I simply code with MySQL,PHP and an Apache server running on your PC. So your end-result is your very own personal website.

May 25th, 2015, 06:40 AM	#5
drexax Member Join Date: Jul 2012 Location: Netherlands Posts: 57 Thanks: 70,113 Thanked 1,022 Times in 48 Posts	True, I put the pictures into a folder, inside the mainfolder of the database, something like this: C:\Database\Pictures In access I give these links: '\pictures\' This way, I can move the mainfolder (including files and subfolders) around at any HDD, and it will still be found. Only thing is to keep them where they are... and that's no problem. Thanks for your thoughts!

May 25th, 2015, 10:35 AM	#6
DB83 Vintage Member Join Date: Sep 2008 Posts: 1,472 Thanks: 1,948 Thanked 12,019 Times in 1,458 Posts	A wee suggestion that might help. How about creating a .txt file of the folder(s) contents using the dos command of dir > file.txt. Might need some work on that line. Then import that text file into access and manipulate it from there. Could save a lot of typing

May 25th, 2015, 11:10 AM	#7
drexax Member Join Date: Jul 2012 Location: Netherlands Posts: 57 Thanks: 70,113 Thanked 1,022 Times in 48 Posts	That's an excellent idea! Thanks!