Using an afterUpDate event

[jwbrickner87]

I have a textbox in a form. I need some code that will cause the following to happen.
1. When text is entered and a button is pushed I need it to find an entry in a field that matches what was typed in the text box. I then need it to check a check box in a yes/no field that is on the same record as the entry entered onto the textbox. does this make sense? Also the field that is checked yes will depend on what date it is. I need it to check in the field that has the current day's date. And if possible I would like it to create a field for the current days date if one doesn't exist. When the field is created it would use the date as the title for the field.

 

[uplink600]

Spend about 10 minutes thinking about this problem carefully and then realise that computers, and especially databases are a stressful waste of time. Then go out and get blind druck on Jack D's and screw a prostitute, (if you're a male that is).

 

[WayneRyan]

jw,

The last solution may be a last resort. But first, can you try posting
a sample DB here? It will make it much easier if the problem (and
table structures) can be seen.

Just Tools --> Database Utilities --> Compact/Repair
ZIP into a file
Then attach.

Wayne

 

[jwbrickner87]

Here is the example DB

Wayne-
Here is the sample DB. When you open it go to the form named: record. In that form there is an explanation of how I would like it to work. Thanks for help.
JW

 

[WayneRyan]

jw,

See rock's efforts on this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=70023

Looks like you and he are gonna have to work this out yourselves. I had
just posted your DB when I saw rock's post and had to DELETE it.

Good luck, I appreciate it that you gave it a try, but I can't do your work
for you.

Wayne

 

[livin4rocknroll]

Please repost the DB There has been some confusion

Wayne,
jwbrickner87 and livin4rocknroll are the same person...me! I just posted under a new name to see if I could get anyone elso to look at it. I am by no means trying to have you do my work for me and I really appreciate your help. Sorry for the confusion. Could you please repost the databse you deleted?

 

[Pauldohert]

Wayne - can you explain the problem with this? as I don't understand whats gone on here?

Is there some suspected skullduggery?

Thanks Paul

 

[WayneRyan]

jw/l & Paul,

When you see the same DB posted under two different names, you just
have to think that it's just a school project.

I just don't understand the "two different techniques". JW is a go-getter,
asked a lot of questions, and wanted to learn.

L, on the other hand, just said: Solve it.

I can't remember the specifics, but the DB should enter a new ROW for
each Attendant. Since (other than the attendance), there's nothing to
add, I displayed it in a ListBox.

Anyway, the DB posted should help you get started.

Wayne

 

[WayneRyan]

Been a Loooong day ...

Wayne

 

[jwbrickner87]

Thanks for help

Thanks for your help. Your example database gave me alot of ideas on how i can improve mine. You are a very smart person! Keep up the good work and tghanks again.