Recent content by shagha

about the counter, I have a field that stores the name of trucks, and names repeat in different records,but I want to be counted just once.

I want to create a report that shows the number of records of specific field and sort it monthly, and also I have a weight field that I want to sum all records in one month. I don't know what should I do! (I have month field in the table)

I want backup my database automatically per week,what should I do?

I have created a filter with the code below, and I want to apply in to a report, what should I do? Private Function buildWhereClause() buildWhereClause = "" ' Has the field got something in it? If Len(Me.Tcode & vbNullString) > 0 Then ' If there is already something in the WHERE clause...

Private Sub Command954_Click() Me.Filter = buildWhereClause Me.FilterOn = True End Sub Private Function buildWhereClause() buildWhereClause = "" ' Has the field got something in it? If Len(Me.Tcode & vbNullString) > 0 Then ' If there is already something in the WHERE clause then...

how do I print a filtered form? I mean I have form, I want to print it by it's filtered value thanks in advance for your help

I want to share my Database on a LAN and I want users to access forms(not tables or Queries) and just in form view not design or layout view. what should I do? Thanks in advance for your help

I want to and the filters at the end of the code belowOption Compare Database Private Sub Command954_Click() Dim strTcodes As String Dim strYcodes As String Dim strMcodes As String Dim strPcodes As String Dim strScodes As String Dim TlngLen As Long Dim YlngLen As...

I tried a lot but i couldn't write a filter with multiple criteria I've written single ones like this: Me.Filter = strMcodes but I don't know how to AND multiple filters

I've designed my database,and I want users to just see the Main form and not Queries or tables. what should i do?

what's the problem of the code below?? I want to create a filter with more than 2 criteria Me.FilterOn = True Me.Filter = "[YEARS] = " & Ycode & "[years] ="&Ycode& "[months]="&Mcode& "AND[POScode] = " & Pcode thanks a lot for your answers

thanks for the code but my form doesn't show any record at first, I want it to show just the specific record that i call.

I want to recall a record by it's primary key in a form with a command button I mean write a primary key in a textbox and press the button then it shows the record.

I've created a macro for saving records, but it's just over write on the previous record, what's the best way to save new records using forms?