Recent content by Liv Manto

  1. L

    Complicated table join with subquery

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

    How to set print attributes for the relationship viewer

    What version of Access are you using?
  3. L

    Getting Checkbox to update visually

    After every change me.form.refresh
  4. L

    Time calculations

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

    Count Multiple Fields

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

    Subforms in Design view

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

    how to count in the report

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

    Access 2000 SubForm Problem...

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

    Cmd Button/Link Doc Help

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

    Is some wrong in code...

    what is the error message?
  11. L

    Access 2000 SubForm Problem...

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

    Get name of control that initiates an action

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

    Text Box Control Source???

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

    Get name of control that initiates an action

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

    Macro Help Please................

    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?
Back
Top Bottom