Recent content by Mantispony

:confused: How do I set it to "only add new records"?

..amazing! Sorry, I can really be amazed by what technology can do! Thanks a million!!

Ahhhh ok now it makes sense to me, thanks! ..but what is a ForeignKey and what does it do? (I'm just curious now)

Ok, thanks for your feedback and opinions! So I'll go with JANR's solution then, but I'm not entirely sure I understand the mechanics.. If I bind both the form and the subform to the same table, and the subform adds records, won't I get loads of records with the same ClientID number? Or will...

JANR, I think it would make more sense to use a separate table.. Vapid, ..I can't follow you, sorry, I don't know enough about coding/programming.. Can you please explain what a me.query is and how to make one?

Hi all, I'm not even sure whether or not this is possible, but this is my challenge: I've got a list of customers and their sales value etc. Now my boss wants to be able to enter comments (for some reason the memo field columnhistory thing does not work for me, boo) that are dated...

David, I tried that again, played around with " marks, but now it's telling me my syntax is wrong, that I may have entered an 'operand' without 'operator' (I'm using a Dutch version, so terms might be different in English).. I just can't get this to work, and it's rather important that it does..

Hi all, you guys (and girls?) have been incredibly helpful so far, so I'm not hesitating to ask yet another question ;) I know about the ColumnHistory function, but apparently it only displays the ColumnHistory for one particular record (as programmed in the function). ..at least that's...

Thanks bob, I'll play around with that for a while.. (it's looking a bit like spaghetti to me right now, but I'm sure I'll work it out eventually..)

Hi everyone! I'm back with another (possibly silly) question: How do I turn the totals row into an actual record, so that I can display it in a form? It should still function as the totals row, though (so "copy/paste into an empty record" is not what I'm looking for here). The idea is that...

Oh many thanks! That helps a lot! :)

..ok so I've got this: DSum (+, TOTAAL2011, «criteria») but I don't know what to put for the criteria. (and I'm not sure about the + either lol, I only have a VERY basic understanding of functions) "TOTAAL2011" is the field where the total sales for 2011 are stored. Does the "group" field go...

Re: how do i replace "#NUM!" AND "#DIV/0!" in my reports? The problem has been solved, thanks anyway :)

Hi, I thought I knew enough about Access until I took a look in here, lol. (Feel free to move or delete this thread if appropriate) My challenge is this: I've got a list of customers and their sales values, as below: custID | custName | custGroup | custValue The custGroup field is where...

Re: how do i replace "#NUM!" AND "#DIV/0!" in my reports? Very sorry about the necro-post, but I've got an issue related to the one described above. I've tried IIf(Nz([Field1],0) = 0, 0, FldA/[Field1]) But that only gave me an error message. I've also tried NZ(Sum([Field1]*[Field2]),0...