Recent content by sqrepants

If picRst.Fields(i) & vbNullString <> newStrVari & vbNullString Then i know what the code does. but i dont understand the syntax. can u explain?

Yes, it is a bit difficult to rewrite some of the code at this point. im certain that your method would be more efficient. the only stumbling block with that however, is that i have no idea how to have that code run on each row of the pictures column. this is why i used a record set and...

Hi guys. With some of your help i was able to figure this out. im posting this here for the sake of the community and also if you have any suggestions on how to make this code more efficient, feel free. the problem was that the access file when moved around lost the links to the images (the...

I will give this a try. My only question would be how am i going to get the root to be processed and placed on the form. would i have to create a module and do something like ?getDir() +"\2013\..."

How exactly can I store the picture name instead of the link?

its the actual file path stored as a text on a table

Hi guys. I have a MS access db with a report that displays a list of students with a pic of their face on the side. The pics are linked to a folder thats inside the folder where the .accdb file is stored. The accdb is often moved around, but when it does, all the links become broken and the...

hi my name is nick and i am aspiring programmer. i have a passion for programming but i lack the job.