Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 34 of 34

Thread: Add form ID to be recognized on another form

  1. #21
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    I entered this:
    If currentprojects.AllForms("FrmSearch").IsLoaded Then
    I get an error 424
    Object required

    Michael

  2. #22
    VBAX Contributor
    Joined
    Jan 2007
    Posts
    146
    Location
    sorry should be currentproject not currentprojects. Typing too fast =P

  3. #23
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    I did this:
    [VBA]
    if currentprojects.allforms("frmSearch").isloaded then
    [/VBA]

    I looked in Help for IsLoaded and it really didn't show a good example, but it did use True/False, I tried that and that gave the same error.

    I get Runtime error 424
    Object required
    i know you were giving me a sample but I just am not good at this stuff.

    Michael

  4. #24
    VBAX Contributor
    Joined
    Jan 2007
    Posts
    146
    Location
    your on the right path. it was my mistake, should be

    If currentproject.allforms("frmSearch").isloaded Then

    There is no 's' in currentproject

  5. #25
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    just got your message!
    That worked!
    Michael

  6. #26
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    Now,
    Again, I have a problem.
    All goes well.
    I added a button to open the "FrmRequestForWO"
    Now i have the same locking up going on????

    Not sure what is going on??

    Michael

  7. #27
    VBAX Contributor
    Joined
    Jan 2007
    Posts
    146
    Location
    hmm...im not sure what you mean by locking up, would it be possible to post a sanitized version of your database so i can take a look? thanks.

  8. #28
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    I can post the whole thing if you want?
    we don't do anything sanitized!?! LOL
    Michael

  9. #29
    VBAX Contributor
    Joined
    Jan 2007
    Posts
    146
    Location
    whole thing would be good. You'll have to zip it first though

  10. #30
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    Ok here is the attached file.

    I can't send the BackEnd File that goes with it, because
    it is way too large, but you can add a couple of records to
    get the idea.

    Thank You,
    Michael

  11. #31
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    I may be able to email you the back end if you like!
    Michael

  12. #32
    VBAX Contributor
    Joined
    Jan 2007
    Posts
    146
    Location
    could you attach the a copy of your backend with just a couple entries?

  13. #33
    VBAX Tutor
    Joined
    Jan 2005
    Location
    Greenville, SC
    Posts
    220
    Location
    How exactly should I do this? I would have to make a copy of my database, somehow delete 1200 records, then delete about 670 contacts?
    Is this correct?

    Michael

  14. #34
    VBAX Contributor
    Joined
    Jan 2007
    Posts
    146
    Location
    Hey Michael, You'd have to create a copy of your Backend, delete all the records while keeping the structure of the table and maybe add 1 or 2 examples.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •