Search results

  1. P

    URGENT: Query question

    Is it very hard to pull a value from a query into another query and use that value to pull records from a table? PLEASE PLEASE PLEASE tell me how I could do this? This is my situation; I have two tables, TBL1 containing original records, TBL2 containing the amended records. TBL1 & TBL2 are...
  2. P

    Retriving data using date as criteria.

    How can I retrive records which have been entered into the database today? Input-date has formatted as follows: dd-mmm-yy hh:nn:ss I've tried Now() and Date() functions in the criteria but it doesn't seem to work. Help you guy, PLEASE
  3. P

    Append query to add current rec

    Hiya, what I want to do is; Append the current record to a table from the form. Would someone help me code an SQL statement for a macro or for a query? I already have this code but its got errors in it, and I don't seem to know how to get it right as I've tried to correct it so many times...
  4. P

    VB specialists help wanted: Would this code work?

    Private Sub Trade_Date_AfterUpdate() On Error GoTo Err_Trade_Date_AfterUpdate Me.Refresh DoCmd.RunQuery CalcualteNetPrice DoCmd.RunQuery CalculateSettlementDate Me.frmTrade(M).Requery Exit_Trade_Date_AfterUpdate: Exit Sub Err_Trade_Date_AfterUpdate: MsgBox...
  5. P

    saving calculated feild

    Could someone please tell me how I could save a calculated feild on the form in a table? I would appreciate all replies. Thanks....
Back
Top Bottom