Recent content by naturalsn

Thank you very much Got it Working...

Good Morning I was hoping someone could please assist. This seems very simple but I get a runtime error 2427 "You entrered an epression that has no value" error the whole time. I have and Option Group call "ApplicationSucc" Yes / No Option group which is bound to a field in my table called...

Absolutely Perfect. Thank you very much

Good Monring I hope someone could possibly assist. I have a report that I am generating with 1 subreports embedded in it. When the subreport has no data , the subreport does not show when I run the main report. Now i know i need data to display the report. But at some stages the report...

Brilliant Thank you very much everyone... SN

Good Morning I was hoping someone could possible assist. I currently have some code. That with a current record on the form. The user can append to a different table. Once user click a message box come up asking Are you sure you would like to "append" the following record, if user says yes...

Thank you very much for both your help. Got is working thanks

Hi I was hoping someone could possibly assist. I have Two Tables TblIntrvCandidates & TblEmpInfo. In the "TbleIntrvCandidates" we have hundred of records of candidates being interviewed and using it for sending document etc. Once a candidates interview was not successfull or experience was...

Brilliant Thank you very much... It worked... thanks Again SN

Good Morning I currently have a form that has four check boxes on it, to allow users to select which report that would like to print with the current record. It is working perfectly but now need need to provide the users with an option to use the the same checkboxes to choose which reports...

Hi Everyone.. Thank you so much for the help It is working PHV i replaced the syntax with the one listed above. And working perfectly... Absolutely brilliant... Thank you very much

Hi bubba yes just did the installation. no change i just recently tested the following DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 If IsNull(Me!DocID) Then MsgBox "Please select a valid record", _ vbOKOnly, "Error" Exit Sub End If DoCmd.OpenReport "rpt1RecipientCopy"...

Hi Bubba Yes Id is on the form. The form is based on the Main table, Pretty strait forward. I have done the steps individually as indicated. Report works fine if i do a normal docmd.print with DocId = " & Me!DocID So it prints the current record i am working with. So this as a test...

Just the primary ID. Yip, on the report but set visible to NO.

It does not like that... Gives me an error, runtime 3464 Data Type Mismatch in criteria expression I used "[Forms]![frmDocTransmittal]![docId]" under the docId Field Removed extra docId syntax. Wonder if that is not because of it being a checkbox and not a combo..