473,386 Members | 1,819 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,386 software developers and data experts.

Duane Hookom's Outlook Style Report for MS Access

For anyone familiar with Duane's report
(http://www.invisibleinc.com/download.cfm?filFilID=6)...

This report is perfect for a project I am working on. I am a novice to
creating reports in Access and would never have dreamt of the elegant
solution Duane created. On the main form Duane states, "The code and
report dimensions assume that all schedule entries are between 8:00 AM
and 6:00 PM, Monday-Friday. These limits could be adjusted by changes
in the code and design." This is the reason for my post. Namely, I
wish to have the user choose the start and end times as well as the
time period between ticks (1/2 hour, 1 hour, 2 hours). What is the
best approach to accomplish this? I have read that you can create an
Access report on the fly. But I am unsure of the performance penalties
incurred in doing so. Should I design the report to accommodate any
options the user may choose (the lowest-common case, as it were)?
Thank you for any and all help.

May 15 '06 #1
0 1585

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Randy Harris | last post by:
I'm using the CreateObject method to send email from Access. Set objOutlook = CreateObject("Outlook.Application") This, of course, launches Outlook to send the message. Anyone know if there...
1
by: Jonathan Pinto | last post by:
I was wondering if it would be possible to snapshot an access report to Outlook, and have fields come in the To: and Cc: fields, and also the subject field of the email as well. Right now, I am...
0
by: Marc | last post by:
I have a Vb 6.0 project The VB 6.0 project with a just a click of the button...exports the calender rows from OUtlook to a MS Access file ( a DB and a table with the calender rows are created)...
2
by: Susan Bricker | last post by:
I have a routine that uses Late Binding to create a email and put it into the DRAFTS folder of Outlook. It only works if Outlook is already launched (Opened by me clicking on my desktop ICON...
5
by: adrian.williams2 | last post by:
Hi, I'm having trouble trying to email a report via access... I get a Outlook message stating 'a program is trying to automatically send e-mail on your behalf. Do you want allow this? This...
0
by: ratnakarp | last post by:
Is there any way i can improve on this code? If i run this application by giving the detials of the start date and end date in the range of 15 days, it's taking 3 mins. I'm looking for a code...
8
by: Wayne | last post by:
My supervisor performs the following steps to generate an email notifying recipients of new problem reports: 1) Generate an Access report containing the columnar data and export it to a .rtf...
7
by: Dean Spencer | last post by:
Can anyone help? I am importing Emails from Outlook using the following code: Public Function ScanInbox(SubjectLine As String) Dim TempRst As Recordset Dim OlApp As Outlook.Application Dim...
0
by: dreamsoul620 via AccessMonster.com | last post by:
Hi all! I'm trying to set up an email application for my database. I tried linking to my Outlook address book, but when reading from the table, I receive an error message saying I need to restart...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.