Search results

Is it possible to create a replica of a main database with only a few parts, so that it acts as an input form? if not is it possible to hide the views on the replica including the other forms and reports?

This will only work if you have all the information at the same time, however it will not append data on a piecemeal basis, it simply creates a new record. Any ideas anyone?

Good idea, however the data will come back at differing times. The 3 forms I'm using are surveys on salespeople and their customers. So a telephone survey is to be outsourced to one company, a mystery shop survey by another and a cusotmer follow up survey by another. It would be fine to append...

You need to look at dialling up the remote computer so you can access the files you want to replicate, then it is straight forward, but it is some years since I did this so you need to look up about connecting two remote computers on the net.

Thought so, you can create a partial replication but this is just a filter, you can't take out any tables etc form a replica. Therefoer, this is not the route unfortunately as the replication would have been ideal. There is some commercial value in the database so I cannot afford to let the...

I have used synchronising replicas before but that is for direct copies of the main database which I don't want to release to third parties which is why I came up with the 3 individual input forms to collate information. Unless it is possible to create a replica with minimal information - I can...

Note: I put this in General original but it is rmore likely to be a table structure problem I have a single table for storing the main data, this is fed by input from 3 forms. I have been asked if the forms can be used independantly and remotely as input forms. My solution was to simply send...

Highlight the field that you want to filter by (for example 10) and then simply click on the filter by selection button on the toolbar.

I have a single table for storing the main data, this is fed by input from 3 forms. I have been asked if the forms can be used independantly and remotely as input forms. My solution was to simply send out a database with just one form and created an append query so that when it is returned with...

Simply because you can't scroll through a report or change the data in real time to see the changes. you have to run the report each time. However, I do agree that it is also a pain when it comes to printing out nearly as much as using MSGraph!

Thanks I've done all that. I have decided to split the form in the end which gets me going, not ideal but I think it is just a limitation of MS Graph and we may never get to the bottom of it. Thanks for all your help, it is appreciated.

The charts are taken from queries. I have experimented in reducing all the boxes/controls etc on the form so that I can see them all on screen and it prints fine, the problem is that it is so small

Does anyone have any ideas how I can get round this problem?

Aha, I think I have found it but it doesn't get me round the problem. If I change the print paper size to A3 everything is displayed, problem is I want to print out to A4... in excel you simply set your print area and it print over as many pages you want but can this be done in Access.

Layout for printing is set OK, there is nothing on OnPrint /Curent and the graphs are made using Microsoft Graph which is always a pain to use I know. Print preview doesn't disply the bars in the boxes either.

I tried acrobat as well as a number of printers and still no go. Messing around with the form I found that if I moved any of the graphs down so they were off screen I had the same problem. So it appears to be that anything which is not visible on screen doesn't print off for some reason. It...

I have 9 graphs on a form that all work fine and appear on screen but when I print off the last 3 graphs only show the outline. Please see the screenshot and PDF file attahced to see what I mean. Any ideas?

Aha! all sorted and it works fine, many thanks for your help it is greatly appreciated.

I see the horizontal scrolling bar in design view but it doesn't display the summary in normal view, it also doesn't appear in the footer in the print out (which I thought it would).

Thank you it did, for other viewers this same thread was posted on the query section.