Search results for query: *

Thank you JB, I have it working now, but it was by luck and I still don't understand how it works. I made a local admin acount, disconnected the PC from the network and got the schelduler running. However the task I am trying to run deletes files from a remote web server, so I then...

Hi, I cannot get the task schelduler to start in XP. The help file suggests that since the computer is connected to a Domain the system administrators have turned off the Scheduled Tasks Service. I have admin rights on my local P.C., is there any way I can start this manually? Cheers Mark

Thank you, I did manage to find it in the end. Cheers Mark

Hi, I am using SQL server 2005 for the first time. I am having trouble trying to change the connection properties in a database from Windows Authenticaton to Mixed. I can see it everywhere, but can't seem to find where to change it. Cheers Mark

Thank you for replying, I am still getting the error though. I use the replace statement in SQL server and it works , so this may be something to do with ORACLE. I am going to ask for permission to create temporary table directly on the ORACLE database, so this will eventually solve the...

Hi, I am attempting to check first name and surname details from an Access table (from a recordset) against names held in an ORACLE database and am having trouble when the surname contains an apostrophe. The code I am using is: SELECT * FROM CLIENT (ODBC table) WHERE FIRST_NAME = '" &...

Thank you for this excellent idea!! I have it working in SQL-Server and it will work in Access as well. I never thought of creating a temporary table, I will remember this idea from now on. Many Thanks Cheers Mark

Thank you for responding, sorry I have not stated this problem too clearly. I need to use cursors as this procedure updates values in a model. The first cursor lists the team names, the first inner cursor the driver names and the second inner cursor updates the values (per team per driver)...

Hi, I am after the correct syntax for using an outer cursor value in an inner cursor select statement. My outside cursor looks something like: declare outerloop cursor for select fieldname from table1 declare @FNAME as varchar(50) open outloop fetch next from outerloop into @FNAME My problem...

Thank you all for replying. I did this work yesterday and ended up using RIGHT(('00000' & fieldname),7) I did have a hard time though, mainly my fault through storing the number values as currency. The actually give three decimal places, but shows two on reports, queries, etc. So $2.48 was...

Hi, Is anyone aware of an Access equivilent of an ORACLE function called RPAD? I need to pad a field with preceding zero to a static number of digits. I can always do this using if or case, but thought there may be a function already that I am not aware of and cannot find in help. Cheers Mark

Hi, I am a first time user of Linux with a very old/slow computer. I tried to install Red Hat 8 and got into some trouble. The installation took several hours, and one of the last prompts was screen resolution which I left at the default of 1024x768. Unfortunately my monitor cannot handle...

Hi Paul, I changed the options as you suggested and I have had no problems since then. Thank you - your advice was much appreciated. Cheers Mark

Yes, it doesn't seem to matter if I set it in design mode, preview mode or both, it will end up defaulting back to portrait at some stage.

I am having trouble with the page setup in ACCESS 2000. I set a report to be landscape and this may work for the first one or two openings of the report and then the next time I open it it reverts back to portrait. Is there anyway to hard code a report to open in landscape? Cheers Mark Svensson

I just aked the same question.... If you use LOAD DATA INFILE "test.txt" INTO TABLE test; without the LOCAL bit, it seems to work O.K. Cheers Mark

Thank you!! Without using LOCAL in the command, the tables loaded successfully. If anyone is interested, I am looking for an alternative to MSACCESS for our users here, as the two gigabyte limit is very restricting as we use large tables. On the same PC, using the same tables, (with the same...

Thank you for replying.. I had already downloaded the manual, but that hasn't help me. I tried entering --local-infile[=1] into the command line, but to no avail. I also made this part of the LOAD statement, but ended up with syntax errors. I also tried mysqlimport, but got the same security...

Hi, I have just loaded MySQL onto a Windows NT box and I cannot get the load command to work, I keep getting 1148 The used command is not allowed with this mySQL version. I have tried --local-infile[=1] This did not return errors, but also did not work. Does anyone know if there is something...

I am having trouble with the page setup for reports. I set the margins and the orentation to landscape and this all works until I "Compact and Repair" the database. As soon as the database comes back, all the reports then have the default page setup and I have to reset every report...