Recent content by Neil07979

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