Recent content by RichardHayes

Thank you for your help, I am using Project 2003 standard edition, standalone. I have created the calendars as you suggest, but I'm not sure I'm mapping to the right field when I import the data. I am mapping to "Task Calandar", but when I import, I get the following error for every record ...

I am trying to import data into Project, and I want a subset of the data (denoted by a flag) to only be scheduled for Mondays. Everything else should be scheduled for Tuesdays through Fridays.

If you use vbYesNo as buttons for a message box, the box will be in French yes. I haven't encountered any other problems to date!

Hey I've fixed it!! I just deleted the word database, so it now reads : DoCmd.TransferDatabase acLink, "ODBC", "ODBC;DSN=ReportRepositoryDC02;DATABASE=" & sDB, acServerView, sSourceTable, sTable ...and works in English and French. Thanks for your help.

The ODBC bit is in quotes, so Access doesn't offer any options, but this is the same as in English. I've looked in the French help files, and it offers an example that is almost identical to mine bar the DSN and database name, using ODBC. It still gives the same error though.

You should be able to use the command : Forms("FormName").ControlName.ProcedureName (Parameters) Make sure the procedure isn't private to the form (change Private Sub to Public Sub).

Thanks for your help cheerio. It's in a function that attachs a SQL server table, based on parameters. The command is as follows. DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=ReportRepositoryDC02;DATABASE=" & sDB, acServerView, sSourceTable, sTable

As I say, it works fine with in English, so ODBC is definitely installed. It's only when I change the windows language in the control panel to French that I get this error.

I am using docmd.transfer database, and it works fine. However when I release the application in a French environment, I get the following error : Erreur d'execution 2507 Le type de base de donnees ODBC database n'est pas installe ou ne gere pas l'operation selectionnee ...which I believe...

I have a form with three subforms. The second two subforms are linked to the selected value in the first subform using Master and Child fields. This is done by extracting the current value to hidden text field on the main form. It works fine when I only have one subform, but as soon as I add...

I am supporting a remote SQL server based application which I can only interrogate over the phone via Access and ODBC, with users with no knowledge of SQL. I mention this so that you know that I am unable to look at anything that cannot be easily executed via the VBA immediate window. In part...

I am running SQL Server 2000 Personal Edition. I have a job running using SQL Server Agent, but when I right-click jobs and select refresh, it doesn't tell me that the job is running. It only works once the job has completely finished. I know that the job is running by doing an sp_who in...

Please post your code as it is not possible to answer this query without seeing what you are trying to do.

I don't think that Enterprise Manager is really designed for displaying/editing table data. If you use Query Analyzer, or even attach the table to an Access database via a DSN, you will have more luck with tailoring the layout of your output.

It was indeed the linked server causing the problem. When I ran the local stored proc (that call's the remote stored proc), it timed out, returning the following error. OLE DB provider 'STREAM' reported an error. [OLE/DB provider returned message: Timeout expired] I have fixed it by...