Search results
-
R
Input a variable to a query
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...- rfcomm2k
- Thread
- Replies: 3
- Forum: Modules & VBA
-
R
24 hour time format
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;"- rfcomm2k
- Thread
- Replies: 4
- Forum: Modules & VBA
-
R
data merge
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...