Search results

Historically I have an Access 2003 Frontend talking to a SQL2000 backend. It is quite a complicated process which I shall attempt to explain here. I have a report on Access that has a record source of 'spSixMonth' and Input Parameters of @vch_Site_ref = [Forms]![frmdashboard]![cbxSiteRef]...

Excellent, thank you very much for the answer and also the webcast link. Much appreciated

I am slowly working my way through the tutorials for 'Reporting Services' in SQL 2005. I am on Tutorial: 'Creating a Data-Driven Subscription' and currently in Lesson 2 which is 'Modifying the Report Data Source Properties'. It says, and I quote 1. Click Start, point to Programs, point to...

OK, I got the SQL steps all running as you suggested and boy doesn't that make life easier. I wonder if I could take it to the next level? Is there a way that I can do the Excel part as well? This might be out of the arena of this forum but I shall ask it anyway as you seem to know your stuff...

I shall give that a go, Thanks for the info Regards

I think from a damage limitation point of view the Access route is a better one If you have any advice on how to create all of this into a DTS (the clear way as you put it) or any websites I could go to then taht would be a great help Thanks SQL Hell Regards Toni

Enterprise manager. There is no front end as such. The only real front end is Crystal Reports X but that is used only by end users to run the reports against the dataset. Regards

SQL Hell, thanks for the response. Do you have any idea of some sites I could go to that could assist me in creating the the form/button etc? Or could I do it in something like Access '03? Regards

I have a Small peice of code I run in Query Analyzer, I then have a DTS I execute and then a further peice of Insert Into code which again I run in query anaylzer. What is the best way to run the code, do the DTS and then run the further peice of code in such a way that someone who is totally...

I have a form that runs a few querys and requerys based on a set of criteria. How can I make it so that if the value returned is Null in a certain field on a query then the contents of the List box displays 'No Records Found' rather than being blank Kindest Regards Toni

Doh!!! of course Stupid of me to ask that one. You can tell I have been away from work for three weeks Thanks Mate

Ummm, yeah, that could work. I will give it a try. That also kind of helps with a problem I was thinking about anyway in showing the difference between last week's and this week's values. How would I then only display the records that have a changed value? A new query that only shows the...

I have a table that contains a significant amount of data. The columns are as follows; ID, WeekNo, Ref, Cost What I want a query to do is only show me differences in Cost value where the Ref is the same For example ID, WeekNo, Ref, Cost 1, 1, ABC, 123 2, 1, DEF, 456 3, 2, ABC, 123 4, 2, DEF...

I found what was wrong, I put a code break in the enter() part of the txt box and when I entered the box it was not breaking, hence therefore I guess why the code was not working. I changed this for _Enter() to _GotFocus() and now all is well. Don't know why it works on the others and not this...

on my way there right now Thanks

I have just tried to reuse a peice of code that I have used in several databases before and for some reason it is not working. Could someone have a glance over what follows to see what I have done wrong Option Compare Database Option Explicit Dim WhichBox As Integer Private Sub Atx_Cal_Click()...

Excellent, my thanks to you both, problem resolved now Case Closed Kindest Regards

I have seen the attachment, thanks, I am trying to work out how I would translate that and use that in a scenario where I have O or C Regards from the thick one

I have a query that looks through a table and shows me any calls that have a status of either 'O' 'or 'C'. What I would like to have in the query result is the O or C replaced with the words Open or Closed. Then when my count will make alot more sense rather than having O 29 etc. I have had a...

Hi Pat I have no spreadsheet at all at the moment, so it is open book when it comes to how it can be set up. The reports are the same report for 106 different sites. The selection criteria is passed in as a variable into the sql code which then fires the stored procedure and spits out the...