Search results

when you say i'm assuming that 'information' is stored in a table somewhere. If so, your report would simply use that data source. You can use the report wizard to create a report from a data source.

is there any element of consistency, such as are there always brackets around the product codes and is one always before and after the | ? if that is the case you can use a mixture of Mid() and Instr() functions to produce what you are looking for. For the data you provided, this would return...

I actually got it working on the last page by cheating a little - I already have the page # of total pages displayed, so i added in the code the following at the end of your GetPageFooterDetails function: If Report.Page = Report.Pages Then mstrTo = ctl.Value End If This way it is forced...

That was clever! Now we just have to figure out what to do on the last page. Once we're dealing with the last page, maybe i can just do a lookup for the last value in the recordset. Thanks!

Do you want to FTP it to another location, or just put it into a specific directory for the member to pick it up from? Check out this thread http://www.access-programmers.co.uk/forums/showthread.php?t=124020 for my post on looping through a recordset and creating PDF reports. As far as moving...

I have a library database which generates a report of all available books. Is there any way, in the page footer of the report, to display the first and last book listed on the page (much like a dictionary)? Whenever I reference a textbox from the detail section it always returns the value of the...

Which date is being entered into the date field?

It's actually really easy to do what you are asking. I will try to explain it concisely here, but if you don't understand it, PM me and I will go more into detail. I used to use Adobe Acrobat to accomplish this, but that got to be cost prohibitive considering that every one of my users needed...

When you say , do you mean when it is in an open state, or do you mean when it is initially opened up? Once a report is open and formatted there is no way to make this change. The only way would be in the OnFormat event, which is executed initially. If what you meant was initially, then you can...

Check out the employees table/form in the Northwind database. That should help you out.

Another idea - albeit slightly convoluted - I would create an order detail section with a composite primary key of OrderNumber (assuming you have a master order table) and detail item (whatever the item being ordered is - this is less relevant for our puporse right now). if you also have...

Can I assume you are going to be using Microsoft Outlook? If so, you can use VBA to use the Outlook Object to create an email. If you are here is a snippet of the coding: (Make sure you add a reference in Access to the Microsoft Outlook Object Library for this to work) Dim strHtml 'a...

Glad it worked out!

Would you be able to be a little more specific on the primary keys and foreign keys of your tables so i could get a better picture of you data? Thanks