didacticone
Last Activity: Sep 20 '22, 05:57 PM
Joined: Oct 7 '08
Location:
-
HAHAHA, OK... I wrote a quick post to start a dialog... what's up your ass dude? Apologies, I haven't grown at the programming pace you would like, no need to turn toxic about it. Asking a question on a forum intended for questions to be asked is embarrassing? Sad that you feel so entitled on a message board to talk to people like this, that's what is actually embarrassing, lol. That's the sad thing about you keyboard warriors. Get me banned or... -
Using Access VBA to update Outlook
I was curious if there is a way to use a form in access and send that data to the default outlook calendar as an appt. I have tried this code but it doesn't seem to work.
...Code:Dim olApp As Outlook.Application Dim objAppointment As Outlook.AppointmentItem Dim objAppointments As Outlook.MAPIFolder Dim objNameSpace As Outlook.NameSpace Dim objProperty As Outlook.UserProperty Dim OutlookStartTime,
-
Appreciate the explanation, good advice, thank you, and thanks to everyone else on this thread for their input. The database is starting to come together nicely and I truly appreciate all of the help provided.Leave a comment:
-
Hi, sorry for the absence, took a little break, anyways, just to be clear Neo, nothing you said was offensive, it was helpful and I totally understand your point, and it is another learning experience, so thank you.
I did have a question, in post #21 I gave my explanation of what I did and that it worked. Can you elaborate as to why the code you posted in post #26 is better (I am not doubting it, just want to understand how it makes...Leave a comment:
-
That's what I tried initially cactus, but when I would try to requery only the control, it would requery the entire form. I tried my way after reading online that if the controlsource is set to dlookup, it will requery everything, not sure if that is true as a rule or not, but I know thats what was happening to me.Leave a comment:
-
Hey Neo,
I try to make things as clear as I can, because I know that is the only way you can provide substantial assistance; however I am not formally trained and most of my learning has been through books and the internet, so there are times, especially when I am rushing to get a response back on a message board and I am not articulating terms correctly due to haste or lack of knowledge.
I understand forms do not have...Leave a comment:
-
So I think I came up with a solution that seems to work. Curious as to your thoughts. I have made the text boxes unbound. The forms recordsource is a basic select query I made to filter out null fields as that was causing an error. In the on load event of the form I have...Code:me.txt_sport1.value=DLookup("[Sport1]","Q1") me.txt_sport2.value=DLookup("[Sport2]","Q2") me.txt_sport3.value=DLookup("Leave a comment:
-
Hey Neo, so my apologies, I am not using the real field names as I do not believe I have the rights to post them (my job may not want that). I can assure you that every field in my form is link to a field in the underlying table. I only have one table in the database as well. I was confused by "sport" and just used cactus' example of "sport1", again my apologies for the confusion. To clear it up, using your method, I have a form...Leave a comment:
-
All good my friend, i thought that was what you meant but just wanted to make sure. The "sport1" is a field in a table called tbl_master, it is a short text field.
I looked through the link you provided and tried a couple of different scenarios using cactus' method and it is still just requerying the entire form.
Your third paragraph slightly confuses me. I removed the controlsource and created a command...Leave a comment:
-
Hey Neo, so I created the form using your method, and it is still requerying the entire form. I don't understand what you mean when you ask "what is Me.Sport1 when it's at home". Also, maybe I am coding it incorrectly, I am creating a command button, and in the on click event I am putting the code above...or the different names I have tried.Code:me.sport1.requery
Leave a comment:
-
I tried renaming and it is still doing the same thing, I don't get it. And you are correct I am definitely more comfortable with this route, but my plan was to get it to function and then try it the way you recommended as to learn it a little better. Part of my anticipated issue is, won't I run into the same requery issue doing it your way as well?Leave a comment:
-
Also, when I add a command button, and try to requery the text box, it is requiring all of the text boxes? I have the controlsource set as you outlined and the command button has:Code:me.sport1.requery
Leave a comment:
-
That's what I was actually going to do lol, but then I thought, with more data that I add I would have a lot of queries and was just curious if there was a more condensed way to do it that anyone knew of. I'm by no means an advanced user and usually my solutions are work arounds until I learn a better way. Thank you for the feedback!Leave a comment:
-
Thanks for the follow-up neo, and your interpretation was 100% correct, I want each field value selected separately and randomly, and you stated. I have a follow up if you don't mind. With either method, would there be a way to just "requery" one of the fields and not the entire query. I am currently working using cactus' method and if I create a button with the me.requery it will randomize all of the fields. I am unsure as to how, if possible...Leave a comment:
-
Neo and Cactus, I tried both of your suggestions and they both work. I'm going to test them out some more and see the pros and cons of each, but thanks so much for the help!Leave a comment:
-
Randomize
Hi,
I am trying to create a form, that will randomize data from a table. For example, I have a table called "tbl_master ". It has 3 fields, sport, athlete, speed. I would like the form on a button press to take one random entry from each field. I have managed to do this with one field, but cannot figure out how to do it for all 3. What i have done so far is created a select query and use the following:
...Code:SELECT TOP 1
-
I understand what you provided, but yes the issue is, it is the body of an email, and as i said in my first post when imported over, the body of an email goes into a field that is auto created called contents. you are correct that the people providing this information are not concerned with making my life easier, but i have certain requirements that i have to follow and figuring this out would certainly make everything easier. What i did not explain...Leave a comment:
-
I appreciate your help, and apologies for not making this clear. the emails I am receiving are from an outside company in regards to work that needs to be completed by my company. I do not have control over how they format anything in the body of their emails. I am just trying to work with what I am given. The body of the email contains a lot of data, the exact row in the body of the email looks like this "Start Date/Time: 07/23/19 At 08:00...Leave a comment:
-
Extract data from outlook email body
Hi Everyone,
I have linked my outlook folder to a table in access. My problem is the body of the email is in a field called contents. I need to extract certain information from the body of the email or contents field. For example, within the body of the email there is a start date, laid out in the email as "Start Date/Time: 1/1/18 at 7:00". I need to be able to extract that piece of information for queries and the like. Perhaps... -
Yes, if i login under the profile of the secondary email address it works. the issue seems to be linking a secondary email address while not being logged in as that user.Leave a comment:
No activity results to display
Leave a comment: