Search:

Type: Posts; User: bat17; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: update query

    by bat17
    Replies
    4
    Views
    712

    just create the SQL in code and run it from code...

    just create the SQL in code and run it from code no need to use a saved query at all.
    How to do it will depend on the structure that you have/need

    Peter
  2. Replies
    3
    Views
    720

    are you sure there is a field [Calc_Fast] in...

    are you sure there is a field [Calc_Fast] in table Screenings ?

    Peter
  3. Replies
    4
    Views
    682

    You cant bind calculated fields to a table. You...

    You cant bind calculated fields to a table.
    You should just create the info on the fly when you need it from the stored data.

    HTH

    Peter
  4. Replies
    2
    Views
    748

    Make them do all their data work with forms not...

    Make them do all their data work with forms not tables. You can run code on the update event of the form to add a date/time stamp to the record.
    Are you using user level security? If not how will...
  5. Replies
    2
    Views
    572

    check for empty strings Is Null Or "" HTH...

    check for empty strings

    Is Null Or ""


    HTH

    Peter
  6. Replies
    7
    Views
    834

    What you have looks OK. Did you try Mike's...

    What you have looks OK. Did you try Mike's suggestion? This will make a differnce if you are using A2K and above.

    Dim db As DAO.Database
    Dim rstProcess As DAO.Recordset

    Peter
  7. Replies
    10
    Views
    1,610

    generaly you need to wrap text in single quotes...

    generaly you need to wrap text in single quotes but not numeric data.

    Peter
  8. Replies
    2
    Views
    716

    You can save a word document in a table as an OLE...

    You can save a word document in a table as an OLE Object data type. Not sure what it will do to your file size though :-)

    HTH

    Peter
  9. Replies
    10
    Views
    1,610

    just had one thought, if you are using text...

    just had one thought, if you are using text fields then they will need wraping in quotes

    Me.Personnel02.Value = "'" & Me.Personnel01.ItemData(1) & "'"


    edit: oops, I mean dont wrap in quotes...
  10. Replies
    10
    Views
    1,610

    It should populate them but only when you are on...

    It should populate them but only when you are on a new empty record.

    Peter
  11. Replies
    3
    Views
    673

    Excel will mostly use anything it can interpet as...

    Excel will mostly use anything it can interpet as a date as a date in a date function, I don't use pivot tables so I dont know why the create an extra problem.

    peter
  12. Replies
    4
    Views
    430

    I tried you code just Dim'ming the variables and...

    I tried you code just Dim'ming the variables and setting the named ranges to ordinary ranges so that it would run on my machine.

    Like this it runs with out error. It may help you to pin down the...
  13. Replies
    3
    Views
    673

    If you highlight the data in Excel and use...

    If you highlight the data in Excel and use Data>Text To Columns...
    You can select Date as the datatype and excel will convert them to real dates.

    HTH

    Peter
  14. Replies
    4
    Views
    430

    Is "guardar2" the same size range as A2:Z2. if...

    Is "guardar2" the same size range as A2:Z2. if not this would cause an error.

    peter
  15. Replies
    3
    Views
    415

    You don't say what is happening! What is not...

    You don't say what is happening! What is not working?
    The Worksheet_Change events should be in there own worksheet code pages rather than in seperate modules.

    Peter
  16. Replies
    7
    Views
    834

    What you have looks OK, Can you post the rest of...

    What you have looks OK, Can you post the rest of the code for us to look at please

    Peter
  17. Thread: SUM

    by bat17
    Replies
    1
    Views
    478

    you are grouping on fields that you probably dont...

    you are grouping on fields that you probably dont want too. We cant tell much with out any detail, but for insctance if you have a Date/Time field included in the grouping then it will return a...
  18. Thread: Help Me

    by bat17
    Replies
    1
    Views
    505

    I expect you used the wizard to set up the sub...

    I expect you used the wizard to set up the sub form and it has matched it to a field in the main form which is filtering out the records.

    Peter
  19. Replies
    5
    Views
    1,052

    This looked fun so I had a play with it :-) ...

    This looked fun so I had a play with it :-)

    Option Explicit
    Declare Function SetForegroundWindow Lib "User32" _
    (ByVal hWnd As Long) As Long
    Declare Function IsIconic Lib "User32" _...
  20. you could add a sub to Enable/Diable controls and...

    you could add a sub to Enable/Diable controls and call it from the afterUpdate event of the combo and, probably, the current event of the form


    Sub LockUp(bolLock As Boolean)
    Dim ctl As Control...
  21. Replies
    1
    Views
    516

    I would do it on the Click event ou After Update...

    I would do it on the Click event ou After Update event.
    You may also find that you need to refer to the subform via the main form.
    Forms![MainFormName]![SubFormName].Requery

    HTH

    Peter
  22. Replies
    7
    Views
    834

    DAO should work ok in Acces, but if you are using...

    DAO should work ok in Acces, but if you are using A2K or higer you will need to set a reference to it.

    Peter
  23. Replies
    2
    Views
    449

    check out...

    check out
    http://www.mrexcel.com/board2/viewtopic.php?t=105441

    Peter
  24. Thread: Date Filter

    by bat17
    Replies
    5
    Views
    492

    and therefore a simpler solution which probably...

    and therefore a simpler solution which probably makes it a better one!

    :-)

    Peter
  25. Replies
    11
    Views
    962

    If WorkOrdertbl is Numeric try this one :-...

    If WorkOrdertbl is Numeric try this one :-
    DoCmd.OpenReport "WorkOrderrpt", A_NORMAL, , " [WorkOrdertbl] = " & [Forms]![WorkOrderfrm]![WorkOrdertbl]


    If it is text then try this :-...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4