Search results for query: *

Hi All I'm trying to put together a list of Functions and Aggregates within BO 5.1.9 for test purposes. Does anyone have, or can point me to, a definitive list of these ('Abs' through to 'Year')? This is proving harder to find than i first thought! many thanks

More info: The word document is split into sections. There are 3 pages in every section. So I just need to add a page break to the last page in every section. Thanks

Hi all I have a word document that is around 200 pages long. Due to duplexing issues whilst printing, after page 3, I need to insert a new blank page. I need to do this after every third page. So basically I will end up with a new blank page 4,8,12,16 etc... Note, I want to keep the original...

Two different, simple ways. Thanks guys! I feel its time to go home already!

All This is gonna be an easy one for you guys. Background I have 3 textboxes: txtPOV, txtPO, txtPU. Only one of these textboxes will be visible at any one time. Problem I want to be able to click a button, then a msgbox will pop up, showing which textbox is visible at that time. This one has...

Thanks NWBeaver, I'll download and give it whirl! Cheers

Thanks for the response NWBeaver... The date I am after is the date I add a file/folder to the server. So if we go back to my example.. if I created a folder on my desktop on 1st Jan 09, and i added the folder to the LAN server today, then i'd want to see todays date (added to server date, if...

Are you using excel?? If so use conditional formatting!

All I am looking to find the date a file/folder was added to a server. So for instants... if i created a folder on my desktop back on Jan 1st. Then that would be shown as the date 'Created'. If I move the folder to one of our LAN servers today, I want to be able to see todays date...

Brillaint.. thanks for the response guys. Remou that code works a treat. Thanks

Hi I have been trawling the net for an age and cannot find a comprehensive list of all the error numbers, and their descriptions, that can occur within Access. Does anyone have a list or....? Many thanks

Magic... have a star!

Just to add.. I can't close the open DB and then re-open it. Regards

...to run a macro. Public Sub OpenAccess() Dim app As Access.Application Set app = CreateObject("Access.Application") app.OpenCurrentDatabase ("*** Your database path in here ***") app.Visible = True app.DoCmd.RunMacro ("M1") Set app = Nothing End Sub Heres the trick, the access database...

Just for info I have got some code that does take a screenshot and pastes it to the clipboard. Just call the Screendump() function to run or use ?ScreenDump() in the Immediate window. Option Compare Database Option Explicit Type RECT_Type left As Long top As Long right As Long...

Thanks Harley. Back to the drawing board!!

Hi all, I am trying to replicate pushing Ctrl+Alt+PrintScrn at the same time to take a snapshot of my active window. I'm not sure why my code isn't working. I have used the help and logic would say (not that i'm very logical) that it should be correct. SendKeys "(^%{PRTSC})" Is there...

Mr Skip you are a legend. Have a star!

All I have two sheets:- Sheet 1 A B C D Trans Date BG Cut Off Date Visits 29/10/2008 1 08/11/2008 30/10/2008 2 09/11/2008 Sheet 2 A B C Trans Date BG Results 30/10/2008 1 420 31/10/2008 1 2,841 01/11/2008 1 2,499...

Excellent guys. Thanks for you help and time. Regards