Color Coding SOS
Tue, 2 Dec 2008 16:19:00 -0800
I have a report called Total Call Summary. This report shows how many audits
were done and if all the Yes or No fields were check correctly. There is a
column called Applied Calls. This Column should always equal the total Call
Count is there a way where I can create a code that would say something like
i ...
|
Modifying text boxes in a report?
Tue, 2 Dec 2008 15:15:03 -0800
Hello,
I'm editing a report that was created by someone else. The report has about
100 different text boxes. An example of the code in a text box is:
=DCount("[ms_id]","Patient_Status","[gender]=1 and [site]=1 and [refuse]=2")
So there are a bunch of columns (i.e. when site = 2, 3, 4, or 5) and 16 rows ...
|
Averaging in a Report
Tue, 02 Dec 2008 21:07:12 GMT
I have a report created that lists one agent's data per page. Each agent
sees their data (calls, time, etc.) plus they also see their team's average.
If an agent has all 0's in their data fields (they were on vacation during
the timeframe of the report) is there a way for Access to not include those
zeros in th ...
|
Manual report detail usage?
Tue, 2 Dec 2008 12:59:01 -0800
In Access 2003, I need to manually spin through a table and populate
individual detail lines of a report using VBA. This is in lieu of writing a
query to make this happen (long story). So if I have 5 qualifying records in
a table, I generate 5 detail lines in the report.
Can someone please point me in the r ...
|
metconv.log
Tue, 2 Dec 2008 12:01:02 -0800
When I open a report in my Access-application, I get the message:'An error
has occured in MetConv.txt file! Please view the MetConv.log file for more
information.' The second, third,... time I open this report, there are no
more messages like before. What is the meaning of this Error-message? Wat is
the sol ...
|
ForeColor Question For Report
Tue, 2 Dec 2008 10:32:03 -0800
Hello,
I have a report that i need to be able to print blank. I have used the
following to open the report to preview and this works, it has all the fields
white so there is no data showing..the only problem is I have some check
boxes that the controls are based on IIF statements. This causes them to
show ...
|
Graphics
Tue, 2 Dec 2008 09:41:00 -0800
I am trying to use the export feature in Access to send a quote as
attachment. The attachment needs to be RTF. So how can I get my logo in the
Quote as RTF doesnt support graphics? There must be a workaround on this...or
at least I hope. ...
|
|
|
distortion chart when print
Tue, 2 Dec 2008 09:34:16 -0800 (PST)
I have a report with charts.
It happens the charts distortion sometimes.
The charts are OK on the screen.
The distortion charts happens once a month.
Are there any issue possible that I can look in to for the distortion
charts on printer?
Your information is great appreciated, ...
|
Lebans RTF2 report print - error message "property is read-only"
Tue, 2 Dec 2008 08:11:40 -0800 (PST)
Hi, I am coming back to the "old good" problem with RTF2 control on ms
access report. I use A2k3 on Vista Ultimate. In my report I have an
unbound RTF2 control and I use Detail_Format event handler to fill the
control with a rtf text. Texts are stored in an array in memory. The
handler is called many times depen ...
|
Microsoft MVP Donald Belcham to Speak on Visual Studio, C# vNext,
Aspect Oriented Programming, Live Mesh
Mon, 1 Dec 2008 21:12:07 -0800 (PST)
Microsoft MVP Donald Belcham to Speak on Visual Studio, C# vNext,
Aspect Oriented Programming, Live Mesh
Bangalore, December 1, 2008: When writing Microsoft technology-related
applications to have strong separations of concerns you inevitably run
across some items that, while appearing as separate concerns, do ...
|
