• WSRainyCity4

    WSRainyCity4

    @wsrainycity4

    Viewing 15 replies - 31 through 45 (of 148 total)
    Author
    Replies
    • in reply to: Entering time in fractions (Access 2002/SP3) #863750

      The customer wants the combo box option rather than typing in the fractions. However, I quickly tested your (Hans) suggestion and it worked perfectly. I’ll use it as a “fall-back” plan if I can’t figure out how to combine the combo boxes into one single data in the column called “Total Hours”.

      Thanks everyone for your suggestions.

      Brent

    • in reply to: Entering time in fractions (Access 2002/SP3) #863751

      The customer wants the combo box option rather than typing in the fractions. However, I quickly tested your (Hans) suggestion and it worked perfectly. I’ll use it as a “fall-back” plan if I can’t figure out how to combine the combo boxes into one single data in the column called “Total Hours”.

      Thanks everyone for your suggestions.

      Brent

    • in reply to: Entering time in fractions (Access 2002/SP3) #860441

      Thanks guys. I am going on a business trip today, but will try your suggestions when I get back on Monday.

      Brent

    • in reply to: Entering time in fractions (Access 2002/SP3) #860442

      Thanks guys. I am going on a business trip today, but will try your suggestions when I get back on Monday.

      Brent

    • in reply to: References missing? (Access XP) #860077

      Good grief. The solution was SO SIMPLE that it was right under my nose.

      For some reason, the main form (in which there are several subforms nestled in it) lost the data source. All I had to do was to tell the form to go to the table that it was supposed to use and it is working again.

      Sorry.

    • in reply to: References missing? (Access XP) #860078

      Good grief. The solution was SO SIMPLE that it was right under my nose.

      For some reason, the main form (in which there are several subforms nestled in it) lost the data source. All I had to do was to tell the form to go to the table that it was supposed to use and it is working again.

      Sorry.

    • in reply to: References missing? (Access XP) #859988

      Just what I suspected. However, why am I getting the error message when it worked just fine last year? Also, what does the error message mean?

      Brent

    • in reply to: References missing? (Access XP) #859989

      Just what I suspected. However, why am I getting the error message when it worked just fine last year? Also, what does the error message mean?

      Brent

    • in reply to: Entering time in fractions (Access 2002/SP3) #859927

      Sorry. I was out of town and just came back today.

      If I split the hours and minutes into two columns, then wouldn’t it be more painful to try to sum up the time? We run a VERY complicated CrossTab Query that separates service types then sum up total hours for each service type a month. I’d rather to avoid modifying the crosstab query because it was a PITA to set up .

      Could we somehow code it so that when we choose hours and minutes in separate combo boxes and somehow merge them and store it in single column called “Service Hours”?

    • in reply to: Entering time in fractions (Access 2002/SP3) #859928

      Sorry. I was out of town and just came back today.

      If I split the hours and minutes into two columns, then wouldn’t it be more painful to try to sum up the time? We run a VERY complicated CrossTab Query that separates service types then sum up total hours for each service type a month. I’d rather to avoid modifying the crosstab query because it was a PITA to set up .

      Could we somehow code it so that when we choose hours and minutes in separate combo boxes and somehow merge them and store it in single column called “Service Hours”?

    • in reply to: Forms collection issue (Access 2002 SP1) #850208

      HansV,

      Thanks so much for your help. It had been a year or two since I last programmed in VBA, so my skills was somewhat rusty.

      Brent

    • in reply to: Forms collection issue (Access 2002 SP1) #850209

      HansV,

      Thanks so much for your help. It had been a year or two since I last programmed in VBA, so my skills was somewhat rusty.

      Brent

    • in reply to: Multi-homed XP (XP SP1) #731983

      Good question. I’ll check others and see if I can find anything different in their routing tables.

    • in reply to: Multi-homed XP (XP SP1) #731982

      Good question. I’ll check others and see if I can find anything different in their routing tables.

    • in reply to: Multi-homed XP (XP SP1) #731974

      That might be difficult because the forementioned videoconferencing calls are actually Video Relay Services…A public service where I go to a webpage and “request” an interpeter via Netmeeting and then the interpreter “call” me via Netmeeting (I don’t know why this has to happen this way) and then I make a phone call. Check out: http://www.usavrs.com if you are interested.

      The biggest problem is that they have a “pool” of interpreters, so I don’t even know what specific IP address I should create in the routing table. Hence, my problem here….I need to somehow to tell my Windows XP to always use my “external” NIC whenever I access Internet via DMZ. What makes this problem so perplexing is that I have already set up 5 machines similiar to mine and all 5 works off the bat without any special configuration. Yet, mine wouldn’t even work the way other 5 machines does.

      Brent

    Viewing 15 replies - 31 through 45 (of 148 total)