Search results for query: *

I have a field of data that looks something like this: C320-EB-17-SOME NAME I need to extract just the part that is SOME NAME. In Access I'd use INSTREV and search for '-' then do a left function from that point. The data is variable so I can't just count on SOME NAME starting at the same...

I want to look up one value in sheet1 that will have a matching value in sheet2, I have to walk through each cell value and highlight matches. Here's my code: Application.VLookup(Range(myRcdA).Value, Range("A3:D535"), 3, False) Range(myRcdA) will have data in sheet1, I need to match that to...

Is it possible to create a batch script or some other script to look at a web page with links within the page, open the link (link is to a file for downloading) and have the script automatically put the linked file (zip file, excel, text, etc.) somewhere on your harddrive?

Anyone have an example of doing something like this? I have a form based on a table which relates to another table (subform holds this info) that I want to be able to select a check box and return those selections inthe main and subform to a seperate temporary table. I don't know if I'm being...

Is it possible to have excel change the format of one cell based on what you enter in another cell? Say I wanted to automatically have excel format bold fonts if I enter a number in an adjacent cell greater than 100 as an example.

Has anyone noticed if databases which link into a main database will cause the processing of updates/changes to the main database data to become degraded?

Hi, I am wondering, I have NAV corp edition running on a win2K OS. If NAV keeps quarantining different virus files but not cleaning them and I've run symantecs FixMumu.exe program on the machine and its report says there are no viruses on the machine and the NAV is constantly scanning, is the...

Is there a way to list all the tables a user has access to without knowing their names?

I have a form I'm trouble shooting, (it's lenghty), After a user selects a check box they are prompted to enter a date in a text field. I check the value of the text field with an onBlur event to make sure it's a date but if the user hits the return button the form posts. I have removed...

To get a users first name and last name I used : dim UserName, User UserName= Replace(Request.ServerVariables("LOGON_USER"),"\","/") set User = GetObject("WinNT://" + UserName) I could then set a variable to User.FullName but our Network group moved the...

I have a mail application that mails fine on one intranet site but gets a Microsoft VBScript runtime error '800a0046' Permission denied error on another. The second site uses a host header to point to the site directory. How can permission be denied if it is sending from another site on the...

I have written an asp page that outputs data from a database into an excel spreadsheet using: Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "filename=mydata.xls;" I want to format the cell widths so the width is as...

How can I enforce NTFS permissions but not have a prompt come up for those users that I've granted access to an application? I've turned on challenge/response (IIS4.0) and added user_group to the folder permissions allowing read access/permissions. We run on a NT WAN which requires a login...

REWebb, How can I enforce NTFS permissions but not have a prompt come up for those users that I've granted access to an application? I've turned on challenge/response (IIS4.0) and added user_group to the folder permissions allowing read access/permissions. We run on a NT WAN which requires...