Search results for query: *

Ok, please forgive my ignorance and non-technical ability with this. I have started using MQ Explorer for the first time recently. I have a local queue which I use to send a test message.i do this by right clicking on the queue, selecting Put Test Message and then pasting some xml into the...

Ok, please forgive my ignorance and non-technical ability with this. I have started using MQ Explorer for the first time recently. I have a local queue which I use to send a test message. i do this by right clicking on the queue, selecting Put Test Message and then pasting some xml into the...

Hi, a quick question hopefully. I have been reading the installation document for some software that my company deploys. One of the recommendations is to run services and IIS Application pools with the NT AUTHORITY/NETWORK SERVICE user. I have always been told that you are better to use...

I have perform 3.5 installed on Hyper-V machine. If I clone this, rename the cloned machine and give it a new IP - what would I need to change in the DB to get the clone working? many thanks

Hi, We have a server room with a mixture of HP Proliant G3, G4 & G5's in use. I would like to increase the available HDD space on these and wondered what the best solution might be. I can't simply replace the drives with larger ones as all the drives have data on so I have been thinking that...

Hi, Is there a way to remember the current filter settings to reapply them later. For instance, I have Column C filtered by "Tea" & "Coffee" and Column E filtered by "Milk". I want to unfilter everything, but before I do that I want to remember the tea coffee milk filter to reapply it later...

Difficult one for me to create a catchy subject. Basically I have 2 worksheets that look like this: Sheet1: Reference Description SAA1 E001, E003 SAA2 E005 SAA3 E001, E003, E005, E004 Sheet2: Number Xref E001 E002 E003 E004 E005 What I would like to do...

This is quite a difficult one to explain, so I've attached an example. In this attachment there are 2 sheets. The first sheet "To go from this" shows a simple example of what I currently have. It is basically a set of tests which have a high level description (signified by a Y in the HL...

I have a form with a combo field in with the MatchRequired option set to true. Problem is, if you type in a non-match you get an error "invalid property value" which I can't seem to replace with a customer message. I have tried: On Error GoTo ErrFindClick ErrFindClick: MsgBox "Please select...

I'm not sure where to begin with this one. I want to populate a list box with the values from a range but that range has duplicate records in and I only want each item to display once in the listbox. I also want to sort the items in the listbox. I've searched these forums but can't find a...

I have put together some code to a sheet which looks at the value for each active cell in column A and then colours the row accordingly. Column A will be full of products and what I do is colour each product alternately blue and yellow. So what you may have is: A B...

I have some code which whenever a sheet is accessed is copies the contents from a master worksheet and then applies an auto filter based upon the worksheet name. The master sheet is call "All Features" and everything is copied off this. Then the filter code strips out the non-numeric characters...

Hi, I'm having a bit of trouble importing an excel spreadsheet because the sheet name has a space in it. Simplistically this is my code: DoCmd.TransferSpreadsheet acImport, 8, "ID_Latest_Temp_i", "INFORM - Increments Document.xls", True, "All Features!i:i" Now that doesn't work because...

OK, the situation is this: I have an old excel template that we use in our office. In order for the workbooks that use the old template to be compliant it has to be upgraded to a new approved template. I could manually copy everything, but there are many workbooks and many worksheets. I tried...

I have an excel sheet where the "F" column contains order status. Where that order status is "Processed" I want to put todays date in the "G" column next to it. There may be several instances or the word Processed in the F column. So for instance: F4, F7 and F8 may have the word "Processed" in...

Hello, I have a form with a listbox which is populated with the names of sheets in my workbook. I want to have 2 columns, the first is the sheet name and the second will be the value of a cell on that sheet. This is the code I currently have: Private Sub UserForm_Initialize() Dim wbs As...

Please bear with me here, I'm not totally sure what I'm talking about so apologies! I have a program that transmits UDP packets to a single IP address to populate data in a SQL database. I cannot amend this program, but what I need to do is send the same data to 2 identical PC's at the same...

I was wondering if the is a command to delete an individual user account through cmd.exe rather than going to Computer Management? thanks

We have a network which has a mix of NT4/Win2000/Win2003 servers. We have tried synchronising the time on all the servers, but it just doesn't seem to work - we can get the Win2003 synched with each other but the NT machines just won't for some reason. There is no connection to the internet so...

I was wondering if it is possible to do a pastespecial in excel using xlPasteValues and xlPasteFormats? I would like to be able to paste the values (not the formulas) but also keep the formatting within the cells. Is this possible? thanks