Search results for query: *

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...

I'm fairly confident with the sp yes. The problem may lie in the fact that it involves linked servers, and command shells on the linked server. I think I may split the proc into smaller chunks to ascertain if a certain part is hanging.

When calling a stored procedure that takes some time to run from within an Access module, I get the following error (by cycling through the DBEngine.Errors collection): "7312 (01000: [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Timeout expired])&quot...

It turns out that all I needed to do was add "> NUL:" to the end of the command being executed. It only works with a slight variation of the command line, but the final working piece of code is as follows. DECLARE @cmd VARCHAR(1000) SET @cmd = '\\PathOfComFile\rtfconv.com -crtf...

I have tried creating a batch file and I get the same error. I have also tried executing the command directly on the server, and it works fine there. How would I check what username it is using? How would I change it? Thanks for your comments. Richard.

I am trying to run a simple DOS command using xp_cmdshell, which works every time when typed directly into a command prompt. The command is designed to convert an RTF file to text and is along the lines of: rtfconv -crtf -ciso-1 notes.rtf txt I get the error "Cannot redirect" and...