Recent content by srmclean

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

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

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

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

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

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

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

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

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

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

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

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!

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

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?

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