Search results for 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...

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

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

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

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

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

Before I beat my head against the wall trying to do this, is there a way to use sql in the SendObject command? For example... DoCmd.SendObject acSendQuery, "qWVR", acFormatXLS, "hooty.mcboob@taxi.com", , , "First Pay Defaults","Please find attached the report for SELECT MAX(tWVR.dtmBusinessDt)...

My group has several inboxes to work and I want to know how many messages are in each box at the end of the day. I am assuming that there is code for that, but I not sure where to start. Thoughts? Thanks in advance! PJ

In a training worksheet, data is on lines 14-24 Below macro returns a count of 4 lines (but there are actually 11 lines of data. Sub LineCnt() Cells(14, 1).Select Dim r As Integer r = 1 Do While Cells(r, 1).Value <> "" r = r + 1 Loop...

I have form in which the user track account purchases. There are four steps: Quote Order Payment received Order Shipped There is a manatory three day rescission period that must be observed before the order can be shipped. I want to limit shipping until after the rescission period is up...

I have a report that currently reads in a column format and I want it to read in a row format. Forgive the kindergarten explanation, but here is what I am looking to do: Current format- 1 5 2 6 3 7 4 8 Desired format- 1 2 3 4 5 6 7 8 What is the best way to do this? Let me know if any...

I am working on a report where I want to show one of five custom symbols. The symbol that is shown depends on the status of a project. I have this functionality in a form and it reads like this If lngStatus = 1 Then Me.imgRed1t.Visible = True else all the other conditions End If How do I do...

I am using the LN function on a data set and it is returning negative values. Is there a way to bypass that error or just have a valid number substituted? Is there any more data needed to answer this question? Thanks, PJ

When I click on a web link in an email, Outlook hangs up for about 30 seconds. Then it pops up a 'Locate Web Link' box. I hit cancel on that and about two minutes later the IE opens with the correct page. This problem started about a week ago. It worked fine up to that point. I have not...

I use remote desktop to hit my office PC from the house via my laptop and VPN. Sometimes it is necessary for me to reboot the remote machine and I usually have to call some at the office to log in and reboot. Is there a way to force a reboot remotely? I am running XP Pro SP2 on the remote...

I have an Excel workbook that I save with the zoom set to 75% and certain windows frozen. When I re-open the workbook, all the saved features are reset. Is there a setting that I can change to make sure it does not delete my custom views? Thanks! PJ

I am developing a company tutorial in an Access database. I would like to code a command button to play a windows media file. How is this done? Thanks in advance! PJ