Recent content by RCheesley

I have a similar but possibly different issue - for some reason my property sheet appears blank! At the top of the sheet it says "Selection Type: Combo box" as per the attachment. No idea why, I haven't done any VBA and these are just really basic forms - never seen it before! I closed the...

Hi Guys, I've searched around for this but I can't find an answer! Spent ages trying to figure out how to display this dataset, then figuring out cross tab queries, parameters for cross tab queries etc. Finally got it working (a biig *WOOHOO* moment!) and thought the next stage would be easy...

Thanks for this example, an explanation of the syntax would be useful as I can't find this anywhere online that explains it in "Normal" speak. Using this example Format(CInt([f2]),"00") I tried the following but it's coming up with "The expression you entered has a function containing the...

Hi all, I'm having trouble with a query when in pivot chart view, as it is sorting the dates wrongly: yyyy ww 2009 1 2009 10 2009 11 when I want it to display as: 2009 1 2009 2 2009 3 and so forth. I've got as far as identifying that I may need it to sort as "CInt" rather than a string...

Still struggling with this - does anyone know how to have it show zero where there are no records for that month, rather than not showing anything. Ruth

Hiya, It's not actually working - if I put something in the link criteria of the combo button it says it can't find the form (I checked that I hadn't made a typo). If I remove the link criteria it opens the form with the combo box showing all the reports in the drop down. Ruth

I do wonder whether the slowness corresponds with the server taking a backup or some kind of maintenance - if it's already at breaking point then this kind of additional load would cause the issues we're experiencing

I have spent the last 4 hours trying to post a message to a forum, getting network error, server too busy, database error to name but a few. Finally it posted 5 minutes ago. How long does it generally take people to post to the forums here .. I've never had such bad problems before with...

Hi all, I've got a form (frmPatientDetailsWithTabs) which is used to display a patient's record. This is based on a query called qrypatientrecord, and on this form is a command button cmdViewReport. When this button is pressed, a form opens (frmViewReport) and on this form is a dropdown box...

I wonder how many of the users who make use of these resources actually contribute financially towards the upkeep of the site/server (or even if there is the option to do so?) and what kind of funds are generated from the ads being displayed - as it will cost to run this forum software, it will...

Paul, Not my work, that integration, but I use the API on my sites along with PH. Don't be fooled by thinking it's easy hosting a forum of this size and popularity, it requires very significant server resources which is not something I could provide free of charge - and there's not a lot of...

I think you would need to create a separate query for this purpose - or have the information you wish to use to limit the query being passed by a form, perhaps?

Woohooo, thanks for that, such a simple tip but it's had me stumped all day!

Ahar, now that's a useful blimmin tip! Will give it a go, thanks for that :)

http://www.vbulletin.org/forum/showthread.php?t=176481 <-- link for vbulletin - not sure if it's been incorporated yet?