Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    110

    Re: Import SharePoint Excel Files

    I'm not sure how to create a SharePoint library in access as the link suggested. any idea on how to do that? If I do this will this link to the actual sharepoint site update as changes are made on...
  2. Replies
    4
    Views
    110

    Re: Import SharePoint Excel Files

    Well it looks like I finally stumped everyone with this one. Thanks for the views and if anyone looking at this knows how to import excel files on a sharepoint directly into access I would appreciate...
  3. Replies
    4
    Views
    110

    Import SharePoint Excel Files

    Does anyone know of a way to import excel files directly from a SharePoint into access
  4. Replies
    2
    Views
    734

    Re: Change date to month in ACCESS

    Great!! Thanks.. I tried that but, I was leaving the ) after the Completed Date was why it didn't work. Thanks again.
  5. Replies
    2
    Views
    734

    Change date to month in ACCESS

    I have a Complete Dt column with the date formatted as 10/8/2019 and I need a formula to convert this to the name of the month. Any ideas? I tried this but all I get is January in the column.

    ...
  6. Replies
    5
    Views
    118

    Re: IFERROR Formula help

    I understand now. thanks for all the help.
  7. Replies
    5
    Views
    118

    Re: IFERROR Formula help

    Not sure I follow. Isn't the last iferror telling me if column d in main city matches ai2 to populate the corresponding cell in column b
  8. Replies
    5
    Views
    118

    IFERROR Formula help

    I could use some help with this formula. First time using an IFERROR formula so not sure what I'm doing wrong. I keep getting a "too few arguments error". Any help would be appreciated.

    ...
  9. Replies
    3
    Views
    698

    Re: MSACCESS Formula Help

    That did it. Thanks
  10. Replies
    3
    Views
    698

    MSACCESS Formula Help

    Not sure why I keep getting an Invalid Syntax error for this formula. I want it to return "Complete" in the cell when StepsDetailOpen column cell is blank. Below is the formula I'm using. Any...
  11. Replies
    5
    Views
    563

    Re: No Read Permission message

    Thanks for the info. Iíll check google to see how to access the hidden tables. Btw it is not a linked table and I cannot open the query in design view either. Another odd thing is when I pull up the...
  12. Replies
    5
    Views
    563

    Re: No Read Permission message

    I Can't do this because I can't open the queries and I can't find the table anywhere so I can delete it. I assume it's hidden somewhere. Any ideas on how to locate the table if it's hidden.
  13. Replies
    5
    Views
    563

    No Read Permission message

    Anyone know how to clear this issue. I get this message with any query I run associated with this table and can't find this table anywhere now. I no longer see tt in my relationship either. I tried...
  14. Replies
    5
    Views
    767

    Re: AccesS Formula help

    Great!! Thanks for the help.
  15. Replies
    5
    Views
    767

    AccesS Formula help

    I could use some help with how to write this formula in ACCESS to determine age bucket for the column DaysAged. It works fine when I input just the formula for <= 30 days but, when I add 30-60,...
  16. Replies
    5
    Views
    803

    Re: Convert Excel Formula To Access

    Thanks. Iíll give it a try
  17. Replies
    5
    Views
    803

    Re: Convert Excel Formula To Access

    I got it to work by using this formula in case anyone needs this in the future


    <>5YRS_OLD: IIf([NTG INTERVAL]<=1825,"< 5yrs",IIf([NTG INTERVAL]>1825,"> 5yrs"
  18. Replies
    5
    Views
    803

    Convert Excel Formula To Access

    I am trying to convert an excel formula in access but don't have the knowledge to do so. Is there a way to convert this excel formula to run with my access query? This is what I am using in Excel....
  19. Replies
    3
    Views
    157

    Re: Pivot table Question

    I was looking to count the unique values when using the Pivot Table. I was able to figure out how to do this with Power Pivot. Thanks anyway.
  20. Replies
    3
    Views
    157

    Pivot table Question

    I have a spreadsheet with a column of names and column of dates. The column of names have duplicate names for same dates. I need to count how many names were on a certain date but my pivot table only...
  21. Replies
    2
    Views
    169

    Re: saving hyperlinks between Workbooks

    great!! Works well. Thanks for the help.
  22. Replies
    2
    Views
    169

    saving hyperlinks between Workbooks

    I am having problems with losng my hyperlinks when I save the exel spreadsheet to another workbook name. Is there any way to save my hyperlink info to another workbook so it appears in the new...
  23. Lose Hyperlinks when saving file to new name

    How can I retain the hyperlinks when I save my excel file to a new name
  24. Replies
    23
    Views
    612

    Re: Matching Number To Number In text

    I got it to work and it works great!!! Thanks for all the help. I'll definitely keep this for future use as well.
  25. Replies
    23
    Views
    612

    Re: Matching Number To Number In text

    I tried the formula this morning and this is what I got. No errors but the formula continues to show in the cell instead of the calculation. I checked the options tab and interactive calculations is...
Results 1 to 25 of 70
Page 1 of 3 1 2 3