Recent content by veasna

  1. V

    Play sound file in Ms Access 2007.

    Can i play the sound file (.wma) in Ms Access? I want to play it when the form load. Thanks,
  2. V

    Code connect to database and query select data from database in Ms Access 2007

    Dear Access members, Could you tell me to code connect to database and the query to select a field of data from database? Thanks,
  3. V

    Select the specific data from database.

    Could you please give me the full VBA code in Access to do with this?
  4. V

    Select the specific data from database.

    In table "Product" i want to write a query to select data from field "Item" where the value of field "Item" equal to "Gin". I am a fresh in Ms Access. Could you tell me to write the code to solve this problem? Thanks,
  5. V

    Please help me to solve this problem.

    Thanks you very much. If you have time could you please give me the example of coding? Thanks,
  6. V

    Please help me to solve this problem.

    Dear Access Programmer, I am a new in Access. Here are the description of my problems: - I have two tables: TblBook that has fields "BookId, BookName, BookQty" and TblBorrow that has fields "BorrowId, BookId, BorrowBookQty, BorrowDate". - In FormBook i have a subform name "Book subform". - In...
  7. V

    Can i do the conditional format in subform with Query?

    Thanks you very much for your answer, but my problem is not happen in the same table. + For example I have the following tables: - Table Language (Language_Id, Language_Name) - Table Guide (Guide_Id, Guide_Name, Language_Id) - Table Guide_Booking (Booking_Id, Date, Guide_Id) -...
  8. V

    Can i do the conditional format in subform with Query?

    + My problem is: - I have table "Guide" that has fields "Guide_Name and Guide_Language" and table "Guide_Booking" that has fields "Booking_Date and Guide_Id". - In the index form i have a subform name "Guide_Booking subform". + My question is: i want to put the conditional formatting (red...
  9. V

    Open the index page in FullScreen.

    Dear Avelino, Thanks you very much for you answer. Now, it's work. Thanks, veasna
  10. V

    Open the index page in FullScreen.

    Many thanks for your answers. Could you please tell me how to Call the function fncDisableRibbon () through macro AutoExec. Thanks, Veasna.
  11. V

    Date Conditional Format in sub form

    Dear boblarson, Thanks you very much for your time and your answer. Thanks, Veasna
  12. V

    Date Conditional Format in sub form

    Dear Access members, In my Index form have a sub form name "Driver Booking subform". In "Driver Booking subform" i have a field name "Date_From" and i want to put the conditional format(red background color) to this field. ***if the value of this field is equal to CuurentDate (eg...
  13. V

    Alert message automatically

    Thanks for your time that you have spent with me. I still got a problem and a question to you. Now, the interval timer is work, but it's got an error with this line "If Format(Me.[Arrival Date], "MM/DD/YYYY") = Format(Date, "MM/DD/YYYY")". One more problem that i forgot to tell you is [Arrival...
  14. V

    Alert message automatically

    I am sorry, i have no idea, because i have no experieces with Aceess. I am a fresh one. If you have the time, please give me one example on how to do a linked table and SQL to deal with this. Thanks, Veasna
  15. V

    Alert message automatically

    I am new in Access. I don't know much about DAO or ADO. If you don't mind could you please tell me a bit on how to use DAO or ADO to check the value in the table against the current date and time. Thanks, Veasna
Back
Top Bottom