Search results

  1. I

    "click" on tabs in navigation form

    Hi, Select the button for the 3rd load event then Property field Choose Data and NavigationTargetName (select the name of the 3rd form).
  2. I

    "click" on tabs in navigation form

    try this :)
  3. I

    export in excel and lock cells

    Hi all I need your help to insert the code that is blocking the cells from the exported excel with the range B1:BB800. :banghead: Below i have the macro code for the export: Function invoice() On Error GoTo invoice_Err DoCmd.OutputTo acOutputQuery, "Export", "MicrosoftExcelBiff8(*.xls)"...
  4. I

    Delete a database

    And also I'm the only admin of this database.
  5. I

    Delete a database

    This is available in company where your job request to do databases , yes it is illegal, but when you wanna escape from the noisy excel files and make your job more easy it is something else.(and you are not paid for this improvments).
  6. I

    Delete a database

    this is necessary to protect my work --- in case something is happening with my job.
  7. I

    Delete a database

    Hi, Please tell me how can i delete from a database (all the tables, macros and the query) if it is open by someone to certain date. Thanks a lot.
  8. I

    block scroll wheal in a form

    Because i work in a company i don't have acces to all folders and to copy .DDL files.
  9. I

    block scroll wheal in a form

    Hy please help me with the following problem: i need to know how i can block to see the previouse records in a form with the scroll wheall (the buttons from the bottom of the form are made invisible for the users but the scroll wheal is still working ) in Access 2003. Thanks
  10. I

    field type - date/time

    Done This thread can be close. thanksss
  11. I

    field type - date/time

    Hy Please help me with another problem: i have creeated the field for userid (the database is protected with user and password) and i need to know how i can connect the previous code: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Modifydate = Now() End Sub with : Me.User = CurrentUser to...
  12. I

    field type - date/time

    THANK YOU VERY MUCH ITS WORKING (I recreate the form) perfectly thx1000000000
  13. I

    field type - date/time

    I updated the fields from the form with the code to Before Update and i receive the error : Can't find Macro 'Me' this because i use Access 2003?
  14. I

    field type - date/time

    I have done this but the field is still empty :(
  15. I

    field type - date/time

    I don't receive any error but when i open the table to see if the field has received the date it is empty (i use Access 2003 - maybe this is the reason?)
  16. I

    field type - date/time

    Thank you for your replay, but in that field 'BeforeUpdate' i need a formula to fill the field 'Modify date' with the year/month/day/hour/min/sec (i think a VBA code or a Macro). by
  17. I

    field type - date/time

    hy, i have a table with the following field names ( id client , address, e-mail, phone, fax) and a form. Because this form is used by 10 persons i need to know if one of them has modify the info's from an old client (i need just the moment when it was made the intervention and not the user). I...
Back
Top Bottom