Recent content by kit_sune

I should have mentioned that the tables cannot be linked. The only field that they share is the tool field, but multiple records in each table can have the same tool. That’s why I didn’t do a query to start with.Imagine this scenario:I have 4 records in table 1:Tool | Operator | CheckoutDate |...

Keep in mind this code is based off my notes and memory because I don't have access to the computer that this code is at right now. (there may be errors) If there's a better way, please let me know!! So the code works right now to do what I want it to do, with one last thing to figure out...

I'm impressed, that worked really well! I usually try to find any way I can to do as much as possible in one query - Having so many queries makes me feel overwhelmed. But I know that sometimes you just can't avoid it. I found a naming convention that helps to make things blocked together...

I have a table of data where an instance of a job is recorded each day (a kind of snapshot, if you will). Each record has a serial number recorded, as well as a few other fields. In most cases all the fields are identical. What I'm trying to create is a query that displays records where they...

I was afraid that I would have to do that. I was hoping to stay away from that option because I have two additional qry_totals that I need to establish. In other words, in the example I've given there are six base queries. In total, there's actually 18 base queries. I'll have to create a 18...

Hello! I'm running into an issue where I'm trying to tie several queries together into a list one running total. I have six queries that pull data from the same table, but that meet specific criteria. What I was trying to accomplish was to have a 7th query count the records in each of the six...

Alright, here's what I've been able to do. I'll admit, SendKeys feels risky, but it seems to work well enough. I read that DoEvents can slow the processor a bit, but when I tested it out it didn't have much of a lag at all. Private Sub SendTasks_Button_Click() Dim olApp As...

The only reference I could find for SendKeys in this context was here: http://www.mrexcel.com/forum/excel-questions/703891-recipients-add-method-causing-error-287-a.html I attempted to add sendkeys to this but the problem that I ran into was how, even with setting it's delay to "True", the...

Just for the sake of trying to contribute something... I played around a bit and I have something that works. I would have to manually add the delegate myself for each training task that is required, which isn't ideal, but at this point, not a dealbreaker... I can work with that. Private...

I understand. I think I am just grasping at straws because I really don't want to have to go through Outlook. I would like to learn more about how you would have Outlook / Access talk to each other. Maybe it wouldn't be as bad as I'm anticipating!

I remember now, looking back at it, that on post #19 we did do ".Assign" first, at the time, but it didn't seem to help. http://www.access-programmers.co.uk/forums/showpost.php?p=1431023&postcount=19

Do you think maybe we need to put the ".Assign" first, to allow a delegate to be put into the task? I Checked through some of our previous work and found that "Assign" was put after the delegate / resolve lines. When I started to think about this I looked into the .Assign method and found that...

I gave that a try, but this time it produced the error at: "With olNSpace.GetSelectNamesDialog" Something that I noticed when playing around with the previous code was that the task that would display didn't have an option to send to a delegate - I had to click the assign button first before I...

I was hoping to be able to allow anyone in a supervisory role of my office (There's currently 5, but will be 3 soon) to be able to use this feature, and I'm afraid that if it needs to be plugged into Outlook in any way, that they, or anyone in the future who needs to add this to Outlook, would...

Do you think this would be possible: Instead of "With olRecipient", perhaps we could set it up to build the entire task first, but leave off the recipient... then, establish a pause when the system displays the task for me to manually add the recipient, and then continue after I acknoledge that...