Search results

links to pictures C:\Images\RiskID_460_before_1.jpg my form shows them perfectly like in this case ID 460. 2 pictures.

i had it. it shows like there is no pictures Tmain Tmain RiskID RiskCode riskTitle isActive RiskdueDate RiskDate locationID location locationPricies risktype riskcolor reporter picafter picbefore picbefore1filepath picbefore1picname picbefore2filepath picbefore2picname picbefore3filepath...

as u can see "RiskID" is always = "picbefore1filepath" as they are basically in one table

hey guys, it didn't take long until i face with another problem for me lol i have a Continuous Forms and Attachment as field type, but now im in a process of switching to storing pic outside of db. so im gonna need to remove attachments soon and .... my Image Object type which does its job...

@theDBguy, @MajP and @Gasman - thank u very much guys ! much appreciated !

hey guys, is there a way to code on click event to refresh (F5) current form ? sorry for simple question, couldn't find on the internet.

i found this PC (IT helped me) and i closed db. then i waited like 1-2 hours - its still in session. then i restarted that PC - and even after restart its still shows that this PC is using db... damn.. i wasn't expect that ... :( maybe it needs some cooldown ?

well explained ! thank you very much Gasman for helping noobies like me to explore access.

im new at access, so i've never split db before. prob. need to go ahead and try who ever new noobies will read this topic i suggest to watch this youtube video

oh... prob. so it is updatable even if someone opens a db , correct ?

whats FE ? i haven't slip my db. any benefits of doing it ?

i couldn't believe it might be so simple !! thank you very much, Gasman !

hey guys, i have my db.accdb in network where many ppl use this db. Now i need to update this file and i need to remove it from network and then put updated file back. BUT ! there is laccdb temp file which is created when someone runs access. But prob. someone opened access and forget about it...

sometimes simple things might not be that simple for some ppl. or how we say in my country - the closest path is the path u know of. :) yeah, i have already subforum in my form. im gonna play with separating filepath into new table then subform and give it a play. if it will turn out hard for me...

each pic has its own 3 buttons to control it.

will i need to see 6 thumbnails (pics) and maybe 12 if file name will do anything useful. so 6 pics, each one has its own file and path to open it. this one

i think its simpler for me just to store file path in a main table, having additional 6-12 fields

thanks for your reply, plog! this is continuation of my journey in access from this post and this one so im gonna have 6 thumbnails (pic) in my form. 3 before. 3 after. and each of them need to have a filepath. not sure about file name, but filepath is necessary cause it will open certain pic...

found mistake. RiskIDpic is now a number filed type. still have mismatch issue

hey guys, so i have Form with everything i need. i've just created a new table i added all these fields to my form and when i try to open it, it says 'Type mismatch in expression" why ?