Posts by HELPHELPTHANXS

okieokie....thanxs alot!!

From my understanding, this the codes to type when you want to select a range of cell:
Range("A15,B15,C15,D15,E15,F15,G15,H15,I15,J15,K15").Select
But how to type codes for case like:
You set 15 above to be a variable known as i that will be changing most of the time.
Range("A'" & r1 & "', B'" & r1 & "'").Select --- i wrote this but when i run i met a run time error saying: Method 'Range' of object'_Global' failed.
Anyone know and can correct me?? really gratefully if you could help me...thanxs

Realli thanxs a lot A9192Shark and gollem!!! it's realli very helpful. (",)

1st form - User Login Form
2nd form - Change password Form

Is it possible to retrieve User Login Form control values when coding for the 2nd form???? How to go abt do it???

thanxs alot...if anyone could help.

Thanxs alot WillR and norie for ur help!!! It's the way i construct my string.

MY insert statement keep giving error. Anyone knows how to slove this can help me?? thanxs alot!!

MY insert statement:

Str = "INSERT Into TBL_RegionSubRegion (SubRegion_Code, SubRegion) " & _
"VALUES ('" & create_subregioncode & "'," & _
"'" & Forms!CreateSubRegion.CCSR_CreateSRtxtbx & "' WHERE Region_Code= '" & Forms!CreateSubRegion!CCSR_regionlistbx.Column(0) & "');"

Thanxs Maqbool!!

can i ask another question:
Is it possible to track wat menu item the user click from a custom menu bar??
if it is possible how to go abt implementing it or wat codes to insert to carry out this action??

Hi,
I further explain the problem.....

I have a custom menu bar that has a menu option called "Adminstration". When a user click on this menu option, user can choose to click on create UserID or to delete UserID. I need to pick up the value of whether the user wants to create or to delete UserID so as to check against my database whether she is authenticated to do so.

Cos only some can create UserID may not delete UserID and some can delete UserID may not create UserID.

Thanxs alot Maqbool!! It did help me alot

sorry, norie....tat's is not wat i meant. Apologize for me not meaning clear enough. i'lll try to explain my problem again.....
There is a button named "product" on a form, then when a user move his cursor and place it on the button and immediately a drop down menu will appear for the user to pick a product for example "clothes" to go into. Is MS access 2000 able to do such a thing???
IF it is possible, can you show me how ???

hi, james Skeggs....thanxs for the reply.
"On Mouse Move"......would you mind to provide me with an example? cos i'm still a beginner at MS Access 2000....thanxs alot!!!!

Hello,
Similar to that of a Web based application, Point to a btn with a drop down list appears using Microsoft Access, is it possible??

if it is possible, can you teach me on how to go about doing it, please thanxs alot !!!

Hi Hi..... i have a problem, can any kind soul help me??
heehee thanxs!!

My problem is: i need to type vb macro codes in excel to search whether this 3 characters "SIN" is in the beginning of a string. Ermm..is it got to do with LIKE operator....heehee...if not ermm...then how :P??

yes.....Gollem...you are rite....okieokie....i know how to do already thanxs alot!!!

How do you filter the worksheet based on 2 conditions: the length of one column for e.g col A and another column
for e.g col K = ""?

Sorry...Due to some changes required, my prob need to be changed slightly

Thanxs lasw10....Sorry to trouble you
i have attached the current worksheet and the 'After' worksheet. i need to type vb macro scripts to transfer the current worksheet to the 'After' sheet. this transferrring is done based on a criteria the length of route Desc = 9 of column A in the current worksheet.
The unique keys in the 'After' sheet are the route Desc, Flt No. and Day Code.

Hi, i have data from row 5 to 43, (i am using excel vb macro to program ) i have a prob transferring data of Column A(Route Desc), Column B(Flt No.), Column E(RteFltDOPSequence), Column H(Sequence) and Column I(SUDRev*) from row 14 to 22 and row 32 to 43 from the current worksheet to a new worksheet.this transferrring is done based on a criteria the length of route Desc = 9.

The new worksheet to be displayed in this format:

Col A route Desc
Col B Flt No.
Col C RteFltDOPSequence

Col D Sequence
Col E SUDRev*
Col F(a new column to be created) Leg Rev

*The data here in the new spreadsheet to displayed based on the Sequence for e.g the first row to displayed all data that is sequence value 1st Leg.