Recent content by beetlebailey

Access Table = tbl TTRN Index Access Data Type = Date/Time, Format = Short Date Thanks for all the help.

Neither of the two suggestions are working. Any other ideas ? I am using Excel VBA and a SQL query to tap into Access. The connection and query are woking fine, the query is making it there just coming back empty every time. The problem is breaking the Date field in Access which contains the...

I need advice on how to query an Access database table column named "Date" containing the short date format, example: 9/20/2005. I would like to query based on the day (20) and return the results something like this: SELECT TTRN from ([tbl ttrn index])where day = 20 Thanks in advance.

I am trying to retrieve information from an Access database using the following SQL statement from within Excel VBA. This works fine: Set conn = New ADODB.Connection conn.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & "c:\temp\scelestus.mdb" &...

I am using an Allen/Bradley 1746-BAS basic module. Within it's basic code is a variable in which I want to manipulate. The data is stored in string variable $(0) is 987723605XXXA9347286. Any ideas on how to access this string variable so I can chop it up into 3 pieces. The formula provided by...

Thanks, could you simply explain how this works ? I would like to understand what is happening. Thanks again.

I have $(0) which = 987723605XXXA9347286 $(1) should always be 4 characters: 9877 $(2) should always be the next 8 characters: 23605XXX $(3) should always be the last 8 characters: A9347286 Is anyone familiar on how to break this up and assign a string variable for each new string ? Thanks...

I have a Ethernet device that randomly sends out data. I need to be able to monitor that IP address for activity and store the data, when it become available, to MSSql 2000, Windows 2000 Server. Does anyone have any thoughts/ideas on how to go about accomplishing this ? Thanks much.

The following query rounds off the percentage to the closest whole number like: 96.00% I would like to see the actual value like: 95.59% Any ideas please ? cast(sum(Hour1)/(cast(Tact1 as decimal(6,2))) as decimal(6,2))*100 as Percent1 SQL 2000, Windows 2000 Pro SP4 Thank you....

Please help if you can with the following SQL query. I am using a ADODB connection from Excel 2000 to a SQL 2000 database. If all three testers are present everything is fine and this query works well. But if one tester gets turned off only 2 testers are found by the query and the last tester...

Please help if you can with the following SQL query. I am using a ADODB connection from Excel 2000 to a SQL 2000 database. If all three testers are present everything is fine and this query works well. But if one tester gets turned off only 2 testers are found by the query and the last tester...

DRW = Database results wizard Yes, it's an ASP page. Yes, greyed out comments and stuff. Yes, <% and %> System DSN connection to SQL database Thanks so much for the assistance, Mark

OK, great that works wonderful. The next question is this: I am using DRW to return SQL data to a table 8 columns by 14 rows. I need to read the value of the cell at column 5 row 3 and determine if it's > or < 90 then apply the appropriate color. Am I heading in the right direction and is this...

I am new to FrontPage and need some additional advice. Where would this code go in the page ? What size table is you code based on ? Thanks so much.

I am using FrontPage 2002 on Windows 2000 sp4. I am pulling data fron a SQL server and displaying it in a table containing many cells. I want to change either the font color or background color of a cell if the returned value falls below 90. Similar to conditional formatting in Excel. Is this...