Recent content by rfcomm2k

Thanks for the tip about using SQL. Here is how I solved it: stSQL = "INSERT INTO [" & TableName & "]( callingparty, dialed, startyear, startmonth, startday, starthour, startminute, startsecond, endyear, endmonth, endday, endhour, endminute, endsecond, hours, minutes, seconds, fname, lname )...

I have code that copies an existing query to a new query. When I created the base query 'ciscoquerystructure' I used an existing table '0901', but I need to have the "new" queries I create from this code select from a DIFFERENT table. (i.e. 0902, 0903, 0807, etc) Look: Dim TableName As...

Solved it like this: stSQL = "UPDATE [" & CiscoTableName & "] SET [" & CiscoTableName & "].dateTimeConnect1 = format(dateserial(1970,1,1) + [" & CiscoTableName & "]![dateTimeConnect]/86400-4/24,'mm/dd/yy Hh:Nn:Ss');"

OK, that seems logical, but where would the appropriate place be to put that code? I tried this: stSQL = "UPDATE [" & CiscoTableName & "] SET [" & CiscoTableName & "].dateTimeConnect1 = dateserial(1970,1,1) + [" & CiscoTableName & "]![dateTimeConnect]/86400-4/24 format([" & CiscoTableName &...

How do I make the output of the following code appear as 24 hour time? stSQL = "UPDATE [" & CiscoTableName & "] SET [" & CiscoTableName & "].dateTimeConnect1 = dateserial(1970,1,1) + [" & CiscoTableName & "]![dateTimeConnect]/86400-4/24;"

A brunette was jumping from one rail to another on some railroad tracks saying "21" each time she jumped. A blond came along and started to play the game too. Suddenly a high speed train came along and the brunette jumped clear of the tracks. The blond was not as fortunate. After the train...

Thanks Grandpa! LOL The data is imported once per month, and the first thing I do after import is to delete invalid records, i.e. records that are incomplete because the daily FTP from the host cut off in the middle of the PBX sending a record. This cannot be avoided, but the loss of 30-40...

It is becoming painfully obvious that I am not an Access programmer, although I am trying. I am filling a need where nobody else has a desire to go. So let me lay all the cards on the table and see what suggestions I get. I have 2 PBX systems on this campus. One is an NEC 2400. It spits out...