Search results

Is there a way to only display the message once the mail merge has completed though? Or should I just display it and hope they don't flick back to the access window and see the message before they've finished the mail merge?

I've got a temporary table which I'm using as the source for a mail merge. I need to either delete the table when it is no longer being used for the mail merge or be able to test to see if it is being used at that moment. Can anyone point me in the right direction?

I've tried that but unfortunately it didn't make any difference. I've now got a workaround, albeit not a very satisfactory one. I've gone with ODBC but as I couldn't get ODBC to work with a query (is that a limitation of ODBC?), I'm now generating a temporary table to use as the record source...

I've got a mail merge document set up, but whenever I open it, it calls a new instance of my database. I know this is a common problem when you set a different database title, but I haven't done that. I still have that blank and the title showing in the title bar of my database is 'Microsoft...

Just to let you know, Neileg your method did work. Thanks. I would be interested to know of any other methods though.

Thanks Mile-o-phile. Yet again, you've really helped me out. The problem I've got now, is that I want to use the pop up calender on a sub form I have on my main form as well, however, because of the way subforms are referenced, the code doesn't work. Is there an easy fix to this, or would I be...

I have a form set up with various date fields and I have set up a form with a calender to fill one of the date fields on my main form. I am opening the calender form by doube clicking on the text box. I am using a command button on my calender form with Forms![Rec_Customer]![Date1] =...

The main table (Cust_Rec) has Cust_ID as an autonumber primary key and the Visits table (Visit_Rec) has Cust_ID (linking records to Cust_Rec) and Visit_ID which is another autonumber field. So for one customer, the visits table might look something like Cust_ID Visit_ID Visit_Date 1...

I have a form with a date field called Date_Entered. This fills in automatically with the date the record was created. I've also got a sub form for Visits made which links to the main form by a customer ID. The table behind this has Customer_ID and Visit_Date as fields. Each time a visit is...

Thanks, but I have sorted it now. I have XP at home so I fixed it last night.

I think your brackets are wrong. Try DateSerial(Year(Date()),1,10) instead of DateSerial(Year(Date(),1,10)

Is anyone out there using Access 2000, and, if so, would they mind converting an Access 2000 database to Access 97 for me?

I still don't seem to be able to reproduce this. Can you post an empty copy of your database and I'll take a look?

Never done it before, but I would guess it's a case of going File, Get External Data and importing the tables from the BE database instead of having linking them. Stephen

I've just tried that but I don't seem to have that problem. Where have you put that code? Is it on your startup form?

What is the code you are using to disable the menus?

I think it may be DoCmd.SetWarnings False that you are looking for. Stephen

Thanks. That'll do nicely.

Does anyone know if it is possible to set a database up to use April to March as the year instead of January to December. It's not a major problem as far as working with the dates, but I also want to use week numbers on a report, and I'd like week 1 to be in April. I have thought that I could...

That might be the only way of doing it. I just settled for only showing the second column in my combo box.