Search results

Wow this post was pretty good. i was trying to learn about the coding since i just recently started working on access typical newbie. but man people know about access alot specially salene and keithg. hope to get a job at fedex so then i will be dealing with the mainframe but for rite now stuck...

hmmm superb thanks rural guy i willl go to my office tomorrow and implent. works fine for me on a dummy database i appreciate that.

limiting how? what do u mean by that?

hey guys. sorry to interrupt you. i was wondering if there is a way to put some kind of freeze on a column?. like for instance we have a column by the name of (INVESTORS). and we already have 200 data already entered. but for some reason company wants to create something else which i have...

Thanks alot fonz i got it i appreciate all your help . Thanks gUys

Got it Thanks for your help man,. :)

i did the same thing clicked on ... build sign and code builder and this is what i wrote Private Sub Number_AfterUpdate() If Not IsNull(Number) Then ' this will format the number with leading zeros upto a length of 6, ' increase the no of zeros to increase the size of the number Number =...

Sorry i am a newbie. where am i suppose to type that Event Procedure.?

Hi. i am very thankful for all your help in my other queries for my database. i have one last question and i guess i will be done after that. i have a form which have 3 fields one is Number and the other is group and the next one is Account. all of them are combo boxes. I am trying to add this...

hey Mark. Thanks for replying. my control box name is Number. so i replaced Mynumber to Number and paste it in the after_update box and when i try to enter the numbers in the Number field like for instance i tried to enter 3 digit that input mask 000000 give me a msg that i had to type 6 numbers...

hi. here is the code i typed in afterupdate basically in VB. Private Sub Combo0_AfterUpdate() If Len(Me.[Combo0]) > 5 Then For x = Len(Me.[Combo0]) To 6 Me.[Combo0] = "0" & Me.[Combo0] Next x End If End Sub My textboxname is Combo0. but nothing is happening. i can now enter as many number as...

Thanks bro. i will keep you updated thanks alot for your help.

one more question the input mask still remains the same 000000 in the field or do i have to change it also. Thanks

Thanks abunch dude let me try it and see if i can make this thing work. i appreciate all your help.

i typed this giving me an error or still ask me to enter six numbers. Number: LEN("HELLO")

yes the user enter this in the form. but where can i use that LEN function i am newbie to access sorry. and what is that LEN function

everything is working fine. thanks for the info. The user enters this in the database i guess forms. i am a newbie to access so still trying to learn. and where can i put that Len function?

Thanks alot. i was just wondering if there is any possibility that if a user try to enter 4 numbers the rest of the 2 digit can be fill out by 00 like for instance user enter 2345 is it possible if there is any command that database can automatically fill the rest 2 digit by 002345 thaNKS alot...

hi i was wondering if anyone can tell me a condition or a command in which a user will be able to enter only 6 digit number. like 123456. if he tries to enter 234 the database should not accept. is this possible also? any help would be great. Thanks