Recent content by AccessFreak

It need to be LEFT JOIN.. thanks but no thanks.

my select statement: SELECT b.boekingsnr, k.klantnr, k.achternaam, (v.prijs_laagseizoen * COUNT(d.boekingsnr))AS vervoerskosten, (((b.aantal_eenpersoonskamers * a.prijs_eenpersoonskamer_laagseizoen) + (b.aantal_tweepersoonskamers * a.prijs_tweepersoonskamer_laagseizoen))*...

can someone tell me if it's possible??

I need to do have a select query for the following information: reservationnr, customerID, firstname(customer), lastname(customer), Total accommodationcosts and Total travelcosts. In table Season there is an attribute called Holiday. If that attribute is NULL, that period is in lowseason. If...

I got a warningmessage with this sentence: Cannot perform an aggregate function on an expression containing an aggregate or a subquery. What does it mean.? I used a select statement in sql server but this doesnt work

Thanks man.. your great. I knew it was DateAdd or DateSerial.. i See i did date() before DateAdd().. that was the problem.. Thank for all.

Sorry for this question. Its STUPID. I have a query with a date field. I need to get al the dates from 6 moths ago untill now. I thought it was something like this: Date BETWEEN Date() AND ....< i dont know what to set here..

I have 2 subreports in my detail section. In the footer of each subreport I have a number exclusive VAT. That works BUT.. read on. The total of both have numbers need to be calculated to the mainreport. This is called the Total exclusive VAT. That doesn't work... It says cant find the controls...

It works with some adjustments..

Yeah I know but BeforeUpdate needs to occur only when I quit the form. When clicking the save button I'll need to stay in the form, the BeforeUpdate have to be cancelled when clicking the save button.

Look within the btn_Save.OnClick the following happens: The user will be asked to save the record and to open an new clean record. The form.BeforeUpdate comes directly after I click on the save button. I want to prevent this by canceling the BeforeUpdate event when I click on the save button...

Hello everyone, When I click the save button on my form, the BeforeUpdate event must be cancelled. How can I do that?

Sorry my bad.. The warningmessage only occuer when hitting the tab or enter key.. I DOES NOT OCCUER WHEN SELECTING ANOTHER FIELD WITH YOUR MOUSEBUTTON. I THINK THAT'S WEIRD.. But oke..

Yeah thats what i mean. It's not a custom message. It's the access standard warning message. If i tab nothing happens. The focus stays in in the drobdown menu untill i select something. But if i tab nothing happens. But maybe i need to set docmd.setwarnings=true in the form load.

A very weird thing occured. I have some comboboxes with a limit to list property set to yes. If a enter drobdown content which is not in the combobox data, there had to popup a warning message saying need to select a drobdown content. It just stay in the field until I select one... but where is...