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!

Register Log in
  • Congratulations Rhinorhino 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. srmclean

    3D Pie Chart - with height

    Hi, I'm looking to make a 3D pie chart using 2 sets of data in one. eg. Slice Names : Company A, Company B, Company C Slice Values: 35%, 40%, 25% Slice Height : 100, 80, 60 The aim would be to show what percentage of the market the companies have and also what their relative profit margins...
  2. srmclean

    Using Description Property in Main DB window

    While in the main database window if you right click a table, form, query etc you can click Properties and then there is a Description field that can be populated. I'm trying to use this Description field to group forms, queries, reports, macros and modules. So far I'm able to list queries...
  3. srmclean

    Changing .backcolor on report detail

    Regardless, I can't change BackColor or BackStyle the issue is that I get an error message stating that the Object doesn't support this property or method. Yet other people seem to be able to execute this code on reports. ---------------- Shaun McLean
  4. srmclean

    Changing .backcolor on report detail

    I'm struggling to change the backcolor of fields on my report. Under Detail_Format I have a condition on the backcolor triggered by the value of a field like so : If Me.IDDescriptionChange Then Me.IDDescription.BackColor = vbRed Else...
  5. srmclean

    Height of Report Sections that "CanGrow"

    I have a detail that is 0.5cm tall which accounts for most of my lines of data. However now and again one of the fields that "CanGrow" does. Basically I want to know how to find out the actual Me.Detail.Height because when I use : Debug.Print Me.Detail.Height to check this value it never...
  6. srmclean

    Disconnect from File/Table

    Ok, I found that I still had a form open that was looking at the "deleted" table. So I guess it was keeping the link alive. Now when I disconnect I close that form and I have no problems. Thanks. ---------------- Shaun McLean
  7. srmclean

    Disconnect from File/Table

    There was a thread previous about disconnecting from a file. The reply was to delete the linked table using : dbasetempname.TableDefs.Delete Tablename I've been using this and it seemed fine, until now. I connect to a remote file's table via this code : Set tdfLink =...
  8. srmclean

    Setting a filter on a subreport

    Hi, Am having a bit of trouble setting a filter on a subreport. I set up a filter string elsewhere and store in a variable and then use the following on the main report: (which works fine) Private Sub Report_Open(Cancel As Integer) Me.Filter = varSummaryMainFilter Me.FilterOn = True...
  9. srmclean

    Incrementing a decimal point

    I have a numbering scheme for a list of items which utilises decimal places. When a user inputs an item number of 1 then I use a function "NexItemNumber" to work out the next number for the next record, in this case 2. That is no real problem with integers, but how would I be able to...
  10. srmclean

    Custom Properties in another DB

    a case of spot the deliberate mistake .. thanks for pointing out my simple error, everything is working fine now. Regards, Shaun
  11. srmclean

    Custom Properties in another DB

    I have two .mdb files and when I link them in VB I want to check that a custom property (one I've created to keep track of table structures) matches. I've written a function in one .mdb to look up the custom property of the other .mdb but it's isn't working. I get the error that the property is...
  12. srmclean

    Alternating Shading between records

    I like the use of Const XorToggle = 4144959 Me.Detail.BackColor = Me.Detail.BackColor Xor XorToggle but how do you work out the number to use for other colours ... like an even lighter grey, maybe a yellow or red? I'm sure I worked it out before but no idea now!
  13. srmclean

    Custom Status Bar

    I'm looking to make a custom status bar which displays information like Current User, Current Report etc. down in the bottom right hand corner of the window (where NUM & OVR are shown) I'm not having much luck finding out how to do this. I have used "SysCmd acSysCmdSetStatus, ..etc&quot...
  14. srmclean

    Menu Item Toggles

    I managed to find the State Property and have a go, I got it to work but was unable to reference the msoButtonUp, msoButtonDown, etc. constants and had to use true & false. (it think) The compiler just didn't recognise them and I have the Office Reference V9 turned on .. any ideas?
  15. srmclean

    Menu Item Toggles

    How you do toggle a menu/commandbar item so it looks depressed (maybe with a tick next to it too) once pressed? I have a custom menu set up and when I click one of the menu items it opens a form. What I would like to do is display that item on the menu as depressed when the form is open, to...
  16. srmclean

    Printing Dialog Windows

    When you print a report there is a small Windows dialog box that pops up telling you which page of at report is printing on which printer. Is there a way of supressing this window from popping up? Also, is there a way of changing the name of the report when it's passed to the printer to...
  17. srmclean

    Cross Tab Report : X pages wide by Y pages tall?

    Duane, Okay, I've relooked at the reports ... I'm just a bit thick. There are two .mdb files in the zip, which one has the report you mention? (then which report is it, if the file has more than 1 report?) Or do I have to put some extra data into the tables to make it go onto a second page...
  18. srmclean

    Cross Tab Report : X pages wide by Y pages tall?

    Thanks but I don't want any wrapping as in those reports, I really need to be able to go onto the next page, length ways, keeping columns distinct. In essence I have a list of car models down the left column, and then columns of colours from left to right and the cross tab is a count of each in...
  19. srmclean

    Cross Tab Report : X pages wide by Y pages tall?

    I have a crosstab query which is of completely variable number of columns & rows. Currently I am able to fit up to 24 data columns on an A3 landscape page but what I'd really like it to be able to do is, if required, have up to 48+ data columns and simply repeat the 3 left most title columns on...
  20. srmclean

    Right-Click Menus

    Nitrous270 You say "I want to make custom right-click menus and I think i've figured everything out" How did you get this far? I'm struggling through the Access Help File... How do I get started? Thanks Shaun

Part and Inventory Search

Back
Top