Search results

Is it possible to run a piece of code that will add the relevant references to Access on opening the database. The code would check that these references are ticked. VB for Applications MS Access 10 Object Library OLE Automation MS DAO 3.6 Object Library Many thanks Tee

Many thanks

Excellent great stuff.... Thanks

If you hold the Shift key down as you open the database, it will open in design view - I have the form in the Startup so it loads first and the database (tables etc) remain hidden. As anyone can access your tables etc by holding the Shift key down on opening, there is a function (available on...

Excellent - works like a charm....

Hi All How do you assign a shortcut key to a command button. I want to close a form with the command button - the button would have the words "Close Form" on it with an underline under the C. If the user does the action eg: Ctrl E - the form will close. Tee

ghudson Hi Just a question - Do I name the module just "Public" and where do I put the bDisableBypassKey command button - I have a user logon form the loads first and then a switchboard or do I create a new form and put the button there? Tee

Ah how do I do that! From the relationship field or in the query?

:) excellent many thanks for that.

Code attached Here is the SQL... And my relationships.... Many thanks Tee.

Silly I know and it is more than likely on the site but I can't find it. I want to search on just my threads to check to replies etc. Tee.

Hi All This post also relates to a query but I figure that it all goes back to how my relationships are set up - they are the root of all my problems. I have set up these relationships in my database - see attached jpg image. When I make a query adding all the members from the Members table...

Hi All I have 28 records in my table - when I run the query (made by using the wizard) it only picks up 6 records. I have no criteria in the query - just a straight query fulling all fields from the table. Any suggestions?

Login form I found this somewhere on this forumn - it may help you. All credit to the designer. Tee

Hi all Can anyone guide me in the right direction to resolve this error. I have added Search code (modified from anothers) to my form. I have no macros on it and I have double checked all my fields. I have no idea why I am getting this message - it seems to appear when I move over a field...

Don't know about you guys but we will miss him terribly in AUS...It is such a loss to Australia and the World. He heart was certainly in the right place...no pun intended......Condolences to his family and friends and work mates.

Input 2000 Here is a file I found in the Sample Databases that may do what you want. Lots of credit to whoever designed it. Apologies as I can not remember who. I have fixed the code up as suggested by the designer and added the form to the startup so hold the shift key down when you open it...

Just tried what you suggested - excellent worked like a charm.....

Oh abit cheeky are we - Darwin is a big city and we have cars and boats and lots of other stuff too ...lol....Many thanks for your reply. I will try it agin....

Hi All I have added the Allen Browne Calendar 2k control to my form. My form consists of 4 pages. On pages 2 and 3 I have subforms and on page 4 I have Personal data. Page 1 is general data and the Calendar is on Page 1. What is happening is that the Calendar is also being displayed on my...