Search results

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

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

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

Hi all, I (foolishly) took a dislike to the layout I had on a form, and decided to put a tabbed layout in its place. I copy/pasted the controls into the relevant pages, however now none of the VBA is working. I'm assuming that I need to declare somewhere the information about the page it's...

Hi Guys, I have a pivot chart which is working great, except that it just misses out any weeks where there are no records whereas I would rather force it to display zero - is this possible? Kind Regards, Ruth Cheesley

Hi guys, I've managed to get my data displaying in a pivot graph by using a query, which displays number of samples by month at several locations (multi chart pivot) which pulls from a table called tblSpecimens. I've now been asked to plot the corresponding trajectory onto the graphs and am a...

Hi all, I wonder if you can suggest what event I should use to call a module on? I've been using beforeupdate but this doesn't seem to be working as I intended. Basically my module runs through a series of dates, and if those dates are within a certain number of days from today it'll change...

Hi all, Wonder if you can help, I'm trying to get text boxes to conditionally format depending on the dates which are updated automatically when a field is completed. So far I have the following (please feel free to point out if there's a better way of doing it - I'd like to have it happen...

Second time lucky, my previous post timed out :( I wondered if I could get some suggestions on the best practice for displaying cascading combo boxes. I have some categories, say 1,2,3,4,5 and within these are sections, say 1a, 1b, 2a, 2b and so forth. I want to have a combo box on a form...

Hi all, Just to let you know I'm back safe and sound (if a little sore and achy!) from my 200 mile sponsored walk! The fundraising now sits at just short of £1000 which is brilliant! In the time I was away walking, a fishing boat capsized off Scotland resulting in three fishermen losing...

Hi all, I have a query which is working really well, which I am using to generate a pivot table/graph to display the number of cases per month for three organisations. These are counted from a table with the following fields: SpecimenID PatientDetailsID PatientDetailsNHSNumber SpecimenDate...

Probably a simple solution but can't figure out the syntax! I have a form which is being completed when a particular questionnaire is returned. I have the name/address of all those it was sent to in one table, and their questionnaire responses are being saved to a separate table. When the...

Hi all, I have a query I'm using which I want to do something funky with but I'm not sure how! Basically I am currently using a very complex excel spreadsheet to maintain a line listing of patients with a certain condition, which automagically calculates certain fields. I'm attempting to...

Hi all, Just thought I'd let you into something we've just discovered in our office - a company which will deliver a box of healthy, tasty snacks to your door (at home or work - anywhere you can receive royal mail post deliveries). So far I've had freshly cut pinapple/fire nuts/granola seed...

Hi all, I've done a bit of searching but all the answers I am finding relate to a report, and not a sub report. I've got a report set up which is working perfectly, it has several sub-reports running off their own queries and whatnot. I've set the reports to can grow/shrink yes, which is...

Morning all, I've got a query which is running a search box on a form (which I lifted from an example posted here incidentally) but it's picking up the GP as the ID number and not the actual GP surgery. Is there any way I can get around this, perhaps by using DLookup or something? SELECT...

Hi all, I'll do my best to explain this situation but I'm somewhat confoozling myself! :confused: I have a form, on which there is a combo box for the user to select the name of the person who referred the application being completed. The combo box stores the ReferrerID in the database but...

I'm off to the Lake District in .. ooh about 10 minutes :D:D:D:D .. doing some training walks in preparation for my Coast to Coast walk this summer. Can't wait, although not hugely looking forward to the 6 hour drive to get there!!!! Anyone else doing something exciting? Ruth x

Not sure if this happens to anyone else but I frequently get the situation arise whereby I post a reply, and the response is posted but my browser sits there attempting to refresh the page but never succeeding - I have to manually browse to the thread. I use Firefox 3.0.10. Just a minor...