Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. baboudi

    Setup project: custom actions

    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];
  2. baboudi

    Setup project: custom actions

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

    raiserror with Nowait not working as expected

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

    raiserror with Nowait not working as expected

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

    raiserror with Nowait not working as expected

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

    another Table of Contents Report query

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

    Reports Grouping custom Numbering

    Thanks works perfectly
  8. baboudi

    Reports Grouping custom Numbering

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

    Reports Grouping custom Numbering

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

    creating custom pakages with Access 2003 Developer Extensions

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

    changing color of slices in a Pie Chart with VBA

    Many thanks dhookom. Your solution did the trick
  12. baboudi

    changing color of slices in a Pie Chart with VBA

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

    changing color of slices in a Pie Chart with VBA

    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] *...
  14. baboudi

    changing color of slices in a Pie Chart with VBA

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

    Percentage\Count by Categories

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

    Percentage\Count by Categories

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

    adding a filter to a treeview via a toggle button

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

    adding a filter to a treeview via a toggle button

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

    adding a filter to a treeview via a toggle button

    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.

Part and Inventory Search

Back
Top