Search results for query: *

Hi, we have two environments, our virtual environment uses Windows 10 1909, Outlook 2016 and several browsers but for this example Chrome v109.0.5414.75. In this environment we are able drag attachments from Outlook to OneDrive online no problem. On our 'physical' environment we have Windows...

Hi, we have a hybrid setup, exchange on prem and O365. I renamed a shared mailbox (and alias) at the request of a user and now the shared mailbox no longer appears for her in Outlook 2016. This is doing my head in. It works for all other users, it works for her account via OWA and via her...

Hi all, sorry if this post is in the wrong forum but was struggling to know where to post it (let me know if I can/should move - this is my first post here in years!). The circumstances: Our Cisco/network engineer left our company last week and I have been left to deal with everything, my...

Hi all, would someone please be able to tell me what code to add to the code below to enable me to change the last letter of every string in column 'L' on my spreadsheet please? This is an adhoc thing for work so don't know much about VBA. This is a .vbs file being called from a .bat file. Very...

Hi - we are looking for a way to 'group' calendars within exchange 2003. This will be used to group meeting room calendars together; This would allow any user when creating a meeting via Outlook to view the scheduling information of all meeting room calendars at once rather than having to add...

Hi, I am trying to run a BIOS update on my Compaq 615 laptop (first time) and the main HP download gives me the instructions below which says that this is used with the SSM program (an HP tool for deploying over a network)- this is the only BIOS update I can find for the laptop, can I still just...

Hi, We use Outlook 2002 on our network and I'm trying to setup so whenever I email a specific email address (contact) that the format is plain text. I have followed the instructions for this i.e. going to the properties of the email address within contacts then changing the 'Internet Format'...

Hi, We have some word docs on our Intranet which when opened have the "Reply with changes" button (the person who created these has since left). Trouble is we now need to change the email address these documents go to - any idea how this is done or even how to create the "Reply with changes"...

Hi, Is there a simple function to return a column range from a number e.g. If my match returns col 11 then I need a function to change/convert the 11 to N:N. Is there such a function? If VBA is the only way - don't waste your time as I need this as part of a larger formula. Many thanks.

Hi, How can I do a vlookup (equivalent) but return multiple entries e.g: Value to search for is: ACQ Col A Col B ACQ 22 BBD 31 CCF 55 ACQ 44 The result would be the following list: 22 44 I need to use formulas for this not VBA if...

Hi - hopefully this should be a quick one: I have one Combo box (chosen from the Form toolbox) in my excel spreadsheet - all I want to be able to do is get the value chosen from the combo box by using the formula/Function area (not having to use the likes of Index, Offset etc) something like...

Hi - I am trying to write a piece of SQL within ASP to bring back a recordset and keep getting "Page cannot be displayed" SQL is below: SQLOpDetails=("select * FROM OperatorDetails_tbl, Manager_tbl INNER JOIN Manager_tbl ON OperatorDetails_tbl.ManagerID = Manager_tbl.ManagerID WHERE...

Hi, I am trying to setup a basic aggregate query which will give me the average of all the times in my table. My first query looks at the base table which has a column which contains dates and times e.g. 07/03/2007 13:50:44 and then formats them to long time format like this...

Hi, Can someone show me how to do a loop so that I can assign recordset field name values to variables please (using classic ASP)? I have a recordset called rsChecker and I want to loop through it to create the variables like I have done manually below: varRecSet0 = rsChecker(0) varRecSet1 =...

Hi, Need some quick help - trying to do what should be very simple. I have a form in access with a text box and a button, when clicking the button SQL updates a table with 1 field (in date format) - it goes in as american date - I can't get British date format!! SQL: sql = "update...

Hi, I have a module which opens a simple select query called "Duplicate User IDs" and I want to check if it returns an empty recordset or not. Ok simple enough using SQL and a recordset but I don't want to have to use these (I have my reasons!) - I want to stick to using docmd's and the like -...

Hi, This should be simple but I'm having difficulties. I have a simple update query with a text field in it, I want to add a little VBA so that if the field (called [Product]) contains text that begins with a comma "," then it will remove that comma and only that comma, completely. Thanks...

Hi, I have the following code written in Excel which calls several queries from Access. It works fine until I call a query which contains a criteria - and by this I mean a criteria which is pre written in to the query not one which requires the user to input anything. Can someone show me where...

Hi, Our Intranet uses ASP, with the File System Object to display specific folders and subsequently excel spreadsheets. This has worked no problems at all for months - a few days ago our web server went down and we recieved the message "cannot display page" whenever accessing the Intranet...