Search results

Huge thanks to you both for your swift replies. I'm going to start testing both methods straightaway.

Hi I have a database with a setup kind of like this. Form1 for Table1, Form 2 for Table2 and Form 3 for Table3. There are no relationships set. All 3 tables have an ID field, which 90% of the time, will have the same ID number on them. What I'm trying to do is set up a button on Form1 which...

Many thanks for the tip Pat, I wasn't even aware there was another method. And sorry for leading you astray Satoshi!

Satoshi, Give this a try and let me know how you get on. I use this a lot on my DB. DoCmd.OpenForm "frmBuyersInterestedPropertiesDirectory" 'Open the form Forms!frmBuyersInterestedPropertiesDirectory!PropertyID.SetFocus 'Sets focus on the PropertyID field' DoCmd.FindRecord...

If you're using Windows 2000, this link may of interest to you

I had a similar issue and didn't manage to get the AVG function to work the way I wanted. Instead I used =([field1]+[field2])/2 Not perfect but it works...

Many thanks one and all. I'm now going to examine each of your ideas and I'll let you know how I get on.

Hi, I have yet another problem with my database. Just before the focus moves from 1 record to another, I need to check whether a certain field has a value in it and if not, to cancel the creation of the record. What's happening is that users are using the scroll button on the mouse or the...

Tim, Many thanks for the reply. I should've given you some more info but I'm in business now. The form was a pop-up form, 9cm wide by 3cm high, with a pop-up property set to True. As you said I needed to change the Autocenter to 'No'. But Access still wouldn't let me move the form in Design...

Hello all, I'm asking this more in hope than expectation but here goes... Is there any way to open a pop-up form so that it's positioned vertically central on the screen and not one third from the top as it is now? Any help on this one would be greatly appreciated as ever Andrew

My fairly limited knowledge of VB6 suggests that there's no easy fix other than to go through each of the lines of code as Pat suggested. For example: Docmd.Quit (in VBA) = End (in VB6)

I do know that on Access 2000, it causes reports to come out as landscape instead of portrait! Not sure what its good points are...

Thanks a million Ricky, worked perfectly as ever...

Hi all, Can someone please tell me what the maximum Timer Interval is on a form? Access 2000 help is telling me 65,535 milliseconds under one help topic and thats it's "a Long Integer value between 0 and 2,147,483,647" on another. I'm trying to close a database automatically after 12 hours...

I can relate to that alright! Just make sure you tell your users to be patient - mine were clicking here, there and everywhere to speed it up but this was making it even slower. Some even used CTRL-ALT-Delete to cancel and try again - a no-no in any language. On the positive side, I've also...

Andrea, I've seen this many times and recovered what seemed like lost causes. It was always, as Autoeng suggests, a security problem. If you want you can send me on the MDB + MDW files as well and I'll take a look... Andrew

Wayne and Pat, Huge thanks once more for furthering my education! Needless to say the code worked perfectly first time... Andrew

Thanks for pointing me in the right direction jfgambit. After a fair bit of trial and error, I found the fix to be to set the "Allow built-in tollbars" flag to ON and then found this sentance on Access Help to back this idea up: "If the AllowBuiltInToolbars property is set to False, you can't...

Here's a contender for the most ridiculous question ever posted on this brilliant site. I'm attempting to disable the Menu Bar when my main form loads up. The code is standard stuff: Private Sub Form_Open(Cancel As Integer) DoCmd.ShowToolbar "Menu Bar", acToolbarNo End Sub But it only seems...

Grade A and Grade B need to be Grade_A and Grade_B me thinks!