Visual Basic with Access

Associate
Joined
13 Jan 2007
Posts
2,424
Location
Belfast,Northern Ireland
As some of you may know im doing some a-level coursework in a very short space of time so i cant learn vb properly to work this all out myself. So i was wondering if anyone could help with:

1. Changing the text on the top bar - it currently displays 'Microsoft Access - [CW - Database (Access 2000 Format)] - Is this possible?

2. Im creating a help system for my program. Basically i want a box to pop up when clicked providing a list of options. Is this creating a form? Trouble is i want it to do different things when things are checked. For example when option 1 is clicked i want box 2 to appear and extend onto the original box and if option 2 is clicked i want box 3 to appear and extend onto the original.

3. Finally im using switchboards, however when i click onto one from the main switchboard then click the 'home' button to go back, it does go back to the home page, but the previously opened switchboard remains on the taskbar, i dont want this, i want one instance of the switchboard open at one time.

Thanks

sorry fior the major blabbing, im panicing, lots
 
Hi mate.

Cant help you with the first 2 but for the third you need to edit the VB code for the button taking you to 'Home'.

If you look at the code it should say:

Code:
DoCmd.OpenForm "Home Form Name"
Above this you need to put:

Code:
DoCmd.Close
You need to put it above or else it will just close the form you are trying to open.

Hope this helps.
 
Thinking about it, for the help system you may want to play about with the Visible option for each part of the help system. For example:

When the Help1 command button is clicked > Help1 text visible = true.
The default value for Help1 text's visible property would be false

And so on for the rest of the help system. This way it would only show text for the command button that is clicked.

You could place all the help texts in the same area and Access would only display the relevant one.
 
Cheers cotton you solved the 3rd one.

Do you know how to do dialog boxes?
Do i need to create a seperate form for it?

Basically i have a quit button that once pressed quits out completely. However i want to change it so that once press it prompts a Are you sure? Yes/no scenario


Cheers mate
 
on the onclick for the quit button....


dim response as variant
response = msgbox("Do you want to quit?", vbyesno + vbQuestion,"Quit?")

if response = vbyes then

'quit code here

end if




thats a rough off the top of my head example


edit: depending on version to change the name of the access database go to tools > database utilities > startup
 
Last edited:
yea got the quit thing sorted now cheers. Now its just the help system, which is just huge amounts of code i doubt ppl can help with. But you could tell me if its all possible just through a dialog box?

Also does anyone know about the title being renamed and displaying time/date for example?

i've tried Application.Name"bnsjkbn"

When a button is clicked just to see if it worked but it said something about read-only properties?
 
Back
Top Bottom