Search results

Hi, I am trying to replicate the find function that is commonly used within Excel. I have a table that contains reference numbers .. eg: S4589-uzef f45565994-ajfhg F12-546iuhf I want to create a query that will give me the left most characters up until the "-" that is contained within...

Thanks - just what i'm looking for.

Hi all, I'm trying to create a simple message box in VBA, which I have done. I need to get the text that I enter as the message to split over 2 or 3 lines; is there any way that this can be done? I'd also like to have some of the text in Bold? Would this be possible using the message box...

All, I have a simple database that stores values against KPI's. Each KPI is different - and as such can be in different formats (%, #, $ , etc) Is it possible, when querying the data - to have the results of the data represented in the required formats? The data at present is in a...

Thanks for this - I think I was trying it on "On click" but only worked when I actually clicked within the page - and not when I clicked the Page TAB.

All, I want to build an input form for a number of users to capture timings of when activities are complete. Each of the activities are linked to a group, and each Group could have a different number of Activities (Pre defined). The underlying table that I want to populate will be a simple...

All, A simple one I think? I'm creating a form with a TAB control on, within the TAB control I have another TAB control that I only want to see when a certain page is selected. I cant seem to get this to work - using the on click function, but dont understand why? TAB Page: Page 1 TAB...

Hi - The inpact figures are linked to a range and not to each day :( The max impact could also be a negative figure so an impact of -0.7 would be greater than +0.6. Very confusing.

Hi - The inpact figures are linked to a range and not to each day :(

Example attached Sorry guys, Didn't really give enough detail. Brian - you are correct in what you said. Peter - Yes, I want to establish what the max impact would be, by summing each of impacts, but clearly not all of the instances will fall across the whole range, therefore I need to...

Thanks Peter - but this doesn't really give me what I need - this will show all of the data that falls between the 2 dates but no indication as to what the max impact will be (See example above) I may have 100 instances all with impacts between 2 dates, but the maximum impact could be on one...

Hi all, I have a fairly complex (In my eyes :) ) calculation/model that I need to create - and hoping that some one can point me in the best way to get this done. I have a simple Query in Access pulling across data such as below: Ref : 123 Start Date : 01/12/07 End Date : 01/01/08 Impact ...

Hi all, I have a fairly complex (In my eyes :) ) calculation/model that I need to create - and hoping that some one can point me in the best way to get this done. I have a simple Query in Access pulling across data such as below: Ref : 123 Start Date : 01/12/07 End Date : 01/01/08 Impact ...

Hi all, I have a fairly complex (In my eyes :) ) calculation/model that I need to create - and hoping that some one can point me in the best way to get this done. I have a simple Query in Access pulling across data such as below: Ref : 123 Start Date : 01/12/07 End Date : 01/01/08 Impact ...

Was hoping to stay away from that - as I've never used this before. Is't there a simple piece of code, similair to making a form read only, but making the whole Database read only? Perhaps I'll have to delve into the world of User Security!! Cheers, Neil

This would be one way to do it - but then the graphs will still be linked directly into the original document. There must be some code which I can put into the On_Open procedure to automatically say no to this message?

Typical - I am using excel 2000???

Hi all, I'm creating an excel report for distribution, I have got a macro to copy the selected sheets to anoth workbook so that the size of the report is at its minimum. However when opening this report - it asks if we want to update links - ideally I want to turn this off when openning the...

Should be an easy one for you: I'm trying to set my database to read-only within the startup module based on if someone enters a valid password or not. I've got as far as a message saying that they only have read only access but am unsure of how to actually set the database to RO. Any help...

Hi All, I have created various databases - and have always come accross the problem of users having different pixel settings on their monitor and therefor corrupting the size of the database. Is there any way to size the actual database depending on the setting of the individual user at the...