A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Command Buttons in a Form



 
 
Thread Tools Display Modes
  #1  
Old January 15th, 2010, 05:47 PM posted to microsoft.public.access.tablesdbdesign
Photoliv41
external usenet poster
 
Posts: 2
Default Command Buttons in a Form

I am new to Access & trying to create a form/database, but the command
buttons I added don't seem to work. Any suggestions as to what I would try
or how to fix it? I have ensured that Data Entry is checked off in
properties, but suspect that there needs to be some sort of relationship
established between the command buttons & the form/database.

Please Help.
  #2  
Old January 15th, 2010, 06:11 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Command Buttons in a Form

What is the code running behind the form and what do you want to happen when
you click on the button?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Photoliv41" wrote:

I am new to Access & trying to create a form/database, but the command
buttons I added don't seem to work. Any suggestions as to what I would try
or how to fix it? I have ensured that Data Entry is checked off in
properties, but suspect that there needs to be some sort of relationship
established between the command buttons & the form/database.

Please Help.

  #3  
Old January 15th, 2010, 07:29 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Command Buttons in a Form

On Fri, 15 Jan 2010 08:47:03 -0800, Photoliv41
wrote:

I am new to Access & trying to create a form/database, but the command
buttons I added don't seem to work. Any suggestions as to what I would try
or how to fix it? I have ensured that Data Entry is checked off in
properties, but suspect that there needs to be some sort of relationship
established between the command buttons & the form/database.

Please Help.


Since we have no idea what you did, it's a bit hard to guess what you did
wrong! Also, "don't seem to work" is not too informative: do you get nothing
happening at all? an error message? smoke coming out of the monitor?

If this is A2007 the database must be in a "Trusted Location" for code to
work. Is it?

If that's not it, open the form in design view, select the command button,
view its Properties, and post what's there in a message here. If it says
[Event Procedure] click on the ... icon by it and post the VBA code.
--

John W. Vinson [MVP]
  #4  
Old January 16th, 2010, 03:36 PM posted to microsoft.public.access.tablesdbdesign
[email protected]
external usenet poster
 
Posts: 4
Default Command Buttons in a Form

On Jan 15, 6:29*pm, John W. Vinson
wrote:
On Fri, 15 Jan 2010 08:47:03 -0800, Photoliv41

wrote:
I am new to Access & trying to create a form/database, but the command
buttons I added don't seem to work. *Any suggestions as to what I would try
or how to fix it? *I have ensured that Data Entry is checked off in
properties, but suspect that there needs to be some sort of relationship
established between the command buttons & the form/database. *


Please Help.


Since we have no idea what you did, it's a bit hard to guess what you did
wrong! Also, "don't seem to work" is not too informative: do you get nothing
happening at all? an error message? smoke coming out of the monitor?

If this is A2007 the database must be in a "Trusted Location" for code to
work. Is it?

If that's not it, open the form in design view, select the command button,
view its Properties, and post what's there in a message here. If it says
[Event Procedure] click on the ... icon by it and post the VBA code.
--

* * * * * * *John W. Vinson [MVP]


Hi, I'm not a professional like many of the guys on here but I do
have a thought. When you created the buttons on the form did the
wizard appear? If not you need to turn on the "Controls Wizard" in
the tool box. the icon looks like a little wand with sparks coming
from it and is located on the top row of the tool box if you have it
floating. When this is turned on just follow the prompts. HTH
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.