Search results

OK...so I'm a lame duck.... I have frmComments which has mmoComments. In the AfterUpdate event I have: DoCmd.OpenForm "frmComType", acNormal, "", "", , acNormal Then.................. the user makes a selection from cboComType which is in frmComType. Then in the AfterUpdate...

GMA, OK...I will do my best to explain.... This is a projects db. tblProjects: anProjID, ProjNum, ProjDesc, ProjType, etc.... As time goes on there may be many updates to this project...."Notes" that is by the PM. There is a MEMO field for this...however, that field is limited....not to...

Hello, I have a table that stores a DueDate (date field) and a FollowUpDays (number field). What I'm trying to accomplish is create a report based on projects where DueDates are within 5 days of being due. I'm not sure how to set the query which the report will be based on. For instance...

Afternoon All, What I'm trying to accomplish is SAVE the FORM as a REPORT. I know the form must be closed in order to do so, so I'm using a combo box from another form to pick from a list of available forms. In the AfterUpdate Event the following code runs: (In order to make it work I had to...

Good Morning, Ok..so I'm a dummy...I know several ways of extracting from seperated strings..but I can't figure out how to separate the following: frmBLABLA....I want to remove the "frm" I know I can use "Left(txtFormName, 3)" but that only returns the value...not eliminate "frm". If the...

Good Afternoon, How can I capture ALL reports and have them listed in a combo box? Also, if a new report is added, I would like the combo box updated...can this be done? Thanks.

Good Morning All, I have the following code that will allow me to pull the files out of Windows Explorer and update a table, I want to take it a step further and update the "Modified Date" of those files. Does anyone have a suggestion for this process? Dim dbs As DAO.Database, rs As...