Hello, I've looked through the FAQ's and past threads regarding conditional formatting, but can't seem to get my sheet working properly. I have a spreadsheet where certain cells are listed as =TODAY(). For example, cell A4 is formatted as =TODAY(), cell A5 is formatted as =TODAY()+1, cell A6 is...
I have a spreadsheet that I'm trying get a count by hour breakdown on. It contains a list of people and their shift times and days worked:
I'm trying to get it to only count those that are working on a particular day (such as Friday). The COUNTIFS code I have works and it calculates the count...
Hello,
I'm looking for a macro that will automatically add a new row(s) based upon values being presented in a set of columns/rows, when the macro button is clicked after pasting the information in the cell ranges. I have a set amount of columns that data can be pasted into. The range of data...
I know with SendKeys that the use of the % sign will process it as "ALT", but is there any way to get SendKeys to actually process a percent symbol as a percent symbol? I have a SendKeys line that contains a percent symbol in the keys it's trying to send, but it's processing as the ALT button...
I have a report with a text control on it currently set to display the date ( =Date() ). I was wondering how I can replace that with information entered into a field on my form.
Example: I have a form with two fields labeled StartDate & EndDate. On my report, I want to subsitute the =Date()...
I have the following code:
SELECT OptionsValues.AgentAssisted,
OptionsValues.CurrentDate,
OptionsValues.Duration
FROM OptionsValues
WHERE OptionsValues.Cable Is Not Null
-- Bigger or equal of startdate
AND OptionsValues.CurrentDate >= '20140421'
-- Smaller...
Fairly new to Access/SQL and have come across an issue I need assistance with.
I'm trying to get a query built upon user input. I have a form with 2 text input boxes. One box is for start date and the other for end date.
What I need for my report is assistance in getting that information to be...
I have a webpage that has a search feature on it. The search feature page is embedded into an iFrame on the parent page. The search page also has the javascript UI Autocomplete incorporated into it. It currently works, but I've come across a few issues as mentioned below:
1. On Chrome and...
Currently I have a webpage that consists of an index.html file. In the index.html there is a framset
Index.html
<frameset rows="9%,75%">
<frame src="header.html" frameborder="0" scrolling="no">
<frame src="body.html" frameborder="0">
</frameset>
In the header.html frame src, there is an...
Currently I have the following script on a page that will refresh an iFrame:
<script>
window.setInterval("reloadIFrame();", 5000);
function reloadIFrame() {
document.frames["marquee"].location.reload();
}
</script>
It works great in IE, but unfortunately it doesn't appear to work in Chrome...
I have another question about using the Userprofile variable in a script. The script is to run a certain file on each users desktop. I have the following in my script:
UserProfilePath = oshell.ExpandEnvironmentStrings("%UserProfile%")
Else Return = WshShell.Run("""C:\Documents and...
I'm not sure if this is a simple solution or not, but I have some code that will open a webpage, but I'm having trouble finding a way to get a new URL to open on a new tab within the same window. Can anyone assist with this?
Enkrypted
A+
This is a general question. I've never had to deal with this yet and just want to make sure the best way to do this.
Our current server (HP ProLiant ML350 G4p) is running a RAID 5 with 4 hard drives. The drives are HP 146GB 10K Hot Swap drives. We would like to upgrade our capacity on these...
I wanted to get some opinions as to whether or not this would be beneficial.
The owner of our company has been asking about having our server moved to a colocation company for reasons of maximum uptime. Where our office is (in rural area), we have experienced several power outages that have...
We recently had to change our IP address. I've contacted our webhost and had them update the records on their end. I double-checked and it does show the updated IP addresses from the changes they made. I believe I have gone through all DNS settings, etc on the server and updated to the new IP...
We have a SBS 2003 server. We also have several websites that are hosted by 3rd party hosting providers. We do have a couple websites that are hosted on our local server.
Will I need to make our local server have an IPv6 record for the websites hosted on it locally?
Enkrypted
A+
We are looking at hiring a new employee in one of our markets. I've never tried to before, but is it possible to remotely cache a new user's credentials on a laptop (already joined to domain...just not with new user info yet).
Enkrypted
A+
We are looking at hiring a new employee in one of our markets. I've never tried to before, but is it possible to remotely cache a new user's credentials on a laptop (already joined to domain...just not with new user info yet).
Enkrypted
A+
We schedule meetings frequently in Outlook. We have several series occurrences setup. As of late, we have been updating the meeting body with certain information. One piece is a table copied from Excel.
After the meeting, the attendees will update the excel table, however they can't send the...
On our website we have a video on the main page. The video up there now is in SWF format. Due to it being a flash based video, it doesn't display on an iPad. I'm in the process of changing that but have ran into a little snag. I have the video reconvert to support playback on an iPad (H.264) and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.