Recent content by smallh

I have a contact log which I display them in descending order. The only problem with this is that I the new record is all the way at the bottom of the form. Does anyone know if there is a way in Access 97 to put the new record as the first record displayed??

The only way that I have found to do it is place a transparent field over the top of the original and have an iif condition within the field as a control source. This will then display the specific field in a different color Example iif statement: =IIf([FF By When]<Now() And IsDate([FF Sign...

I have a word template that is opened from access 97. If you then goto save the document in word it will only allow you to save it as a template. Does anyone know how to open a template in word as a document?? This is the code that I'm currently using, any suggestions are welcome. Helen...

I'm trying to run a query when I form opens so that I can send an automatic email. I have the query already written and when I run it on its own I get four rows back. When I run it in the open event. It first brings back one record, I then use getRowsOK to put the recordset into a variant and...

These are the following steps you need to take: 1. Create a hidden field thats going to contain the value you selected in the combobox 2. In the onUpdate event of the combobox write the vba code to update the field you created in step 1. 3. You then need to manually link the field created in...

I'm trying to put some data into a word dcoument. I would like to output the data into a table. The amount of information is variable, so I do not want to use bookmarks. I looked at using Tables(i).Cell(j,k) = "Test" but it said I could not do this. Can somebody help me??