Search results for query: *

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.

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

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

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

I have lots of RTF strings in a table, and I would like to manipulate just the text that is contained in the string. Does anybody know of a way of extracting the text without all the control characters that sit around it? Saving it as a text file and opening in Word is not sufficient, I need...

I am finding a cross-product (Cartesian) query I have designed very slow to run. The only join I can impose on the two tables is that values lie within a range of other values. The other problem is one table has over a million records and the other in order of hundreds of thousands. Any tips...

I have stored a number of field names in a recordset which I want to use to retrieve the data from a different recordset. An excerpt from the code is as follows: Response.Write(&quot;<td>&quot; & rsRenewals(rsFieldNames(&quot;FieldName&quot;)) & &quot;</td>&quot;) Which returns the error of...

I am having problems when creating DTS packages to copy data from SQL into Excel (in order to mail spreadsheets to users). The problem I have is in creating the tables in Excel. I use an &quot;Execute SQL Task&quot; to Drop and Create the necessary table(s) in my spreadsheet. The problem...