Recent content by strive4peace

hi @Tonybenz maybe the error message isn't exactly right ... perhaps you have a bad formula? Can you run Excel at all? Maybe it needs to be reinstalled?

... and the calling code!

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...

good point, @The_Doc_Man I was just moving things off my C: drive yesterday to give programs more space for their temporary processing files ... after permanently deleting Recycle Bin and Temp files wasn't enough

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...

hi @Tonybenz, maybe it's time to reboot your computer?

@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...

hi @Pac-Man > By the way what does this (WHERE 1 = 0) where condition do. I failed to understand it. This makes no current records be in the recordset (1=0 is False). Since records are being added, the recordset doesn't need to have what is already there ~

EDIT: oh gosh, I see lots of comment I didn't see before ... but to avoid issues, this is good to read anyway ... hi @zebrafoot try this ... before: DoCmd.OpenForm ... and before DoCmd.Close acForm, "frmQuotes" and before code that takes it somewhere else do this: with me 'save record if...