Recent content by rob b

Alex Thanks for your help it worked great. Rob b

Is it possible to change just the year in a table of dates. The year in the date field varies and I want to change them all to say 2002 without changing the day and month. Ive tried picking certain years and then using dateadd to get the year I want but there has to be a quicker way doesn't...

I need to update records in a table from an identical table from a laptop. How can I append some records to the table (if there are any) and update records which have changed slightly, ie the completed field becomes true. Thanks for any help

That just gives me 19 January 1999 I need it to say Monday 19/1/99

How can I get a report to display the day of the week and the date ie. Monday 25 Jan etc. Thanks in advance for any help.

Sorry Ive managed to work it out.. If strPasswd = passtring Or strPasswd =passtring2 Or strPasswd =passtring3 Then docmd etc etc.

I'm having trouble with the following code If strPasswd = passtring Or passtring2 Or passtring3 Then docmd etc etc. I keep getting a type mismatch message even though all the variables are defined as string. Thanks for any help.

Why not try:- If Fac_tab = "BADGER" Then DoCmd.OpenTable "BADGER_FAC", acViewNormal, acEdit end if If Fac_tab = "BB&W" Then DoCmd.OpenTable "BBW_FAC", acViewNormal, acEdit End If

I need to print one report and send it to three different people, each copy requires a different heading. I could make three reports but I want to ensure that they will always get the same info. Any one help?

BOROLEE Thanks for the advice it works great, however if I decide not to send the e.mail at the last minute and close the application an error message comes up about incorrectly closing down the dialog box.

Ive been trying for weeks to sus this out if you could help and e.mail me this it would be well earned rest for my brain. Many thanks

When in report preview you can "send" a copy by e.mail. Is there a way that this can be automated so that you could click a button in a form and it will send without previewing the report?

If you have a combo box which shows two fields it usually works when you click into the box, both fields will be shown, but when it hasn't got focus only the first field is shown. Is there a way of showing both fields all the time?

How do I highlight records on a form if they meet a certain criterea, ie. all records with a date over a year old. I would like to show them in red or bold for example in amoungst the other records..

Hello richie Thanks for the info on printing odds or even pages. Ive tried your code but I can't get it to work I must be missing something. I guess that the combo box is called "printedpages" yes? The message boxes appear correctly but the report still prints out all pages. If I am doing...