Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Roosters

  1. Roosters

    Chr(13) = Carriage Return not working in email

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

    Chr(13) = Carriage Return not working in email

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

    Conditional formatting subform in datasheet view dependant on a parent form value

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

    Conditional formatting subform in datasheet view dependant on a parent form value

    [smile] Answered my own question - thanks anyway
  5. Roosters

    Conditional formatting subform in datasheet view dependant on a parent form value

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

    String to sets the name of a checkbox

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

    String to sets the name of a checkbox

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

    String to sets the name of a checkbox

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

    Open a pdf file at a certain page via vba

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

    Open a pdf file at a certain page via vba

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

    Chart data location changing?

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

    SUMIF problem

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

    SUMIF problem

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

    SUMIF problem

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

    SUMIF problem

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

Part and Inventory Search

Back
Top