Search results for query: *

It sounds to me like you need a reference to the DAO library to include the DAO methods.

How does one start ppviewer at slide 15 and go to 24 for instance.

QuickViewPro will allow you to view such files. Rollie E

Does anyone know a method of changing Lotus Word Pro files with an "lwp" extension to "rtf" or other protocols? I no longer have access to WORD PRO Rollie E

Use the unbound combo box click event to enter a new "data source" in your to be filtered combo box. rollie

Have you considered using command buttons to perform the desired function 'on-click?'

dlackey, I just built a mdb as table1 with a field named field1. I tied the data to form1 with an unbound box named text2. The following code says "bingo" when there is a hit and somethiing else with no hit. There are more sophisticated ways but try this. Private Sub Text2_DblClick(Cancel...

Until you place a value in a field ie; (me!pic1 ) it is filled with a null value which is like no other. null + 1000 = null is an exmple. One way to get around a null is to use the nz( ) function which changes a text value to "" and a number value of null to zero which is manageable. You could...

ooops!!!! Rollie

Use "set" in front of the r2 - good practise. What it appears to be saying is that you have not created an empty table of the name you use or you have not set the Tools/ Refverence/Microsoft DAO 3.6 in your libraries Rollie E

What is the error? Try it with the "s" removed from the set command. r2 = currentdb.recordset("History") Rollie E

This can be done with DAO or ADO. I prefer DAO and the following code will do what you want. DIM r2 as DAO.recordset , r1 as DAO.recordset ' this requires the DAO library to be checked in Tools/References in the Design Mode. set r2 = currentdb.recordset("NuTable") r2.addnew r2("fieldname1")...

Just write a public function in a module and send the two sets of text to the function with a return variable of the line as you describe it. If you need the code for such a function, ask and I will code it for you. Rollie E

...right click on the hidden button at the upper left of the form and look at the properties. One of them is the data source. Double click on that data source and you will see something like "SELECT * FROM tblSubscribers WHERE <critera> ORDER BY SubID;" The ORDER BY you will have to add...

Add your text field but do not try to make an autonumber anything but a long integer. Keep the autonumber and make your text a primary key. Rollie E

What are you doing with the text files? If you want to parse into a table, you can read them as a binary file and do the parsing. What you do with them makes a great diff. Rollie E

Do an ORDER BY on the recordset of the date value. If you want it to be latest date first add a DESC to the order by. "ORDER BY" is one of the reserved methods of a recordset. Rollie

You need to tell us why you want to do what you want to do. The recordset source of a combobox is, of course, a recordset. You can set the criteria to the test value of "hello" or any other OR You can search the recordset for the value. It depends on what you want to do with it once you have...

'97 has a DAO default recordset. 2000's default is ADO. To use the DAO is rather simple and the thing to do if you have any '97 users. Just link the design Tools/Reference to one of the DAO's 3.51 or 3.6 and then define the recordset variable as a DAO.Recordset Rollie

Lloyd, It sounds like you would do well to create a JOINed query with the main table the Sum table and the JOINed table the subordinate table. Then let the 'wiz create a form with that query. An alternate would be to use the Sum table at a main form and use a a subform to tag all the child...