Search results for query: *

Please adice how can I realize in the report such function: If [Value1]=yes then me.[Filed1].visible Please advie the exact spelling for that condition.Thanks.

Is trying to run a code for Set in a field Expiry Date the date that is 3 month bigger that the one in shipement date.Has made a code: Forms!insurance![Expiry date] = DateAdd("mm", 3, Forms!insurance![Date of Loading]) That does not work Any ideas?

I do have a table [Commodities] with fields (Code(key);Number;Commodity name;A;B;C;D;E;F;Special conditions) A;B;C;D;E;F stands for different directions (Europe, USA,ETC) The data in the table are the rates for different commodities depending on a zone. Zones are described in a separate table...

Tring to use following NotinList code. Receiving error "type missmatch", but the table Servides has 2 columns: No (autonumber) and ServiceName (text): Private Sub Service_NotInList(NewData As String, Response As Integer) Dim Db As Database Dim Rs As Recordset Dim Msg...

I do have a replicated spilted database Crm.mdb is replicated database with replicas user.mdb contain all forms,report,queries and is linked to CRM.mdb I want to make a button in local copy of user.mdb that would Synchronize replicas. So the button should:Get the path to linked CRM.mdb...

I have a Subform Contacts wich has fields :Firm,Contact peron I want the RowSource for the Firld Contact person to be Selected form the SoWorkers table on Firm field Please help me to do that. Thanks alot Arseniy

I am usingAfterUpdate function. I check the added value with a function fcheck, and if fcheck=true I want to delete the added record. How can I delete it? Thanks Arseniy

I know that the answer is really very simple, but I can't get it. I maade a procedure Fcheck to make a check for duplication in a table. I want that when the new data is added in the form, it is checked with this procedure, and if the procedure=True than not allow to add it or delete the added...

I have a form with a subform.Both are in table mode. In a parent form there is a filed named Firm (number of the firm) In the Subform there is a field name ContactPerson. I want the RowSource for the ContactPerson to be the data selected from the table CoWorkers,where Firm=Firm in a parent form...

I want to make such procedure: 1.Open Table1 2.Search for the first line responding a criteria 3.Get the Data from Field1 5.Run a procedre1 with this data 6.if procedure 1=true add line to Table2 7.Go to line 1 up to the last line responding criteria Could you please give me a syntaxis of such...

Would you be so kind to help? I have a table Firms,with fields:Code,FirmName,FirmField I have a table WorkingForm that has the Field:Project;Firm;Manager I made a form to add firms from Table Firms to table Working form: I make a Subform where there are the list of FielmFields and a button Add...

I am trying to make the crosstab query, which would be showing for each partner such table: The list of books, the dates of orders and the numbers of the sertain book ordered. When in constructor i ad the field Orderer and give the exact value- everething is going ok, but when in the field i...

I am trying to make the crosstab query, which would be showing for each partner such table: The list of books, the dates of orders and the numbers of the sertain book ordered. When in constructor i ad the field Orderer and give the exact value- everething is going ok, but when in the field i...

do have a database a book firm. There are such tables: Books, Partners,Orders,Orders details, I do need to make a report showing by partners which books and when they have ordered.It should look like: Partner 1 ........... .... 23.12.01 25.12.01 22.04.02 1.Book A......2 2.Book B...