Search results

Wayne, That worked . . . Thanks ! ! !

Wayne, This did not work either. I want the value in 'Bill Due Date' to change to red after it's been updated to a new date. I'm trying to accomplish this is 'afterupdate'. The value is changed after clicking on the 'Add Record' button.

Wayne, This did not work (see attachment). I want the value in 'Bill Due Date' to change to red afterupdate (i.e. 'Add Record').

Is it possible to change the color (to red) of text in a textbox after it's update. I don't see how to do this in the 'New Formatting Rule' in 'Conditional Formatting' of the 'Format' section.

Pat Hartman, One more question . . . why am I getting the 'This Recordset is not updateable.' error when trying to clear the textboxes in the form ? The error appears for both "" and Null. Me.[Bill_Due_Date] = "" Me.[LastPaid] = "" Or Me.[Bill_Due_Date] = Null Me.[LastPaid] = Null

Pat Hartman, Thank you very much ! ! ! I'll try what you said.

Pat Hartman, I can't select a new date for 'NextPaymentDate'. I want to be able to modify the 'NextPaymentDate' (from 'Date Picker'), then add this new record (with 'Bill_Name' and 'Last_Paid') to the 'Bills' table.

Arnelgp, I had to modify your code a little bit (missing '&' - see below). Still, the code does not put he the 'Last_Paid' date in the 'Textbox'. Also, the original 'NextPaymentDate' and 'Last_Paid' dates are not put in their textboxes. What I'm trying to do is load the these textboxes with...

June7, I want the results of the recordset (for 'Last_Paid' from SQL) to be put into the 'Last_Paid' 'Textbox.

JDraw, I'm not getting any errors. Attached is a 'Test' database. When I click on any name in the 'Listbox' I expected to retrieve the latest 'Last_Paid' date in the 'Bills' table.

How can I retrieve the results of the below SQL code ? Also, How can I replace the hard coded 'Target' value with the variable named 'Account' ? Dim strSQL As String Dim rs As DAO.Recordset Account = [List7].[Column](0) strSQL = "SELECT Bill_Name, Last_Paid, NextPaymentDate FROM...

Ridders, Yep, got the e-mail. That was the problem. Thanks again to everyone ! ! !

Ridders/Uncle Gizmo/CJ London, Thanks ! ! ! I viewed the images. My 'Edit Options' /Messaging & Modification' was not set to 'Instant email notification' as shown in 'attachment.php (663x75)'. I'll try this. Thanks again ! ! !

June7/Uncle Gizmo, Thanks ! ! !

I did not a response from an Administrator, I'm asking the question again. How can I be notified when someone answers my question ? It use to work and I did not make any changes.

How can I convert a table with horizontal data to a table with vertical data ? This example illustrates one row (Table 1) of data to many rows of data (Table 2). Source Table 1 Name Type Field1 Field2 Field3 Field4 Field5 Field6 Field7 Results Table 2 Name Field1 Type Name Field2 Type Name...

Ridders, Thanks ! ! ! I'll add these fields.

Ridders/Pbaldy, Attached is a sample of what I was referring to When a name is clicked on in the listbox, the 'Last Paid' date should be insert into the textbox, then a new record is inserted into the 'Bills' table.

I have a form (with a listbox) that gets it's listbox names from a query. I can retrieve names from listbox (via ---- '=[List7].[Column](0)') I also have a textbox on the same form. The textbox is not providing the date from the same query results. What is the problem ?

Ridders/Mark, That's the problem. I'm not getting any e-mails.