473,324 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Continuously run report for display in Access 2007

Gene Pimental
I'm use access to collect real time production data. I have a report that shows each line and the production and quality. I need the form to go through each record and when it gets to the last record, open a different report, which I have showing for 60 seconds then it reopens the first form(no problem)does not have multiple records.

I have tried to use a macro to gotorecord, next, but it gets an error saying "Can't go to specified record" when it gets to the last, I can clear the macro error box, but not the above mention error dialog.
Jul 8 '11 #1
2 2165
ADezii
8,834 Expert 8TB
I'm a little confused by your question, but to Recycle Records on a Form, then to wrap around to the first Record after you are on the Last Record:
  1. Set the Form's TimerInterval in Milliseconds. In this case I'll use 10 secs. (TimerInterval = 10000)
  2. Place the following Code in the Form's Timer() Event:
    Expand|Select|Wrap|Line Numbers
    1. Private Sub Form_Timer()
    2. If Me.CurrentRecord = Me.Recordset.RecordCount Then
    3.   DoCmd.GoToRecord , , acFirst
    4. Else
    5.   DoCmd.GoToRecord , , acNext
    6. End If
    7. End Sub
Jul 8 '11 #2
Works great, just had to replace "DoCmd.GoToRecord , , acFirst with DoCmd.Close acForm, "MTD-DailyFPY", acSaveNo.
Jul 8 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Eugene | last post by:
Hello All, I need a report in Access 2007 to show a dynamic image on every page. I have a table, and I store image's path in a cell in each of the rows. In 2003, I was able to do that using...
1
by: Ashish Gupta | last post by:
I have Access 2007 formatted field (memo). I want to display it on VB form using a control. Richtextbox does not work. Pls suggest a solution.
1
by: scousineau | last post by:
are there any workarounds for using a specific printer for a report in access 2007? something i can write in code? i have 12 different label printers and based on which btn the user clicks it...
9
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd...
11
by: julietbrown | last post by:
Either I or Access is mad! I have a table called "MAILING_TABLE" which is filled from code to create a mailing list of names and addresses. The code works fine, and after it runs the table contains...
3
by: mulamootil | last post by:
Hi friends, I am new to access and I need to create a report. Please pardon me for such a long post.Appreciate your patience. I have a table in Access (MyTable) with data about products...
2
by: mfuentes74 | last post by:
Hi! I need help I have a report in Access 2007 and I need to insert a page break after every operator id (kn028mf) the first five characters are the same only the last two change, I have tired...
1
by: Sharon Brennan | last post by:
I would like to divide my report by our departments and then sites. I've gone into properties for each of my sorts and put in page breaks but nothing happens. Everything just runs together on one...
0
by: Enid Lopez | last post by:
I created a report with 215 records which are divided in three columns, each column contains four fields. The report takes two pages to print. I would like to know if there is any way to make the...
1
by: colsoft | last post by:
Please I want to know i how i can search for a specific record in a report and print that record without using the arrows at the bottom. Like show a dialog or use an input box to search through the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.