Recent content by AdamSmith

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...

Thank you Gasman, isladogs and MajP for your discussions... appreciate your help. I solved this Issue by MajP's suggestion

I don't know if I explained my idea clearly. but I will try right now: this access file is for a library, so any member borrow any book, the other member can't borrow the same book unless the book is returned. Example: No--------- Books--------- Status 1---------- Book1 --------- borrowed. True...

On. You can get duplicates Just If the same book as "returned" Not |borrowed"?

thank you for your reply. but the first field is PK (autonumber), and other fields can be duplicated.

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"...

Yes I have.. but the real file (my Project) has a fixed template. Thanks AccessBlaster

thank you isladogs.. again I didn't notice the code work also with the command button

My problem now is when I use the command button that export the report to PDF, the code doesn't work unless show the report in "Print Preview" before.

thank you theDBguy in advance! I don't notice the code is working in Print Preview. "Why not increase the field width?" because I the real file (my Project) has a fixed template

thank you theDBguy, but I tried my file on other PC and also the code didn't work. based on my idea the third record should to appears all letters of "Sara", not only 3 letters, but with smaller font size.

pbaldy and The_Doc_Man thank you for your welcoming words. I'm glad to be a part of this family

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...

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