Search results

Hm... And what happens when I define them in the front end? Do I get the cascade delete then?

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

As I said, everything is OK in VB's references... Nothing is missing there.

Is there any place to specify references for DESIGNER? Because in VB's references everything is fine, I suppose... I CAN access the Date() function from VB's code...

No, there is no quotes there... Any other ideas?

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

The problem was solved. It was about the dpi settings of specific printer...

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

Where?? I can't find it... I am working with Access 2000. //Edited: Ah, OK.. I found it! Thanks!

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

Thank you!

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

Yes, it can. As always, there were some issues with compilation etc., but not something serious. Thank you all!

Yes, I have the 2003 version as well =) But now we are moving a customer from Access 2.0 to Access 2000, so we need Access 2.0 to to see how it should work. Yesterday we've solved the problem after performing exhaustive search in our storehouse! You'd better envy me, because yesterday I found...