Recent content by adevera

I have I table which is linked to a tex file. I created a code in which it will programatically refresh the linked, however, after the refreshed process is done, it always put the first record as a Field Header. Can somebody help me what is needed inorder not to Access automatically use the...

You didn't clearly specify what is your problem

If you have a main form that is always open (even minimize), you can put a timer on it to open the form. Dont make the form (timer) in invisible mode. All you have to do is create a function that will set the form open once the designated time is meet.

I change to docmd command and it work the way you want.. Private Sub Command0_Click() On Error GoTo Err_Command0_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "subform" DoCmd.OpenForm stDocName, acFormDS 'the acFormDS tells the form how to open your...

You can go to this site: http://support.microsoft.com/?kbid=208786

I will be happy to help you...Is ther a chance you can attached your db ? Remove all confidential data...

Does the form F_Progress value depends on the value of the subform (Job ID) ? In this case, I would declare a Global variable only to capture the Job ID in the subform. And then on the ON Open Event of the F_Progress, I write an SQL statement which will now the basis on the Record Source for...

Your reference to Child and Master Fields of the subform is invalid. On your subform, frm_Client_sub, you must set the Link Child Field to Company_Name (which is the name of the textbox for the co name) and Link Master Field to clients (this is the name of your combo box in the main form).

You are welcome....But can you invite us on your funeral...

Check my early post....

You need to give each user's an access rights. If you dont want to do this, you better hide all the query objects you created.

I figure out your problem.. Your Code: Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("Appointment Letter JW Q") With rst .MoveFirst Do While Not .EOF .Edit ![Status] = "08" ![DateMail] = Date .Update .MoveNext Loop End With My Code: Dim db As...

How about your fields Status and datemail.. are these fields have the same name on your field the way yo type it (except for the brackets)...

What is the reason why do you have 25 names in 25 combobox ?

Did you checked your Reference table ? Maybe you do have any reference to Microsoft DAO/ADO Object..