Search results

Something strange must be going on with it... Thanks for all your help.

Well...i didn't last too long. It seems that my code is not working at all... Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tblDateCycleTestingChanges", dbOpenDynaset) With rs .AddNew ![CycleTestingDatesID] = Me.CycleTestingDatesID.Value ![ClientID] = Me.ClientID.Value ![ProjectID] =...

Thanks. I will try that... Hopefully I will make it...

Hello. I'm building a history table to keep track of some changes that occur on one of my forms. Here is what I'm using to build my history table: Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tblDateCycleTestingChanges", dbOpenDynaset) With rs .AddNew ![CycleTestingDatesID] =...

Thank you for your post! I appreciate all your input!

One more question I'm still working on this issue...and it is very frustrating. :( I have found a copy of a database where you can import MicrosoftProject into a list in Access (database attached). What I'm wondering if there is a way to make modifications to those dates in the list (see...

Thanks, I will try that.

I still need some help on this... What I want to do is eliminate MS Project all together... I looked at the thread that WayneRyan posted and after playing with that I realized that I don't want to deal with MS Project at all (no combining the two together). Now, I have a dilema however. I have...

I’m wondering if there is a way to incorporate Microsoft Project and Microsoft Access together. I have a database for projects and I also have a project plan created in MS Project. Rather than having to type in Start/End date for each and every task into my database (which will be a lot of...

Is there a way to code something that will say do Undo All changes. I have a button called Exit without changes…and I would like to be able to undo everything that a user has just done on the form. Thanks.

I think I will do that... Thanks for all your suggestions.

I could, I guess... I have a lot of code behind that button and also, I would need to place this code in 2 different text boxes. Just thought may be there is a way... Thanks.

I have a form on which I have a button that I want the user to click after a cetrain field on that form is updated. I display a little pop-up box saying to make sure that a user clicks on that button. Is there a way to know that this button was clicked? Is there a way to not proceed with...

Ooops...thanks!

I'm trying to create a varible in my Query which would hold a sum. I'm using the Nz function and as soon as I hit a number that is blank, my whole total goes blank. Here is what I'm using...

Thank you for all your posts! I didn't even think about users missing references to the ActiveX calendars. Will definetly check out these custom Access calendars! Thanks!

I have a form on which I have a little pop-up calendar which once clicked updates a date field on a screen. I have an After_Update event for this date field, the problem is that even though the date field gets updated with a date selected from a calendar, the After_Update event isn’t triggered...

Thanks, this does help!

I have a date field in my query and what I want is dates that match Now() + 14 days (doesn't matter working/holidays). Is there a way to put DateAdd function of some sort in the criteria for this field? DateAdd("d",14,[Date]) may be? Thanks!

I didn't know there was a rectangle button, but now that you mentioned it, I found it, thanks!