Recent content by thiazi

worked great thanks!

Hi there, sorry.. it's displayed as 00:10:00 and the field is set to hh:nn:ss format.

Is there a way to have conditional formatting look at time values, such as in hh:nn:ss format? I have a field that produces a value of 10 minutes, and I want to set a conditional format to say anything over 10 minutes needs to have the text changed, background color changed, etc. However...

Hmm, in further searching, I came up with the <!---Report Body---!> tags (or something simliar, however they're coded. Is that all you can do, specify where the header, body, and footer go? I was under the impression you could specify exactly where each field from the report would land on an...

I'm a bit confused on the HTML template option of emailing an Access report. I'm familiar with HTML code, but I can't seem to find how to incorporate the Access fields in an HTML layout. If I layout a table in HTML code, is there a resource somewhere that describes the tags necessary to carry...

LOL.. best "use at your own risk" I've ever seen. Thanks Paul, I'll give it a shot! :)

For template and appearance purposes, HTML is essential to one report I'm using. Do you remember where you saw it, per chance? I've tried various google searches relating to the matter (prior to making this post), and have come up empty handed.

I'm using the DoCmd.SendObject acSendReport command to send reports formatted in acFormatHTML. I'm finding that if the report exceeds one page, Access will break the report up into seperate files (one file for each page). So if the report is three pages, it will send report1.html, report2.html...

I have a form that I'm using DoCmd.OpenReport now that takes arguments from the textboxes/comboboxes and produces a report. The code I'm using for that button is as follows: Private Sub btnReportOpen_Click() Dim strWhere As String Dim cData As Date strWhere = " EmployeeID = " +...

Nevermind - it helps to have error handling! :)

Well that was super easy.. thank you!! When I exited the message and clicked on Cancel, I got a SendObject failed message from Access. Is this normal?

Got it working! Thank you both!

I have several forms working that currently generate working reports. I'm generating the report through DoCmd.OpenReport function, then my report name, then acViewPreview. What sort of code would I need to put in a command button so when it is clicked on the form itself, the report is...

Thank you for your detailed response. Could you point me in the right direction for such a function? I'm a bit new to Access. Not sure if this matters, but I'm importing this information from a flat file and it's coming in on the import in hh:mm:ss.

Is it because I'm calling this as a string? It seems to work with just one field only - any other fields give #Error, and the formatting for the fields in the table layout is the same.