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

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

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

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

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

Hi all I have this code to open up access, using VB in Business Objects, and 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...

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

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

Hi all. I have a Toshiba laptop (8 months old) and this morning it decide not to boot at all. Heres what happens and what i've tried... On boot this appears.. windows boot manager windows failed to start. A recent hardware or software change might be the cause. To fix the problem insert the...

All I have 32 teams in cells C1:C32 and 32 teams in cells E1:32. The ColorIndex of all these cells is 2 (White). So none of the teams are visible. What I want to do is, using CommandButton1_Click(), to change the Colorindex of C1 to 1, then 2 seconds later, change the Colorindex of E1 to 1...

I have had a look through this FAQ along with other posts and can't seem to find what i'm looking for. What I need is to be able to display (on my access form) the part of the status bar that shows 'Ready', 'Design View', 'Form view', 'Run Query ???' etc... Is this possible?

Hi I have been frantically searching the net trying to find if there is any way of finding all .mdb's that have linked to a table in my .mdb called tblAgent. I have to make changes to fields in my table, hence wanting to know if the changes will affect any other queries linking to it, in other...

Quite simply all I want to know is, can you delete a file from a .zip using code? (Note: There will be multiple files in the .zip and i'd only want to delete the ones that matched to my tblzip.) The version of winzip we are using is 8. This cannot be upgraded etc.. So we are stuck with this...

Hi all This a follow up of the thread i started: thread705-1506980 I was given some code by Remou that allows me to open all .doc's in a folder, find an underlined Word, 'strProduct', find a value and add 300 to it, 'strPrice', then save the document with the strProduct and strPrice. I have...

Hi All I have scrolled my way through many posts and can't seem to find what i'm looking for. Being a VBA novice doesn't help as I'm sure I could possibly adapt another post to what I want. Anyways... What I am trying to do is find any commas (,) in the first 3 sentences in my word doc. I then...

All I have some code to detach attachments from outlook express to a folder. Now I would like to take it on a step further. See below example paragraph: This is for a Jambo pack at 4%. Selling to you for $4000. If you would like..... What I want to do, is to be able to open up the...

All How can I stop people creating links from another database to the tables in my database?

After many days and many threads, I still can't get the answer i'm looking for. Is there a way to refresh Outlook2003 using Access2003, without Outlook being opened?

I have a linked excel sheet 'xlAgentsStats' in my database. I regularly append data from my database into this sheet. However the sheet is part of a workbook template. So each time an append takes place the workbook will be saved as another name and the data will be deleted from the template...

All I have a Table 'tblOrders'. Within this table will be 2 fields 'InvoiceNumber' and 'CompanyName'. e.g, CompanyName InvoiceNumber Athlon ATH001 StockShare STS001 Athlon ATH002 StockShare STS002 I will be using a form...