Search results for query: *

Perfect! That did the trick.

I have an audit log that records the values of a control before and after it is changed. The first part of the process runs on an OnDirty event to record the value before the change and the second part runs on an AfterUpdate event (code below). The OnDirty part works fine, but when I try...

If it were me, here is what I would do: First, change your months from text to a number, say, long integer. January will now be 1, etc. (You may wish to create a new field for the numeric date and run an update query to populate the new month, then just delete the text months.) Call your new...

Perfect! I was thinking it may be the syntax, but I am just too fried to figure it out. Thanks! PJ

I am creating an audit log for a database that tracks contract in my company. When a user makes a change to a field in the database I need to know what the original value was and what the new value is. The original value is captured on an 'On Dirty' event. I want the new value to be captured...

Thanks for the re-direct! I will post it in the correct forum.

I am new to Excel VB and I want to write a routine that will save the current Excel file in same directory as the original, using the same name as the current file with '_External' appended to the end. The current file is : C:\Rpt\Richards_June07 The new file will save as...

I am new to Excel VB and I want to write a routine that will save the current Excel file in same directory as the original, using the same name as the current file with '_External' appended to the end. The current file is : C:\Rpt\Richards_June07 The new file will save as...

I just started a new job where part of the team prints out survey results, hand tallies them and inputs the data to Excel. (I am back in the dark ages.) I want to create a form that replaces the text surveys and gives me the abilty to export that data into Access. I do quite a bit of coding in...

LF, Perfect! Now that I look at how it is done it makes perfect sense. Thanks! PJ

That is where I am stuck. I have never converted a recordset into anything like a query.

I want to e-mail a recordset as an excel file. Here is what I have right now: Sub Mailrs() Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection Dim rs As New ADODB.Recordset rs.ActiveConnection = cnn1 rs.Open "SELECT * FROM tContract" End Sub I know how to e-mail objects like...

I ended up going with the code below that I pieced together from other sources and little common sense. My last question is how to point the code other Inboxes. There are five Inboxes that I want to run this on. For example on is call 'Mailbox - PIC'. What is the proper way to do that? Sub...

Here is what I currently have Sub CountUnread() Dim myOlApp Dim myOlNameSpace Dim objFolder Dim itms Dim ItemCount, UnReadItemCount Set myOlApp = CreateObject("Outlook.Application") Set myOlNameSpace = myOlApp.GetNamespace("MAPI") Set objFolder = myOlNameSpace.GetDefaultFolder(6) Set itms...

I am looking for a way to count the unread items in an outlook folder and have the subject and date received written to a text file. I have seen the UnReadItemCount used to give the count in a message box, but I am not sure how to use it to write the above data to a file. Suggestions? Thanks...

Nuts. Well, at least I am not the only one... The good part is that I am mostly done with changes. Glad you like the handle! Not many people get it.

Below is a statement that works correctly; however, when I open it to make a change, part of the statement is automatically changed and causes an error in the query. SELECT [CurCount]/[PrCount] AS 7RollRate, T1.CurMonth, 7 AS Bucket, (SELECT MAX(BusinessDt) FROM WVR) AS BusinessDt FROM (SELECT...

Not quite. What I am looking to do is to actually imbed a file into excel. It is almost like hiding one document inside of another.

My company uses the Internet Explorer plug-in for Hyperion Intelligence. We use Hyperion to query various loan data from managed portfolios. The summary data is then dropped into Excel sheets and send it to the relevant folks. One issue that we have is that different analysts will update...

Perfect! I have always seen the 'D' commands, but have never really looked into them. Thanks for the help!