Search results

  1. R

    Problems with linked table from compacted excel pivot table

    Hi, I have a very large excel file that is updated monthly and left in a compacted pivottable. It has confidential information that obviously can't be shared but needs to be parsed for each individual employee and emailed in a table format so that it is easy to pull into excel or Access. I have...
  2. R

    Access to Outlook Calendar for Alert or Alarm Message Reminders

    Thanks for the quick reply. I need to create a new record and it worked. Now I just need to figure out the email part. Have a great day.
  3. R

    Access to Outlook Calendar for Alert or Alarm Message Reminders

    Hi, I added the table and form and code as described initially in this thread and was able to successfully add ONE appointment. If I change any of the other details it tells me it has already added the appointment but it refers back to the original field. I didn't see that anyone else posted the...
  4. R

    Visit planner

    Hi DBGuy, Ultimately I need to see where customers are in relation to each other from their addresses and reorder for meeting planning. I generate a list of 5 customers labeled 1 thru 5, map them and realize that i need to switch the order to 3,4,1,5,2 based off of proximity. I then reorder...
  5. R

    Visit planner

    Hi, I am trying to simplify my business trip planning process. I generate a list in a table which includes customer names, addresses, date, time plus some other data I use for my suppliers. I manually pull each address into google maps to determine the most efficient route. I thought about...
  6. R

    Crosstab query with qtr and year

    Hi CJ, Ultimately I would like it to look like Supplier Name , customer name Q1 2018, Q2 2018, Q3 2018....Q2 2019. I have other metrics I will add like average runrate and other information like Gross profit. I am definitely open to more suggestion. Thank you in advance. Barry
  7. R

    Crosstab query with qtr and year

    Thank you.... I got an error and edited it to: PIVOT "Qtr " & Format([Invoice Date],"q" & "-" & "YYYY"); It works!
  8. R

    Crosstab query with qtr and year

    Hi, I am working on a forecasting tool and I need to see historical sales by supplier by customer by quarter by year. I made two crosstab queries one for quarter and one for year but am struggling to get them together with a union. The quarter query doesn't show the year and well the year...
  9. R

    Combining two queries in one sql statement

    Hi, I am relatively new at access and am trying to reduce the amount of objects in my database by combining queries or embedding queries in forms. I am breaking the "if it ain't broke don't fix it rule". I receive data updates daily which I have linked to a table in access. It requires some...
  10. R

    Attachments from Outlook automatically saved for use in Access database

    Hi June7, Sorry... nothing happened. I first tried to put it in the thisoutlooksession but nothing happened. I then moved the code to a module and setup a macro button with the same result. Here is the code in case you see something I missed. Thanks, Razzbarry...
  11. R

    Attachments from Outlook automatically saved for use in Access database

    Hi June7, Happy New Year! I gave it a go and wasn't successful. I updated the file names as you advised plus the path. Do I also need to update strFolderpath = strFolderpath & "\Attachments" statement or is that ok? Did I miss anything else? I set it up as a macro button and also as a test case...
  12. R

    Attachments from Outlook automatically saved for use in Access database

    Thank you, I will try tonight and report back
  13. R

    Attachments from Outlook automatically saved for use in Access database

    Hi June7, That is correct and it only renames it. Downloading it is a nice plus. The file names are correct with the exception that there are two opps reports. One is SLX opportunity review and the other is SLX Open opportunities OSR Where should this code reside? thisoutlooksession or module...
  14. R

    Attachments from Outlook automatically saved for use in Access database

    Hi June7, I started to look at modifying the code in the link you provided and found myself unsure what code to use and what to delete or comment out. I did a search and changed my search words and found the following link...
  15. R

    Attachments from Outlook automatically saved for use in Access database

    Hi June7, No, I do need to download it as I haven't already saved the file. The file location is always the same. I do write over the old file. I do eventually delete the original file but I do that in Outlook. I could do that automatically to once I have reasonable confidence that everything...
  16. R

    Attachments from Outlook automatically saved for use in Access database

    Maybe I am looking at this the wrong way. Since there is code out there that increments the file name in some manner then saves it on the hard drive upon receipt. Is there a way to have access look for that file despite the increment like backlog*.xlxs? Right now I have the file backlog.xlsx...
  17. R

    Attachments from Outlook automatically saved for use in Access database

    Hi June7, I believe you are correct. I was hoping somebody had already invented the wheel or might have some links to help me. Have a great day. Razzbarry
  18. R

    Attachments from Outlook automatically saved for use in Access database

    Hi All, I receive several reports daily which I want to automatically rename and save into a folder where Access will read from when I open my access file. This way it automatically gives me the latest information from those files. Example: I receive a shipping, booking, opportunity, and...
  19. R

    Deleting leading and trailing rows after/before import

    I tried like"*" in field5 and it works to take out leading and trailing rows with unwanted data. Thanks again!
  20. R

    Deleting leading and trailing rows after/before import

    Wow CJ....just wow. That was so simple yet so profound. I will apply it in my database and advise. I can't thank you enough. Is there any way to keep the headers?
Top Bottom