Recent content by Liv Manto

Have you tried: SELECT r.dwg, r.revision, r.trackingID FROM tbl_wkpkg_dwg_rev r, (SELECT MAX(revision) as maxrev, dwg FROM tbl_wkpkg_dwg_rev GROUP BY dwg) MaxResults WHERE r.dwg = MaxResults.dwg AND r.revision = MaxResults.maxrev group by r.dwg, r.revision, r.trackingID

What version of Access are you using?

After every change me.form.refresh

MOD Returns the remainder after a number is divided by a divisor. Syntax MOD(number,divisor) Number is the number for which you want to find the remainder after the division is performed. Divisor is the number by which you want to divide Number.

Your Field has either True or False, why do you have to count per field... There is only one count per field.. You can put the iif(field1 = true, 1, 0) then at the summary page, you can summarize the above values...

Try first the database repair in tools (i believe) Check the link (child, parent).. did you change spelling of a field.. Is there a code that refers to the subform that uses a different subform name. Try taking it out, save, then putting it back.then save.

if the report is based on a query, add a field in your query iif(instr([table.field1],"-")>1, 1, 0) Then sum it up in your report if you have a summary row there.

Skates, give me your email address.. Its a small file. You need to change relationships and also use the "middleman" table so it would update it too, in your form. Sorry took a while, have to do something else...

What do you mean attach a file to a record? insert contents of a file to an existing table OR insert the filename to a field in a record. You need a dialog box? You have a form where you have a dialog box, you want to drag the filename to a textbox , press button so it would insert data...

what is the error message?

Im at work now, and the site is blocked from my workstation (high security whatever at Boeing) . I'll look at it from home..later.. Im in Long Beach, CA now , 1043 am , i would be home in Huntington Beach by 6pm, so if you can wait 9 hours, I'd appreciate it.

Private Sub Command2_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim CTLName As String Dim ctlCurrentControl As Control Set ctlCurrentControl = Screen.ActiveControl CTLName = ctlCurrentControl.Name 'MsgBox "now do whatever what you want with Ctl Name " & CTLName...

Do you mean mindate is a result of a query that looks for the earliest date?

Private Sub Command2_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim CTLName As String Dim ctlCurrentControl As Control Set ctlCurrentControl = Screen.ActiveControl CTLName = ctlCurrentControl.Name MsgBox "now do whatever what you want with Ctl Name " & CTLName End Sub

Give me more details, or better send me a copy of the database with sample recordsets/tables. Livmanto@hotmail.com What is the command behind the macro? Is the form a free form, meaning no recordset is behind it, its just used to hold textboxes? The command button then inserts the records?