Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    15
    Views
    180

    Re: Archive data error in code please help

    what is the error?

    again you are going from top to bottom, you will eventually run in to blank lines and some rows will not be tested.
  2. Replies
    1
    Views
    199

    Re: Constant Back End Corruption

    There is a known corruption issue with Access running on Windows 10 where the back end is on certain versions of Windows Server - I think Windows Server 2012 is the worse culprit for it but also...
  3. Re: Either of 4 cells equals a value then get the desired result

    If C2 & E2 never contain 1 then you could use countif, if they can then use OR.


    =IF(OR(B2=1,D2=1,F2=1,G2=1),100,"")
  4. Replies
    15
    Views
    180

    Re: Archive data error in code please help

    Using the method you are using you would just check mytext for the values:


    Option Compare Text


    Sub archive()
    Dim i, lastrow
    Dim mytext As String
    lastrow = Sheets("projects").Range("A"...
  5. Replies
    15
    Views
    180

    Re: Archive data error in code please help

    Just now it is lookiing for any value including delivered - therefore not delivered would be picked up.

    An issue you will face is starting from the top down means some rows wont be checked.

    if...
  6. Replies
    15
    Views
    180

    Re: Archive data error in code please help

    Looks like your quotation marks are wrong throughout -
    “ instead of
    "

    If you replace all of them to the correct one the code appears to run as intended.
  7. Replies
    4
    Views
    339

    Re: Access Annoyance: ComboBox Ordeal

    Can you share a copy with no data or mock/test data?

    Your description of what you are trying to achieve is unclear.
  8. Thread: Table Compare

    by stumac
    Replies
    7
    Views
    675

    Re: Table Compare

    As Micron Says, it is unclear if the only difference is the additional space, assuming it is there are a few options.

    The cleanest is to create a query (or 2) that changes the format of one or...
  9. Re: Run the “ready” query in ACCESS from VBA Excel with the parameter

    What do you mean it doesn't work?

    what would you like to happen? The original query is a select query - if that runs you wouldn't see anything. Are you trying to write something back to the...
  10. Replies
    3
    Views
    456

    Re: Report Queries Back End vs Front End

    Your back end should only contain tables, no queries or reports.

    even if you had the reports in the BE you would need to release a new FE every time in order to link to the the new report.

    In...
  11. Replies
    2
    Views
    394

    Re: help with iif statement in access

    I would say adding a basic table with 2 columns is the best option for this, it is a lot easier to maintain than updating formula across all queries/reports/forms.

    Nested IIF will have a...
  12. Replies
    7
    Views
    964

    Re: Access: VBA to Make a Table from a Query

    gheyman - why do you need the calculated fields in a table? Can you not use the query?

    Does this tie into your previous DSum issues - perhaps there is a better way of going about the problem if...
  13. Re: Show (2) Form Tabs Open when Access is Opened

    On the macro add a third open form Action and set it to open the first form again - as it is already open it will just have the focus set back to it.

    Edit: Use the selectobject action - and select...
  14. Replies
    5
    Views
    718

    Re: AccesS Formula help

    I find the switch function is a clearer and neater option for things like this. If DaysAged returns and integer then:


    Switch([DaysAged]<31,"<30 Days",[DaysAged]<61,"31-60...
  15. Re: Access: IIf formula missing a bracket, parenthesis...

    I am not sure what your Dsum is meant to achieve, you are only filtering out zeros with the month active filter - so it will sum (which is the same as counting in this case) ALL the 1's in the query....
  16. Re: Access: IIf formula missing a bracket, parenthesis...

    :eeek::eeek:

    Oops!


    IIf(DateDiff("m",[PDIR Due Date],Now())<>0 Or DateDiff("m",[PDIR Submission Date],Now())<0 Or DateDiff("m",[PDIR Completed],Now())>0,0,1)
  17. Re: Access: IIf formula missing a bracket, parenthesis...

    Agree with Joe, you are using Cstr and then comparing to a number, I would take that out. You can also reduce to one IIF if you switch from AND to OR:


    IIF(DateDiff("m",[PDIR Due Date],Now())<>0...
  18. Replies
    5
    Views
    832

    Re: Retrieve last row Value from Access Table

    If you have an autonumber or date field then you could also combine Dmax with Dlookup to get the true last. If there is no additions or deletions then DLast will get the last entry.
  19. Replies
    5
    Views
    778

    Re: Convert Excel Formula To Access

    Similar with your Excel formula the second IF and the AND function are not required. If can return one value if true and another if false. IF,Then,Else.


    =IF(S2>1825,">","<")&" 5 Years Old"
  20. Replies
    5
    Views
    151

    Re: .CSV Email issue

    You could try adding in a friendly name -
    =HYPERLINK("mailto:"&E1,E1)
  21. Replies
    5
    Views
    151

    Re: .CSV Email issue

    How about using the Hyperlink function along with 'mailto:':


    =HYPERLINK("mailto:"&E1)
  22. Replies
    4
    Views
    1,153

    Re: New table by grouping fields

    Realised that your data is probably in different fields (not one field separated by commas), the code above wont work as is for that. If that's the case and the fields are in the correct order (as...
  23. Replies
    4
    Views
    1,153

    Re: New table by grouping fields

    Just had a thought - you would need to watch out for commas that don't act as a delimiter - i.e. in a comment.
  24. Replies
    4
    Views
    1,153

    Re: New table by grouping fields

    It can be done with VBA - in the code below I have highlighted the fields you would change to suit your DB. In the example the data would be in a table called MyTable within a field called MyField...
  25. Replies
    2
    Views
    1,113

    Re: MS Access Top N Values Show in Table

    One way using SQL would be to combine 4 Select top N queries then group them:


    SELECT Prd_code, Prd_desc, Cat_code, Cat_desc, MAX(Q1_Sales) AS xQ1_Sales, MAX(Q2_Sales) AS xQ2_Sales, MAX(Q3_Sales)...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4