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...
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?
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...
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...
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...
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...
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...
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...
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...
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?
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...