Recent content by Playbus

Yeah, Gary that'd be cool. I'll give you a shout when I get done with my latest project, and you can dazzle me with code. Hehe! You're too nice, y'know! Cheers

Groovy. Thanks again for the help everyone, especially Gary :D

So that code just literally needs .update sticking on the end of it?

Thanks for your help Gary. I did have a button with the code attached to it (modified for my table names and stuff of course) but when I clicked on it, nothing happened. Not even an error. But never mind, all is well now. In the end I came up with a workaround which is very simple but had not...

Hmm, I've played around a bit, and although I can get the code to not throw up errors when I run it, it doesn't actually add anything to my second table :(

Whoah :eek: That bit of code just blew my mind .... ok .... I'm not sure how it works (my VB is as basic as basic can be) but I'll have a go and see if I can adapt it to my database .... I'll report back with progress Thanks Gary :D Thanks for your input also neileg .... interesting idea....

Thanks Gary, if you can find me example code that does this I'll be very grateful. Enjoy the pub. :D I'll see what I can find searching things for .add ....

I understand that people are going to say "Ooh nooo you don't want to do that!" but two things :- 1. The above is not an exact representation of my database -- I have simplified a LOT. If you can tell me how to do what I asked above, that will be enough for me to work out what to do with my...

I need to make Access automatically create new records in a table for me. Just for example:- Table #1 has 2 fields PersonID (autonumber) PersonData (text) Table #2 has 3 fields ID (autonumber) PersonID (number) MoreData (text) The database user creates a new record in Table #1 using a...

Thanks ansentry, I think I have found the problem. It's my PC! I just recently started a new job and working on this database is part of the job. When I tried your example, I did it last night from home ... where it worked. I tried it at work today and I get the same error! Therefore, my...

Thankyou, ansentry, for taking the time to help me. :) I downloaded your example, and it works. :D However, it is exactly the same as my database. Apart from the names of fields, your example is exactly the same as what I have. Except yours works, and mine does not. :cry: Can you think of...

Thanks for the reply! I did what you said, but unfortunately I still get the error "Object or class does not support the set of events" :confused: Do you know what I might be doing wrong?

SetValue Question - Please Help! I have a command button that I want to automatically enter the date into a date field on the same form. Setvalue item: [Forms]![FRM_View_Orders]![OrderDate] expression: Date() This works in Access 2000 -- but in Access 2003 I get this error message: "Object...

Thanks BukHix. That will come in handy.

Well I went about it a whole different way, using a macro (I can feel the glares of disgust from the experienced Access people here already) and an extra hidden form. The method I used in the end is probably not very efficient, but it works and is definately good enough for my purpose at hand...