Recent content by owenh

I think I've done everything right now, but I am once again plagued by parameter questions. Every time I try to preview the report, I am asked for an "Invoices" parameter. It makes no difference what I type in, I always get the Invoices table data and no InvoiceLoads (subreport) data. Also, I...

I'm back finally...had to design another (simple :rolleyes: ) database. The form I've created with a wizard that works great uses all the fields from the Invoices and InvoiceLoads tables, not the Customers table. The Invoices table has a field (CustomerID) that is related to the Customers...

edonahue, I have had the same problem. I concatenated a "Name" field with a "Website" field in a query, ending up with Joe Smith#http://www.joesmith.com/joe/# However, when the "Website" field was empty, the query returned Joe Smith## Only when this happened did the exported HTML files...

Each invoice needs information from three tables: Customers, Invoices, and InvoiceLoads. When I create the form, I use the wizard and all of the fields from the Invoices table and the InvoiceLoads table. When I create a report using a wizard and the same fields, I do not get a subreport, just...

I am designing a database for invoicing. I have designed three tables: Customers, Invoices, and InvoiceLoads. They are related so that one-to-many from left to right (many loads per invoice, many invoices per customer). The tables are working together splendidly. Then I created a form (two...

Hyperlinks in Reports I have been wondering the same thing, except that I have created a simple directory with email addresses and websites as well as a person's name in each record. I have created a macro to export the report to HTML. I would like to be able to click on the email address and...