Search results

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...

Nevermind. I now have it all working. Thanks anyway pbaldy :)

Thankyou! I will try that today and report back with my results. :D /edit No, that doesn't seem to work. Normally, if I have "Anything in quotation marks like this" after .To and .Body, then I get a new email appearing on my screen, with these typed into the To box and the message body as...

The purpose of my new database is customer queries. This is for our Customer Support rep, who when she recieves a query from a customer, passes it on to the relevant department, via email, to deal with it. I have a module which has the code to create a new Email. This works, I can get Access...

Nevermind, I have worked it out now. Thanks anyway.

Hmm that doesn't sound like it will work in my case. I don't want to ask the database "How many items were recieved between #date# and #date#" --- because I don't want to type dates in to run the query every time I run it. I want the database to compare the Date Recieved field on each...