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 Replies
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
May 6, 2005
Hi all,
I'm having a problem trying to get some code to work that a member of this forum helped me with some years ago. Basically I have a form with a combobox that is used to select the user name and a textbox for the password to be entered. There are two different types of user, manager and clerk. The logon button must open the selection screen form but if the user is a clerk, then the delete client command button must be disabled.
I keep getting a 'Compile Error stating Block If without End If' and I'm not sure where I'm going wrong.
I'm also not sure what code I should be writing to disable the command button dependant on user.
I know this is not great security, but it's only going to be used as an interim solution for 4 people (none with access experience). Can anyone please explain to me why I'm getting the compile error and what code I would need to disable the command button on the form and where I would need to put it.
Many thanks.
Here is the code:
If Me.Password = Me.Combo10.Column(4) Then
If Combo10.Column(3) = "Manager" Then
DoCmd.OpenForm "frm_Splash_Screen"
ElseIf Me.Password = Me.Combo10.Column(4) Then
If Combo10.Column(3) = "Clerk" Then
DoCmd.OpenForm "frm_Splash_Screen"
End If
Else
Msgbox "Incorrect Password, try again"
End if
View 8 Replies
View Related
Jun 25, 2006
Was woundering if the was a way to habdle multiple command buttons with one procedure. I have done a little VB.Net and I remember that you coud use one sub to handle multiple buttons using the handles key word. I was wondering if Access could do that. What I have is 37 command buttons named cmdView1 through cmdView37 all I really need is the number that prefixes the command buttons name. I know how to pull out the number but I can not figure out how to use only one sub procedure for all 37 buttons. Any help is appreciated.
Frank
View 2 Replies
View Related
Sep 27, 2006
Hi...total newbie here trying to get out of the blocks!
I want to be able to open forms with a button and filter in the process.
I have Customer details in a table
I have Site details in a table
I have Product details in a table
From my 'frmCustomer' I want to hit a comand button to open 'frmSite' and filter only the records related to that customer, then from my 'frmSites' hit a command button to open 'frmProducts' filterd by that site.
Please help, driving me mad!
View 4 Replies
View Related
Oct 19, 2005
I have a form that contains a subform.
The subform is bound to a table.
The form is based on a query but still writes directly to the appropriate table.
In the header of the form I have a series of command buttons - new record, navigation buttons, and buttons to open new forms. None of them work at all.
I checked each button to be sure the On Click Events still had the right Event procedure, and they do.
for example, the command button to open the Cases form has the following VBA (generated form the button wizard.):
Private Sub cmdOpenCases_Click()
On Error GoTo Err_cmdOpenCases_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmCases"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_cmdOpenCases_Click:
Exit Sub
Err_cmdOpenCases_Click:
MsgBox Err.Description
Resume Exit_cmdOpenCases_Click
End Sub
When clicked, the button just blinks - nothing happens. I check to be sure the form isn't a popup and also closed it after clicking it to see if maybe frmCases had opened behind the current form for some reason. Nothing - it's not opening at all.
Any ideas?
View 1 Replies
View Related
Feb 20, 2008
Is it possible to put a command button on a report? I can't do any kind of programming so only use the command button wizards.
I'd like to have a button to click on in order to print or close the report, rather than use the menu bar.
Is this possible, easily?
Thanks very much.
View 2 Replies
View Related
Jul 23, 2012
I have attached a screen shot of my application. I want to create menu commands instead of command buttons. How can I create menu in access 2010.
View 3 Replies
View Related
Sep 26, 2007
I've tried the basics, like changing the coding to 'OpenTable' and using the wizard, but I can't seem to get my form to open a table. So my 'dumb' question is- 'is it possible to open either an access table, or an excel spreadsheet with a command button on a form?' I've tried linking an excel spreadsheet to my database, I've tried importing it, but when you go to put the info in a form, its all in 1 field, so doesn't show all the information i need it to. :confused:
View 2 Replies
View Related
Feb 1, 2005
I am attempting to create a form "frmROrder" with two command buttons, daily detail, and annual detail. Is there a way for me to set frmROrder up so that If I click on cmdDaily it opens subform frmROrderDaily or if I click on cmdAnnual, it opens subform frmROrderAnnual? Thanks for your help!
View 2 Replies
View Related
Jun 30, 2005
Hi all,
I have a frmUserLoginScreen that opens frmMainSelectionScreen, which has 4 command buttons on it. Dependant on user level, some of the command buttons are disabled.
I have four user groups, manager, admin, IT and guest. When the guest logs on, the frmMainSelectionScreen only has one command button enabled. Once clicked, this opens frmClientDetails which has a command button that enables the user to add a record.
Basically, I want the add record command button to be disabled on the frmClientDetails if the user is a guest.
I've tried all sorts of code to reference the other forms but I'm not having any luck. Has any kind fellow got any ideas?
Thanks
View 7 Replies
View Related
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
