Recent content by Reenen

See attached file (form1) I created an *unbound* combo box, and then set some code in the event to set the current record. You probably still want to have save record etc buttons. I hope this is what you were looking for. Basically the code changes the "active record" when you select it via...

Thanks! I knew in some languages I have to use %, but I thought I could just copy paste the code from access. I use the thanks button for you! :D

Set a global variable AlreadyDone (or whatever) Set it to false when you intialize, and then at the start just check if AlreadyDone=true, skip to the end.

But why don't you just write a report, and export the resulting report to word?

Ok, I have it open, but I am struggling to understand what you are trying to achieve. Please ask your questions in small chunks. (I have your DB now so I can go wherever your reference me). It feels to me that your UI is deceptive. IE you are hiding things, while you could just be...

I assume your DB isn't huge. Perhaps you can zip it and attach? (I'm new here, so I dunno if that is allowed, but it should be).

I am connecting to my Access DB via ADODB connection (from Excel), I can delete all, but I cannot delete a subselection of data. This works: sSql = "DELETE ManualSplits.* from ManualSplits" cn.Execute sSql This does not work sSql = "DELETE ManualSplits.* from ManualSplits WHERE...

Hi I'm Reenen. I need help with a query, but this is just my introduction thread. I am 34, from South Africa, and I work for a retail chain. I am struggling with my ADODB connection between my excel and access DB. But will be posting that here soon.