Search results

  1. E

    compile error in format function

    Hi All. Private Sub Form_Open(Cancel As Integer) cboDateStart.Value = Format(Now() - 7, "short date") ... End Sub When I run procedure the Format is highlighted and popup error message:
  2. E

    Limit Login Attempts

    hi All. I create Login form and would like to limit enter wrong password no more then three times. How do it? I will appreciate for sample. Thanks.
    • eugz
    • Thread
    • Replies: 5
    • Forum: Forms
  3. E

    display button on selected record in continuous form

    Hi All. I have continuous form in Access 2010. I highlight selected record. Now I would like when user will select record, that record will display button to give ability user delete it. For not selected records button not visible and disable. How to display button only in selected record in...
    • eugz
    • Thread
    • Replies: 2
    • Forum: Forms
  4. E

    Show image based on click continuous form record

    Hi All. I have continuous form in Access 2010 and I would like when user will click on record, the image, for instance, imgTest become visible for that record. But for other records the image not visible. How it to do? I will appreciate for sample. Thanks.
    • eugz
    • Thread
    • Replies: 6
    • Forum: Forms
  5. E

    no focus for textbox

    Hi All. I have unbound TextBox in continuous form and I would like that it never get focus. In property I specified Enabled=No and Locked=Yes. But it doesn't help. How to solve that problem? Thanks.
    • eugz
    • Thread
    • Replies: 8
    • Forum: Forms
  6. E

    highlight record on click Record Selector

    Hi All. I would like to highlight record when user will click Record Selector in the continuous form. How to do it? I will appreciate for sample. Thanks.
  7. E

    change color border of button on mouseover

    Hi All. I would like to change color of border button on mouseover event. How it to do? I will appreciate for sample? Thanks.
  8. E

    create query

    I have table that looks like: Case_Name.........Time.............ItemID.....Label.............RecNo =================================================== 35316E05.10G.....6:46:45 AM.....4...........Last Name......SHARIF 35316E05.10G.....6:46:45 AM.....5...........First Name......YANIS...
  9. E

    Navigation pane is greyed out

    Hi All. I tried to modified access 2010 database. But I open it the Navigation Pane is grey out (disable) and I cannot to see any database object. How to make the Navigation Pane active? Thanks.
  10. E

    navigate pane is disabled

    Hi All. I need to modify the access 2010 database. But when I open it the navigate pane of that database is disabled. How to make it enable? Thanks.
  11. E

    display dynamic report title

    Hi All. I have form with ComboBox that has list of projects. And I created chart report that reference for those projects. I would like when user will select value from project list and click button to open report so report will display project name as a title. How it to do? I will appreciate...
  12. E

    Question source of OLEUnbound field

    Hi All. In my old DB I wanted to modify OLEUnbound field but I forgot how I link it to the source. Where is source? In the property of that field in Data tab: Source Doc ..........| Source Item .........| Link Master Fields...| Link Child Field.......| Row Source...........| OLEType...
  13. E

    Question generate user identifier

    Hi All. If is possible generate user identifier? I mean user generator ID with any charters letter and number not table ID AutoNumber. Thanks.
  14. E

    count total and keep desc order

    Hi All I ceated simple query that sorted in desc order SvcDate. And created report besed on that querty with count total record like ="Total " & Count([CountField]) & " Patient(s)" in report footer. Without count field the report in desc order when I incude count field I'm loosing order. What is...
  15. E

    validation multiple fields

    Hi All. In my detail form has field that I would like to validate during enter process. For 3 TextBox and 1 ComboBox I would like create validation if user forgot enter data and couple TextBox number of entering characters must =7. If is it possible how create those validation when user open...
  16. E

    tab control data source

    Hi All. Is it passible to use diferent data sources to each tab control pages? If yes how use tableA for Page1 and tableB for Page2 of tab control. Thanks.
    • eugz
    • Thread
    • Replies: 2
    • Forum: Forms
  17. E

    current date and time on save

    Hi all. In my form I have 2 textbox that display current date and time Private Sub Form_Timer() txtDate1.Caption = Format(Now, "mmm d yyyy") txtTime1.Caption = Format(Now, "hh:mm AMPM") End Sub I would like when user close form by save evet values of current time and date save in Table1...
  18. E

    display current time

    Hi all. I created form when user click in text box it display current time. But I would like to display current time when user open form and when user reopen this form again data of time field keep previous value. How to do it? Thanks.
  19. E

    lock part of tables in Acc2003

    Hi All. I would like lock part of the tables in my database. If is posiable how to do it? Thanks.
  20. E

    import and update excel spreadsheet

    Hi All. Is this possible? I need import 30 Excel spreadsheets from different Excel files to one Access table and update this table. Thanks.
Top Bottom