Recent content by jonnyk

I need to add a column to a sql statement that will give me a running total by group sql is selct item, week, sum(qty) group by item, week The column will need to add qty as a running total for each item for each week Any ideas

I have a pdf report that I need to generate in an Access 2000 database at the end of a report. Can I run the pdf at the end of the access report or is there a way to import the pdf into an Access report? Advise please

The SQL server job to clean up the distribution database is running - all our replicating databases are up to date but the distribution database is still growing. Any ideas

I have seen this report and yes I am definately on SQL 2000

A replication agent running from one SQL Database to another on the same SQL 2000 server throws up the following error every night. No major processors are happening at this time Any Advice SQL error occurred. See entry specific information. Error : 16943, 37000, [Microsoft][ODBC SQL Server...

I have an Acces database producing a report listing Invoices. I want to print a tems and conditions footer at the break of each invoice. This is held as a Word Document. Any Ideas

I have a Maintenance plan on a database that 1)Backs up the database 2)backs up the transaction log 3)Optimizes the database Options 1 & 3 run OK BUT Option 3 returns Backup can not be performed on this database. This sub task is ignored I have checked permissions etc but no joy Any Ideas?

Our Tranasction Log is 55GB!! Back up fails Space is now beyond critical DBCC LOGINFO shows all entries to stsus of 2 Is there a solution without doing a back up Advise please

I need to popukate a list box with the tables in the database. I believe listtables mayt do the trick but can find no reference to it in the help (access 2000)

I have created a report to run on the web. The report works fine in client and publishes to the Web successfully. When I come to run it the process bar appears flashes as if running then i get an 'Application Error'. The only bit of legible error text is 'logon error while connecting database'...

I need to set up a special date category that looks at a specific period spanning seven months in a year. What is the best way to do this?

I need to find all records from one table that dont have an entry in another table. Is there a SQL staement that will do this for me? IE All customers that have no orders

Is it possible to set up an alert to contact a mobile phone using a text message

I have successfully attached to SQL server using connection strings, but am having difficulty with the syntax to connect to a database using ODBC. I do not want to be reliant on DSN's.

I HAVE BEEN ASKED TO MIGRATE AN APPLICATION FROM APPROACH 97 TO ACCESS 2000. IF I OPEN THE PROJECT IN ACCESS I LOSE ALL THE FORMS FROM APPROACH. IS THERE A MIGRATION FACILITY AVAILABLE ?