Input Values from Textbox cannot be tabulate

[edisonl via AccessMonster.com]

Hi,

I have this Accesss application that run well with all computer in the
company except for this particular one.

Problem rises output generated base on Text Box controls was dissimiliar from
the rest of computer.

Eg: What I want to achieve is to round up timing to half hourly
totalhours = DateDiff("n", [starttime], [endtime]) / 60 'In hours
totalhours = CDec(totalhours)

How I did was>>

if(starttime_text < "10:00" AND endtime_text > "10"15")then
totalhours = totalhours - 0.17 ' 0.17 = 10/60 round
2 decimal
if(totalhours < 0.5 and totalhours > 0.1)then
totalhours = 0.5
endtime_text = 0.5
exit sub
EndIf
EndIf

All but 1 computer was not able to offset break time round up by half hourly

Regards, Edison

 

[John W. Vinson]

I have this Accesss application that run well with all computer in the
company except for this particular one.

This appears to be the very common References bug. Open any module in design
view *on the affected computer*, or open the VBA editor by typing Ctrl-G.
Select Tools... References from the menu. One of the .DLL files required by
Access will probably be marked MISSING. Uncheck it, recheck it, close and open
Access.

If none are MISSING, check any reference; close and open Access; then uncheck
it again. This will force Access to relink the libraries.

 

[edisonl via AccessMonster.com]

Dear Vinson,

I tries to view my application in VBA editor, tools> References, scroll down
3 time and found now
missing .DLL file though.

Persistence of the previous mention bug unable to tabulate text box input
still exists.

Regards, Edison

 

[John W. Vinson]

Dear Vinson,

I tries to view my application in VBA editor, tools> References, scroll down
3 time and found now
missing .DLL file though.

So is it fixed now? NONE of your code will work until it is. You should not
have any references checked unless you're actually using them - normally there
will be just three to five checked (Visual Basic for Applications, Access
<version> Object Library, either Microsoft ActiveX Object Library or Microsoft
DAO <version> Object Library, and perhaps OLE Automation). You can add others
IF you're using external programs in your VBA code - if you are not doing so
intentionally you probably should just uncheck the reference and compile to
see if anything stops working.

You should Compact and Repair this database and use Debug... Compile in the
VBA editor to be sure that there aren't any other code bugs.

 

[edisonl via AccessMonster.com]

Hi Vinson,

Not at the moment, will try to compare references, for additional checked
boxes I reckon it would be of not much impact, isnt it ?

Nonetheless I will sort it out.

Regards, Edison

 

[John W. Vinson]

Hi Vinson,

Not at the moment, will try to compare references, for additional checked
boxes I reckon it would be of not much impact, isnt it ?

The checked boxes should all be at the top of the list. If any of them are
marked MISSING your code will not work. That box must be either unchecked or
the link must be repaired (you may need to install or register the .DLL file
referenced).

 

[edisonl via AccessMonster.com]

Hi John,

There isn't any Missing indication in the top listed boxes as you had mention,
However..

I go to editor> help>> About Microsoft Visual Basic I got version 6.5,
version 1024 where my other user got Visual Basic 6.3 Version 9972.

How do I go about update this version thingy ?

Regards, Edison

 

[John W. Vinson]

Hi John,

There isn't any Missing indication in the top listed boxes as you had mention,
However..

I go to editor> help>> About Microsoft Visual Basic I got version 6.5,
version 1024 where my other user got Visual Basic 6.3 Version 9972.

How do I go about update this version thingy ?

AHA! That's probably the problem.

Make sure both users have the *same version* of Access, and have applied all
the service packs.

 

[edisonl via AccessMonster.com]

Hi Vinson,

I just got it done, its about the Regional setting, time format
Wrong>> h:mm:ss:tt
Right >> hh:mm:ss

I just got it changed..

However one thing I don't quite understand, Why is it that for time format hh:
mm some user need to key in right arrow to input second digit
Eg: Desired input>> 15:30
From 1 to 5 required 2 keystrokes instead of key in 1530 continuously.

Regards, Edison

Hi John,

[quoted text clipped - 5 lines]

How do I go about update this version thingy ?

AHA! That's probably the problem.

Make sure both users have the *same version* of Access, and have applied all
the service packs.

 

[John W. Vinson]

However one thing I don't quite understand, Why is it that for time format hh:
mm some user need to key in right arrow to input second digit
Eg: Desired input>> 15:30
From 1 to 5 required 2 keystrokes instead of key in 1530 continuously.

No arrow key should be needed. Is there any Input Mask on this field?

 

[edisonl via AccessMonster.com]

Hi John,

Yes Input mask 00:00, most of the pc are doing fine except few of them..

Regards, Edison