Search results

I was plying with the query and got this one working the way I wanted: WHERE (((Polissen.[Provisie-ontv])=Yes) AND ((Polissen.Ontv_datum) Between StartOfMonth(DateAdd("m",0,Date())) And EndOfMonth(Date()))) OR (((Polissen.[Provisie-ontv])=Yes) AND ((Polissen.Ontv_datum) Between...

Tried both solutions : RuralGuy's only returns from previous month and the month before that (?!), not the current.. MicroE's opens the report but doens't filter anything while I set one record to a date that it has to show. Created a module with the functions, removed the criteria's from the...

Sorry MicroE but this link doesn't help much.. no code visible or sample for download.. Anyone else can help me ? I found these functions: Function StartOfMonth(D As Date)As Variant StartOfMonth = DateSerial(Year(D), Month(D) - 1, 1) End Function Function EndOfMonth(D As Date) As Variant...

RuralGuy is correct.. it doesn't work.. :(

Hi, I'v been reading a lot of posts, but can't find the solution for my question: How do I create a report that covers this month and the previous month ? I have a date field [Ontv_datum] in the table from where I extract the data. I don't want input boxes "from date" - "to date" Thanks for...

Great ! Thanks

Hi, I got a Date field[Provdate-ontv] which only is allowed to set if another field, a Yes/No field[Prov-ontv] is set to Yes (default is no) How do I do that ??

Send you a PB

Hi GaryPanic, Thanks man ! I'll have a look at your sample.

Hi Doc Man, Thanks for your reply, I've been reading up on junction tables, but it's dazzling me a bit.. Situation is: Each customer can have multiple policies, sold by one advisor. Each policy is owned by a company. A company can have multiple policies I want to have a form where I can add a...

PLz!?!? Anyone want to help me out ? I almost got no hairs left to pull out...

Hi, I'm trying to build a mdb which holds customer details, which insurance they have, who sold them this and which Insurance company provided this. The relations I have to make are driving me nuts ! When I try to enter a new customer in a Form, there is a advisor added, the package the customer...

Oke, I think I get the picture.. Thanks for helping out !

Hi Oldsoftboss, Thanks for your efforts, but problem here also is that the actual help file is external from the db. Thus needs to distributed as well. What I am looking for (and don't know if it's possible) to create a help function - file - or whatever that is in the db, like a form or...

Thanks, will have a look @ it.

Hi, I am wondering if and how others create their own help file ? What are the possible methods? I have a manual but now it's a separate document. I would like to stuff it 'inside' the mdb file so it's always available and easier to maintain. Hans

I searched and found the values like Moniker explained, declared them in a standard module like lagbolt said and things look oke. I think I read to remove the references to all office libraries , correct ?

Really appreciate your help.. Where or how do I find those values you're talking about ? Have no clue...:confused: Small example perhaps to put me on track ?

Thanks for your replies, So the code should look like this then? Private Sub Exportmail_Click() Dim objOutlook As Object Dim objOutlookMsg As Object Dim objOutlookRecip As Object Dim objOutlookAttach As Object Dim AttachmentPath Dim DisplayMsg ' Create the Outlook session...

Hi, I've been reading some posts about late binding to prevent having errors with different Office versions. I have this issue.. However, I don't know how to implement it in my own code.. :-( Anyone willing to help me with this ?? Private Sub Exportmail_Click() ' Private Sub...