Recent content by JasonLiew

how do i add a scroll bar into a vb form?

=) Anyway Thanks Bry. You are indeed a good helper. Btw, do u know how to set the field of a msgbox into hidden field? Example: Private Sub Command33_Click() Dim stLinkCriteria As String If InputBox("Enter Password to enter", "Enter Your Password") = "123" Then...

Hi Bry, I think u have got the wrong idea.[smile] What I mean is : For example I key in "1/12/02" for [Enter begin date] and "31/12/02" for [Enter end date], I want "1/12/02" and "31/12/02" to be appear on the report. I don't wanna capture the result. I...

Hi Bry, I think u have got the wrong idea.[bigsmile] What I mean is : For example I key in "1/12/02" for [Enter begin date] and "31/12/02" for [Enter end date], I want "1/12/02" and "31/12/02" to be appear on the report. I don't wanna capture the result...

Hi all, I have 2 parameter value to be enter at the same time. Eg: [Enter begin date], [Enter end date] My problem is how to capture both values and to show it on report? Any helpers? Jason.[upsidedown]

Hi Dreamboat, Thanks for your reponse. I have used html to link all of them. thank you. Jason.:-)

Hi Craig, Thanks for the suggestion. Where can I put the function Nz(Value, OptionalReturnValue)? [bigsmile] Jason.

Hi ppl, I have a little problem and I need helpful suggestion from you guyz out there. Here goes the question: Can I bind microsoft access, microsoft words, microsoft excel..etc, all in 1 as binder? After that, I would like to Have a page to collect all ther binders. Summary: 1 page that can...

Erm.... hi, Can anyone tell me how to code this thingy? I used 2 different sub-form so it is quite troublesome. I have done something but it only works when ID is enter in both sub-form. ID is an unique key to identify products. If 1 sub-form is left out then it will not calculate. I want...

Hey! It works! Wow.... amazing. Thank you guyz. Me not so good in Access. Thank you.[bigsmile] Jason.

Hi all, Do u guyz know how to search and show dates between dateA and dateB? Does access itself has this function? [sadeyes] Regards, Jason.

Hi Steve, You listed out a good point. It works![bigsmile] Thank you very much. I forgot to set the "Cascade Delete Related Records" option and that hold back the whole program.[peace] Thanks guyz.[thumbsup2] Jason

Thanks alot Steve and Larry, I finally know the function of the "Control Wizards", I have created a delete button but I can't delete my record.[surprise] It shows a message box state that "The record cannot bee deleted or changed Because table 'Part (Fixed)' includes related...

Hi all, I got a problem in creating a button to delete a database record. Do you guyz have any example? Please help.[wink]

Hi mswilson16, I think theres a syntax error. It show a warning: Compile Error: Expected: list seperator or ] Jason.