Search results

  1. W

    Using VBA to Link Main Form to Sub Form?

    TyFer, You should use linked tables for your parent/child tables. Google for the Parent-Child links mentioned above. They are not filters but properties of the form. You can Set "Enabled=False" for the fields you don't want updated. You can set up an Audit Trail either in Access or with...
  2. W

    Problem with filter continuous form

    S, Access is helping you too much. The Me.Refresh is removing the trailing space and not applying it to the filter. Note: Set a breakpoint (or put the word Stop) in your OnChange event and look around. Remove it and it should work fine. Wayne
  3. W

    Problem with filter continuous form

    S, Me.Filter = "[Table1].F1 Like '" & Me.txtBox.Text & "*'" hth, Wayne
  4. W

    Problem with filter continuous form

    In the OnChange event, you have to use me.txtBox.TEXT You can't use the txtBox.Value or just me.txtBox Wayne
  5. W

    Problem with filter continuous form

    sneuberg, The filter doesn't affect the unbound text box. The unbound text box affects the filter which affects the rows that the form displays. As you continue to type in the unbound text box; it will continue to modify the filter. Wayne
  6. W

    Problem with filter continuous form

    Basilyos, The OnChange event fires for each keystroke. Use Me.Text41.Text for the value of the current string. If you just want to check it after entry use the Before Or After Update of the Text41 control. Wayne
  7. W

    Method or Data member not found... yet intellisense says it's there??

    MackMan, Access at times will highlight a variable saying its undefined, but it's really the variable next to it. Wayne
  8. W

    SQL Server ROW_NUMBER() OVER( PARTITION BY

    Ex, Free ebook SQL Server 2012 T-SQL Recipes. chapter 7 is good. Wayne
  9. W

    VBA To Open Linked Table

    cheer, CJ, you have the patience of a saint. I'm confused here too ! rsTemp1.Open strSQL, cnnNew13 Wayne
  10. W

    Trying to convert a SendKey command to something "newer"

    You can use .SelStart and .SelLength to position the cursor at the start of the control. Wayne
  11. W

    How to alter tables in SQL Server from Access

    Mike, The DoCMD works on your local Access db. You have to issue the command over an ADO connection. ADO_Connection.Execute strSQL Wayne
  12. W

    query left$

    On a phone so this is brief Replace(replace(area code, "(", ""), ")","") Hth, Wayne
  13. W

    SQL Syntax Error

    You can't use a Values and a Where clause together. Wayne
  14. W

    TSQL Logic test if DateTime2 variable has a Date

    Ex, Don't both languages have IsDate ? Wayne
  15. W

    IIF Statement not working

    Jim, I'm thinking that your real problem is that you're trying to do a joined-table update. Did the answer to your other thread help here? If not, it would help if you'd post the table defs and a definition of the problem. Wayne
  16. W

    Syntax Error

    Update ItemT Set ItemT.D3Qty = TransactionT.Quantity from ItemT, TransactionT where ItemT.Item =TransactionT.Item And TransactionT.Item in ('Adjustment', 'Usage') Wayne
  17. W

    DAO Loop

    RH, Isn't your loop supposed to be an Update instead of an Insert? Update tbl_RateSchedule_NEW Set tbl_RateSchedule_NEW.EquipmentType = tbl_EquipmentTypeValidValues.EquipmentType From tbl_RateSchedule_NEW, tbl_EquipmentTypeValidValues Where tbl_RateSchedule_NEW.EqTypeID =...
  18. W

    Function 5 Dates- need to know what date category was greatest -return char (string)

    Rx, Sorry, I had trouble communication via the phone interface. CREATE FUNCTION [dbo].[RE_2100](@StAPDSubmittedDt DATETIME, @StAPDApproved DATETIME, @StAPDExpired DATETIME, @StAPDWithDrawn...
  19. W

    TSQL - case - Latest date for 5 Date variables - Identifgy what variable had latest

    Rx, on a cellphone so this is a little rough. how about doing this with a query ... With mydates as (Select @date1 as thedate, 'name1' as thename Union Select @date2 as thedate, 'name2' as thename Union ...) Select top1 thename From mydates Order by thedate desc should be a lot more concise...
  20. W

    Dynamic stored procedure call problem

    Hi voiD, Look at the Help for --> sp_ExecuteSql. You'll have to use dynamic SQL for what you want. hth, Wayne
Back
Top Bottom