Search results

Fixed It ! the code needed Range:="spreadsheet!A1:AA600" after true, It now works, Thanks for all the help & pointing me in the right direction Regards Ian Clegg

Thanks for the prompt reply Bob, I have amended the code as you suggested, I now get the message Microsoft jet db could not find the object spreadsheet$A1:AC85. Ensure that the object exists. The tabs on the workbook are as follows Job progress, spreadsheet,tma,timesheet my code now reads...

Can anybody pointme in the right direction? I need to link or import a spreadsheet into access for processing. The worksheet that I want is on the secondtab in excel and is called worksheet, the firsttab is called JobProgress. My existing code is as follows DoCmd.TransferSpreadsheet acImport...

Thanks Bob for the prompt reply The followhyperlink is just what I wanted, I did not know that exsisted. I can then emil the pdf from within adobe reader to a mail recipient Regards Ian

Can anyone help me with code to open externally saved PDF files from a button on an access formn using VBA. My pdfs are located in a folder on the c: drive eg. c:/jobpacks/a/alfreton/yyy.pdf /b/barnsley/xxx.pdf etc All I want to do is open them and display them on...

Can anyone give me an example of using F3 to paste a value stored in a variable into the current field on my form. I can work out how to use F Keys to display messages but cannnot work out how to paste as in Ctrl+V Regards Ian Clegg

I Find the easiest way is to use docmd.sendobject eg docmd.sendobject acsendtable,"audits",acformatxls,"To email Addres","CC Address etc",,"Subject" see the format in the helpfiles Regards Ian Clegg

Thanks I'll try to do that Regards

Can anyone point me in the right direction, I have an input screen that with my normal working resoloution 1024 x 768 does not all fit on one screen. I thought that I may be able to change it using vba to 1152 x 864. Is this possible Regards Ian Clegg

That was it, leftovers from the trying with the detail section conditional formating Thanks again for all your help Regards Ian

As requested http://www.iccsuk.org/ScreenShots1/ the field I am trying to highlight is the daysleft Regards Ian

Hi I never thought of that, I have never used it before. However I have set the values to field value is less than or equal to 10 set the back colour to red and bold letters It still does not work Am I missing something. Ian

Can anyone help I need to change the background colour of a field in a report dependant on it's value my code is a s follows and it is placed in the detail section in the on format event if togo.value < 10 then togo.backcolor=255 (Red) end if I can make all the records togo foreground...

Thanks The field appears to update but I still get nothing in the field when I look at the table. Is it me? Regards

I seem to be missing something! I have a memo field in a table that I need to update. The update data is in a fom field that is either a text field or another memo field. I have tried updating the recordset by adding the input to a string field and then adding it back but still the field does...

Thanks for the prompt replies I have tried both methods and have still the same problem. On setting true to False & using the suggested routine, I get the message "A program is trying to automatically send email on your behalf. Do you want to do this? Yes/No Help. At this point Yes is not...

Can anyone help? I have a minor problem when sending emails from vba in an access appliaction. The code I use is as follows docmd.sendobj ,,," '" & email address & "' " ,,,msubject,,true My code sends the email ok, however before sending, Outlook displays the correctly formatted email within...

Hi The jobno is numeric eg. 5000005589 and the code is AlphaNumeric eg N573 Regards Ian

Hi Can anyone help? I am trying to identify selective records using vba and sql and am unable to select the correct records using my code. I have a table containing the records fro selection having the fields JobNo and Code which in all records the criteria for selection. The code reads...

I hope that it is ok to post a supplementary question I have compressed the code into the following The parameter is passed to the function by the code behind the form as in SearchArea = recsetip("area")................read record FindCountyName (SearchArea)...............extract areacode...