Results 1 to 15 of 15
  1. #1
    Join Date
    Jul 2009
    Posts
    185

    Unanswered: Outside my internet... will not open

    After downloading a sample mdb when I try to open I get a out internet ... error and will not open the file. Only happens on some of course the ones I really want to look at.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ?? So make sure you're connected to the Internet!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jul 2009
    Posts
    185
    dah I am and the file is on my local c: drive

  4. #4
    Join Date
    Mar 2007
    Posts
    277
    Did you RightClick on the file and go to Properties>Unblock?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  5. #5
    Join Date
    Jul 2009
    Posts
    185
    Now why in the ##$%% would I know to do that. Learn something new everyday in this access world.

  6. #6
    Join Date
    Mar 2007
    Posts
    277
    It is a Windows "feature" for all downloaded files.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  7. #7
    Join Date
    Jul 2009
    Posts
    185
    I thought that kind of junk was only in vista I am running XP.
    Do you know of any sample of code in vb to read a couple of tables. I have form with all unbound fields and I need to read two tables one by ID# and need sdescription and second via a combo box to select a record and read three fields then I fill the form and update the two tables fields and add to a third table. I got code working to add to a table but I don't know how to read a table using a combo box. I've checked my large book store and my library but no luck on books that have this kind of infor. The best I have found is "Absolute beginner's guide to vba"
    Anyway that's very much for your help now I can look at more sample mdb files that I have found.

  8. #8
    Join Date
    Mar 2007
    Posts
    277
    The "feature" came without warning in WinXP SP2 I think. It certainly took me by surprise until I figured out what to do. As for your other issue, I've not seen many situations where an unbound form was necessary. Maybe if you described your situation in more detail we could offer some suggestions.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Wow! This was a new one on me too -- I've never seen that unblock button until now. Must be lucky I guess!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    Jul 2009
    Posts
    185
    Basically it is rather simple I though. I have three tables, planes, batteries and flights. The flight is the form I am having trouble with. I read the battey file for description and number of cycles that have been charged. When adding to flights I add one to the cycles and post it back to battery table. I do the same with planes which has number of flights field which I update and post back. But where having problems if the use edits or deletes a flight the cycles and flight fields don't get reduced by one. I want to control that a flight is not added until you press the save button. I would use a different form for deleting and editing so the cycles and flight get updated to reflex the changes.

    I hope this make sense.

  11. #11
    Join Date
    Mar 2007
    Posts
    277
    When the form is bound, all you need to do is put code in the BeforeUpdate event of the form to stop any changes until you change a public flag in the form. You can also do basically the same thing in the BeforeInsert for new records if you want to.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  12. #12
    Join Date
    Jul 2009
    Posts
    185
    Ya I didn't know about all the form's events though some don't seem to get call when I thought they would I am put a msgbox in the dirrent events and seeing when they happen. I am learning whre I can set my own flag to control things. All I need to track the first plane number before a edit can happen then on confirm of the edit reduce the original planes flights by one. And do the same on a deletion. The book I bought go into all the these events though some are access 2007 events and most of a objects properties. It is slow but I am slowly getting some docs.

  13. #13
    Join Date
    Jul 2009
    Posts
    185
    I have the following:
    Now how do i get the data updated in planes.
    But not cause a insert to my other table.
    Private Sub Form_AfterDelConfirm(Status As Integer)
    Requery
    MsgBox "plane.iflights=" & [planes.iflights]
    [planes.iflights] = [planes.iflights] - 1

    End Sub

  14. #14
    Join Date
    Mar 2007
    Posts
    277
    I will have to be honest and say I don't really know what you are doing. I can not see what you are deleting or how your forms are bound or how your tables are related.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  15. #15
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    This appears to be a duplicate thread at this point. Closing accordingly, please refer to the following thread:

    http://www.dbforums.com/microsoft-ac...es-delete.html
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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