Search results for query: *

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

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

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 = '" &...

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

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

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

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

How can I deliver an access 2000 database (application, queries and tables) to users in a format that shows them the application windows only? If I build an MDE with bypass disallowed, I can still open with the shift key down, keep it down long enough to change start-up options, then exit and...

Hi, I am creating dynamic graphs (charttypelinemarker) using OWC and I have managed to put data labels against the points by using: objSeries.DataLabelsCollection.Add Now in Excel there is a function that shows the data table beneath the graphs, you just click "show data table." I...

Hi, I have created a recordset which when put in a simple table returns values as such: Year Code Value 1999 A 100 1999 B 25 1999 C 27 2000 A 85 2000 B 115 2000 C 45 Is there some way to manipulate the output to?: Code 1999 2000 A 100...