Search results for query: *

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

...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] * [B}>12,"Red",True,"ExistingControls ") AS healthStatus I have Query2...

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...

ok...worked it out by using the initial subquery in a comlpetely new query and doing a join on it

...I am ommiting the fact where JobA and JobB also have to be completed and this is where my problem starts. select category, count(task)/Count(*) * 100 from tblTasks group by category here I tried to get the number of tasks completed but it ignores the category. So I have the total number of...

got it Private Sub Toggle12_Click() xProductTreeview.Nodes.Clear SetupTreeview CreateFilteredbdgNodes CreateFilteredFloorNodes End Sub

Im nearly there, but need an extra help.... I have a toggle button which is suppose to reload the treeview, based this time on query (with the Reviewed filtered) Private Sub Toggle12_Click() xProductTreeview.Nodes.Clear however not sure how to add the treeview nodes after this and keep having...

No need for any apologizes, your help was very much apprciated and have my treeview almost completed not when applying the filter. I clear the nodes, and reload the treeview based on a query.