Recent content by dudezzz

  1. D

    How do I create this report? (Access newbie)

    Agree Excel would be a better standalone if one person were to do this. Reasons why I want this in Access: 1. Eventually, 6 teams with different set of data will input data 2. Right now I am entering data into the tables myself. Eventually, I will have a form to collect data 3. Also after a...
  2. D

    How do I create this report? (Access newbie)

    Thank you for jumping in on this. Currently folks are doing this work manually in a word doc. I am just trying to automate that. Data entry happens directly on the tables and we need to spit out a report. does that answer your question?
  3. D

    How do I create this report? (Access newbie)

    I am getting stuck with the xtab qry and unable to get it to show the data in the way you described. I don't need a form for parameters so OK with hard coding the month variable in Q1 for now. Are you able to help me with step 2 and 3 please? i have attached a stripped down version of the db I...
  4. D

    How do I create this report? (Access newbie)

    thank you so much. working on your feedback now.
  5. D

    How do I create this report? (Access newbie)

    Hi, I have used access before but lost touch. Need some help to get me started please. Forgive me for asking such an elementary question but I am stuck for more than 2 hours googling. any help would be most appreciated. I have two tables as below (tbl1 and tbl2). I need to create a report...
  6. D

    Export Outlook email to Access - Run Time Error '424': Object required

    Found it. Appears that this line should be: OlApp.GetNamespace("Mapi").GetDefaultFolder(olFolderInbox).Parent.Folders("Test") My revised code that works in my environment is below. Thank you both for helping me today.:D Private Sub cmdmail_Click() Dim TempRst As DAO.Recordset Dim rst As...
  7. D

    Export Outlook email to Access - Run Time Error '424': Object required

    Thanks for helping me understand this a little better. While I did not yet fix this code, I have a working code below that I used by tweaking the code found in http://www.blueclaw-db.com/read_email_access_outlook.htm My working code that does the job is below. I hope this helps someone like...
  8. D

    Export Outlook email to Access - Run Time Error '424': Object required

    http://www.vbforums.com/showthread.php?624260-Automatic-email-export-to-access-VBA
  9. D

    Export Outlook email to Access - Run Time Error '424': Object required

    Thank you for giving your time on this. I tried what you suggested, but that gives an error "Method or data member not found" VBA doesn't show me options when I type "adors.items" in the VBA editor. Maybe that is not a method? I don't know....Perhaps you are steering me in the right direction...
  10. D

    Export Outlook email to Access - Run Time Error '424': Object required

    Hi, With the following code assembled from multiple sources online, I am attempting to download a specific folder in my Outlook Inbox (outlook 365) into my access table called "Email" (Access 2016). I get a Run time error '424' Object required on the line: If Items.UnRead Then What am I...
  11. D

    Hyperlink Address pointing to SharePoint URL

    Yes, SharePoint URL has a http:// prefix. thank you, and sorry for my delayed response. I was admitted to the Hospital briefly...all ok now :)
  12. D

    Hyperlink Address pointing to SharePoint URL

    Hello, I have an Access Form (Access 2016) with a drop down box and a button. The After Update event of the dropdown box has the following code to populate the hyperlink address in the button: me.cmdbutton.hyperlinkaddress = "http address pointing to our sharepoint site" When i choose an...
  13. D

    Importing multiple Text files with "Field Name: Field Value" into a Table

    Re: Importing multiple Text files with "Field Name: Field Value" into a Table Thanks for your response. I actually have about 45 rows of information, to get the idea across I entered 3 rows. Would it be possible to share a code sample please?
  14. D

    Importing multiple Text files with "Field Name: Field Value" into a Table

    Hi, I have about 100 text files of the following format: Name: John Doe Address: 123 Main Street Zip: 55555 Name: Jill Doe Address: 234 Clyborne Zip: 66666 I need to import all these text files into a Single Table in Access. Obviously, the table would look like this: Name Address...
Top Bottom