Search results

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.

Galaxiom, Got it, but which one is for e-mail notification for answered questions ONLY ?

I don't see a 'Control' panel. Where is it found ?

Ridders, That worked . . . Thanks ! ! !

Is it possible to get an e-mail when someone answers a submitted questions ?

Pat/Ridders, I'm running the code a button on the form. The statement is as follows: Right(Year([NextPaymentDate]), 2) & DatePart("y", [NextPaymentDate]) Unfortunately, I'm not getting a leading zero for two (2) digits dates. If it possible to use the above command for two (2) digits date...

Pat, I tried your suggestion (shown below). Nothing is being returned. What am I doing wrong ? 'NextPaymentDate' is a textbox on the form. Format(NextPaymentDate, "yy") & DatePart("y", NextPaymentDate)

Arnelgp, I'm receiving the below error for your recommended (as shown below) VBA statement. It appears that a reference is missing. Which one(s) is the statement looking for ? Undefined function 'JulianToDate' in expression DoCmd.RunSQL "Insert Into Bills (NextPaymentDate) SELECT...

Ridder, I'll try adding the shortcut to the 'Startup' folder. If this is still slow, I'll re-read your previous comments. Thanks ! ! !