Recent content by dcorey

For what it's worth, here's how I've done this: Create a dummy form. For the Open event, insert the code that will make everything happen. At the very end of the event, put the command: Application.Quit (This is using VBA; I'm sure there's an equivalent for macros.) That exits the database...

We're small, so we don't have a server or anything. The website is just through a hosting service.

Hi, everyone. My company would like to set up a website where clients could look up the results of lab tests we do for them. I have a working prototype written in ASP and using a "mini" version of our in-house database. My question is, what is the best way to update it? I want to continue...

Hi! I'm trying to make a report that compares the results of the tests of several samples in a lab. I have a form where the users enter the samples they want compared (up to, say, 10 total), and the report prints from there. Now, the only way I could think of to get the data I need from the...

You can put all your fields in the Detail section, and set their Can Shrink properties to Yes. That way, if the field is null, it will disappear. However, if the value is actually 0, that won't work. At any rate, the Detail section will repeat for all records. Hope that helps! dcorey

Thanks for the reply, Rich! I should have been a little more specific: The report lists outstanding invoices for a company, and calculates and displays how many days old each invoice is. So I do use the Sum function for a grand total (which works fine), but I also want to add up amounts...

Hi, everyone. So, nobody responded to my last question... but I'm not hurt. :-) How about this one: I want to sum the fields in the detail section of a report. What's the most eloquent way to get around the fact that Access' On Format event occurs twice? The help section says the On Retreat...

I have a report that takes the name of a company, and a subreport lists all of the outstanding invoices for the company. It also calculates and displays how many days old each invoice is. I would like the report to determine what invoices are current, one month old, two months old, and more...

Thanks, Rich! ...But how do I use Visual Basic to run a SendKeys statement when {esc} is pressed?

Is it possible to reassign keys to perform different actions? Specifically, I would like to change {esc} to act like {shift-tab} (reason being my users are used to an old DOS-based database, and they hit {esc} out of habit). Thanks!

Hi! I would like to build a report with different sections. The report will show information for just one record, and the different sections would be visible only under certain conditions. Each section wouldn't contain only controls -- it would be like its own report, with text, etc...

I have a form in which various tests to be performed on a sample are checked (some are simple check boxes, some are option groups). I am creating a report (which will be a sort of worksheet) which will show for the record only those tests that were checked in the form -- i.e. only those tests...