Search results for query: *

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..

Hi Kiwiman, Thanks for your help. I am running 2003 sp3

AAa my apologies the error 438 is Nameing problemsss..ppprrff my apologies There is another problem though.. It is now printing brilliantly. But for every report i click to print. It prints every single record in the DB. I added the "DocId = " & Me!DocID" to the code. to associate the Document...

Hi Kiwiman Thanks for you help... No luck though I now get an error Object doesn't support this property or method (Error 438) and on debug, goes to the first entry If Me.Recipient = True Then etc etch My code is now as follow [code] Private Sub cmdPrintReports_Click() If Me.Recipient =...

Good Morning I am hoping someone might possibly assist I have a very simple DB 1x Table 1x Form 4x Reports In my table i have four yes/no fields that will indicate the required reports to print (with the specific record) I have taken the four fields and placed them on the main form as the...

Thank you Both very much for the help.. I eventually got it sorted.. Regards Susan