Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.57 seconds.

  1. Replies
    6
    Views
    222

    Re: Any chance mdb to get data from xlsx

    I also believe that you can't use the new (now old?) xlsx formats with Access 2003 or earlier. mdb is strictly speaking just a file format, but Access 2003 and earlier cannot read or write the new...
  2. Re: SQL to multiply value from previous record ? How ?

    There's no good MSAccess SQL for this that I can think of. I would drop the data into Excel for the calculations here.
  3. Re: Changing Values of Text Box on Main Form from Sub Form

    I think a lot depends on the details? Is the subform related to the main form (i.e., parent-child or anything of that nature?). How are they related? Also, are the fields bound? If so what are they...
  4. Re: If value in report combobox A, B or C, then another combo box d or e.

    Okay. You could put a long in () clause in the formula I guess. But dlookup would be cleaner.
  5. Re: If value in report combobox A, B or C, then another combo box d or e.

    this might work:


    =IIF(Left([InterestCode],1) = "M","Dividend", IIF(Left([InterestCode],1) = "P", "Interest"), "")

    But I'm not sure what happens if nothing is selected (null? blank? Error?)....
  6. Re: INSERT INTO SELECT * FROM tblName IN 'Db Location'

    There is probably no simple was to do this with plain SQL. I suppose there are tools that would allow it (such as SSIS import export mappings or who knows what else might be available these days). I...
  7. Replies
    1
    Views
    312

    Re: Access: Delete all records in a Table

    Running a delete query in the button code is a simple option:

    Either:

    Sub Foo()

    DoCmd.SetWarnings False
    DoCmd.RunSQL "delete * From [Table2];"
    DoCmd.SetWarnings True
  8. Replies
    22
    Views
    2,482

    Re: MTBF Analysis in Access query

    Remove the second word "from". Then try again. If it doesn't work post back but do try to fix the syntax errors yourself so you don't have to wait for me.
  9. Replies
    22
    Views
    2,482

    Re: MTBF Analysis in Access query

    as a starter, that should be a simple join (self join, technically):


    select distinct
    t1.BarCode,
    DateDiff("d", t1.DateWarranty, t2.DateWarranty) as DateDifference
    from...
  10. Re: Access: Autopopulate a field on one from using another Form.

    Something like (in the first control's after update event or possibly change event):

    [Forms]![MyOtherForm].[MyOtherControl].Value = Me.MyControl.Value
  11. Re: INSERT INTO SELECT * FROM tblName IN 'Db Location'

    can you give an example of what you mean by an unmatched field? Is this in your Select clause? Or your Where clause or Join clause?
  12. Replies
    22
    Views
    2,482

    Re: MTBF Analysis in Access query

    It should work for 1, 2, or more...

    With only 1, min and max are the same so difference is zero.
    With two or more, min and max should work also with largest difference resulting (also would be...
  13. Replies
    4
    Views
    456

    Re: Combo Box List Rows limit

    You could. You could also just work with the "selected" row. Or use the data without moving it to other forms. There are usually a variety of options. UI design is not easy in my opinion but it is...
  14. Replies
    4
    Views
    456

    Re: Combo Box List Rows limit

    I'd say in general combo boxes with 30,000 rows probably violate some basic principle of UI design. Probably the one that says "never put 30,000 rows in a combo box". You're going to have to find a...
  15. Re: Advanced Filter Coming Up Empty Despite Values Existing

    Your code works fine for me as far as the basic filtering is concerned (I removed most of your variables and set up a simple sheet for testing - moved a few things around slightly. The empty column...
  16. Replies
    4
    Views
    455

    Re: Access: TExt Box = Combo Box

    It works for me.
  17. Thread: Date parameters

    by xenou
    Replies
    3
    Views
    698

    Re: Date parameters

    Also beware of time data if your dates have times in them.

    For instance,

    9:15 AM on on Jan 1 (2019-01-01-09:00:15) is not less than or equal to Jan 1 as a date (2019-01-01 00:00:00)....
  18. Re: How to resume a record set where a macro left off?

    Note: There are two MoveNext commands here. Not good usually.


    Just one is more common:


    Do While not rst.EOF

    If not rst.Fields("Status").value = "Done" then
  19. Replies
    3
    Views
    499

    Re: Access; Error Message on form fro ComboBox

    CStr() converts a number (or any value you give it, really) to a string. You said you need a text data type for some field. So that's how you would ensure that all values in that field are Text.
  20. Replies
    3
    Views
    499

    Re: Access; Error Message on form fro ComboBox

    Not sure what field you are dealing with. It should probably be cast to a string.

    for instance,
    RowSource:
    SELECT [ModelGeneral_vluItem].[ItemID], [ModelGeneral_vluItem].[ItemDescription],...
  21. Replies
    6
    Views
    812

    Re: Access: Timestamp new records

    Hi,
    Note that since we are doing the same update for both new records (inserts) and non-new records (updates) the above is the same as:

    Private Sub Form_BeforeUpdate(Cancel As Integer)
    Dim...
  22. Re: Running an update query via VBA, execute command can't find the update query

    I think would really need to know the value of cstrUpdate_1 at runtime to debug the original code.
  23. Replies
    22
    Views
    2,482

    Re: MTBF Analysis in Access query

    Here for kicks is SQL for doing this with an alternative strategy:

    SELECT
    t1.BarCode,
    DateDiff("d", t3.MinOfDateWarranty, t3.MaxOfDateWarranty) as DateDifference
    FROM ...
  24. Replies
    6
    Views
    812

    Re: Access: Timestamp new records

    I would try using a default value in the table. It is also possible to do it with a before save event on the FORM. But the former doesn't require any code and always works - you would just leave...
  25. Replies
    22
    Views
    2,482

    Re: MTBF Analysis in Access query

    Hi welshgasman, that is not a continuation character. It is a regular underscore character that is part of the field name alias (i.e., just an ordinary character). Actually you should have realized...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4