Recent content by Malc8179

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