Recent content by baboudi

realised that I was missing ==true in my if statements but still failing if (Context.Parameters.ContainsKey(Access2003)==true) Access2003_Path = Context.Parameters[Access2003]; if (Context.Parameters.ContainsKey(Access2007)==true) Access2007_Path = Context.Parameters[Access2007];

Hi all, I have been struggling with this for a while without success. I need to deploy an access application and moving awayfrom the Ms Access Package Wizard. To be able to create the shortcut target with the right path, I need to check which version of access is installed. I set up a launch...

thanks tsuji and markros. Thats was the mistake I was doing...looking under results instead of messages!

Apologizes if this is a stupid question, but havent figured this one yet, and all my research showed that I should get a message immediately when the nowait is used. any comments/pointers very welcome

Hi all, I am using raiserror with nowait for the first time but I am not having the expected behaviour. i.e. if I run the following, I should have the first message immediatley and the second one after 5 secs, but both messages are appearing at the end of the procedure run (as if NOwait is...

Hi all, I am using Access 2003 and need to produce a TOC for a few reports which are about 50 to 100 pages long in the following format Report: ---Main report showing Title/executive summary /new page ---Subreport which contains TOC /new page ---Body of main report There have been quite a...

Thanks works perfectly

Thanks a lot for your help dhookom, I will give this a go.

Hi all, Have been investigating/searching on this without success and hope that someone can help I have a report with different groups/subgroups and want to change the numbering of the subgroups to something different to the numerical format available (1, 2, 4, 4). For example for the first...

thanks lameid

Hi all, I have been working on an access 2003 application which is almost ready for deployment. I have been testing the deployment up to now on two virtual machines with access 2003 and 2007 already installed. In the msi package, I am also deploying the runtime. Will be grateful if those two...

Many thanks dhookom. Your solution did the trick

found one problem with the queries. I will let you know once its fixed. Switch([A] * [B}>0 And [A] * [B}<5,"Green",[A] * [B}>4 And [A] * [B}<13,"Yellow",[A] * [B}>12,"Red",True,"ExistingControls ") This 'True' bit was assigning a default value. So this was removed and replaced with [A]*[B] = 0

thanks dhookom. I gave your suggestion a go without success. here is some more details I have Query1 (qryPieChart_RawData) which calculates the status from the product of two other fields A and B: Switch([A] * [B}>0 And [A] * [B}<5,"Green",[A] * [B}>4 And [A] * [B}<13,"Yellow",[A] *...

Hi all, I have a query which calculates the 'health' status of a system e.g. Red: 15% Yellow: 35% Green: 50% This is used to plot a pie chart. I manually changed the Pie Slices color to match the health description. I.e. The Red Slice will be Red, etc. When changes are made to the system...