Search results

You launch the 2 front end from the same PC? What 's happened if you launch the first front end from the directory of the second?

Hello, May be Warnings were disabled in the second front end ? Close the application and launch again.

hello, Can you show your code to load another form?

Yes, of course

Hello and sorry, but it is not possible to assign valu to a control with the "contionnal formatting" process. You must use events of controls like : Private Sub Texte1_AfterUpdate() If textbox 1 = "abs" and textbox 2 < date then textbox 3 = "expired" end If End Sub Or create a global...

Sorry, if there'is some mistakes in the code because I write it on the fly without test. It's good if you find the solution that is correct.

It is not very clear for me. Can you confirm. You have following tables with fields : Table1 : MasterId - Table1_Name - Table1_Memo - ... Table2 : Table2_Id - MasterId_FK - Detail2 - Value2 - ..which link to Table1 with fields MasterId and MasterId_FK with a 1 to many relation. TableA : A_Id -...

Can you post your code to copy record form the Table 1 to the Table A and the structures of the Table 2 and Table B ? It can serve as a beginning.

You use the expression in the correspondant box textbox 1 = "abs" and textbox 2 < date

Hello, As you do with the Table 1 and the Table A : 1- You create a Recordset from the Table 2 filtering with the MasterID selectionned. 2- You loop the records and add them with a AddNew method in the Table B. It's the simpliest method I think. Have a good continuation.

Hello, Like the attached file ? Have a good continuation

Hello, Where is the problem? you write the code as you show : If textbox 1 = "abs" and textbox 2 < date then textbox 3 = "expired" End If I hope it helps you. I suggest you to read some things about conditions in VBA Good continuation

Hello, May be with this code : dbs.Execute ("DELETE * FROM CORRES_TYP WHERE CODE = '" & Me.CODE & "' AND DESCRIPTION='" & Me.DESCRIPTION _ & "' AND FOLDER = '" & Me.FOLDER & "'") Good continuation

Hello, You have the "Locked" propriety of a control. A code like this If Me.Membership = "withdrawal" or Me.Membership="terminated" then Me.MemberName.Locked = True end If You put it at AfterUpDate event of the MemberShip Control Good continuation

Hello, You must update your combo box when it receive the focus. Put the code Me.YourComboBox.Requery on the SetFocus event of your combo. It fixe your problem. Have good continuation.

Hello, You can create a field for "comments" in the Access table and pull the value with the code : Dim com As String com = ActiveCell.Comment.Text Good continuation

Hello, If you want theses informations only in your combobox, you can adjust the number of column of the combo and their width. And if you want they are visible in the Quotation's form, Look at the help of the "Column" propriety of an combobox. I think you can't do it in a table. Good continuation

An example :

Hello, May be because [CountOfPermit_Type] is not an avalaible field in your report. Try =Sum(Count([Permit_Type]))

Hello, 1- Look the help of the "Docmd.TransferSpreadSheet" method to import your Excel sheet in a passing table "Tableprov". 2- Delete data in your table "dataupdated" with a Delete Query 3- Add data from "Tableprov" in "dataupdated" with an INSERT query. Good continuation