Recent content by Prog76

I have documents that need to be read-only, but that have headers and footers that is pulling info from an access database application. How can I get these docs to have write capable headers and footers, but not the rest of the doc? Please Help.

Try the onclick event of the button.

Actually in this case it doesn't because I am calculating a value for each record in that control depending on other controls for that record. Can someone please let me know if they have ever tried to do this?

Have you tried Me.Requery or SubForm3.Requery where SubForm3 is the name of that subform?

I am trying to sum an unbound control in a continuous form in the form footer and I keep getting #Error. What am I doing wrong?

Thank you so much!

Does that mean no data validation in the Close event????

I tried that and I got an error when I compiled: "Procedure declaration does not match description of event or procedure having the same name

I am checking for required fields in the OnClose function and if there is a field missing I want the Close function to stop. It just keeps closing on me. This is what I have: If Me!txtReqNum <> "" Then If IsNull(Me!optionReason) Then MsgBox ("Please enter a reason for the status...

This is how the code looks now: DIM objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "Provider=SQLOLEDB.1; DataSource = 192.168.114.144; Initial Catalog=ContactInfo; user id = sa; password = eleven" objConn.Open I am still getting the error. I appreciate...

Now I am getting Microsoft OLE DB Provider for SQL Server (0x80004005) Invalid connection string attribute ???????????

thank you so much; I can't believe that was my silly mistake. But now that I have the connection open, I am getting this error: Error Type: ADODB.Connection (0x800A0E7A) Provider cannot be found. It may not be properly installed. /connection.asp, line 12 In my code Provider = SQLOLEDB

I set up the connection and opened the recordset, but when I ran it this is what I got: Error Type: ADODB.Recordset (0x800A0E7D) The connection cannot be used to perform this operation. It is either closed or invalid in this context. /resultspage.asp, line 12 Here is my code; what am I doing...

Thank you both. I was finally able to figure this one out. I could not run the IRR function behind the code of the form while using control values from the form, for some reason, so I had to create a function within a module and then call it from the form. Odd isn't it. I guess this all...

I need to use the IRR function in a form with fields on the form as the values in the array. Could someone send me an example of how they did this? Is it possible to use the function simply as the control of the control source for the text field?