Search results

Yes, it's an Exchange server. Is it having trouble communicating?

I'm at a loss for words... I'm still receiving the same error message, but now it's on the line "MsgBox olNSpace.CurrentUser" I'm looking through the Locals window and I see CurrentUser = <> , with Type: Recipient. I don't know if this has anything to with it, but I'll just throw this...

Adding the olTask.Assign didn't seem to have any affect on the program (But it didn't hurt it). I added the MsgBox commands - the first one didn't work for me, but the second two did once I commented the first one out. When I clicked Debug to look at the first line a mouse over revealed this...

When I added those lines it was able to display the task item as "Untitled - Task" before erroring out at the usual location. So this confirms that it's not the Outlook object reference. We use a Global Address List to manage our personnel connections, but if at all possible I would rather...

Yes, I've created my own training tasks previously (which is what gave me this idea to begin with), and I've also created / assigned tasks to some of my guys. I created a contact for myself just now and tested that out. I tested out various versions (Before and after I created the contact)...

Yes I did - I added the variable initialization, and replaced the assignment code with what you suggested. It's strange, it feels like it doesn't know what to do with the variable. I was going to update my above post, but figured I'd just do it here since that was ages ago. Private Sub...

Thanks, I set the "Recipients" back to a singular Recipient. I enabled the Save/Display lines to see if I would get at least one confirmation, but I didn't, so it appears that it doesn't cycle even once. Yes, Outlook is open. I have also just switched it over to "strRecipient =...

I tried to sneak back to work over the weekend but my wife didn’t like that idea… So this morning I tried your code and enabled the Outlook object reference. Enabling the reference did allow the compiler to work past the point that it was stuck at. But now it’s giving me another error that I’m...

No, sorry. I went home for the day, but the suggestion makes sense. I'll implement it at the first chance I get. Thank you!

Yes, the idea is that it should set up the task item and then assign it to one of my personnel to complete so I can be notified when they mark it as completed. It would do this for each record that the query produced. Thanks for your time.

Hello all, I'm struggling to understand how to accomplish this. At first I tried taking what I learned from two different forum posts and make it work, but I wasn't really sure what I was doing, and couldn't get anywhere. So I tried another aproach, and still wasn't able to get this working...

It's been a while since I've been here. I'm back at it again. I'm trying to teach myself by creating an Access database for my own personal use at home. Let's jump right into it. My project is a Chores/Rewards database for my wife and me to use for our three kids. The current goal I have...

I'm trying to come up with a function that can track how long a user of the DB has been inactive for, and once it reaches a determined limit, it would save and close the DB. At the moment I'm just playing around with a test database. I have a form with a button on it (Command0 - I didn't...

Version 2010 The radio/option buttons are just sitting on the spreadsheet. I moved them into some cells near the top. They are the ones that look like dots that become filled when you click them, but become unselected when you choose another. There's no macro on them. The plan is to refer to...

I wasn't sure if I should have added this here, or in the Excel section. I'm trying to do this in Excel, so here goes. In my spreadsheet I'm using VBA to modify the contents of a pivot table. It works really well, actually. However, I'm also trying to include three radio/option buttons that...

Update - I figured it out! Original message: Hey, I copied some vba code from elsewhere and I've been trying to modify it to fit my needs, but it's doesn't work as expected. When I step into the process I can see that it recognizes LastRow as being row 63, but then nothing else happens...

In your opinion what would be the easiest way to do this? I have two tables that in essence are identical. The big difference is that one is meant to be a finalized version of the other. For simplicity sake let’s call them “CurrentData” and “FinalData”, and the idea is to import data from an...

That worked great, it really beats using an IIF statement twice. DDR: IIf(Len((Select count(*) from tblG081MDCDataImport AS TMP Where [tblG081MDCDataImport].[TIMESTAMP] < [TIMESTAMP] AND [tblG081MDCDataImport].[EVENTID]=[EVENTID] AND [tblG081MDCDataImport].[ACFT]=[ACFT]))=1,"00",IIf(Len((Select...

CJ_London's recommendation actually worked just fine - I'm assuming this method creates a temporary copy of the table to compare to? Sorry for the long delay, got caught up in work but now I need to return to this. Here we go: "tblDataImport" stores data imported from of a delimited text...

I have a ranking issue. I put together the below expression but I get "0" for every value - One of them should read "1". I have a text file linked to this database, and I'm trying to create a Query that will pull all of the data out of this text file, and add a rank if two of the values match...