Recent content by JuliePritchard

I'm getting this error message and have no idea why - can anyone help me with this - My query makes perfect sense to me !!!

Thanks ColinM

Robert - thanks - what exactly is T-SQL ? - does that mean I can't do it in Query Analyser ?

I have SQL Server on a NT Server and I want to put an icon on the desktop so that once clicked on, an SQL script is run - is this easy to do - if so - how would I go about it ?? Thanks for any help Julie

Can someone let me know how to put prompts in a SQL Server query In Oracle the code would be Select x from table y where field = '&&1'; this would then prompt the user for a &&1 value I'd like to know the equivalent in SQL Server Thanks for any help

Michael, Where excatly is the scale setting ? Julie

I have a graph with Date and Time info along the X Axis - The data it is using goes on for a month, but the graph only displays about the first ten days - any one have any ideas why ??? Julie

Thanks for that

I have a forms database and a 'data' database with all the tables on it. Occasionally I need to 'repoint'(change the path of) the forms database to all the 'data' tables in the 'data' database using Linked Table Manager. When I first started using this, I could repoint all the tables in one hit...

Does anyone know how I can schedule an Access report/query/macro to run from NT. Possibly via a batch file ?

Terry - no it doesn't help really - all I want to now is if I want the Status bar to say "Hello Terry", then what would the code be.

I have an Access module that is basically a series of runcmd.dosql commands. How can I get the status bar to display which command I am on. e.g. If the module is running docmd.runsql "update names... etc" I want to add a line in the script that makes the status bar say 'Updating...