Page 1 of 3 123 LastLast
Results 1 to 15 of 35
  1. #1
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145

    Is there a way that I could implement a loading Bar!


    I have a Splash Screen type deal that loads after the user logs in I wanted to know if there was a way that I could add a Loading Bar that would say different things like Are you having a nice day? and some funny stuff like that?
    Something to be fun about?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    This has been discussed in threads, as recent as last week, now finding it again is the trick. Think this is it https://www.accessforums.net/access/...3-a-44782.html

    Ooops, misread your post. Code can set info in the bar at bottom of Access window, otherwise set caption of textbox or the bar at top of form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    Well now that I have been thinking about this little project I wanted to Make a button here!
    That would update the forms data and open a loading bar that gives the user a visual update.
    Click image for larger version. 

Name:	000000000000000000100010001000100010101001001000101000010010001.jpg 
Views:	20 
Size:	113.7 KB 
ID:	17059

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    Does not alter my suggestion.
    Last edited by June7; 07-01-2014 at 01:43 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    Here is the end result of me trying an it doesnt work for me it only opens it up with nothing happening and the status says 100%
    Click image for larger version. 

Name:	01010101010101010001.jpg 
Views:	20 
Size:	96.3 KB 
ID:	17070
    Click image for larger version. 

Name:	210210201201201.jpg 
Views:	20 
Size:	161.1 KB 
ID:	17071

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    You are using OpenQuery method to run UPDATE sqls?

    I've never done anything like this but code looks okay.

    Have you step debugged? Review link at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    Do you think I should make it a different method?
    How would you do it?

  8. #8
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    The video in which is displayed on the forum that you showed gave me what I have It doesnt work for me am I missing something???

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    Doesn't work means what - error message, wrong results, nothing happens? Have you step debugged as suggested?

    I've never had any interest to build a progress bar. I did explore the Hourglass method but apparently have not retained it in any code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    well I did try the step debugged nothing happens well this is what I said happens Nothing and the Status says 100% and nothing comes up as visible

  11. #11
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    Something is happening if the label caption is changed.

    You set a breakpoint in code?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  12. #12
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    I don't know what a Breakpoint is?
    Last edited by Z1nkstar; 07-01-2014 at 03:28 PM. Reason: Had to run out now im back

  13. #13
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    Then the code execution should pause on the breakpoint and you can step one line at a time and follow as code executes.

    The image points to a command button but code is in the form Open event.

    What does button do?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  14. #14
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    the button Opens the form that has the Loading Bar and when its finished it should close out but neither does it close or do any of the loading and the button also refreshes the data in the database
    I can provide you with a download from google docs i have tried to add it here but i cant get it

  15. #15
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    Attach a zip file up to 2MB. Click Go Advanced below the Quick Reply editor. The Attachment Manager is below the Advanced editor.

    I cannot download from fileshare site until late tonight.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 1 of 3 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to Implement??
    By radick201 in forum Database Design
    Replies: 3
    Last Post: 01-15-2012, 02:02 AM
  2. implement expressions
    By quandore in forum Access
    Replies: 7
    Last Post: 01-11-2012, 03:48 AM
  3. Implement Forms Only on Start Up
    By fat ralphy in forum Forms
    Replies: 5
    Last Post: 10-21-2011, 02:08 PM
  4. How would I implement this?
    By redfox1160 in forum Access
    Replies: 4
    Last Post: 03-09-2011, 03:07 PM
  5. Finalise database and implement??
    By turbo910 in forum Access
    Replies: 4
    Last Post: 12-12-2009, 04:28 PM

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