Search results for query: *

yeah!!!! I figured it out. After realizing that the 0:00 was *supposed* to be there, I went back to my original excel file that I imported to make the ParticipantListing table. There were a few "#####" where the date was supposed to be. When I clicked it, the date appeared. I imported it...

OK, I'm getting closer. I exported the ParticipantListing table and it had (example): 1/1/2005 0:00 for the [START DATE] field. So I deleted all the " 0:00" and imported it back. Still doesn't work, but I will see if I can find anything else.

I retyped 5 dates in the [START DATE] column for people that are members. When I run the query it still says it will update 0 rows. Anything else I can try?

OK, I tried another update query and took out any "date" references and it works fine. So the problem is with the dates, what do I have to do, retype all the dates? Any way to reformat them or something? I don't even know what's wrong with them, they look fine. Thanks very much for all your...

I have reviewed the values. Exactly what am I to look for? FCSD and [START DATE] both are set to: Date/Time Format: Short Date Input Mask: 99/99/0000;0;_ I scrolled through all the dates, and they visually look OK - is there anything else I can check?

There are over 1700 rows in tblPersonal and over 900 rows in ParticipantListing. 178 of the rows have matching "User" fields. 144 of those are members. Didn't know if that made a difference or not.

Again, thanks for your quick response! That makes sense - wish I would've thought of it. Unfortunately, now when I run it from design view I get 1 blank row in an FCSD column. When I doubleclick it, it says that it will update 0 rows, so I just cancel. Anything else I can try?

Thank you for the quick response! I tried it, and it said it was going to update 144 rows again, I said Yes, but when I check the tblPersonal table, nothing is updated. When I tried it from design view, it lists an FCSD column with 144 blank fields. There are no existing dates in the...

I have the following query: UPDATE ParticipantListing INNER JOIN tblPersonal ON ParticipantListing.User = tblPersonal.User SET ParticipantListing.[START DATE] = [tblPersonal].[FCSD] WHERE (((ParticipantListing.[MEMBER STATUS])=". Yes a Member")); When I run this query, it is supposed to...

oops, I guess I shouldn't have said: or else leave the tblPersonal.LOSD and tblPersonal.FCSD "BLANK" Instead I should have said just not to update that field. Thanks for any help!!

Hi, I have the following update query that I haven't tried yet: UPDATE tblPersonal INNER JOIN ParticipantListing ON tblPersonal.User = ParticipantListing.User SET ParticipantListing.[START DATE]= "tblPersonal", ParticipantListing.[START DATE]= "tblPersonal", ParticipantListing.Email =...

Wow - was I confused ;) Of course yours works perfectly!! Thanks VERY MUCH!!!!

Hi, I'm trying to write an OnExit event procedure so that if the date in the TxtStart field is 01/01 of any year, then the TxtEnd field will automatically show 12/31/ of that year. Or else, TxtEnd field will automatically show the last day of the month/year for the TxtStart month/year. I...

Thank you! Didn't try the GotFocus, although that is a good idea too! The OnExit works like a charm :)

The following works like a charm!! Thank you so much!!! SELECT tblProgramPlan.ProgD, tblProgramPlan.NLProg, tblProgramPlan.NLStaff, tblProgramPlan.STProg, tblProgramPlan.STStaff, tblProgramPlan.WBProg, tblProgramPlan.WBStaff FROM tblProgramPlan WHERE (((tblProgramPlan.ProgD)) Between...

Hi, I have an afterupdate event on a date field that will make the next date field the last day of the month based on the first date field: afterupdate code Private Sub TxtStart_AfterUpdate() Me![TxtEnd] = DateSerial(Year(Me![TxtStart]), 1 + Month(Me![TxtStart]), 0) End Sub Now, I want to...

Hi, I have a query that displays the ProgPlanD (program plan date) that is between a date range in a form. I would also like it to display the previous and next month program plans. The program plan date will always be one row on the first of each month. Here is my query: SELECT...

Did that - thanks - learn something new every day!

Works like a charm! That -1, +2 stuff is beyond me, haven't been able to figure it out yet - but it will come eventually :). Thanks again for all your help, you have been invaluable!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Yes it does! Thank you!!!!!