Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    585

    Re: Access: If Statement to Run Macro

    In Access 2016 this doesn't work. I have tested it as per the OP's scenario, without the private statement it works fine, with the private statement the following error is returned.
    ...
  2. Replies
    8
    Views
    585

    Re: Access: If Statement to Run Macro

    Think this is referring to Excel, Macros are a different object in Access, furthermore, I don't think this works with Access subroutines.
  3. Replies
    2
    Views
    398

    Re: Access: Using Toggle/Option Buttons

    The value is assigned to the frame control:




    Private Sub Frame244_Click()
    Select Case Frame244
    Case Is = 1
    Text256 = "1"
    Case Is = 2
  4. Replies
    19
    Views
    305

    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.
  5. Replies
    1
    Views
    338

    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...
  6. 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,"")
  7. Replies
    19
    Views
    305

    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"...
  8. Replies
    19
    Views
    305

    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...
  9. Replies
    19
    Views
    305

    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.
  10. Replies
    4
    Views
    413

    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.
  11. Thread: Table Compare

    by stumac
    Replies
    7
    Views
    743

    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...
  12. 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...
  13. Replies
    3
    Views
    553

    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...
  14. Replies
    2
    Views
    450

    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...
  15. Replies
    7
    Views
    1,023

    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...
  16. 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...
  17. Replies
    5
    Views
    746

    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...
  18. 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....
  19. 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)
  20. 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...
  21. Replies
    5
    Views
    843

    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.
  22. Replies
    5
    Views
    785

    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"
  23. Replies
    5
    Views
    158

    Re: .CSV Email issue

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

    Re: .CSV Email issue

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


    =HYPERLINK("mailto:"&E1)
  25. Replies
    4
    Views
    1,181

    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...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4