Solved

Update access form every 3 seconds

Posted on 2011-09-14
9
309 Views
Last Modified: 2012-08-14
DisplayApp.mdb

I have been tasked with designing an access app that will show a form a big TV within a call center. This app will have forms that will need to show updated query results every 3 seconds. I have attached an .mdb with some tables and a form with subforms. I need help with the VBA to update the form every 3 seconds requerying all query's behind each subform on the main form. I'm also looking for any creative input that you can provide to dress up the form and make it eye catching / fun.

0
Comment
Question by:Dalexan
  • 4
  • 3
  • 2
9 Comments
 
LVL 42

Expert Comment

by:dqmq
ID: 36539720
No eye candy from me.  But, you can add an event to the form's timer property and do this:

 me.requery  

0
 
LVL 42

Accepted Solution

by:
dqmq earned 200 total points
ID: 36539764
Specifically, I meant the main form's on timer event.  You also need to set the timer interval 3000 = 3 seconds
0
 

Author Comment

by:Dalexan
ID: 36539782
I setup the timer but its not refreshing the query behind the subforms
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:Dalexan
ID: 36539824
Also is it possible to change the font size of datasheet view within the form?
0
 
LVL 21
ID: 36539845
for the sub forms include a line like this:

 Me.SubFormConyrolName.Form.Requery  


0
 

Author Comment

by:Dalexan
ID: 36539852
I found the code to change the font size of the datasheet view, I just need help with the timer refreshing the values on the subforms from the query results....and any eye candy help....

Private Sub Form_Load()
    With Me
        .DatasheetFontHeight = 14
        .DatasheetBackColor = RGB(255, 0, 255)
        .DatasheetFontName = "Verdana"
        .DatasheetFontWeight = 700 ' bold
    End With
End Sub
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 50 total points
ID: 36539888
for the sub forms include a line like this:

 Me.SubFormConyrolName.Form.Requery  

Open in new window



Boyd Trimmell
Microsoft MVP - Access Exprt
0
 
LVL 21
ID: 36539910
I think the look of datasheet mode is not very eye catching. I never use them. All the user I have ask say that they are "ugly". The most common response.  I agree.  I think the look of a form in continuous mode can be made to be a lot more eye catching.

Boyd Trimmell
Microsoft MVP - Access Exprt
0
 

Author Comment

by:Dalexan
ID: 36540673
Thanks now all that's left is to install virtualbox I'n ubuntu server and get this app working I'n there.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question