Search results for query: *

Hi, I've worked it all out now! Thanks very much for your help.

Funnily enough I just got it working, but I also need to include the date column next to the note now, this is the formula that I used ...

I've been fiddling around with this for a while and I can't get it to work, obviously I'm doing something wrong, if you could provide an example dataset with this formula I think that would really help. Many thanks.

Thanks for your help, I'll have a bash with your suggestions and let you know if it works out ok.

Hi, I am an inexperienced VB user and I want to do something which may be simple but I can't work out how to do it. Here's the situation. In Excel I have 2 sheets, one called Information and the other called Notes. I want to copy from Notes to Information, I need to match an id from column A...

Hi, Thanks for your help with this. In the end I decided to write everthing to a temp table using the following SQL : insert into rag_temp_notes (schemenoteid, schemeid, notedate, notetypeid, note) select schemenoteid, schemeid, notedate, notetypeid, substring(note,charindex('###', note,4)...

The use of STUFF will not work for me because our SQL version is 2000. What I am trying to achieve is a list of the notes (without the ### etc where it is included in the notes - not always) along with the unique identifier - in this case schemeid. The notes come from the tableschemenotes and...

Hi gmmatros, I have copied your scripts and got the hang of what you mean but when I try it on my live data using the following : Declare @site_info VarChar(1000) Set @site_info = (select distinct cast(note as varchar(500)) from schemenotes) Select SubString(@site_info, CharIndex('###'...

Hi, I've trawled previous threads to see if I can find an answer (that's clear to me!) to my problem but no joy. Anyway, I'm using SQL scripts to extract data from a source database into a reporting database. Some of the data contains text which I need to remove e.g. ### Bronte Rent ### this...

Thanks pwise, I can create a new stored procedure which successfully looks up the tenures in my table. However, I need to get the parameter to list the tenures so that when the user is running the report they can select from a list. How do I incorporate this stored procedure into the...

Hi, I am writing a stored procedure in Access which is connected to a SQL DB. I like to use the design window and have created parameters in the criteria column which require entry of a date range. However, I now need to create one which looksup the possible values from a column in the table...

Hi, After a bit of fiddling around I got this code to work so many thanks for your help. Incidently, I checked out the help and whilst I can see that the basis of your code came from the help script, there's no way I would have been able to work it out. This is only my second ever VB script...

I see what you're saying with the ABS function but that's not really the bit I'm stuck on. I need to know how to write the macro or VBA to search for the values which are less than zero AND have a cost account equal to one of those in my list. If these conditions are met then I need to replace...

Hi, I have columns of financial data and I need to search for a cost code / value combination and where certain conditions are met I need to carry out a replace. Here's some sample data : cost centre cost account Period Balance date 1002111 1100 186000.00...

Hi - I've sorted this out myself, the problem seemed to be with the code being in the detail_print section, I've moved it to the detail_format section and this seems to have sorted out the incorrect pagination and retained the page break in the correct place. Sorry for the unecessary post.

Hi Remou, Oh dear I've just noticed that my pagination has gone wrong as a result of this conditional page break. My report now shows Page x of 16 but in total there are only 12 pages. Any ideas why and how to resolve this. I've tried putting the pagination at the top of each page instead of...

Hi Remou, That's done the trick - thank you very much for your help. I think the problem was due to the fact that in the page header section I had set condpgbreak to visible = false and this appeared to override what was in the detail section. Having the condition and then the page break...

Hi Remou, Thanks for the advice, I tried it and I didn't get an error but infortunately I didn't get a page break either. I need the page throw where the 'front sheet' does not appear on an odd numbered page so I changed the code to read If Me.Page Mod 2 = 0 which is hopefully correct because...

Hi, I posted this in the VBA forum but have been pointed to this one so hopefully someone can help me. I'm producing a duplex report in Access 2003, on the reverse page are diary comments which sometimes go over one page, this throws what should be the front page onto the back page. The diary...

Hi, I'm producing a duplex report in Access 2003, on the reverse page are diary comments which sometimes go over one page, this throws what should be the front page onto the back page. The diary comments are inserted via a sub-report. In the main report I'm trying to create a conditional page...