Search results

Before attempting to create a VBA User Defined Function that will accept arguments for creating UPDATE/INSERT INTO SQL statements, I thought I would check to see if some already exist. It seems like a very tough task to tackle. I'd like it to determine the data type of the the values being...

How do I suppress the "Save to PDF file" dialog box when sending a print job to the default printer Acrobat Distiller? I'm using Access 2000, ADO, VBA. Would someone please provide me a code sample that will allow me to print a automatically name file name to a designated path without having...

I know how to overcome this problem if I'm working with numeric values but a string??? The following is an example of the line of code that produces this error. I dimmed APNumber as String. The vno field is 6 chars wide. If APNumber <> rsApp2.Fields("vno").VALUE Then This problem is only...

I noticed that when I use ADO in the backend of a dataview form, upon returning to the display the changes are still not reflected. If I hit my button event (Me.Requery) immediately I still will not see the changes made. I must wait about 2-3 seconds before hitting the me.requery button...

While in form1 (a tabular form) with database1Query as the recordsource, I CALL a public procedure in a General module. The database1 table is opened, changed, .updated, .requeried with ADO. Once done, I return to form1 and do a me.requery. The highlighted record does not display the latest...

Please help me Cyber Buddies! What used to work with DAO does not work now with ADO. I want to use ADO from now on. I have a form that has a backend query as the recordsource. I filter the record I want by calling a function (i.e. GetPOnum()) to retrieve a value in a public mem var. The...

Dear Cyber friends, I want to learn how to update a table within a distant web site Access mdb file with the data maintained on a local Access 2002 mdb file. I'd like to add a button in a local mdb form that will connect to the distant web site and send the data. I'm familiar with ASP...

Help! I'm converting my code from DAO to ADO. With DAO I simply call my stored query with: Dim db1 as database, rs as recordset set db1 = currentdb set rs = db1.OpenRecordset("Stored Query") How do I do it with ADO? Please show me the code syntax. Thank you! Steve :confused: