Search results

First of I would make general query to pull all the field you need plus the FK one. Then Build a form to display it how you want it look and use the your new query as your control source. This form would include all task for everyone btw. Now that you have a general form and query you can now...

Ok.. I just took a look at your DB and DCrake is right your DB is very denormalized. Yet lets try to figure out what you want to do with having to rebuild your tables. So let me get this right in my head. You want to pull all 6 tables together in one query. then from that calculate all the...

Take 2 DBs and call me in the morning.. lol

woot!!! :D:D:D:D:D:D:D:D:D Thank You!

I don't know how your tables are setup but here you go. You can add a field to you table work_database that tell which user is assign to that task by using your user table PK and then setting up a relationship between the two fields.

I'm running Windows 7 also and it does the same thing. Windows 7 like to group/stack the applications icons. So even with custom Icon it sill falling under MS Access application.

Well I started off in the I.T. Field and did that for about 6 years. I when back to college to get my B.S. and I have been programming ever since. That pretty much it in a nutshell. After college I found that I like being in the field with databases. Don't really matter what kind.

Might be a little late on this but seem to me your syntax is a little off. Try doing it like this. If txt1.Text = ("Scott_Atkinson") Then response = MsgBox("83 new hythe lane, Larkfield, ME20, Kent") ElseIf txt1.Text = ("James_Ludlow") Then response = MsgBox("27 Tonbridge road, ME17, Kent")...

Well I found this site about 2 months ago when little after I started my job. I was new to MS Access but not new to programming. While I come from a back ground of doing mostly MySQL DBs and PHP/Java I found this site with a wealth of information not just limited to MS Access. I'm glad I can...