Search results

I am a novice as far as Crosstab queries are concerned, but if I understand the suggestion properly, it doesn't work. The 'From-To' field is a field calculated in the query, from two fields [From and To] and is the only 'Value' field in the query. If I change 'From-To' to a Row Heading, I get an...

I have a membership database which contains [amongst other things, and in a variety of tables], members names, offices held, and the 'from' & 'to' years for each office held. I set up a crosstab query to enable me to produce a tabular report showing all the offices each member had held and when...

As I said in my original submission, I have gone through File/Page Setup and then immediately saved the report, but it still reverts back to 'Letter'. It doesn't matter whether I choose the default printer or another printer, whether I immediately save the report object or close it and click on...

I am using Access 2003, running under Windows XP SP3. I do not know whether this is an Access problem or not, but cannot find any suggestions anywhere for a solution. A user modified a report and has problems with the new version. In trying to resolve these, I set up a db with both the original...

Bob is quite right about posting solutions for future users; I just came onto the site with the same question and got the answer p.d.q.!

SOS - thanks for the '+' and '&' explanation; I've now used your example and it works perfectly. I can now copy that into all my various databases that produce envelopes. This will be easy to do as I use the same object definitions to ease copying of 'good things' from one Db to another. Its a...

Before resonding to the specific points raised, I should say that the various databases were converted from Access 97 only a few weeks ago, and I can't recall having these problems when I used Access 97. None of my 'envelope reports' were defined to have the same dimensions as the envelope...

Thanks for the suggestion. This is a much neater way of removing blank lines from addresses than the method I was using, and I will use your code from now on. However, this does not solve the problem of the second page/envelope being vertically displaced.

I use Access 2003 running under Windows XP SP3. I have a number of databases which I use [amongst other things] to produce envelopes and/or labels. I use several different sizes of envelope, but use the same method for all envelopes and all databases: I create a report, with dimensions...

Another MS improvement! I surrender and will have to find some other way around the problem.

Hi James, Thanks for that info, but I'm not sure that is the problem. As I said in my original posting, the normally multi-user database prevents changes even when there is only one user active. millwheal

I have an Access 2003 database residing on a server and used by multiple users. The only security is that a password is required to open the file. It is common practice for some of the users to create one-off reports, etc. to meet ad hoc information requirements. Until recently, the database...

Bob, Many thanks, I can now do exactly what I wanted. millwheal

John, I have already done that [as a 'default'], and I realise I could do it manually once the spreadsheet is created. However, I was hoping to do it automatically as I want to email the spreadsheet to someone else and was hoping to do the whole export/email as part of one, automated procedure...

John, Thanks for the suggestion, but that Option is already set to 'Verdana', yet the spreadsheet still ends up as 'MS Sans Serif'. millwheal

I am using VBA [TransferSpreadSheet] to export a table from an Access 2003 database to Excel 2003. I have no problems at all with the data, but the resulting spreadsheet has the 'MS Sans Serif' font, whereas the defualt font in Excel is 'Verdana'. I can find no settings in Access or Excel which...

Paul, Brilliant! MoveSize is just what I needed. Many thanks for your prompt assistance. millwheal

Paul, Thank you very much for the tip; the 'zoom' worked first time. I simply wasn't aware of it and couldn't find anything about achieving what I wanted in 'Help'. With the report now at the size I wanted, I tried to find a way of increasing the size of the window to accommodate it. I...

I have a couple of applications which, on loading the database, automatically run a report in 'preview' mode. Without me having set any parameters, in Access 97, the window size is set to 100%, which means that I can read the report easily. Having now converted the databases to Access 2003, the...

Thanks HiTechCoach for the advice. I'll live with the minor inconvenience of the 'message box' ... until my distribution list gets up towards it's final expected total of 2,000+, at which point I'll have to try increasing the batch size. millwheal