Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: EZLI
  • Content: Threads
  • Order by date
  1. EZLI

    Split the Field value

    Hi, I have on Form three Fields: Field1 Value *123456*72.47* I need to split that value following to: Field2 Value 123456 Field3 Value 72.47 Can somebody help. Thank's in advance
  2. EZLI

    Switch unvisible Subform to visible

    Hi, How to switch unvisible subform in Form to visible using Button. Thank's in advance for help.
  3. EZLI

    Switch unvisible Subform to visible

    Hi, How to switch unvisible subform placed in Form to visible using Button. Thank's in advance for help.
  4. EZLI

    Hide subform in Form

    Hi, I have a check box in form and a subform. If check box value is True, subform must be unvisible. And If check box value is False, subform is visible. Can somebody help to dissolve above described. Thank's in advance.
  5. EZLI

    Change the Button color in Main Form by change value of CheckBox

    Hi, How to change Button1 color placed in Main Form by checking CheckBox1 which is placed in Slave Form? Thank's in advance.
  6. EZLI

    Add Date&Time Picker Control(SP4) to unboud Date Field

    Hi, I have the Form with unboud Data Field. How to add Date&Time Picker Control(SP4) to unboud Date Field? Thank's in advance.
  7. EZLI

    Row painting by condition

    Hi, I have a subform (in DateSheet)on form. If by condition in one field in Subform row (DateDiff>=30) I need to paint in Yellow colour all that rows where this condition is true. Thank's in advance, Bob
  8. EZLI

    FIFO in one table

    Hi, I have a one table T1: ID 1 Date 01.07.04 Field1 A Field2 B How to assign Field2 value "B" to Field1 for the next record ? Next records must look so: ID 2 Date 01.08.04 Field1 B Field2 C ID 3 Date 01.09.04 Field1 C Field2 D e.t.c...
  9. EZLI

    Assign Field Value?

    Hi, I have a table: ID 1 Date 01.07.04 Field1 A Field2 B How to assign Field2 value "B" to Field1 for next record (Date)? Must look so: ID 2 Date 01.08.04 Field1 B Field2 C ID 3 Date 01.09.04 Field1 C Field2 D Thank's in advance for help.
  10. EZLI

    Amount number conversion to text?

    Hi, I need convert amount from number to text. Can sombody help please?
  11. EZLI

    Exclamation icon in MsgBox

    Hi, Please help how to show in MsgBox the exclamation icon. Private Sub Form_Current() If Len(A) <> 0 Then aa = CLng(A) If aa >= 20 Then Msg = &quot;abc!&quot; Style = vbOKOnly + 48 Title = &quot;Attention&quot; MsgBox Msg, Stile, Title End If End If End Sub Thank's in advance, Niks
  12. EZLI

    Function LastDayOfMonth

    Hi, I'm asking kindly for help. Function FirstOfMonth() FirstOfMonth = DateSerial(Year(Now),_ Month(Now), 1) For Mart: Function LastOfMonth() LastOfMonth = DateSerial(Year(Now),_ Month(Now),31) For different months the last day is different. The Question; How automaticly define the last day...
  13. EZLI

    Working days calculating?

    Hi, Please help to calculate working days for every month in year. Thank's in advance, Niks
  14. EZLI

    VBA code for FIND DIALOG BOX

    Hi, Have somebody code for FIND DIALOG BOX? Thanks in advance, Bob
  15. EZLI

    Assigning E-mail address

    Hi, I would like to create new field in my form where to write E-mail address. By Click in that field I will open the Outlook with this address. When You have WWW-address: no problem with hypperlink. Any suggestions? Thanks in advance, Bob
  16. EZLI

    Code for Find Dialog Box

    Hi, I’m created database in Access 2002 in native language. Only one form for Find Dialog Box-in English. I can’t find the code or modul for Find Dialog Box. Without that I can’t design the Find Dialog Box form and change field name (Find what, Look In, Match, Search) with native name. Have...
  17. EZLI

    Code for &quot;Find&quot;

    Hi, For my .mdb I need to use &quot;Find&quot;. To change in native language I'm looking for design mode. Maybe sombody have the code for such module? Thanks in advance, Bob
  18. EZLI

    Date and Time Picker 6.0 (SP4) control.

    Hi, How can I use Date and Time Picker 6.0 (SP4) control to display visible (by month)several different dates? It's necessary to overwiev all duties of stuff member. The range setting in properties allow set the date only one by one. Thank's in advance.

Part and Inventory Search

Back
Top