Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PJFry
  • Order by date
  1. PJFry

    Parameter value on update query

    Perfect! That did the trick.
  2. PJFry

    Parameter value on update query

    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...
  3. PJFry

    sorting record in form view

    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...
  4. PJFry

    SQL- Update an multiple user table

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

    SQL- Update an multiple user table

    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...
  6. PJFry

    Save an Excel file with a new name

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

    Save an Excel file with a new name

    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...
  8. PJFry

    Save an Excel file with a new name

    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...
  9. PJFry

    Help creating outlook form

    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...
  10. PJFry

    E-mail a recordset

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

    E-mail a recordset

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

    E-mail a recordset

    ...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 queries, but I have never tried it with a recordset. Thoughts? Thanks in...
  13. PJFry

    Using UnReadItemCount in Outlook 2003

    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...
  14. PJFry

    Using UnReadItemCount in Outlook 2003

    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...
  15. PJFry

    Using UnReadItemCount in Outlook 2003

    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...
  16. PJFry

    SQL changes in design view

    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.
  17. PJFry

    SQL changes in design view

    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...
  18. PJFry

    Insert IE file into Excel

    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.
  19. PJFry

    Insert IE file into Excel

    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...
  20. PJFry

    Add SQL to SendObject?

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

Part and Inventory Search

Back
Top