Recent content by Rolliee

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

If you wish your recordset to open in some order, you must specify that order. The data for the forms you describe above is a recordset. You can see that recordset if you go to the design mode, right click on the hidden button at the upper left of the form and look at the properties. One of...

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