Search results for query: *

bmackkc I had a similar experience a while ago now, maybe take a look at faq779-5234 See if this rings any bells with your situation Happiness is...not getting what you want but wanting what you have already got

vacunita Thanks for your guidance (just got back to reading the posts)and havn't actually tried connecting it up yet. Happiness is...not getting what you want but wanting what you have already got

appi I appreciate that I can do it that way, just wanted to build it in the box if at all possible. Maybe I should just try it out! Happiness is...not getting what you want but wanting what you have already got

I have aquired a new PC which has a SATA HDD. I also have a prevous 300gb IDE HDD. The new PC only has one DVD drive and has spare IDE cable slot on the MB. Can I connect my old IDE HDD to the spare IDE slot? will it work or conflict with other hardware? Happiness is...not getting what you...

Hey thanks guys... more solutions for my "dates" library on this one! Happiness is...not getting what you want but wanting what you have already got

ck1999 Doh... No you're not missing something - you are spot on, I am sure that I tried that too! I think it was a case of looking at it too much. Thanks a bundle - now I can move on with some hair still left! Happiness is...not getting what you want but wanting what you have already got

alvechurchdata I have tried DateAdd 365 days but the results are different in the leap year as follows:- Dates in UK format dd/mm/yy for 2006 - 2007 dates (both non leap years) 01/08/06 +365 result = 31/07/07 for 2007 - 2008 dates 01/08/07 +365 result = 01/08/08 I still want 31/07/08 Any...

2008 being a leap year is causing me a headache on a date calculation - any help welcomed. I have a start date to which I need to add a year -1 day days and end with a new date exactly one day prior to the original start date e.g. 01/01/08 to 31/12/08 31/08/07 to 30/08/08 I have tried various...

JerryKlmns Glad someone understands me....thanks for your post, will give it a try and post back result next week probably. Thanks again Happiness is...not getting what you want but wanting what you have already got

JerryKlmns I appreciate the NoData event exists but I would like to check rather than actually call the report itself. The reason is that I have a Parent report with 3 or more nested sub reports, if none of the sub reports have any data then I don't want the Parent report to open. I cannot...

I would like to check from within a Function if a Report has data but not sure how to go about it. My Function needs test to see if the specified report(s) had any data and if not would then be ignored. I assume this is going to require using the Object syntax and I don't know where to start...

fumei Thanks, will give it a try. Happiness is...not getting what you want but wanting what you have already got

Jim Suggest you build a query and concatanate all the address fields in to one column (if thats what you need in the next application) You can then either export the query as a spreadsheet, or, open the query, copy and paste the records in to Excel or wherever. Happiness is...not getting...

Word 97 Template form I have created a form which will open using the "New" event. On the form I would like to add a command button that will open a pdf document (user help notes), the pdf is located in the same directory as the template. Sofar, all I have been able to do is create a...

TheAceMan1 (and PHV for the re-post) Now theres a thread worth archiving & rewarding, I reckon I can put this to good use Custom Properties here I come.... Happiness is...not getting what you want but wanting what you have already got

Thanks PHV, I thought there might be a way of doing this without a table but will gladly accept your expertise here. Happiness is...not getting what you want but wanting what you have already got

I would like to set a Public variable in my application called "LastUpdate" and store the date that an upload took place, this would then be displayed on my Switchboard when the application is opened. The variable value will then need to be updated and stored following the upload of data done...

uberpudge Thanks for your thoughts, I was originally looking to have the formula in the cell but having now seen CautionMP's simple one line solution I am rethinking the need to retain the formula. Thanks to both posts. Happiness is...not getting what you want but wanting what you have...

Sorry - I am using Excel 97 Happiness is...not getting what you want but wanting what you have already got

I have the following piece of code which splits a string date formatted 20070101(yyyymmdd) and attempts to rebuild it in to dd/mm/yyyy 01/01/2007. Range("j1").Select ActiveCell.Value = "=Left(I3, 4)" Range("k1").Select ActiveCell.Value = "=Mid(I3, 5, 2)"...