Search results

Hi, In MSAccess2003 this worked fine, in 2007 it doesn't.. why not ? Code: 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 all, I have a form where I want to show three numbers: - Competitors who are member (they have Memnr) =Textfield 1 - The ones without Memnr =Textfield 2 - Total of competitors =Textfield 3 In Access2003 this os working fine. in 2007 the second field is displying "Name?" Textfield 1 has...

Ok, thnx m8 !

I got it sorted out.. Created a specification file for every query I had to export (5 queries) and now it's working fine.. Thanks for your help.

Hi Namliam, You mean in the regional settings? Those are: Decimal , Amount of decimals 2 Number groupings symbol . seperator ; I live in the Netherlands where these are the way supposed to be. So this is not it.. Any other thoughts?

Hi, I have a query export to csv, which in A2003 works great. In A2007 it won't work (on same computer!), I read several posts about the export specifications but have not found the solution yet. This is line where the export is defined and then exported ExportScore =...

Hi, I have a calculation which is depending on three fields: VerzId, Kapitaal (currency) and Perc. If one of those fields is edited (let say user made a typo in the kapitaal field) how do I refresh the calculation ? So, whenever one of three fields is editted, the calculation should run again...

Hi RuralGuy, You're the man ! First I removed the line from query, didn't make a difference, then I checked the references while I knew I set the DAO reference.. But I set it to DAO 3.51 and when I changed it to DAO 3.6 the problem was gone..! Problem solved ! Thanks !! Got one more question...

Yes, [Polissen].[VerzId] is a LongInteger

Hi RuralGuy, [Polissen].[Kapitaal] = Currency (Euro) [Verzekering].[ProvisiePerc]= number (double precision) [Verzekering].[v_ID] = (Auto)number (PK) [Polissen].[VerzId] = number ProvisiePerc is supposed to hold a percentage value. Is the number propertie wrong ?

Hi, I got this piece of code but it's giving me error 13 : Types don't match.. Pointer is set to Set rec = Anyone sees what's wrong with this ? Private Sub Kapitaal_AfterUpdate() Dim intKap As Currency Dim SQL As String Dim rec As DAO.Recordset intKap =...

Hi Doc Man, Well that certainly shines some light on this !! Thanks for the explanation, and funny thing is, I practice fast shooting for real ! How about that !? LOL Not the fast-draw, but steelplates where the clock (and misses) are your enemy.. Anyway, I think you're right, but still, without...

Don't know what you mean.. sorry.. Was thinking in the CASE SELECT direction.. isn't that an option ? If the piece of code I wrote is correct, which I think it isn't...

Oke, got some inspiration from this.. Thanks again, Gary ! If I can't get it done, I'll post again... :D :eek:

Hi Gary, You got the idea.. I added in tbl "Verzekering" a field ProvisiePerc with the %Rates appropriate for the product linked I was playing with queries and through VBA selecting if v_Id (unique ID for combi Company/product) is 1 then run query A etc. I have different queries working for the...

Hi, I got several queries which all can apply to the same field, I was testing with this: Private Sub Provisie_BeforeUpdate(Cancel As Integer) Dim Fee As Integer If Me.VerzId = 1 Then DoCmd.OpenQuery "ProvBerekGelders" Me.Provisie = Fee End If End Sub But it's not exactly what it...

Not sure what you mean by that, but anyway.. I've been playing with Queries and I have working queries now for every 'fee construction'. So, question that remains is how to implement those queries so that when I fill in the Form with details about customer, which product from what company, the...

Hi, Best to have a look at attached relations picture. Basicly this is what I'm wondering about: I add a new customer who bought a product from a specific supplier. That unique combination gives me the right on commission. From company A I get, let's say 5% of the capital. Company B gives me...

Hi Stopher, Tried that one too, no luck What is the place to set this ?? Maybe I set it on the wrong place..

Hi, I want a datefield defaults value to be the first of the current month. DateSerial(Year(date), Month(date), 1) should do the trick, but whatever I try, it won't work...don't know where to set this. Tried the field props in table, props on Form, no luck so far.. Anyone ideas ? Thanks