Search results

Hi Nate @naterook Welcome to AWF. I'm self-taught too, having learned Access many years ago when it still came with books (which I read cover-to-cover) I've learned much more though, from participating in forums! ... because someone else had a better solution than the one I proposed. We get...

hi @gemma-the-husky for manipulating image files with Access, I like Irfanview since it has switches you can end to the end of the command line to change things. Here's an example using VBA to use Irfanview to resize http://msaccessgurus.com/VBA/Code/Irfanview_ResizeImage.htm ... and in...

thanks, Colin @isladogs -- great examples too ... very creative! Good teaching and fantastic food for thought

hi @access2010 (what is your name?) I just happened to see your post -- next time you want me too look at something, tag me not sure what you want us to look at. I downloaded your db and looked at code behind the find combo... first, before moving to another record, save the current record if...

hi @ekje most important to remember is that, because data takes time to bring down, only bring down what you need. On forms, RecordSource should be limited to show record you want to edit. For populating RowSources, use pass-through queries It took about a week to build an Access app -- then...

delete rst_PDF! -- you only need Me.txtLocation if that contains the full path and filename

you're welcome. Does that mean you changed it and now it works? or is the issue that Exit Sub is there? If so, put a Stop statement in, temporarily, before the Exit Sub to verify it actually isn't working. My guess is that code isn't going to that statement. Is it inside an IF block?

@A380b747 as long as you're browsing for the file anyway, why not just copy it into a Files folder under the back-end database and store the path\filename? You can also include the initials of the person who added the file to make it easier to see all of their files ~

hi @A380b747 > other users need to have access is your database split into Front-End and Back-End? If shared filed are placed in a folder under the back-end location, maybe called 'Files', then a relative path can be stored that is different for each user but still points to the same place.

hi @A380b747 echoing @theDBguy's comment ... best not to store external files IN the database. Better to store path\filename and render with Image control if pictures or maybe Web Browser control for other types of files. I like to put all files referenced by the database in a folder under...

hi @sekoma Reports have a Running Sum property so it's easy there ... Choices are No Over Group Over All To show a running sum on a form, you need to do a calculation. Easiest would be to use DSum. The problem though, is what if the form is sorted differently? Or there is criteria to...

you're welcome. @Manos39 -- forgive me for looking too fast to notice all your specifics... hopefully the example back has given you understanding -- for if you are responsible for the database, you must comprehend what is done each step of the way. My goal is to teach, not do it for you ~

Now there is an attachment -- thanks for noticing there wasn't Colin @isladogs ... @petertheme edited his post to have the attachment

you're welcome, @Manos39 It would help if you explain your logic better ... what you're trying to do in real world terms one of your screenshots shows a drop-down list for a combo RowSource -- you didn't mention that and I didn't look at that when making the sample db which mainly illustrates...

you're welcome, @Manos39 I did the example quickly since I'm working on something else today -- so maybe the logic you want isn't quite right. There shouldn't be a different whether you use Datasheet or Continuous forms --- but no need for criteria in the RecordSource when you use...

hi @Manos39, put the linking controls on the main form: RaceID eventID GenderID I didn't set Visible to be No, but that would be the next step after you test and ensure it is working ok. By doing it this way, there is no code to link them -- Access will do that automatically. The...

@kevnaff, to enforce referential integrity, the field in the parent table must have a Unique Index. Normally it is customary to use the primary key (ContactID), not a text field. That also has much better performance if ContactID is an AutoNumber (Long Integer).. If you use a numberic foreign...

maybe it was my Automate Word presentation, @GPGeorge ? @drshahriyar, This code loops through an attachment field in a table and saves all the files externally. Sub run_SaveAttachmentsToFiles() '130117 strive4peace SaveAttachmentsToFiles "MyTablename", "MyAttachmentFieldname"...

glad it's working for you now, lannoe! I think what @Gasman was perhaps wondering about is who's post helped you to see it for yourself ~

hi @Wysy > Why the exit sub does not work if it is in a called sub? Exit Sub only exits the current procedure, not the whole process. If you want the calling sub to exit as well, you need to add Exit Sub after you call it. I don't know your logic ... so perhaps there is more to this. Perhaps...