Search results for query: *

sorry, never cracked it. I think there is now a printer property that you can get to fairly easily in office 2002 - or was it windows XP?? - either way, it didn't help me. (selfish brain I know - it only remembers what's important to me)

Mind if i jump onto this thread? I have tried the above (and all manor of variations) but keep getting the error that the macro cannot be found. I have tried placing the macro in the personal workbook, in workbook that I actually want it to work on (which is loaded) and always no response. Any...

cheers Jo and Gol4 Jo: - you're quite sneaky aren't you. Gol4: - You've guessed the way I'm doing it at the moment, but unfortunately, the contents of text0 etc.. are quite longwinded (comstructing full names from first name, middle names, surname and title, with the resultant NZ()'s etc) I...

Any ideas how to do this one? I have a combo box and I would like the row source to change dependant on what page of a tab control a user is looking at - so if the user is looking at page 1, the rowsource is taken from the contents of text boxes on page 1, if looking at page 2, the contents...

This sounds so simple I'm certain I'm missing something. Is there something along the lines of { NumRec } that would give the total number of records in the datasource for a mailmerge. For background what I'm trying to do is to control the mail merge. I'm using the NEXT mergefield to show...

Sorry, should've given more info... What I'm trying to do is to control the mail merge. I'm using the NEXT mergefield to show more than one record on a page, but I want to do a NEXTIF and only move onto the next record if the last record hasn't already been reached. As it is, I am just...

I can't believe I can't work this one out (feeling it's very obvious) Is there a way to tell how many records there are in your data source in a mail merge? I want the equivalent of a { NumRec } field! any help would be much appreciated.

anasazii, just for info, (i assume it's a long dead question but...) I had exactly the same error coming up, it was me altering the database in some way which meant I had the database opened exclusively. It took me ages to work out that even just clicking save on the toolbar converted the...

Cheers Ben - seems to work a treat. Figured it was something simple (unfortunately what I do know is self taught, and so fundamental stuff is not my strong point...)

Thanks Ben, that solved the instant problem. I'd still like a general way of getting round this though. I think the simplest way to explain it, is that I'm after the equivalent of: Docmd.RunSQL(SQLString) But instead of running SQL code contained in a string, I'm looking for a way of...

Thanks PGK, The code I'm trying to execute is just VBA. The current situation is that a control has the focus, but which control will be different each time. I move the focus elsewhere, then I want to move it back to the original control. Hence the example string is...

I think this is pretty basic stuff, but that's probably why I can't work it out... Can you have a string and execute that as if it was a line of code, e.g. CodeStr = "Forms![Form1]![Control1].setfocus" and then a command or something along the lines of RunCode(CodeStr) I'm on...

I think I posted the above when all of you clever Americans were on Labour day - so I thought I'd be cheeky and post this on the bottom to bring it to people's attention.

I think I posted the above when all of you clever Americans were on Labour day - so I thought I'd be cheeky and post this on the bottom to bring it to people's attention.

Cheers PGK - Will do, though it may take some time, my knowledge of API is nil, but at least it's a start...

Ahhh, Nope, didn't work. I tried referencing any object libraries that looked vaguely likely to contain the Printer object, but I kept getting the above error message. (Oh - just done some searching on general web and I think that a downfall of Access VBA is that it doesn't include the...

Thanks PGK I'm getting a "User-defined type not defined" error. I'm hoping that this is just that I haven't got a specific object library referenced - any ideas which one covers the Printer Object? (I'm assuming that once I have the library referenced, I can try your hint from Word...

I think I posted the above when any clever americans would have been asleep, so hopefully by adding this to the bottom, it might bring it to the attention of someone who can help me (worth a try...) Thanks everyone

Can anyone help with details on how to change the printer properties using VBA code? For background, I am using Access to load and run Word and then run mailmerges in word using info from Access. For each merged document, I need to print one copy on headed paper, one copy on plain. This was...

I have developed a very annoying problem... For background, I am using Access to load and run Word and then run mailmerges in Word using info from Access. For each merged document, I need to print one copy on headed paper, one copy on plain. I had originally recorded a macro to print both...