Search results for query: *

I'm using Windows 2000 Server IIS ASP and I'm attempting to display a picture via an vbscript/ASP of a Blob image in SQL Server 2005. Below, is part of the code (the important part) that I'm using after reading up a bit. Unfortunately, I'm not getting the Blob image in one of our Vendor's SQL...

In MS Word 2000, I've added a text form field. Then, I gave it "Date format" setting of MM/DD/YY. Now, based on the Date that the user enters, I would like to create a second field that automatically populates the day of the week based on that date (Mo, Tu, We, etc). Any ideas?

I have to input hundreds of streets in the following select expert formula: {DataWarehouse.Address} like "*" & "S MAIN" & "*" or {DataWarehouse.Address} like "*" & "BELLEW" & "*" or {DataWarehouse.Address} like "*" & "JEFFERSON" & "*" Instead of coding out each "or" line is there an easier way...

When any user logs into a computer at the office, the user may wait one second to several minutes before the computer starts to log in, which is very frustrating. However, if the user logs into the same computer after someone who has their Power options set to "Never" for "turn off hard drives"...

The database that I'm pulling from using one field for the address (Ex. 123 S Main St.). I was able to strip out everything before the space, which was 123 in this example. Unfortunately, garbage in garbage out. In this new field, I can see for following for a digit field: 123 123B 123-Blk...

I'm looking for a formula to give a time difference with two criteria. For every row that is GOOD, a time difference rounded to a second with post. However, when a "TIMEOUT" occurs, the time difference, rounded to the second, will be the difference between the first "GOOD" row and the next...

I'm looking for a formula for a query that will subtract the time in seconds when comparing one row to the next row. For example, here's the time 1 08/10/08 09:08:07 2 08/10/08 09:09:00 3 08/10/08 09:09:37 4 08/10/08 09:10:45 and I would like to see the amount of seconds like this...

I have a batch file that produces a line of date/time that looks like this: Sat 08/30/2008 17:30:51.09 Sat 08/30/2008 17:39:28.25 Sat 08/30/2008 17:57:39.57 In CR8, I want to show how many seconds (rounded off to one second) it took for the next line. Thus, the report would look like: Sat...

I have data in two databases with similar data that I want to combine (one is for employees alone and the other database is used by clients). Although each database has similar fields, they are not exact. Database1 has a a case_number format like PD07001001 (based on julian date in the...

Here's what it looks like: EventID Code comment 1 James billed ? 1 James billed ? 1 James spoke with ? 1 James billed ? 2 Dan billed ? 2 Dan spoke with ? 2 Jeff billed ? Here's what I want. I need suppession of Code field...

I'm still using Access 97 and saw something the other day that I would like to use that was in Access 2000. In an Access 2000 database, there was a .mam file in a directory that launched the Access 2000 program and ran a macro. How do you set this up? Can it be done in Access 97? If so, how?

I have an outside vendor that just updated there web access to aspnet on a Windows 2003 server. Just before the new install, I had a separate Windows 2000 server with IIS 5 that I used to tap into the vendors database and then spit out a hyperlink that pointed directly to their web server...

I have a hyperlink formula that calls up a web page. Is there a way to have the hyperlink bring up the linked page in a new browser window? TIA

About 4 years ago, my IT department set up my server for CR8 (Licensed as CR7, then CR8 profession upgrade). The employee that set it up is gone and the new employee can't figure out the following even after looking at the manual. Anyway, I have CR8 working, but I use Recrystallize to create...

Okay, I'm missing something here. #1 - Did I set up the "datstring" correctly to define exact time 24 hours ago within a SQL Server 2000 database? #2 - If so, should I use it in the WHERE clause differently? datestring = DateAdd("h", -24, now()) SQL = SQL & " Where CallReceivedTime > '" &...

I have a Crystal Report that has an address field. Within that Address field are the digits, a street name and then a street type. However, sometimes a free format can be used (i.e. Main St/1st St, Taco Bell, Garage area of 123 Main St). Anyway, I need to find a way to take away for numbers in...

I have a Report section that prints out about 3 lines of text. The next section is the Details area and the last is the page footer. Here's the problem: If the details section is less than one page it prints out fine. However, if the details section results are several pages (one field can...

I have written most of the easy ASP portion for a MS Access DB insert. In the database, I have about 15 checkboxes in it. Five of them represent a point total of 1 point, 5 of them at 2 points each and 5 at 4 points each. Over time this database will get quite big. In the database, I will...

Within the database, an intersection will appear as S Main St&First St& or 3rd St&Abel St&miscdata . I need to make the true intersections like S Main St&First St Thus, how can I strip off the last & when & is the last character? Thx

I have an Access 97 DB called employees.mdb within a NT security type folder. Most users only have read access (Everyone to read only in Security settings of folder). Other users have write privileges to this document to make updates (Managers to change in Security settings of folder). This...