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...
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...
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...
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...
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...
Hi all,
Was wandering if someone could take me out of my misery. have been struggling with this for a few hours without success.
I have to calculate the percentage of tasks completed by category.
For a task to be considered as completed it has to meet the following criterias:
1. Task is...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.