Recent content by TJC

I was hoping to maintain local control over when the tables are updated. The table content doesn't change on a routine basis. Can I execute some procedure out of adp?

I currently have a database that has been upsized to Microsoft SQL server. I administer the content of the tables locally with an Access 97 database. Rather then re-creating all the forms in ADP, I want to create a stored procedure or some other function to periodically update the SQL tables...

JPeters, thanks for response as well. The table name is Inventors that the data is being pulled if I undersstand your question correctly. The previous code worked in Access 97 and I also converted this database to Access 2000 with no problem. I pasted your code as written above but still...

Thanks for your response. I changed the Dim statement for dbs as you suggested. I still get the same error message. Any other suggestions?

I recently had an Access 97 database converted to ADP. I can't get any of the forms to work. I've updated my references and added DAO to a statement in my code. I still get Error 91, Object variable or with block variable not set. Debugger highlights the "Set rst" statement. Here is my...

I added "Find Record" and "Find Next" buttons using the Access 97 wizard. However, they don't work. When you click the button it launches the dialog box. You enter your search criteria and it can't find anything. For example, I put my cursor in a field named "Title&quot...

I updated the code for the select customer combo box as follows: Private Sub CbSelectCustomer_AfterUpdate() Dim SQL As String SQL = "SELECT

I have a quotations form (Access 97)with two combo boxes. The first is a two column combo box listing all quotations by quote no. and Title. The following is the code. Private Sub CbQuoteNo_AfterUpdate() Dim myDynaset As Recordset, myCriteria As String Set myDynaset = Me.RecordsetClone...

Is it possible with a plug-in of some type to save or export PDF forms only using the Adobe Acrobat Reader? Everything I've read so far indicates that a user would need the full Acrobat product to save a completed form to their local drive. Most of my users need the ability fill out the form...