Search results

Hello, My Access application consists of two MDB files: the application file and the database file. The application file has links to tables from the database file. Now, I want to define relationships to optimize my database performance. Where should I define them? In the database file? In the...

Hello, I have a strange problem with Microsoft Access 2000. I have a form with a date field. When I try to set the default value for that field (from the designer) to "=Date()", it tells me that the use of this function is illegal in that place. But if I use the same function Date() from the...

Sorry for a stupid question, but... How do I define the hot keys for buttons? Like when you have a button with caption "Search" where "S" is underlined, and then you can press Alt+S instead of clicking the button.

I am trying to define a relationship between tables. The relationship is one-to-many with forcing referential integrity. When I try to define it, I get the dabaase engine error: "The database engine couldn't lock the table, because it is already in use by another person or process" I am sure...

How can I allow multiple instances of the same application in Access 2000? Today when I try to run an application which is already running, it just maximize its window...

Hello, I have some REALLY strange and uncommon problem. When the customer prints report, he gets text which is "out of border". The text can be placed anywhere, even at the middle of page. And it will be "cut"... It's like the text box has negative margins or something like that... Now, when I...

Hello, I have an application where all the forms are popup (i.e. the PopUp property is set to True). It was done because the customer wanted to see only one entry of the application on the taskbar. Now I have a real problem! When the customer opens reports in preview mode, he gets it opened...

Hello, I have two forms like "MainForm_Version1" and "MainForm_Version2". I want to choose one of them using VBA (according to some specific condition) and save the chosen one as "MainForm". Just like when I click on it in Forms View window and choose "Save As" - but this time it has to be done...

Hello, I need to insert a table into some report. The simpliest way that I found to do that was to insert many text boxes, when each text box was bounded to a column of the table. This worked OK, except for one annoying problem. The problem is that some columns contain a lot of text. So they...

Hello, Here is some strange problem. My application deals with tenders. One of the things that the user can do for each tender is to fill in some table. The records he enters into this table are stored in table MyTable in the database. A special field in MyTable specifies the ID of the tender...

Hello, After converting a database from a previous version of Access (to Access 2000), there is a strange problem: menu items from the MenuBar macro are duplicated... actually even triplicated. I.e. I see something like this: File Edit Tools Help File Edit Tools Help File Edit Tools Help What...

Hello, I have an Access application which was written on Access 2.0. I need to run it (as is). I saw that it was possible to run it using some kind of Access 2.0 runtime environment - my client uses the following command to run the application: Msarn200.exe application.mdb /ini application.ini...