Search results for query: *

Hi Guys I have a list of field names in a value list; I have set a global value to contain a value from this list What I want to do is click a button select the value from the global and use it to go to the selected field Thanks in advance

Thanks Guys this has helped immensely, i can now keep my boss happy for a few more days (whopps i meant hours)

Hi Guys I have a model that contains many sheets (these sheets have various names that do change), what i need to do is move from sheet1 to the last sheet in the model in turn using VBA, something like next sheet Any Ideas

Thanks Guys worked a treat

Hi Guys Any ideas on how i can do this the criteria part of the forumla contains Vanilla and not just vanilla on its own we could have Vanilla IT Vanilla S & S Vanilla and i need to return the result of all these SUMIF(A:A,"vanilla",B:B)

Cheers Guys thanks for your help they work great

Hi Guys I need to find out if the autofilter is On or Not I have tried Public Sub t() Sheets("Effort").Select If AutoFilter.Active Then MsgBox "On" Else MsgBox "Not On" End If End Sub also Public Sub t() Sheets("Effort").Select If AutoFilter = True Then MsgBox "On" Else MsgBox "Not On" End...

You guess right as we want to hard code the server location, saving as web will rely on the user to enter the correct location (mm danger)

Hi Guy I'm new to VBA in Outlook and have been tasked to write some code that will save the calendar as a web page on a file server, and guess what i have know idea how. any ideas Malc

Thanks for this its a great help Malc

Thanks Pampers i tried this yesterday, however the tip stays the same no matter which switchboard you look at switchboard 1 button 1 has the same tip as switchboard 2 button 1 Malc

Hi Guys Does anybody know if you can change the ControlTip Texts within the switchboards depending on which switchboard you are looking at If so how?

Hi Guys Does anybody know if you can change the ControlTip Texts within the switchboards depending on which switchboard you are looking at If so how?

Hi Guys Does anybody know of a way I can stop users from pasting data in to fields (Memo), as they keep pasting carriage returns etc

Thanks lespaul faq181-261 works a treat many thanks for your help

Hi Guys Does anybody have a idea how i can calculate the number of working days between two dates in a query

Hi Guys im getting this error message on one of my users PC's "The query could not be processed: O the data provider didn’t supply any further error information" when you open in data sheet view all the data is there but when you move to pivot view the error shows any ideas

Thanks for your help with this litle issue i had all is working now

Thanks i will try the debug once im in the office Are you sure this has a value? =[forms]![Form1]![ComboGroup] This is a combobox in an unbound form and i select the value then open the SP Is this what you have in the recordsource? midasuser.qstpProjects Yes Is midasuser the database owner...

Hi cmmrfrds I noticed this faux par after i set the thread up and made the change and its still not working I open the form select the value in the combo box then run the sp and get a prompt to enter data Thanks for your help