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

Thank you so much for this tip! I'll check it out and let you know how I do. Steve

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'd like to have a copy of the custome email code also Please. Steve

That's exactly what i came up with for the time being. Wow what a coincidence. I used the timer interval (4 seconds) as the delay time then it closes. There has got to be some kind of work around though. Don't you agree? Thanks for replying so quickly! Steve

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

Thank you for replying! Yes, I know about emptying the filter property and the orderby property. My header/footer is not too large. I'm not using any queries with joins. The form is updateable (once the forms displays properly). The problem seems to be the syncronizing of the background...

I have the same problem. I checked my backend recordsource by viewing it in a dataview. The record is selected. When going back to the blank display I have to click on the records menu / Remove Filter/Sort in order to see my form objects and bound data. I'm using MS Access 2000 with Windows...

If I go to the Records menu and choose Remove Filter / Sort while the form is displaying blank, the form immediately display perfectly! Does this help? Is there a way to toggle the above menu item with code or is there a better way. Thank you in advance. Steve :confused:

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

I can help you if you are using Access 2000 or 2002. Find the file called MSCOMCT2.OCX. This is the control file. It will most likely be in your System or System32 folder. Copy it to the PC that you want to add it to (System or System32 folder). Open Up an Access form in design view. Click...

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

Thank you! Thank you so much. This is a great help to me! Steve

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: