Search results for query: *

Hi guys, Bit of a strange one here making me lose some hair, I have a macro in a spreadsheet that compares a list of 2 sets of files to check that all have been processed in both locations this now needs to be done only on files processed on a particular date that is in a column in each...

Hi guys, Just wondering if anyone has any ideas as to how I would dynamically loop through all forms within a project and then open each from a specific list of form names? All ideas greatly appreciated as I am new to VB.NET having more experience with VBA where to perform this I would have...

Hi I have developed a bit of macro code for excel that uses the filedialog object class. This code was developed on a machine with office XP and therefore the Office Object library 10.0 where this class is available. I have now transferred this code to the machine that is going to be using...

Hi guys, I am trying to create some macro code for outlook that will allow the system to open a sourcesafe database and search through the projects looking for files with a particular label. So far I am struggling with the early declaration bits of the code as I can not get the sourcesafe open...

Hi guys, I have got a piece of macro code in Word 2002 that uses the find function to search through a word document to locate a particular instance of a font with certain formatting. The code is going through each story correctly and is finding the font specified on the search form but only...

Hi guys, I have got a piece of macro code that uses the find function to search through a word document to locate a particular instance of a font with certain formatting. The code works fine on documents without textboxes but on any document that contains textboxes and multiple stories the...

Hi guys, Having a bit of trouble with some code I have been doing to allow the user to load up a word form that will then give them the option to enter a document file location. The code then checks through the document in the location entered and grabs all of the fonts that are used within...

Hi guys, I am trying to write a bit of code that will loop through my sent items folder and pick out the task status messages that my system is sending. Within these messages I then want to check whether they have been sent over 14 days previously, if this is the case I would then like the...

Hi guys, Was just wondering whether anybody knows of a way that I can edit one of the forms that are built in to outlook. Specifically I want to use some of the functionality that is on the Task request form to give a Person selector for a group task control macro that I am building. I want...

Hi guys, I am having some trouble getting an Auto macro to run from either the Startup.dot global template or the normal.dot global template. I currently have the following code in the ThisDocument section of either template as a proof that the function is being run. Sub AutoExec() MsgBox...

Hi guys, I am trying to use a piece of code to search through a document to locate where a particular font, size and formatting is used and then put the user focus on this character in the document. I currently have the following code but on my call to goto the object I keep getting a bad...

Hi guys, Been having a look at writing some code to automatically remove tasks from a users task list after they have been completed for a certain period of time. Wanted to check through all tasks in the specific users calender and if they have passed the time period delete the task and send a...

Hi hope someone can help, I have got a number input from a form that should match the number of a printed stationary, these numbers can have preceding zero digits and I cant stop access from removing these preceding digits when it stores the value in the database. Is there an easy way to stop...

I have an active-X RTF control on an Access form, I am trying to use this control to enter an XSL document into the table that is then called by the backend system to transform a particular XML message. The problem I have is that whenever I enter the XSL document into the RTF control and then...

Hi guys, I have created a new database, and a table that I am going to export data to, the problem I have is when I am creating the fields I keep getting a Type Mismatch error Set fld = tdf.CreateField("ProductId", dbInteger) tdf.Fields.Append fld This is the code I have been using to...

Hi guys, I have created a new database, and a table that I am going to export data to, the problem I have is when I am creating the fields I keep getting a Type Mismatch error Set fld = tdf.CreateField("ProductId", dbInteger) tdf.Fields.Append fld This is the code I have been using to...

I have an active-X RTF control on an Access form, I am trying to use this control to enter an XSL document into the table that is then called by the backend system to transform a particular XML message. The problem I have is that whenever I enter the XSL document into the RTF control and then...

I need to output the date field that is stored in the format, dd/mm/yyyy, it needs to be output in the following format yyyymmdd without any punctuation. I have tried to use the format function with the following command, Print #1, Format(rs("ProducedDate"), yyyymmdd); but the output remains...

Hello, I am trying to use a loop to output a recordset to a text file, the data output is processed as it is output and formatted correctly. The output seems to include 8 lines of output for each record, though all I want is a single line for each of these records. Can anyone shed any light on...

Hey I am trying to force the cursor to be shifted to a new record on a subform, the event that calls this is also within another subform on the same parent form. All of these forms are unboud and therefore no parent child relationships are able to be defined. The problem I have is when the...