Search results

Thanks very much Kinger43! that worked perfectly.

Hi there I've been looking for this one for a while. In my query I'm using a date field to extract dates using the between And function. I'm refrencing to txt boxes within a dialog form within the query. For example: Between [Forms]![frmViewByCatagory]![TxtStartDate] And...

Just a quick one. I'm not usre how to handle the error when cancelling a report. so when I hit a control to bring up a report and say I cancel it before I put in any parameters for example I get the dialog box " runtime error" "OpenReport action was cancelled" etc. Could anyone help me on...

Thanks a bunch CraigDolphin

Thanks for the reply Pbaldy! I wasn't actually asking for the easiest solution on how to make a field required! What I was asking was if anyone knew what the VBA was to make a field required! Thanks anyway:) Does anyone know? cheers

Hi I know this one is a simple code issue! does anyone know what the code is for making a control on a form required so that the user has to enter info into it before they can exit? Cheers

Thanks for the reply Raskew. The txtProjectYear is just an ordinary unbound text box. I've used the same method with another imput box which has two combo boxes with drop down months and two text boxes which the year will go in. This set up will create the from and to dates and I've used the...

Hi there I thought I knew this one but I'm having problems. I have a report which is opened by an imput form. for this I have entered the expression Year([forms]![frmProjectYear]![txtProjectYear]) which, when opening the report will open the imput form above, I'll enter my year and it will...

Hi there I've tried to change the default of a yes/No field so that it's either NUll or "" or Yes. This has proved unsuccessful and all the fields are still showing as No for default unless I obviously select Yes Does anyone know if there is a way to change the Default of this field to either...

Hi I'm trying to use a control to calculate a bunch of related records on a form. I'll just clarify my setup. The parent form is called "frmProject" that will list different Projects an organisation is working with. It's child form is called "frmApproved" which has a total amount of funds...

Hi I have a subreport within a group header. I have a currency field in there and the there will be many records within one group. At the Group footer of the report I want to calculate all of the amounts that come from the subreport within that Group The standard sum function =Sum([Sent])...

I'll have a look at that CraigDolphin! cheers

Well, I did say it was a silly question! Yes, I did try Google for a graduation pic and was curtious to see if anyone new a particular site that was good. Anyway, I'm using Powerpoint for the graduation pic. Thanks

Thanks JustinDB for your reply I should have clarified this a little more! I know how to add a bitmap. What I meant was, if anyone knew where I could get sample pics; if there was a web site that supplied them so that I could add them in the first place? you know, like Microsoft clip art...

Silly as this question is, does anyone know where I can find bitmap pics for my database background? for example, color graduation backgrounds that I can add. I guess I could purchase a painting program for this but thought I'd ask if anyone knew before I done this? Thanks

Silly as this question is, does anyone know where I can find bitmap pics for my database background? for example, color graduation backgrounds that I can add. I guess I could purchase a painting program for this but thought I'd ask if anyone knew before I done this? Thanks

Query I've had a look at the query which I should have done well before this and it's this that's giving me the duplicate. I've tried different join types and that's not really working Does anyone have any suggestions for me to try?

Duplicates Thanks BURRCM for replying. Well, this is strange. I had the details about the amounts etc in the "AmountApproved" Header and because of this, I didn't make use ot the detail section. I put the amounts into the details section and what I get is duplicates. Some records are fine...

Hi there. I've made a report and am having a problem with it. I have three group headers in the report. One is for the names of organisations One with all the projects within that organisation. And one header with all the payments to the projects. So I have the Organisation footer and in...

I've just been looking at some articles and can't see any solutions to this one. Using The Val function within the Tables "advanced sort & filter" sorts as if it's numeric but misses out the all of the text part. (any text either is missed or becomes 0) And the only real solution I can find...