Search results

I'm trying to retrieve the value in the 'Category' field of the 'Sales Tax Table' table with a VBA SQL statement. The SQL statement matches the 'Name_Choose' (textbox) with the value in the field 'Company Name' in the 'Sales Tax Table' table. I need to place this value in 'Category_Name'...

No, [Sales Tax Table] is a table.

Run=time error '3061' Too few parameters, Expected 1.

theDBguy, Did I miss something ? This did not work. Dim strSQL As String Dim rs As DAO.Recordset strSQL = "SELECT [Sales Tax Table].[Category_Name] FROM [Sales Tax Table] WHERE [Company Name] = '" & Me.Name_Choose & "'" Set rs = CurrentDb.OpenRecordset(strSQL, dbOpenSnapshot)

How can I retrieve the results of the below SQL statement in VBA ? Dim strSQL As String strSQL = "SELECT [Sales Tax Table].[Category_Name] FROM [Sales Tax Table] WHERE [Company Name] = '" & Me.Name_Choose & "'"

Ridders, Great, that what I need. How can I achieve this ? Are there any examples ? What code is needed ?

Is it possible to share tables with two (2) different databases ? To clarify . . . I have a database that collects data into tables (via form) that are needed to produce reports by a different database.

Wayne/Arnelgp, It works . . . Thanks to the both of you ! ! !

Arnelgp, Got it . . . Thanks ! ! !

Arnelgp, You still uploaded the wrong database . . . Nothing changed.

Arnelgp, You're right . . . I fixed this by adding Me.Bill_Due_Date.ForeColor = 0 in BeforeUpdate. Also, did you load the wrong version for your solution ? The textbox does not change the color to red.

Arnelgp, Wayne solution worked. Did I miss something, what were you referring to ?

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