The way that the code is written now, FirstDate and LastDate are 12:00? When I make FirstDate and LastDate As Strings, they are just empty (""). I am trying to find the very first date in the Project and the very last date in the Project. I really just need help with getting the FirstDate to...
Jan,
Thanks for responding...I am not trying to generate the UniqueID. I want to get the UniqueID for a task. Would you know how to do that? Like I said earlier, I have tried a few ways to get it, but I have received an error.
Any help will be greatly appreciated.
Thanks,
Lori
I am writing a macro to pull information from a text file downloaded from Dell's website to insert into MS Project 2003. I am trying to get the TaskID or the Unique Identifier of a task after it has been added. Here is the code I am using:
'This adds the DetailInfo, which is a string, as a...
We are using Outlook 2003 with Microsoft Exchange 5.5. I have a user that was able to send e-mail before today, but today she gets the following message when trying to reply to a message:
"You don't have appropriate permission to perform this operation."
It also shows up when the Send/Receive...
The script runs, but nothing is populated into the UsersTemp table. I know that the query is correct in the script because I created it in Access as a regular query and it pulls what it is supposed to. When I open the UsersTemp table, nothing is there.
Thanks! That did work. I didn't even think about that. And the lecture wasn't unnecessary...I needed it to understand fully what I was doing wrong...So thanks for the extra time you put in. Now I am just having a problem with the data actually popluating into the table, but I'll get it...
Thanks! That did make the error message go away, but now I get an Overflow error??
I get it on the line in the do-while loop where I am trying to increase the autogenerated number?
I am using Microsoft Access to update a table on a SQL Server. The table on the SQL Server has an autogenerated number in it so I cannot just update the table and be done with it. I have written some code (will follow) to generate a number in the table and also to update the table. The...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.