Recent content by tbprog

I have two data bases, each has permissions set using different mdw files. Each data base has the same objects. I wish to update a form from one data base to the other. THis I can do but the permissions get transferred so I need a way of resseting the permissions of the form/object after it has...

Thanks Pat. Thanks. This is fine for the mdb which is called first, however this 1st mdb uses 2 others as libraries and I have not found a way of relinking a reference in the library mdb without opening it. The reference collection has to be accessed via the Application object. Tom

I have a collection of three mdb files which link together to form an application. In order to transfer from the development system to the live system I need to copy them to new directory, Run functions in the databases to relink tables and reset References to library data bases. Can I create a...

There is a microsoft article Q20975 on using generic printers on the microsoft support website. http//search.support.microsoft.com/kb/c.asp All the best I'm just finding my through it. Tom

Having created a report for a specific printer I will occassionally want the report to go to another specific print. I am looking for a method of redirecting the report without the users intervention at the time of printing. Must work within an MDE file with Runtime. The redirection need not be...

Hi with your help and others I came up with this function which works, however I couldn't see how to use the 'SELECT DISTINCT' any ideas. Public Function TB_Count(InSource, InField,InFilt) Dim mydb As Database Dim myrs1 As Recordset, myrs2 As Recordset Dim oldid As String Dim idcount As Long...

I am using the code below to output html from a report, it works fine but when I close my applicaion and exit from Access it appears that a version of access is still running. It appears on the start bar but cannot be closed only by using the end task from AltCtrlDel. Any suggestions...

I have a report which shows a number of columns of information , the selection of data and its oreder are controled by the the clauses of an openreport method. I can show the count of the over all number of records by a field = sum([field name]), however i would like to count the number of time...

Hi is the sort order defined in the query or on the form. If in the query ensure that the forms ordeby is blank on opening the form

I would like to change the color and shape of the I beam cursor that is used to show the editing point in a text field on a form. Is this possible. Thanks