Search results for query: *

Hi Guys i have this in a bit of code DATEADD(d, - DATEPART(dw, dbo.TimeSheets.Date), DATEADD(d, 2, dbo.TimeSheets.Date)) its returning sundays as the start of a new week not the end of the week (works fine for all other days in the week) any ideas what in doing wrong

Hi PHV This did the trick, thanks for your help Malc

Hi Guys i have a bit of code that loops through a number of rows then looks for the information and changes a bit of data when the selection is not found it errors out with error 91 i have added an error trap but it dont work any ideas Public Sub AddMissingAlpha() Dim strvalue As String Dim...

Hi Thanks for this it works fine now Malc

Hi Guys I have a small issue I'm looping through a very large word document changing certain characters to other characters namely apostrophe to an apostrophe with a carriage return , the code also updates the status bar with progress The issue I have is the screen freezes not updating the...

Thanks Bob shortly after i posted this i spotted this fopar I changed the code all works ok but I get a message telling me that no more can be found do I want to start from the beginning again (Yes NO) Yes being the default, I have tired to hide alerts but as yes is the default I get stuck in...

Hi Guys Im new to coding in word i have an issue im trying to set up a loop that will find a section of text carry out a process, the issue i have is looping until the search text can't be found, I have set the start of the loop to Selection.Find.Found = False, this seems to stop the loop...

Hi Guys I have a merged document that contains nulls each line is a link to a address field Strand Consulting Ltd 50 Essex Street NULL NULL London NULL WC2R 3JF any ideas on how if the the field contains null how i can move the next field in so the data should look like Strand Consulting Ltd...

Thanks guys Reason for two instances is i'm using forms within excel, set to show model false and when the user moved its focus to another workbook the combo boxes created an error Managed to sort in another way (stopped the users moving focus from workbook)

Hi Guys I have a excel spreadsheet that when its opened it needs its own instance of excel have you any ideas on how i can achive this Malc

Hi I have an issue that when a user closes a access database she sometimes get around a 100 apps open up things like auto suggest dropdown, sys fader gdi+ Window

Thanks for your help with this it's saved me a lot of aggro

Thanks this helps is there a way i can tell the state of the record ie if no changes have been made what is its state, i than can add an save button and an if statement to the code above saying if no pending changes end sub

Hi Guys I have a access form that is bound to a table when the users make a change in a field on the form and move to the next field or record the record is saved, the users have asked if this can be changed so they have to click a save button to commit any changes before they can move to the...

Thanks Guys This did the trick for me

Hi Guys I have 980 excel docs in a folder i want to run a script in excel that will open each file in turn copy the file name store the the file name in a list im able to copy the file name and store the file name i am stuck with opening the files from the folder in turn

Have done all pc's have the same settings, this is what i find so odd

Hi Guys we are using version 2003 its a standard custom list i have developer access (i can see in data view as can 40 other users (with read/write access) i have two whom can't) I am the designer error message the list cannot be displayed in datasheet view for one or more of the following...

Hi Guys Im trying to open a list in datasheet view, all i get is an error any ideas

Thanks Sorry its Excel and im trying to set it up for a CSV