Results 1 to 12 of 12
  1. #1
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8

    access database form dissapear directly when i open it.

    Access database 2007: I have a database with some forms init but when i type my username and password to open the main menu to insert data the form shows 1 second and closes the whole database. I don't know whether the problem is the VB code or the microsoft please help

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,540
    Can you post a copy of your db
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8
    iam about uploading its 89mb

  4. #4
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8
    how can i send you the user and the password so only you can see it? to your email maybe?

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,540
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #6
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8
    hi i have tried to make it smaller but still 4mb what to do

  7. #7
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,540
    Delete most of or all the data from your tables. Just give us a few records so we can understand something of how it all fits together
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  8. #8
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8
    I have deleted all the data and many forms but i dont dare to delete the macros.

  9. #9
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8
    this link try to open maybe you can open it from onrdrive
    Last edited by ario; 01-13-2015 at 02:22 AM.

  10. #10
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8
    and the username and the password i have sent it earlier today in private message

  11. #11
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,540
    Your db is being closed by the code in the on load event of main form
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  12. #12
    ario is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2015
    Posts
    8
    how to fix it

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Linking directly to an access form from an email
    By stardust1979 in forum Programming
    Replies: 2
    Last Post: 10-01-2014, 05:00 PM
  2. Replies: 1
    Last Post: 01-24-2014, 01:21 PM
  3. Replies: 4
    Last Post: 12-05-2012, 03:24 PM
  4. Access database won't open directly
    By Rale in forum Access
    Replies: 0
    Last Post: 03-24-2011, 03:33 AM
  5. Why 2 users cant open an access file directly???
    By finnegan bell in forum Access
    Replies: 6
    Last Post: 03-22-2009, 09:06 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums