Recent content by strive4peace

  1. strive4peace

    Unable To Fix Excel Issue.

    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?
  2. strive4peace

    Unable To Fix Excel Issue.

    ... and the calling code!
  3. strive4peace

    relate combobox value, between two linked subforms

    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 ~
  4. strive4peace

    Solved Changing Color Theme via VBA in Runtime

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

    relate combobox value, between two linked subforms

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

    relate combobox value, between two linked subforms

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

    Unable To Fix Excel Issue.

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

    relate combobox value, between two linked subforms

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

    Unable To Fix Excel Issue.

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

    Referential Integrity

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

    long binary data for storing images

    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"...
  12. strive4peace

    #Type! Error

    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 ~
  13. strive4peace

    Exit Sub in called sub

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

    Solved Changing Color Theme via VBA in Runtime

    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 ~
  15. strive4peace

    "No current record" error now affecting all versions of my database

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