Search results for query: *

Thanks guys, The constant vbCrLF works a treat, problem solved, your relpies are much appreciated

Hi, First of all I'm only a part time user of Access code and would be in huge trouble if not for the help received from you guys here :) My latest problem is with building an email and sending it to Lotus Notes, in short my code is as follows Private Sub cboSendEmail_Click() Dim strEmail...

Ended up using the menu (format - conditional formatting) Exception option, entered my expression pointing to the main form field that contained the varying value and it worked a treat.

[smile] Answered my own question - thanks anyway

Hi, Is it possible to change the background colour of a single field in a sub form in datasheet view dependant on a value on the main form (using the menu option conditional formatting requires a set value that does not vary) Any help would be really appreciated. Thanks Phil

I am slow. Just worked it out, thanks for your help.

Thanks dhookom but I don't understand, I used the Parent reference but Access is now trying to find the field Parent. As I said I am very green at this so sorry if I sound dumb Phil

Very new to coding so take it easy on me. I need to know how to check a mainform checkbox from a double click on a record in a subform. The string below sets the name of the checkbox that needs updating but I can't get the last line of code right. Private Sub txtShift_DblClick(Cancel As...

Perfect - thanks taupirho, works like a treat. Thanks for your help.

Hi All, Just throwing this one out there for any thoughts. Can I open a pdf file at a desired page via vba. Opening the file is easy but to a desired page has me stumped! Any ideas would be much appreciated. Thanks Phil

I have a spreadsheet that has similar data on consecutive worksheets (one sheet for each day) On a "Charts" worksheet I want to change a charts data range from one sheet to another. i.e. in a macro delete an existing chart and then add a new chart of the same name - can I in the code below have...

Hi D32 is text "A" and E332 is 2009 (format is General?) Phil

Hey Skip I have successfully used the SUMPRODUCT in 2003 but have now tried the SUMIFS() in 2007 with no luck. My problem if with the YEAR() part of the Dte range giving me an error warning My formula is =SUMIFS(QTY,Type,D32,YEAR(Dte),E32) Any help would be appreciated Phil

Hi Skip, Works great, thanks for your time. Phil

Hi, Is there a way of finding the sum of a range that has to satisfy 2 criteria with the SUMIF function? I have a list labelled Type - Year - QTY as shown below, I need to find the sum of the QTY column when for example the TYPE is "A" and the year is 2009. The result should be 4. TYPE - YEAR...

Hi Skip, The sheet names with the latest data change some months and that is my problem - if they were uniform I would not have any problem - the position of the sheets remain constant so I was wondering if the sheet can de selected by its position, not it's name? Phil

Here is my problem, I have data sent to me in an Excel workbook at the end of each month (large company) with safety stats for the whole company, from this I extract data to my spreadsheet at the press of a button. I have code written that works fine untill the monthly spreadsheet sent to me has...

Works a treat - Thanks TheAceMan1

Are you able to clear the contents of the clipboard via code? Thanks Phil

I need to copy the contents of a field to the clipboard for use in another application. What I want is the user to click the field for this to occur - this is then used by an on screen phone dialler