Search results for query: *

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

I do not have a lot of SQL experience so I hope this makes sense to someone. SQL Server 2000 is loaded onto our server. I have been working with it through my computer on the enterprise manager. Everything was fine until suddenly today I received an error: A connection could not be...

Thanks, but I have tried that already.

I have a form where I choose a name from a combobox. On the AfterUpdate() I have: Dim rs as Object Set rs=Me.Recordset.Clone rs.FindFirst "[Name]=""" & Me![cboName]&"""" If Not rs.EOF then Me.Bookmark=rs.Bookmark This works great until I have to add a new record. Once I add a new record, I...

I have the same situation. What I have done was have the front end on the network server and put shortcuts onto each individual computer. This makes updating a lot easier. You just have to make sure everyone has the proper permissions to access the server.

If your text content does not need to change very often, I would put it in MS Word and to a mail merge to it. If it has to change with the data all the time, I would put it into a MS Access report.