Search results

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;)

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:

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...