Executing Command Buttons On Other Forms

Sep 20, 2004

Hi

I have a Visible form and an Invisible (visible=false) form open at the same time. Is it possible to use a button on the visible form to execute the code behind a button in the invisible form. The subroutine on the invisible form is Public. I tried DoCmd.RunCommand and a macro with RunCode but... nada...

(There is a valid reason for this approach but i will spare you the boring explanation. I can think of a work around where I can bypass this need, but this way is cleaner (there are cases where the invisible form is visible and used directly, the form has data which is sent to a report to create a label). I have done everything else with VBA code but for some reason can't get this to work, so now i am obsessed)

Thanks, this forum is really a gem!

View Replies


ADVERTISEMENT

Forms :: Copying Command Button Appearance Properties To Other Command Buttons

Dec 17, 2013

I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .

View 2 Replies View Related

Executing An Update Command With “'” In The String

Nov 3, 2006

Hi,
I try to execute an update command i.e.:
UPDATE Results set Data = 'Heiner's key' where ValidationNumber = 1 and TestNumber = 2 and Line = 'E1'.
Access does not let me do this because the “'” in Heiner's terminates the update string prematurely.
Does anyone have a suggestion how to do this? Thank you.

View 4 Replies View Related

Putting Command Buttons On Forms

Aug 4, 2005

I ma going to sound a complete idiot with this question, but I have been working on a database for some time now, successfully putting buttons on forms with the wizard, jumping from form to form, form to report, basically the button wizard used to work now it doesn't and I don't think I have done anything stupid. (I hope). The wizard was brilliant, I'm lost without it. How do you restore it?

Thanks in advance guys. :confused:

View 2 Replies View Related

Forms :: Pictures (BMP) In Command Buttons

Nov 3, 2014

I am trying to create command buttons with a picture (bmp) on it, and centering the label and the pictures in the middle. I selected bottom position for the label, but it seems to keep the pictures always aligned on the left.

View 2 Replies View Related

VBA Coding For Forms And Command Buttons?

May 31, 2012

I have an initial start up page where someone in any division can go and select their division from a combo box. What I want them then to be able to do is click one of the forms (New Entry,Edit Entry,.....).

For the form New entry I am looking to open the form with the division name to filled into a text box. I also would like to have that box that box also correspond to a field in a the table for a new entry.

View 1 Replies View Related

Forms :: Command Buttons For Access 2003?

Mar 16, 2013

I am making a database for some people I work with, I'm having trouble with making a button to work. I want a button to go to the next tab on the tab control, but still in the same record. I prefer not to use the vba, but if I need to use it

View 9 Replies View Related

Forms :: Command Buttons Are Not Displaying Properly?

Jul 10, 2013

Access 2013 People,where the command buttons are not displaying properly?Notice the words and images are nice and centered in the buttons. The buttons are all the same size.Now look at the same DB in Access 2013:

See how the buttons look bloated and the images and wording are not centered anymore. And working on it in design view is a nightmare! When you try to move the command button part of it is left behind every time to try to move it.You can turn the themes property to "Off" but I like the themes.

View 11 Replies View Related

Forms :: Rename Command Buttons From A Table?

May 4, 2015

I made a Point of sale using a form with different sub-forms which have command buttons on it. They basically run a append query from tblStockMain to table cash and on to transactions. That works all fine no problem.

The one missing thing to make it sweet is to rename the command buttons automatically from tblStockMain. With other words, if I change a product in the table it would change the name on the button and the picture if possible with it.

Is there a way to do it?

View 2 Replies View Related

Forms :: Put Command Buttons In Page Header

Sep 2, 2014

I want to put command buttons in the Page Header, however the page header is not visible from form view?

What is the purpose of Page headers?

View 5 Replies View Related

Forms :: Command Buttons On Form That Go To Two Separate Tables

Jun 18, 2013

I have two command add buttons on my form that go to two separate tables. I also have a go to next record button as well. Is there a way that I can put all three commands under one command button? They are already coded in VBA and all work properly individually, I just want to make it smoother if possible ..

View 3 Replies View Related

Change Colour Of Navigation Buttons And Command Buttons?

Mar 17, 2006

Is this possible? I can't seem to find this q anywhere here so I thought I'd post.

I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.

Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.

:confused:

View 2 Replies View Related

Change Colour Of Navigation Buttons And Command Buttons?

Mar 17, 2006

Is this possible? I can't seem to find this q anywhere here so I thought I'd post.

I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.

Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.

:confused:

View 4 Replies View Related

Command Buttons

Mar 24, 2006

I am a newbie at Access and I am currently learning it for my job...I have a database going and I am wanting to do two things and I can not figure it out for the life of me.

Little background, the database I made is a continuous form. I am wanting a command button that when pushed will put it in data entry mode, and when pressed again will put back in a 'view all' state. I know it is a simple If Then, but I don't know VBA very well =

Other thing, is I wanting to be able have button that when pressed will output to an excel sheet, right now I have it when it is pressed it asks me what kind of format I want outputted, and I want it automated to just go straight to excel.

Any help would be appreciated, thanks.

View 3 Replies View Related

Command Buttons

May 18, 2007

How do I make the command buttons on my form actually do something, the only one that attempts to work is "DELETE RECORD" the others dont do anything at all

View 8 Replies View Related

Need Help On Command Buttons

Mar 1, 2006

I want to create a new database which has a startup form that has 4 command buttons.. My problem is that I want that every click of the command buttons will take me to the main switchboard of the other/different database.. How am I going to link those buttons to different databases?:confused:

anyone help me?:(

View 2 Replies View Related

Command Buttons, Is This Possible?

Apr 5, 2006

I know how to change the color of the font of the command button, but saw nothing in properties on how to change the color of the button... is this at all possible. If you need a reason, it is for designing preference really.

View 1 Replies View Related

Command Buttons

Apr 27, 2006

hey, i have a form which uses one table only which is for purchases. it has 4 fields:

memberID:
productID:
quantity:
date:

and then it has a button - "Add Another Purchase" which confirms the purchase.

However, I want the stock number in tblProducts to decrease by the quantity whenever that button is pressed. I have tried using MS visual basics to enter a code but i dont think he "Stock number" is recognised, as it is in a different table to the one i used for my form. (i have linked the two tables, however)

any solutions????????

View 1 Replies View Related

Help With Command Buttons

Sep 19, 2006

hello.. i want my form to look like this:

http://i114.photobucket.com/albums/n258/lushh_16/employeeform.jpg

where there is add, edit, save and delete buttons.. and that the record cannot be edited unless the "Edit button" is clicked and the entry will only be saved when the "Save" button is clicked. i tried to search for sample databases, but it doesn't inlcude a sample of this. thank you so much...

View 9 Replies View Related

Command Buttons

Feb 24, 2005

Hi, I am having troubles with adding command buttons on to my form.
I have created a new form and used the wizard to create a command button
with Cancel (which i just want to click on and the form closes). but when I am done the
button doesnt work. can someone give me instruction or tell me what the heck i
am doing wrong. thanks

View 12 Replies View Related

I Need Help On Command Buttons

Mar 2, 2006

I want to create a new database which has a startup form that has 4 command buttons.. My problem is that I want that every click of the command buttons will take me to the main switchboard of the other/different database.. How am I going to link those buttons to different databases?

anyone help me?

View 3 Replies View Related

Icons On Command Buttons

Apr 13, 2006

I'm running Access 2000 and want to use some different icons than available through Access on some command buttons. So far, I can only get it to accept bitmaps. This isn't a problem if bitmaps can have a transparency. I don't think they can though. Any suggestions?

The icons I want to use have a transparency.

Thank you,

alteque

View 7 Replies View Related

Hiding Command Buttons...

Jun 22, 2005

I have a form listing clients. Each has a command button linking to another form with client details and other option. One the bottom of the form is an Add Client button. I want the user to only be able to add a max of 6 clients, and the buttons to these clients be invisible until the Add Client button is pressed and the information about the client is filled out. Then back on main form listing clients, the client name will appear with a command button that will link to client details. How can this be done? I've seen it done, but can't figure it out.

tritonvt

View 1 Replies View Related

Multitasked Command Buttons

May 17, 2006

Is it possible to have a command button that UNDO's the informations filled out on a form and closes the form?

View 3 Replies View Related

How To Add Command Buttons To A Report

Jul 16, 2007

What I want to do it when the report is generated and opened in a preivew mode, I want to give the user the options to:Save the report, Print the report or Email the report. How can I add these three buttons to the report?

View 10 Replies View Related

Command Buttons In A Sub Form

Feb 23, 2005

Hello

I have created a form in Access 2003 based on a query, the form has a sub form( basically the form shows different projects, the sub form shows the stages of the project, one project can have many different stages). I want to put a command button to add a new record for the data in a sub form, I have managed to create one for the main form, but not the sub form.

I would appreciate any help, thanks



Please can you help

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved