Forms :: Command Or Action Not Available Now

Jul 11, 2014

I have a form for users to be able to delete or edit records. I have 2 command buttons (Delete and Save), when I click on them I get this error "the command or action is not available now"... It was working fine before but for some reasons it stopped. Even two other buttons actioned by vba codes do not work (No message popping up for these 2)

I checked:
Allow Additions: Yes
Allow Deletions: Yes
Allow Edits: Yes

Nothing is blocked or locked.

I think it has to do with the query my form is based on, as I tried a dummy form based on a table and the button worked fine...? I tried re-creating query+form and no luck. I did remove a field from my query at some point this morning, not sure if this might be the cause of issue, as this field was not connected to anything in my form.

View Replies


ADVERTISEMENT

Forms :: How To Do Some Action After EXIT A Command Button

Mar 25, 2014

Code:
Private Sub Command124_Click()

On Error GoTo Err_Command124_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "PRINTSQUARE 1"
DoCmd.OpenForm stDocName, 3, , , , 4

Exit_Command124_Click:
Exit Sub

Err_Command124_Click:
MsgBox Err.Description
Resume Exit_Command124_Click

End Sub

An command button would open a form to display some query result, and how could I do something after user exit that form!! I have tried to put some action afater the Docmd and EXIT_COMMAND124_CLICK:, both didn't work!!

View 3 Replies View Related

Forms :: Copy Record Button - Command Or Action Isn't Available?

Jan 13, 2014

I've rebooted my copy record button and just used the macro wizard for now, it seems to work as far as I can tell but there is something strange about it.

I've added in some text boxes so I've got some confirmation, but when I click this copy button I get the following error;

"The command or action 'RecordsGoToNew' isn't available now."

View 1 Replies View Related

The Command Or Action ApplyFilterSort Isn't Available Now.

Jun 17, 2005

I have created a search window that looks up certain invoicereport by invoice No. I have used this search method in other forms and has worked successfully!

However,
after I created the same thing for a report, I get this message: The Command or Action 'ApplyFilterSort' isn't available now.

I really don't understand the problem.
txtSearch = a textbox where user can type in any value to lookup a certain report.
rptInvoice = where I want the search to be placed.
fraSearch = an option group with (Starts with...,Contains...,Ends with..., Equals...)
InvoiceNo = the txtField in rptInvoice.

this is what I wrote for the cmdSearch button:

Private Sub cmdSearch_Click()
On Error GoTo Err_cmdSearch_Click
Dim strFilter As String
Dim strInvoiceno As String

' Check that the report is open
If SysCmd(acSysCmdGetObjectState, acReport, "rptInvoice") <> acObjStateOpen Then
MsgBox "You must open the report first."
Exit Sub
End If
' Build InvoiceNo criteria string
If IsNull(Me.txtSearch.Value) Then
strInvoiceno = "Like '*'"
Else
Select Case Me.fraSearch.Value
Case 1
strInvoiceno = "Like '" & Me.txtSearch.Value & "*'"
Case 2
strInvoiceno = "Like '*" & Me.txtSearch.Value & "*'"
Case 3
strInvoiceno = "Like '*" & Me.txtSearch.Value & "'"
Case 4
strInvoiceno = "= '" & Me.txtSearch.Value & "'"
End Select
End If

' Build filter string
strFilter = "[invoiceNo] " & strInvoiceno

' Apply filter to report
With Reports![rptInvoice]
.Filter = strFilter
.FilterOn = True
End With


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70

Exit_cmdSearch_Click:
Exit Sub

Err_cmdSearch_Click:
MsgBox Err.Description
Resume Exit_cmdSearch_Click

End Sub
----
Could anyone help me with this?

View 1 Replies View Related

Command Button To Perform Popup Action

Aug 29, 2005

Hello,

I am having trouble making a command button do what I want. I have a subform within my form, but I only want it to appear when I click the button. I tried using the wizard but there is no option to open subform, only open form. Any thoughts would be greatly appreciated!

View 1 Replies View Related

The Command Or Action 'Show All Records' Isn't Available Now Error

Apr 17, 2007

Hi,

I am getting this error "The command or action 'Show all records' isn't available now", i get this when i try to do

DoCmd.ShowAllRecords
DoCmd.GoToControl ("ID")
DoCmd.FindRecord Me!Text116

I am trying to do search on ID..but i get this error and i dont know how to proceed..

P.S My form displays all records(say 6000), it has a search functionality where a search on particular ID should be done, i am trying to do this and dont know whats happening even though this seems to be easy (

Please help!
Thanks!

View 1 Replies View Related

Modules & VBA :: Add Contact From Outlook - Command Or Action Not Available

Jul 26, 2015

I am trying to use

RunMenuCommand
command : AddContactFromOutlook

But i get this error message

"The command or action AddFromOutlook isn't available now "

on a demo access "project manager" it works but in my data base does not ...

View 1 Replies View Related

"The Command Or 'SaveRecord' Action Isn't Available Now"

Mar 7, 2006

Hi Folks,

No hits on a search of this site for this error. I think this is a security or corruption problem.

From the main dialogue form of my database some users get the "The command or 'SaveRecord' Action isn't available now." error when they try to run a report or perform an update. The report is launched by code which includes the SaveRecord command.

Everything operated correctly with the administrator logged in. The users have appropriate permissions to tables etc. However, I made some small modifications to the form and then the report / save would not run for the Administrator either.

Things I have tried to resolve this:

Giving users full permissions - same as adminstrator
Making new database and importing all items
removing security from back end


I also tried half a dozen other things of varying logic and relevance that didn't work either.

Anybody have any idea what is going on / how to procede?

Regards,

Keith.

View 4 Replies View Related

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

Forms :: Run Macro Having Three Action Queries

Jan 9, 2014

I want to run a macro which is having three action queries from the another database when i click the button from my current database. I am using Access2010.

View 3 Replies View Related

Forms :: Action Buttons Increase In Size 50% To Right And Down

Jul 7, 2013

It has been a month and I'm still 'stuck' on my Microsoft Access lessons due to a peculiar error. I have a video of the error, but it won't let me post a link until I have 10 posts. When I create an action button and then scroll at all, the button jumps in size 50% to the right and down, but this extra space can't be edited. Clicking on the 'extra space' is like clicking the background.

I have tried

1. Reinstalling Office 365
2. Reinstalling my graphics card drivers (Using a GTX 560ti SLIx2)
3. Manually entering the size for the buttons in the button properties (still increases in size)

I have a project where the schedule calls for a web-enabled database for 100+ users to merge five separate systems into one. If I can't get past this problem, I can't continue my lessons.

View 11 Replies View Related

Forms :: Make Confirm Dialog Appear Before On Click Event Action

Jul 3, 2014

I'd like a confirm dialog to appear on button click, so when the user clicks 'yes', the on click event should continue and when the user click 'no', the event should stop.

View 2 Replies View Related

Forms :: Increase Maximum Characters Allowed In Expression Of Macro Setvalue Action

Apr 23, 2013

Is there a way to increase the maximum characters allowed in an expression of a macro setvalue action ?

I have an expression in a macro setvalue action that adds multiple form textbox values. I need to change the form name from "RATING ENGINE 2" to "E RATING ENGINE 2". When I do this, I exceed the maximum characters allowed in the expression. Is there a way I can rename "RATING ENGINE 2" without this problem. The expression is as follows:

[Forms]![RATING ENGINE 2]![Excess Liab Premium 6]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 7]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 8]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 9]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 10]

View 6 Replies View Related

Forms :: Print Multiple Forms Or Reports From One Command?

Sep 23, 2014

I have forms that are printed based on a query parameter of [enter item number]. There are several of these forms that I would like to print at one time (with one command) making it easier for the user to gather their information at the beginning of the day. I also don't want to lose the ability to print them out individually as we do now.

View 14 Replies View Related

Forms :: Add Record Command?

Mar 14, 2014

I have a form which i have added an ADD RECORD command button too. how I can change the code so it only looks at certain fields to add data too, fields, i.e field 1, field 3, field 5.

View 1 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

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 2 Replies View Related

Changing Forms With Button Command

Oct 1, 2004

I want to open a new form with information related to the main form.

The code I've used is:
Private Sub GoToContacts_Click()
On Error GoTo Err_GoToContacts_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Contacts"

stLinkCriteria = "[Outside Rep]=" & Me![Outside Rep]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_GoToContacts_Click:
Exit Sub
Err_GoToContacts_Click:
MsgBox Err.Description
Resume Exit_GoToContacts_Click

End Sub

When I use the button I get an error message for a "Syntax error (missing operator) in query expression.

Any suggestions?
Judy Hewitt

View 3 Replies View Related

Command Button To Link Forms

Apr 6, 2006

Alright I give up. I searched the forums and read up but still not grasping it. I know I've done something like this before but my brain must be dead today.

So I have 4 important tables. I have a main one and 3 tables that have records related to the main one. They're all the "many" sides of the one to many relationship with the main table. Outline is below:

Main Table:
EMP_ID (Primary key)
...and other fields

Employment Table:
HIRE_ID (Primary key)
EMP_ID (for relationship)
...and other fields

Insurance Table:
INS_ID (Primary key)
EMP_ID (for relationship)
...and other fields

Skill Table:
SKILL_ID (Primary key)
EMP_ID (for relationship)
...and other fields

So basically what I'm looking for is to have a main form pop up that has the Main table information (employee info). Then on that form I want 3 command buttons, each one going to a new form that relates to the three tables above and is relative to the Main table. Each employee may have several hire/fire listings, insurance listings (if they change their insurance), and skill ratings (updated as they improve). When I have set all my relationships so that the EMP_ID on the Main table has a one to many relationship with all the EMP_IDs on the other tables. When I create the command buttons though and start to populate a record in one of the three "subforms" the EMP_ID is not populating to be the same as the EMP_ID from the main page thus making me unable to create a record because it doesn't recognize a related record.

What the heck am I doing wrong

View 14 Replies View Related

Forms :: Using The Wizard To Add A Command Button

Jan 2, 2014

Working on a form and when using the wizard to add a command button or a txt box the wizard gives it a funny name like command989. Im wondering why? Where does this default come from and why is the number so high? There is no way anywhere near that number of command buttons on this form.

View 4 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

Forms :: Add Explanation Box To A Command Button

Nov 6, 2013

I have a form with command buttons that run different macro's that downloads queries into Excel.

What i would like to do if it is possible, is to somehow add an explanation of what the download will contain if the user should either hover over the button or even better if there was a way of adding ? box to the button so that the user could click on the ? and get a description of what will be downloaded.

I do have a very brief description on the button stating what it does but I would like to give the user a more detailed description of what is in the download.

View 2 Replies View Related

Forms :: How To Build A SetFocus Command

Mar 8, 2014

How can I build a SetFocus command on the fly? I am creating a Find form where the user can select their options. I am building the listing of options for the user to select from based on which form opened the Find form. All forms are set as Modal and PopUp so I have to set the focus to the form and field to be searched before I call the FindRecord command from the Find form. I am stuck on how to build the SetFocus statement when concatenating the pieces together for the obvious is not working.This is what normally works.

Code:
Forms![frmClients]![txtStreetAddress1].SetFocus

This is how I am trying to build the statement without success. How can I do this?

Code:
"Forms![frmClients]!" & Me.cboSearchField.Column(1) & ".SetFocus"

Code:
Me.cboSearchField.Column(1) = txtStreetAddress1

View 3 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

Access Command For Saving To 2 Indentical Forms

Oct 31, 2004

Hi i was wondering if anybody could offer some help to a problem i don't know how to solve. Some Background; i have two tables that are indentical called 'Order' and 'TempOrder', the purpose of this is that one saves the records unless manually deleted later, whilst the other is designed to have its own form, which has a print button which also deletes the record. Now i can create the data entry form to save the details in order, however i also need it to save the details into temporder, which i just cant seem to do, as i do not know the code, it appears relatively simple just i cannot seem to do it, i have tried a macro to save the record into the 'tempOrder' table but this does not work, any help would be much apprieciated.

View 1 Replies View Related

Forms :: What A Command Button To Link To A Field

May 10, 2013

Ok so the Data I have holds a hyperlink to a file this field is "basepath".In Form view I want to have a command button that reads the basepath (for that record) then opens said hyper link.

View 3 Replies View Related







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