Recent content by jokelogpop

Hi erverybody! I have a problem with access 2003: When I open a file in access 2003, a poup alarm that there is a unsafe code.... and ask " Do you want to OPEN?". I click YES but my database still close. Access 2000 open it normally!

Hi SJ McAbney! I search in the assistance and find the result here! FormatConditions, FormatCondition Object Example The following example adds a conditional formatting to a text box, "Textbox1" and sets some properties of the newly added FormatCondition object. With...

Hi everybody! I have a truoble! Anyone can help me?? I want to colorize a record of a tabular sub form when I has just updated it or find it from a table! Thanks all! :)

Hi pbaldy! I understand what you explained but I cannot apply for a List Box. My code is: Me.RecordsetClone.FindFirst "[fldNumComp] = " & List_NumOfComputer & " And Not Isnull([FirstTime]) And Isnull([SecondTime])" List_NumOfComputer is listBox name. I think the value of list box will be...

Thanks you one more Pbaldy! Yes, It is Nomatch not Notmach. Now it work well.!! I am sorry! I have a tupic question. I don't understand the functions of two symbol & & in the code you wrote. Me.RecordsetClone.FindFirst "[fldNumComp] = " & NumOfComputer & " And Not Isnull([FirstTime]) And...

Yes, this is possible using the following details and design - If you are storing your Flash movie clip in the same directory as the database you can try the following: With your start-up form in design mode, go to Insert >> ActiveX Control. From the list choose Shockwave Flash Object. Open...

Hi! I think I may put 50 pictures like 50 buttons in a List Box?? How do you think about this idea? Can I do that??

How can I put 50 Toggle Buttons of a Group Option on a small form??? This is my question for all. I have 50 options for my users and all of them must be put on a form. how can I do that?? I know the List box is the suitable choice but I want Buttons instead of texts like ListBox. I expect your...

Thanks Pbaldy! How should I thank to you!!! It work very well. But I don't know how to put it to the If ... Else. My idea is that If the action find the record, it locate here_it is OK, Else, the other action will create a new record! (I know how to code to create a new record. If you know how...

Hi!! I am trying change the the Variant into Interger but it still has error. Can I use Me.FrameToggle.Value? When I use this expression, I got the error: It is seem that the [fldNumComp] condition accept only number value ex. "[fldNumComp] = 2 And ...". How can I solve it.

HI all! I have this code: Private Sub cmdGoToBlkRecord_Click() 'Find Blank Record Acording to the number of Toggle Button. Dim NumOfComputer As Variant NumOfComputer = FrameToggle ' Dimention the value of Toggle button MsgBox "The Number of Toggle is NumOfComputer " ' I want to search the...

Hello to all Access experts, Can someone tell me how to put and code a "Find Record" Group Option on a form with some other conditions? The problem is here: I have a Table: tblComputerManagement with Field: Field_ID , Field_Date and Field_Null And a Form linked to tblComputerManagement like...

Hi !! I wan to find a record that has ID field =1 and Day field = day() and ....

Hi all! I want to use a VBA to search a record with many conditions. I am a beginer, so I down know there are any way to do this? May I use a query? First I thinks the query but I do not know how to use a query with my variations. Does anyone help me. I thanks very much! -- Minh Hien--

I want to ask everybody 2 questions: Q1: Can I use Flash as a background of a form? Q2: How can I make a form as a screensaver? I need a help from you. Thanks for your attention! --Minh Hien --