Search results

Yes, I see. There won't be a lot of users, perhaps 5 or 6 at most. Thank you very much for your help.

Thanks Bob, actually I have set up multiple front ends and a single back end, however, my client's network guy is having everyone access the front ends from their server using Window's Remote Desktop Connection. Each front end has it's own name. Users come from different geographical locations...

I am new to Access and would like to know the best way to set up queries for a database that uses 20 - 30 reports. Will it run better with a query built for each report or should I re-use queries for more than one report if possible? I am concerned that if two separate reports are run using the...

I'll have to look into subscribing, that article does sound very interesting. On the other hand, I'm sure I could put together some Excel macro routines to fix the small problems with each report, however it would take a little time to do this and could get messy if the wrong report was pasted...

I am trying to prepare the reports for exporting into Excel but I find that this functionality been omitted from Access 2007 and probably for a good reason. Using older Access versions I can export data into Excel but it involves a lot of work for the operator. This is because exporting...

That does provide a good replication of the report, and I assume without the need for MS Office, but I am really looking for a way to send this in a way that it can be integrated into another database or spreadsheet. Any other ideas?

I have a client who needs to do more than E-mail an rtf copy of his Access reports to his clients. I Understand that a lot depends on what the client receiving the report has to work with, but generally speaking, what are some common and/or best approaches to the data transfer of reports using...

Right! I understand now. I aim to steer away from as much pain and suffering in my growth as possible. Thanks much gentlemen!

I should have mentioned it, but both databases are split into a front end (all objects except for tables) and a back end (tables). Thanks for the help and the website, that's a great site!

As a novice Access developer I've created a few small databases but I haven't been successful enabling the databases I have created to be used by more than one user at the same time. Here are a few details to share: - the "Default Open Mode" for all the users is "Shared", "Default Record...

How do I modify my vba code (below) to E-mail the report record I am viewing on my Form? Here is my code: Private Sub cmdMailAdvOfSttlmnt_Click() On Error GoTo Err_cmdMailAdvOfSttlmnt_Click Dim stDocName As String stDocName = "rptAdvOfSttlmnt" DoCmd.SendObject acReport, stDocName...

Thanks missinglinq, but that is me.

My client wants to have a single input form to input data into several different tables. All of this feeds reports that combine the data entered from the single form in different ways. I need to be able to see all the data on this form, search any field using the Find/Replace button, use a...

Thank you very much, that was extremely helpful.

How can I get the code below for my print button on my form to only print a report's current record (the one displayed on the form)? Here is the code for the print button: Private Sub cmdPrintAgencyAwkReport_Click() On Error GoTo Err_cmdPrintAgencyAwkReport_Click Dim stDocName As String...

Thanks Bob, that is a big help!

How is that done?

How do I add a text field to a report whose Field List does not include this field?