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 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 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...

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...

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

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...

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

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

Hi Guys I need to open the import data dialog box as part of a script, any ideas on how to do this Malc

Hi Guys Can you help I’m building have a excel compiler that creates a set of data to be added to a table in a database on a SQL server, the users can run this at any time the issue I have is how do I insert in to the table from excel using code

Hi Guys Any idea on how i can set the option "Edited Record" on the record locking section on the advanced tab of the Options Menu using VBA Malc

Hi Guys im trying to change a reports recordsource from a bit of code im using Reports!GND37R01.RecordSource = "qrygnd37r01" and i get a runtime error 2451 any thoughts

Hi Guys Has anbody an idea how to open a ms access report from a bit of code i need to write in excel