Recent content by Rechmali

Hi, Thanks for the input. Copying seems as tho it may work. Good guess about the maindata being the primary data source. There are many reports already built alas, otherwise the query option would be the favourite. Once again, thank you. Chris

Hi, I have inherited a database to work on which has a large number of queries many with dependent queries. A requirement just in is to run a set of reports based on a subset of the main table a little bit like grouping. I don't really want to go through and change each query and a far more...

Thank you so much for the help you guys. Turns out that the guy who is responsible for the network hadn't linked the app to the citrix server correctly, that and recompiling the app after applying SP6 on VB6. Once again thank you.

Hi, I have an application that I am trying to get to run using Citrix. Having installed it, only people with adminsitrator rights are able to run the program, not even power users are able to and certainly not humble users. The installation package of application has also been set up on the...

Hi, I was wondering if anyone knows how to programmatically populate a datalist. I am able to bind it, but have a feeling I read somewhere about doing it in the program so that I can play around with the data first. I have in mind an AddNew property, but can't seem to work out how to do it...

Thank you both for your quick response. Nevermoor, I am having trouble getting the lines with the If and the Set statements in to my stored procedure. You say that they need to follow the select statements, so does that mean immediately before the FROM??? It seems no matter where I put these...

Hi, I wonder if you can help please? What I have in mind seems simple, but can I work it out.... doh! The value in YNProvisionalDiagnosis is either '0' or '1'. If it is '1' I would like to tag on 'Provisional' to the front of the assignment statement, before the Description. Does anyone...

Hi Vaughn9, This is a little tricky, as you haven't actually asked a question yet but I am guessing you want something to be hidden at some stage and visible at others. Using the .visible property will achieve this, setting it to true or false accordingly. If I haven't guessed correctly...

Hey guys, Thank you so much for your help. I am going to have a play and see if we can get to where i am after. bjd4jc, have a star for your most kind plug and play code :) Cheers Chris

Ok, I am feeling more than a little dim! I am trying to set up a form which will display a number of records and allow the user to select a record. I have previously used a DataGrid which comes close, however, what it doesn’t appear to do is cater for a lot of text in one of the fields. The...

Hi, Hope you don't mind me hijacking the thread, but i seem to be getting exactly the same problem, but at server level. I am trying to store 1.80, not 1.8, but when I edit the field direct through enterprise manager it keeps losing the trailing zero. Where am I going wrong? Hope you can...

Hi Guys, Thank you both for your help. Turns out that I had changed the component list and when I made sure I had the dblist with the yellow on the icon, I was able to make it work. BIG LEARNING CURVE at the moment! :) Chris

Thanks for your quick response. It is returning a value. If I put in another line of code after the set, I can see the info that I want... Darn coding!

Hi, I wonder if someone might be able to give me a nudge in the right direction please. I am trying to populate a dblist box using the following bit of code : Set ScriptRS = objcomm.Execute("get_PrescriptionDetailsListBox", pr_Parameter, adCmdStoredProc) With dblScript Set...

Thank you guys for your help. I got side tracked into doing something else, hence the late reply. This did the trick nicely with a bit of lateral thinking :) My next step is to get the combo box to recognise text and position itself in the list, like an Access combobox would do. Once again...