Over 1 million tech questions and answers.

Timestamp from command button

Q: Timestamp from command button

Hey guys,

I am starting a new database that tracks time spent on jobs, I was wondering if it is possible to create a log in and log out button, that would enter in the start time (log in) and end time ( log out) based on when the user clicks on the corresponding command button. If at all possible I would like it to transpose to a text box setup in a table.

Thanks in advance,

Jay

RELEVANCY SCORE 200
Preferred Solution: Timestamp from command button

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Timestamp from command button

Read other 7 answers
RELEVANCY SCORE 50

how can i develop a command button in vb such that when we move mouse icon on command button then command button change his color and font size and when we move outside the command button then command button restore the previous color and font
 

Read other answers
RELEVANCY SCORE 50

how can i develop a command button in vb such that when we move mouse icon on command button then command button change his color and font size and when we move outside the command button then command button restore the previous color and font.
please tell me the vb code
 

A:command button in vb

http://articles.techrepublic.com.com/5100-3513_11-5648718.html
 

Read other 1 answers
RELEVANCY SCORE 50

Does anyone know how I can create a command button that will take me to another word document?
 

A:Command Button

how about recording a macro?
Then attach the macro to a command button
 

Read other 1 answers
RELEVANCY SCORE 49.2

Hello all,

I would like to run a user manual, pdf or doc extension from a command button on my main menu.

Anybody know how to do this?

Thanks in advance,

Ray
 

A:Access - command button

You can use the command button wizard to get it started and make a run application command button. Once it is made go into the onClick VBA code for the command button and you can append the file name and location to the the PDF app location. It will look something like this.

stAppName = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe C:\my documents\pdfname.pdf"

and it should open the document you specify.
 

Read other 3 answers
RELEVANCY SCORE 49.2

i have 10 checkboxes on a sheet and a command button that is hidden, if checkboxes 1 - 8 values are true i.e checked and checkboxes 9 and 10 are false i would like the command button to appear, what codeis needed please
 

A:Command button show

Read other 11 answers
RELEVANCY SCORE 49.2

Mr. Tech Guy,
In Excel 2007, I want to place a command button in a cell that, when clicked, unhides subset cells. Easy enough. But how do I get it to rehide those cells when I click on the button again. And, of course unhide next time and so on. An on-off switch as it were.

VBA is Greek to me; I create macros by entering commands on keyboard.

Much obliged for any help.

Dan L
 

A:Excel on off command button

I'm not much of a VBA person myself - I sure it is possible (probably reset a state each time it is clicked) but you could use radio buttons instead - one for unhide and one for hide.
 

Read other 3 answers
RELEVANCY SCORE 49.2

I am using access 2007. I am trying to go from a form to MSW. When I select the command button and then applications MSW does not show up as an option to selection.
 

A:Command Button For Applications

Read other 7 answers
RELEVANCY SCORE 49.2

I have a cell "M11" that contains this
Code:
=J11&","&E12&","&E13&","&E14&","&E15&","&E16&","&E17&","&J12&","&J13&","&J14&","&J15&","&J16&","&J17&","&C21&","&D21&","&E21&","&F21&","&I21&","&J21&","&C22&","&D22&","&E22&","&F22&","&I22&","&J22&","&C23&","&D23&","&E23&","&F23&","&I23&","&J23&","&C24&","&D24&","&E24&","&F24&","&I24&","&J24&","&C25&","&D25&","&E25&","&F25&","&I25&","&J25
These are values of cells delimited by a comma obviously. I need a button that takes these values and pastes them in the sheet titled "Data". I would like for it to just paste the order above in each row. J11->A2, E12->B2, E13->C2, E14->D2... J25->AA2. Then I need it to advance to the next row that so that when they ca... Read more

A:Excel Command Button

Read other 16 answers
RELEVANCY SCORE 49.2

I have set a command button to load with enabled set to false. I want enabled to be set to true if things meet a certain criteria which are

textbox1 to contain text
textbox2 to contain text
textbox3 to contain text
Combobox1 to have value selected
Combobox2 to have value selected
Combobox3 to have value selected

It must meet all these criteria for the button to be enabled but how do I make it do this?
 

A:enabling command button

if not isnull(me.textbox1) and not isnull(me.textbox2) and not isnull(textbox3) ....etc Then
me.commandbutton.enabled = true
end if
 

Read other 3 answers
RELEVANCY SCORE 49.2

Hi,
I have a spreadsheet with three worksheets in it.

The first sheet holds information on shops, the second sheet information on hotels, and the third sheet information on retaraunts

Each retailer, be it a shop/hotel/r-raunt is denoted by a code i.e D306 , D308 etc.

I would like to add a worksheet to the spreadsheet, and put in a command button, so that when i click the button, it will search for a retailer in the three sheets, by searching for the Dxxx.
So if i press the command button a Msgbox will open asking me to enter the Dnumber i require. I type in the D number and the macro will find the D number among the thousands in the three sheets.....

Can anyone please help me with the VBA coding ?
Many thanks.
 

A:Xl Command Button Help reqd.

Read other 10 answers
RELEVANCY SCORE 49.2

How do I reference the command button that called a particular "on click" subroutine from within the subroutine? The name of the button is part of the subroutine title but I don't know how to reference it.

Sub CommandButton1_Click()
Dim ReferringButton as Shape
Set ReferringButton = ????????
debug.print range(ReferringButton.BottomRightCell.Address).Value
End Sub

Right now I have to hard code either the button name or the associated cell in each button's subroutine. Any help greatly appreciated.
 

A:Excel VBA Command Button

Hi there,

Depending on your controls (there are many), check out the Application.Caller method.

HTH
 

Read other 3 answers
RELEVANCY SCORE 49.2

I am running Windows XP pro. In the PC at home we are three users, each one
has his own password.
One month ago when we wanted to "Switch User" (without Login Out) we used to
click on the "Start" menu then on "Log Off" which opened a window with three options (buttons):
Log Off, Switch User and Cancel.
Now on this window there are only two options (buttons): Log Off and Cancel.
How to modify this window in order to add the 'Switch User' button.

Thanks

A:Missing Command Button

Go to the Control Panel, and select User Accounts. Then, click Change the way users log on or off and put a check mark next to Use Fast User Switching. Then click Apply Options

Read other 3 answers
RELEVANCY SCORE 49.2

I have created an electronic letterhead that is stored on our networked server. Which means all of our field offices can access these documents. I have been asked to revise this letterhead so that it has two buttons in it. The 1st button should be titled "Letter" and the 2nd button should be titled "Memo". I've tried to do this with macros but the macros are stored on my toolbar and not in the document. I've also tried a command button but I can not get it to exactly what I want. How can I create a command button (that does not print when the document is printed) that will carry out a specific action like a macro would? Or is there some other way I can do this? Thanks!!
 

A:Command button or Macro

I don't think you can. Anything on the page will print. You could set up each computers' toolbar with the macros - but that depends how many and where they are. Surely the simplest thing is to have two templates either on each computer or on the shared drive.

Don't try to crack a nut with a sledgehammer.

stepheno
 

Read other 2 answers
RELEVANCY SCORE 49.2

Hi all. A New member so pretty raw at this. I am trying to construt a database in Access 2007 in which to store all my wav and MP3 files that I use (or may use) in my home produced holiday DVD's. I have a form titled frmTuneInput. Within the form I have a number of fields one of which is named fldLocation. What I would like to do is put a comand button on the form that when clicked will play the audion file displayed in the location field.
i.e. Record 1 location file displays G/My Music/All Music/ Classic/The Flying Dutchman Overture.wav
By clicking on the command button i would like to play this file
Record 2 location file displays G/My Music/All Music/ Classic/Il Balen Il Saloro.wav
By clicking on the command button i would like to play this file.
Ihave managed to get a command button to play a wav file byut it plays the same file for every record.
Any help would be very much appreciated but I am a complete novice and this is my firt attempt at constructing a database so I may need any solution explained in detail. Many Thanks
 

Read other answers
RELEVANCY SCORE 49.2

Hello all,

For those in the know, this should be a simple one. In Excel 2003, I have added a number of command buttons to a sheet (from Developer>>Controls>>Insert>>Form Controls rather than from Developer>>Controls>>Insert>>ActiveX Controls). Now that they have been added, I would like to refer to them in VBA in order to change some of their characteristics...The trouble is:

I'm not sure how to find out the name of each control!! Right-clicking and going to Format Control doesn't seem to do anything useful.

Any suggestions would be really appreciated!!

Thank you!

Dave
 

A:Command Button reference

To get you started:

Sub Macro1()
StartCell = ActiveCell.Address
For Each Shape In ActiveSheet.Shapes
MsgBox Shape.Name
If Shape.Name = "Button 2" Then
Shape.Select
Selection.Font.Bold = True
End If
Next Shape
Range(StartCell).Select
End Sub
 

Read other 1 answers
RELEVANCY SCORE 49.2

I have developed a workbook that uses command buttons to perform various functions (such as add names, delete names) to a list showing members of a golf group. The attachment shows the current layout.

The buttons work fine, except they do not move with the changes in the length of the list of names and so can get in the way. I tried placing the buttons to the side of the list of members but when I filter the list the bottoms can disappear (cut off).

Is it possible to anchor the command buttons to particular cells rather than be 'floating' as they are now?

Read other answers
RELEVANCY SCORE 49.2

In working in Excel 97, I have a command button, that I am looking to hyperlink to another tab/cell in the same work book. However, when I take the button out of "Design Mode" the hyper link no longer works??? Why not? Any ideas? I like this button vs. the Forms button as you can change the color / add pictures, as this is a visual presentation. Thanks,
 

Read other answers
RELEVANCY SCORE 49.2

I created this macro and it creates a button. however, everytime i run the macro now it creates a new button. What is the code to create button only once if it is not there and not create it if it is there already.

Sub InsertHeader()
' inserts the same header in all worksheets
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
With ws.PageSetup
.LeftHeader = "&12&BDRAFT"
.CenterHeader = "&12&B" & "Preliminary + Tentative" & Chr(10) & "For Discussion Purposes Only"
.RightHeader = "&12&BDRAFT"
End With
Next ws
ActiveSheet.Buttons.Add(104.25, 90, 224.25, 92.25).Select
Selection.OnAction = "InsertHeader"
Selection.Characters.Text = "Test"

End Sub

thx
 

A:Excel VBA Command Button

Welcome to the forum.
What you could do is, once the buton is created you name it, the same way you name a range.

Select the button
Go to the top left corner, it will sya something like Button 5 or 6 or whatever.

Give it a name:

My own example:

Sub ToggleButton()
if ActiveSheet.Shapes("START").Visible = False then
ActiveSheet.Shapes("START").Visible = True
else
ActiveSheet.Shapes("START").Visible = False
end if
end sub
 

Read other 3 answers
RELEVANCY SCORE 48.8

Hi gurus

Is there any way to add a command to the Windows 8.1 start button (right mouse click throws up a menu).

That could be quite useful for launching something like a user tool bar from the start button.

Cheers
jimbo

A:Any way to add a User command to the W8.1 start button

Power User Tasks Menu (Win + X) - Edit in Windows 8

Read other 4 answers
RELEVANCY SCORE 48.8

hi
can anyone please show me how to setup a command button on a excel worksheet.
what i want to be able to do is click on the button on say sheet 1 and for it to open sheet 2 and go to a particular cell reference.
unfortunately as i am just learning how to do this i do need a step by step guide
thanks in anticipation
 

A:Solved: command button excel

see if these help
http://www.ehow.com/way_5427348_tutorial-excel-command-button.html
or
http://www.taltech.com/support/sw_tricks/exmacros.htm
 

Read other 2 answers
RELEVANCY SCORE 48.8

I have an excel spread sheet where I have certain cell that I clear each time I use this as a template. Can someone tell me how to use a command button to do this. The cells are E3:E10, E5:E20, G3:G20 & F24. I just want to clear the the number in the cell... not the formatting.

thanx
 

A:Solved: excel command button

this should do it...
Code:

Sub Macro1()
Range("E3:E10").ClearContents
Range("E5:E20").ClearContents
Range("G3:G20").ClearContents
Range("F24").ClearContents
End Sub


but I'm confused as E3:E10 and E5:E20 overlap, in which case you can replace the first two lines with range("E3:E20").clearcontents
 

Read other 2 answers
RELEVANCY SCORE 48.8

Hi Guys,
I have a problem with Excel 2003 on some computers. The problem is I have a command button on the workbook which sends the active workbook as an attachment to the email address that I placed in the code. It works 100% on most computers that use Excel 2003 or excel 2007. This makes me think that the code etc ie OK. However there are a few computers that will not allow the button to work and send the email. I have checked all the macro and VBA settings including the Preferences in VBA. They are all the same as on the computers that it works.
Has anyone experienced this and any thoughts what to look for to solve the problem.
Thanks in anticipation
Charlie Fox

 

A:Excel 2003 Command button

Read other 7 answers
RELEVANCY SCORE 48.8

try to analize my HJT file, thanks for any help ill appreciate it........Logfile of HijackThis v1.99.1Scan saved at 3:20:02 PM, on 11/15/2006Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)Running processes:C:\WINNT\System32\smss.exeC:\WINNT\system32\winlogon.exeC:\WINNT\system32\services.exeC:\WINNT\system32\lsass.exeC:\WINNT\system32\svchost.exeC:\WINNT\System32\svchost.exeC:\WINNT\system32\spoolsv.exeC:\Program Files\Grisoft\AVG Anti-Spyware 7.5\guard.exeC:\Program Files\Network Associates\Common Framework\FrameworkService.exeC:\Program Files\Network Associates\VirusScan\Mcshield.exeC:\Program Files\Network Associates\VirusScan\VsTskMgr.exeC:\Program Files\Common Files\Microsoft Shared\VS7DEBUG\MDM.EXEC:\WINNT\system32\HPZipm12.exeC:\WINNT\Explorer.EXEC:\WINNT\system32\igfxtray.exeC:\WINNT\system32\hkcmd.exeC:\Program Files\Network Associates\Common Framework\UpdaterUI.exeC:\Program Files\Network Associates\VirusScan\SHSTAT.EXEC:\Program Files\CyberLink\PowerDVD\PDVDServ.exeC:\Program Files\iTunes\iTunesHelper.exeC:\WINNT\SOUNDMAN.EXEC:\Program Files\iPod\bin\iPodSer... Read more

A:Run Command On Start Button Is Missing

Hello,Please perform my steps in the right order..First of all, you didn't unzip/extract hijackthis.. and it's still in the tempfolder.So I strongly advise to unzip/extract hijackthis.Read here how to unzip/extract properly:http://metallica.geekstogo.com/xpcompressedexplanation.htmlCreate a permanent folder and move hijackthis.exe into it. The reason is because hijackthis creates backups and when it's in your temp-folder it can be accidentally deleted.How do you make a permanent folder:Click My Computer, then C:\ and then on Program Files.In the menu bar, File->New->Folder.That will create a folder named New Folder, which you can rename to "HJT" or "HijackThis".Now you have C:\Program Files\HijackThis. Put your HijackThis.exe there.* Download Killbox.Click killbox.exe.Select the option "Delete on reboot".Click the button: All Files (!important!)Now it should flash green.Now copy the next bold part:C:\WINNT\system\svchost32.exeC:\WINNT\system\svhost.exeOpen 'file' in the killboxmenu on top and choose Paste from clipboardThen press the button that looks like a red circle with a white X in it.Killbox will tell you that all listed files will be removed on next reboot and asks if you would like to Reboot now, click YESIf you don't get that message, reboot manually.Your computer should reboot now.After reboot,* Start HijackThis, close all open windows leaving only HijackThis running. Place a c... Read more

Read other 2 answers
RELEVANCY SCORE 48.8

I am so tired of this database. I thought this would be such a simple application to create. I want to my user to open this form only in datasheet view. It has a subdatasheet in it as well. The problem is I want to put a command button at the bottom in the form footer to return to the main menu. I created the button, but every time I bring up the form in datasheet view, the command button is gone. Can you not have a form footer in datasheet view?
I would gladly put it in the form view, but it won't let me view continuous forms...every time I try it gives me some error about activeX or such...
The form is supposed to be a record from the master table and then the corresponding records from the 2nd table, then the next record from the master table and then the corresponding records from the 2nd table, and so on and so forth...
 

A:Command Button in datasheet view

Okay...never mind...figured it out on my own. Created another form with both subforms viewed as datasheets inside the new form. Then it let me create the form footer with the command button in it.

AAAAH!!! SUCCESS!
 

Read other 1 answers
RELEVANCY SCORE 48.8

Hi,
I'm new to vb.net and to programming - I have a project that I'm working on that requires multiple forms. I have command buttons loaded at the bottom of the page that I would like to press and have the form be visible at run time. i know the answer is simple but I can't seem to get it to work. Any help is greatly appreciated!!!!!!!!!!!
 

Read other answers
RELEVANCY SCORE 48.8

I have a simple question. I know you change the event to something like "on key press", but what would you do if you wanted the script to happen when you press a certain button? For example, I'm trying to make it so that when I press enter it navigates to the URL in a combo box.
 

A:Solved: Command on a specific button in VB.net

This code should do the trick:

Code:
If (e.KeyCode = Keys.Enter) Then
'Insert code you want to execute here
End If
That will work in a KeyDown or KeyUp event handler, but not a KeyPress event handler.
 

Read other 3 answers
RELEVANCY SCORE 48.8

My Windows search button is not working. Start>Search does nothing, and the command Start + F does not bring up the search window.

I can go to an explorer window and ctrl-F or hit the top search button in an explorer window and have the seach function show up that way.

I'm thinking somewhere a link got broken to the command or a registry value......any ideas?

I've tried
sfc /scan now
srchasst.ini install

A:Search command/button not working

Quote:





Originally Posted by boo1010


My Windows search button is not working. Start>Search does nothing, and the command Start + F does not bring up the search window.

I can go to an explorer window and ctrl-F or hit the top search button in an explorer window and have the seach function show up that way.

I'm thinking somewhere a link got broken to the command or a registry value......any ideas?

I've tried
sfc /scan now
srchasst.ini install




Found this. Good luck

Search - Doesn't Work

Open Explorer and go to the Windows\Inf folder. Locate the srchasst.inf file. Right click it and select Install. You'll need your XP CD or the files from the I386 folder. (This fix will require you to have your Win XP CD).

The Windows\Inf folder is a hidden folder. You can adjust your Explorer Folder Options (View tab) to Show hidden files and folders. You can also click Start, Run and enter %SystemRoot%\Inf to open directly to the Inf folder.


Also this. http://support.microsoft.com/kb/913503

Read other 3 answers
RELEVANCY SCORE 48.8

Can someone please tell me the code to open a file using a simple form and command button
 

Read other answers
RELEVANCY SCORE 48.8

I want to disable a command button after an event is fired.

The button fires of a RunSQL event, sets a value in a table to not show the button and then I tried to have it set Me!ControlName.Enabled = False, but it will not let me because the control still has focus. Is there a way to remove the focus and then set the control to disabled? I was thinking of setting the focust to another control and then disabling it.
 

A:Solved: Disabling a command button

Read other 6 answers
RELEVANCY SCORE 48.8

I need a command button on a form that puts a number in a field. The number comes from a field in a table that works similar to an autonumber. I need the command button to pick the last number in the field and add it to the blank in the table. I am fairly new to this as it was an inherited responsibility.
Any help would be appreciated

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel(R) Pentium(R) 4 CPU 2.66GHz, x86 Family 15 Model 2 Stepping 9
Processor Count: 1
RAM: 511 Mb
Graphics Card: MOBILITY RADEON 7500C, 32 Mb
Hard Drives: C: Total - 28568 MB, Free - 13263 MB;
Motherboard: Dell Computer Corporation, 09U807
Antivirus: Symantec Endpoint Protection, Updated: Yes, On-Demand Scanner: Disabled
 

A:Solved: Access Command Button

Read other 16 answers
RELEVANCY SCORE 48

Hello all, hopefully simple problem:

I have a function under ThisWorkbook called ReadAllFiles. I would like this to run when I press a command button that I have added in Sheet1.

Any ideas?

Thanks in advance.

Ray
 

A:Excel: Command Button call to function

In Design mode, rightclick the cmd & choose "View Code". You should be presented with the sheet module containing:

Private Sub CommandButton1_Click()

End Sub

Paste the code from the workbook module between the 2 lines. Then ALT+Q to exit the VBE.
 

Read other 3 answers
RELEVANCY SCORE 48

Is it possible to set the VISIBLE property of a command button to FALSE when the command button is clicked?

I want to set the VISIBLE property of the active command button to FALSE.
 

A:Solved: Excel Macro -> Command Button

Read other 13 answers
RELEVANCY SCORE 48

Hello,
I've been having a rough time getting this code to run properly in MS Word 2012. I'm trying to create a command button upon document open and modify it's properties.
Code:
Private Sub Document_open()

'Add a command button to a new document
Dim doc As Word.Document
Dim shp As Word.InlineShape
Set doc = ActiveDocument

Set shp = doc.Content.InlineShapes.AddOLEControl(ClassType:="Forms.CommandButton.1")

doc.InlineShapes(1).ConvertToShape

'On Error Resume Next
With CommandButton1
.AutoSize = False
.Caption = "Save & Close"
.Enabled = True
.Font = Calibri
.Font.Bold = True
.Font.Underline = False
.Font.Size = 10
.Height = 24
.Left = 500
.Locked = False
.TakeFocusOnClick = True
.Top = 25
.Width = 72
End With

End Sub
When stepping through the code I get the "can't enter break mode" when reaching the button creation line, this isn't so bad because the code still runs. I just wanted to mention in case it might help point to the problem.

The reason I converted it to a shape is so I can access it's properties that require modification, however, upon reaching the "with" statement I get error 424 object required.

The weird thing is that if I leave the button still in the document and run the code again it works fine (althoug... Read more

A:MS Word VBA to Create Command Button and then Format it

The code below works for me but I removed the .LEFT and .TOP properties because they were throwing errors for me. I'll keep playing with it to see if they can be added back but I suspect they are not true properties for a button object.
Code:
Dim doc As Word.Document
Dim shp As Word.InlineShape
Set doc = ActiveDocument

Set shp = doc.Content.InlineShapes.AddOLEControl(ClassType:="Forms.CommandButton.1")


With shp.OLEFormat.Object
.AutoSize = False
.Caption = "Save & Close"
.Enabled = True
.Font.Name = "Calibri"
.Font.Bold = True
.Font.Underline = False
.Font.Size = 10
.Height = 24
.Locked = False
.TakeFocusOnClick = True
.Width = 72
End With
Rollin
 

Read other 2 answers
RELEVANCY SCORE 48

I created a command button with the search/find using the wizard of access 2003.

Is there a way to customize the dialogue box that pops up when i click the button?

Thankx
 

A:Customize search/find command button

Read other 6 answers
RELEVANCY SCORE 48

I'm simply triing to add fifty(50) to a interger value every time someone presses a command button. This is in excel vba by the way.
Please Help.

I really should go learn a little more about this language.

Thanks,
Eric
 

A:Solved: Adding a value when command button pressed

Ok. In regular VB you could declare using static instead of Dim and add 50 to the variable each time the button is pressed. Like this:

Code:
Private Sub Command1_Click()
Static intNumber As Integer
intNumber = intNumber + 50
MsgBox intNumber
End Sub

This way the value of intNumber is accessible only in the Command1_Click event and the change is not lost when the event ends.
 

Read other 3 answers
RELEVANCY SCORE 48

I have a form with several subforms on different tabs. I created command buttons to open the subforms if the item does not appear in the lookup list in the main form. For example, Upon entering a person's information, when you get to the school field and the school you need is not listed, there is a command button to Add School (which calls on a macro that simply opens school subform). It allows the user to add the new record to the school subform, but it does not refresh the look up list in the main form. If I close the main form and reopen it it appears in the lookup list.
Thanks everyone for reading my post. I hope someone can help.
 

A:Solved: Subform Command Button Problem

Read other 10 answers
RELEVANCY SCORE 48

I have placed a command button on one of my worksheets. The command button is used to place an image on the worksheet.

I would like to set the command button's property Enabled to false once it has inserted the image on the worksheet. However, I am unable to figure out how to do that through code.

Also, is there a way through code to determine if teh image was inserted?
 

A:Solved: Excel 2007 -> Command Button

Read other 13 answers
RELEVANCY SCORE 48

Hi there, I am a relatively new user to access 2007 and am having trouble with a command button.

Basically I have created a table of items with the reference field set to autonumber and also the primary key, from this table I created a form to enter all my items in, this works fine. the table and form were named event details.

Next I created a query to show a listof specific data, the ref, name and date of my items and used it to create a tabular form, this also works fine. I named this all events

Next i wanted to add a command button next to each entry on this form that when pressed would open the specific form, i used the wizard to do this but it wont work and I keep getting the error message,

The specified field '[Ref] could refer to more than one table listed in the FROM clause of your sql statement.

Can anyone point me in the right direction, in basic terms as not overly confident with VBA.

many Thanks

Alan
 

A:Access 2007, command button problems

Read other 7 answers
RELEVANCY SCORE 48

I have developed a form in Word 2010 with several embedded macros running on Click events from Command Buttons.

The problem is that when the Click event is activated it clears data in form fields and unchecks all previously checked check boxes. How do I keep the command button click events from clearing my form fields and check boxes?

Thanks!
 

Read other answers
RELEVANCY SCORE 48

I have created a tabbed form in Access, but when I try to create command buttons (close, find record) the buttons will not work. Any suggestions? Two of my fields are enabled to prevent the user from deleting them or overwritting them.
 

A:Command Button on Access Tabbed Form

mclemorek, welcome to the Forum.
What version of Access are you using?
 

Read other 1 answers
RELEVANCY SCORE 48

Hi Everyone

I hope someone is able to help me.

My knowledge of VBA in Excel is very limited

We use Excel 2003 at work. I have a workbook that contains 2 combo box's and 2 command buttons. What we need is some code if possible that when the user selects a document from the validation list in the combo box and then clicks on the command button it will open that document for use. The documents are all kept in a seperate folder here C:\Users\Home\Documents\Manager Forms, and are a mixture of Word docs, text docs and PDF files.

Is anyone able to help please

Ortz

I have attached a sample file here if it helps
 

Read other answers
RELEVANCY SCORE 47.6

Is there a simple way to open a word doc with a command button in access?
 

A:Solved: Open word doc with command button in access

Yes, do you need to browse to it?
 

Read other 3 answers
RELEVANCY SCORE 47.6

my work pc running xp pro has the task manager button grayed out when i do a ctrl alt del... also when i go to start... my run command line is gone... i thought it might be and admin policy but other pcs are doing just fine... any ideas...
thanks
sd
 

Read other answers
RELEVANCY SCORE 47.6

Thereís a command button on my spreadsheet that canít be deleted at least through ordinary means. This is what Iíve tried:
1. The straight forward way by right clicking the button, then selecting cut. Some processing takes place, but the button remains.
2. Again the straight forward way by right clicking the button then hitting the delete on the keyboard. The same thing happens.
3. Just for fun, I moved it from is initial location to another location on the same spreadsheet. Now there are two identical buttons that canít be delete.
4. I donít know why, but I did it again. The new button that appears can be deleted, but not the other two.
5. Assigned a different macro to each of the two buttons and each worked properly, but still the buttons canít be deleted.
6. Copied the original to another sheet. It was easily deleted, but still canít delete the first two buttons.
7. My final try was to use the Visual Basic Editor to see if thereís a macros embedded in the sheet itself. No, nothing there.

Canít think of what else to try, except to ask for help.
 

A:Solved: Excel 2003 Command Button, Can't Delete

Read other 12 answers
RELEVANCY SCORE 47.6

Hi,

I want to run code from an activex command button in MS Word 2007 that reads and changes the caption and name of the command button. Is that possible? If so, how do I do it? I have some experience with VBA from MS Access and thought I could use Me.Name or Me.Properties.Name or something similar but that does not appear to be available.

Thanks for any help!
 

A:Access command button properties in Word 2007

This would be easy in something like C# but I can't find a way to tell VBA to run anything other than the [CurrentName]_Click event when it is clicked. If you only need to change it a few times and to known (before program execution) values then this can be done using the known values.
Code:

Private Sub bye_Click()
bye.Name = "hi"
bye.Caption = "hi"
End Sub
Private Sub hi_Click()
hi.Name = "bye"
hi.Caption = "bye"
End Sub
I'm guessing you need something smarter than this but just incase this is all you need...
 

Read other 2 answers