Search results

  1. A

    DCount Distinct Values

    Hi everybody... I'm trying to use a DCount expression. It's possible to get distinct values using a DCount in a form as Control Source, or using VBA? I figure out a way to get distinct values by using SQL statement (in a query), like: SELECT Count(*) AS [BookCount] FROM (SELECT DISTINCT BookId...
  2. A

    Prevent duplicate values based on more than one field

    Hello everybody... I have form based on table (Borrow) with following column name: Borrowid PK (autonumber), Bookid, Satuts My questions is that, for "Bookid" with "Satuts", I would like to prevent duplicates when entering in the form. I can't make all the fields primary key because "Bookid"...
  3. A

    Report with dynamically changing text box size

    Hi Everybody.. Is it possible to have a report with flexible text width and height? I want to change font size based on the length of text. I try this code ON FORMAT but it didn't work: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Len(Me.FName) > 3 Then...
  4. A

    Hi Everybody

    Hi Everybody.. My name is Adam, from Bahrain. I am not beginner in MS ACCESS, but I hope to learn from all of you. :)
Back
Top Bottom