Recent content by TeriCoombes

You are so awesome! It worked. Thank you.

Is it possible in ADP to have a combobox in a form that filters a second combobox in the subform? I am developing a purchase order database where an employee would select the company and then the subform combobox would list only those items sold by that company.

I am at a loss as to how to create this stored procedure. I am basically trying to copy a record in my table and insert it into the same table, but with a different primary key. Can this be done?

Thanks! It totally worked!

I am having a problem with my SQL statement. I am trying to query out results in a table based on a date column. However, when I try: WHERE (dbo.tblTestResults.LastModified = Date()) I get an ADO error that says Date is not a recognized function. When I try: WHERE...

It worked. Thanks.

I have been looking for a conversion style number that will change my datetime field from 1/1/1900 03:00:00 to 03:00 (hh:mm). Everything I have seen so far are styles that will change my field to hh:mm:ss. What I am trying to ask is if there is a style code for just hh:mm? Any help would be...

The combobox is bound to the Analyst table. And that is working correctly with the form. The problem is getting the table to take the value from the combobox.

I have a form that requires a user to select their name from a combobox before they log in data. Their name is then supposed to be added to the records they modify. In the form I have: =Forms!frmSelectTest!cboAnalyst which displays their name correctly. However this value is not inserted...

We recently upgraded our system to SQL from Access. We had fields in Access set as hyperlinks. When the data was put into SQL, the hyperlink became a text field. Also, when I link back to the SQL through an Access front-end, the hyperlinks are now memo fields. How do I get the hyperlinks to...

I figured out what my problem was. PHV, your code worked when I changed the procedure to After Update instead of On Change(). Thanks. [thumbsup2]

Neither of them worked. [sad]

I have a form that requires the user to select a test name and their name before enabling a command button that allows them to enter data. However, I can go to the form, delete the name, and still have the command button enabled. How do I disable it when the selection is null? Here is my code...

Thanks. I am going to give it a try.

SQLBill: (1)I am using Enterprise Manager on my computer while SQL Server is on our server. (2)I am still connected to the server because I can still use the ADP that is on my computer. (3)We have set up the databases and connections for Windows authentication. (4)I don't know what my default...