Recent content by Jacino

Hello, How can I disable the close window button on the datasheet resulting from the command: DoCmd.OpenView "myVIEW", acViewNormal, acReadOnly In fact, the result is not shown as a form where min,max and close buttons can be controled. It is important to keep showing it directly as a view...

Hi, I have prepared a form for adding a record in a table1. This table has foreign compound key (4 fields) resulting form a relation with another, table2. I am trying to prepare a list box that select the compound key (4 fields) from table2 and assign them to the new record in table1. If the...

Hi, everybody I have 4 long queries ( really very long! :) ) and I need them to be run. They promt the user for parameter information, almost the same information. I'd like the 4 queries to be able to run, so that the user is not required to inter the parameter information twise or more. 1. I...

Hi everybody, How could I compact the current database from code within an Access 2000 database. The purpose is to import a large text file, and then the code has to directly compact the current database in order to take the major changes into account. Any ideas. Thanks in advance;)

Fine! This is really Genial!. By French, c'est vraiment génial!. For the benefit of the others, this is your idea in a finalized way: SELECT field1, field2, Sum(IIf([field3]=500 Or [field3]=580,-[field4],IIf([field3]=700,[field4],0))) AS Calculation FROM mytable GROUP BY field1, field2...

I have a table with four columns: col1, col2, col3 and col4 There are X records in this table ( X is not determined yet), each record with filed1,field2,field3 and field4. The field3 is in (700,500,580). Now I need to do the following operation: For the 3 records of the same field1 and field2...

In the same table, how can we make arithmetic operations on fields of the same column in different records provided that the records are with the same date and person number. Your help is really appreicated. I need the easiest solution please :cool:

Thanks alot.

Pardon for my English. The situation is as what you have explained: The query is consisting of three tables RSKS02, RSKS97 and RSKS19. In the table RSKS02 we are concerned by the field NPCOR. In the table RSK97 we do concern by three fields NPCO1, NPCO2 and NPCO3. For the table RSKS19 we need...

I am very sorry, this is the correction: Iif(RSKS97.NPCO3>0 , RSKS97.NPCO3, Iif(RSKS97.NPCO2>0 ,RSKS97.NPCO2, Iif(RSKS97.NPCO1>0 ,RSKS97.NPCO1, Iif(RSKS02.NPCOR>0 ,RSKS02.NPCOR,0))))) No problem for the normalization. As a matter of fact I needed to list in one query certain records which meet...

Hi every body, I am new in this discussion form. In fact, I have the following problem: I have a selection query of three tables, in which I select the data with certain conditions. It is imperatif that a filed of one of the tables be equal to another one (under certain conditions!). At the...