General :: Command Button Stays Active
Feb 17, 2014
I have a macro that Runs from a button that I attached to a form called " plans" the macro opens up a Dialog form from which I select a drawing number from, on selection of that drawing number a query is run and finds the information I want
The problem I am having is when I close the query the macro button goes active so if I want to run another query using the button it goes to the last record I selected. I have tried the refresh command but that does not work..I really need the button not to be active when the query is closed.
View Replies
ADVERTISEMENT
Dec 7, 2012
I have have a form with 4 subforms in it, one of the subforms is based on a filtered query . For a reason I can not work out I cannot get it to requery when I add a new record.
To add a new record I select from a combo box and use a command button to save the record
I have tried using this in the buttons on click event
Code:
Forms.trialcatalogueF!TrialCompetitorsSF!competitorsSF.Form.Requery
with no result, however it does kinda work in the combo's after update event, just not until I select another value.
View 2 Replies
View Related
Jul 12, 2013
I am trying to open MX Excel using a command button. I have tried using a hyperlink a various codes that i have found online with no luck. The Excel file is being used by the Access as it bring data from the spreadsheet a displays it within a subform. (I think this is where the problem occurs) The subform displaying some data from Excel is working fine but when i click my hyperlinked button i am met with errors and the file will not open.
View 6 Replies
View Related
Jul 27, 2012
I have a form. and it has three buttons. Such as Submit, Reject, Under Observation.
I want :
1) If i click SUBMIT button it will be disable and other two buttons REJECT and UNDER OBSERVATION will be enable
2) If i click REJECT button it will be disable and other two buttons SUBMIT and UNDER OBSERVATION will be enable
3) If i click UNDER OBSERVATION button it will be disable and other two buttons SUBMIT and REJECT will be enable
View 1 Replies
View Related
May 8, 2013
I am using access 2010 and I created couple of buttons on my forms that do some stuff in vba, but beside triger them with mouse I would also like my users to be able to have shortcuts on keyboard so for example I have btnClose an I widh when user press ALT + that btnClose do the same thing as it is doing when you press mouse on it.
View 4 Replies
View Related
Jan 15, 2014
I am trying to open MX Excel using a command button. I have tried using a hyperlink and various codes that i have found online with no luck. The Excel file is being used by Access as it bring data from the spreadsheet and displays it within a subform. (I think this is where the problem occurs) The subform displaying some data from Excel is working fine but when i click my hyperlinked button (To open the excel file) i am met with errors and the file will not open.
View 1 Replies
View Related
Mar 19, 2014
After inputting data into a text box on a form i want to click on a command button which will open an email program and then put the text there so i can send it.
View 1 Replies
View Related
Aug 11, 2013
I have two tables, one is GENETIC and the other one is BoneSampleDNAprofile. Both tables have the field CY-Code. I want to create small form with 2 text box fields and one command button on the form to be able to insert CY-Code from the table GENETIC to designated DNA_LAB_Code in the table BoneSampleDNAprofile.
In that small form I would type DNA_LAB_Code and CY-Code where after pressing command button will insert CY-Code for the designated DNA_LAB_Code. This is continuous process after our Laboratory receive results from DNA laboratory. I have attached two .png files which are example of two tables.
View 2 Replies
View Related
Oct 19, 2014
I have created an accdb file and saved as an accde file. The accde file opens with a form with command buttons. But the commands buttons do not work with the accde file (they do work with the accdb file). How do I get them working.
View 7 Replies
View Related
Nov 17, 2012
In form I want to put a command where we can browse a picture and insert it...how to do ...
View 5 Replies
View Related
Apr 3, 2013
Beginner using 2010. I wish to play MP3 files from a command button on a form. I would like to avoid third party / ActiveX controls if possible.
I am aware that use of "CurrentProject.Path" will be useful to locate the MP3 file within a directory within the Project Folder.
But have be baffled by the sparse previous postings about this subject (going back to 2004). Searching this forum yields zero results on the term "MP3".
This accdb/e will be used to present historical information to a small number of people and will be used with runtime without user input.
And all I need is Play / Pause / Stop. No other functions required.
View 10 Replies
View Related
Jul 20, 2014
How to modify an existing database template to meet my needs.
I am trying to create a command button that sits on the order details page and that will open up a report i have created called 'picklist' which is basically the same as an invoice but with some different product information listed on it.
I want the command button to open up the picklist that corresponds to the order that i am on e.g picklist #2 for invoice#2
I have 2 issues/questions:
1) I have seen this code on the internet -
DoCmd.OpenForm "SecondFormName", , , "FieldName = #" & Me.ControlName & "#"
Would this work for me if i was to modidy it to:
DoCmd.OpenForm "PickList", , , "InvoiceID = #" & Me.[txtID] & "#"
2) Where do i input this code? If i click on the 'onclick' in the properties form I am presented with this page (attachment):
View 8 Replies
View Related
Jan 30, 2014
I have a form that records data entered by a user who I then want to email the record via a report run from a query.
I created a command button on the form with DoCmd.SendObject acSendReport,"name_of_report", "format", "to","subject", False
The email program (Lotus Notes) opens a new email msg with the report attached as pdf. However, the data recorded does not appear.
View 5 Replies
View Related
Mar 20, 2014
I am trying to create a command button in Access to generate a Meeting Invite. I found code for creating an Appointment and it works great but cannot get it to invite attendees.
Private Sub AddAppt_Click()
On Error GoTo AddAppt_Err
' Save record first to be sure required fields are filled.
[Code].....
View 1 Replies
View Related
Apr 7, 2014
I am creating a small database to record payments.
There are three tables :
Supplier - tblSupplier
Payments - tblPayments
Invoice - tblInvoice
There are two Forms :
frmPayments (Bound to tblPayments) - Main Form for payment entry.
frmInvoice Sub (Bound to tblInvoice) - Sub form to display not paid invoices.
What i need is a Command button , lets named it "Commit", to perform a few tasks :
1. When click, prompt message asking whether to Save current payment record when all relevant input is completed during data entry.
2. If Answer is "Yes", then it will compare the "Invoice No" on the Main Form with the "Invoice No" of the Sub
Form , and if found to match, then put a tick in the "Yes/No" field of Invoice Table (tblInvoice) against the matching "Invoice No" of Main Form. This is to record payments made to this particular Invoice in Invoice Table.
3. Proceed to save current record, Refresh Main Form to be ready for a new data entry.
4.If Answer is "No", discard all current entries in the Main Form, Refresh to be ready for a new data entry.
Sample DB is attached...
View 1 Replies
View Related
Apr 19, 2007
Need some help on a command which would close any on screen active form. I want to have this Esc key enabled as an autokey to close any screen active form. I know how this autokey thing works but unable to figure out proper code.
thanks
View 6 Replies
View Related
Mar 5, 2008
hi,
when i select a button from the active control menu and want to use that button for either next record, previuos record. attach macro, print, i am sure that was part of the menu when selecting the button. i am not seeing that menu when i select the button from the active control could you please tell me why
thanks
steve
View 3 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
Feb 19, 2014
I have created a web-database (? - There are globes over all the forms and tables icons) based on the Issues & Tasks template. This means that most of the data is entered and seen on the "Main" form, which has two tabs - Open Issues and Closed Issues. I have created a form that allows people at my work to input the necessary data and save it, so that it will show up on one of the two tabs. However, once a record has been created, I want to be initially locked if the ID/PK is clicked, so that data can't be changed or entered inadvertently.
SO, I changed the code so that when the ID/PK for a record is clicked, it brings up a different form, but one that looks exactly like the one that is brought up when entering a new form, but I locked all of the fields so that the information cannot be changed. It seems from what I have read that I can create a button on this form so that when clicked, it unlocks the fields on the form so that they can be changed, and then when clicked again it will lock the fields again. Is this true? If so, how can I do it? Or is there something similar I can do? I have seen codes that I could copy and paste, but I cannot figure out the place to copy and paste codes in Access 2010.
I have changed the Form properties so that Data Entry and all the "Allows" are set to No...
View 9 Replies
View Related
Aug 12, 2005
Hi, I have got a small problem and maybe someone could advise me.
I am creating a customised command button from a label button. The new button works fine but I can't apply the 'requery' function to it, if i do an error occures and i am being prompt to save the data first???? :confused: :
Private Sub Labelsearch_Click()
Me!itemquery.Requery
End Sub
Private Sub Labelsearch_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.SpecialEffect = 2
Me.Labelsearch.BackColor = 255
Me.Labelsearch.ForeColor = 10092543
Me.Labelsearch.FontItalic = True
Me.Labelsearch.FontBold = True
End Sub
Private Sub Labelsearch_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.ForeColor = 255
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End Sub
Private Sub Labelsearch_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
'Come back to initial state when button release'
Me.Labelsearch.SpecialEffect = 1
Me.Labelsearch.BackColor = 16373685
Me.Labelsearch.ForeColor = 8388608
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End
If I create a command button with the wizard and assign the code :
me!itemquery.Requeryto the on_click event my form is working fine.
Why is his code is not working if I assign it to a label? :o
View 6 Replies
View Related
Feb 15, 2006
I have a list box on a form, as well as a tab control...I need the tab control to be on top of the list box...I tried doing Format > Send to Back (list box) or Bring to Front (Tab Control)...but to no avail..
List box still stays ontop...any ideas?
Thanks :)
View 4 Replies
View Related
Jun 15, 2013
I am trying to insert a new line below the active cell ive tried several attempts but i am getting error 1004. Some attempts are commented out.
Code:
wks6.Activate
With wks6
.Select
' .Rows.AutoFit
' .Columns.AutoFit
.Range("A:AO").Select
[Code] .....
View 6 Replies
View Related
Dec 25, 2012
I have a main form (in a single form view) that show a record from a table. I am going to add a sub form (probably a continuous form view) which can show a list of fields (probably a name) from all records from a child table that match condition PrimaryKey = ForeignKey.
What is the best way to make the list of the fields sort of clickable so that I can click on any of them and e.g. open a form with information about a child record? Should I look for hyperlinks in reports, a list box, a continuous sub form with records?
View 3 Replies
View Related
Mar 12, 2006
I've got this yes/no message box that deletes an appointment. When i click yes to confirm delete, the box just stays there. I have to click yes again before it works. Clicking no works fine. Its like its going round the else if statement for vbYes twice. Does anyone know why this is happening? Heres a snippet of the related code. Thanks in advance.
If myYesNoQuestion(strDelete) = vbNo Then
myDisplayInfoMessage "Appointment kept on file"
'If the user decides not to delete the customer then appointment kept
Calendar3.SetFocus
'Sets the focus away to allow the rooms to be disabled
lstRoom1.Enabled = False
lstRoom2.Enabled = False
lstRoom3.Enabled = False
lstRoom4.Enabled = False
'Disables the rooms again
ElseIf myYesNoQuestion(strDelete) = vbYes Then
strSQL = "DELETE * FROM tblAppointment where [AppointmentID]= " & .Column(2)
'SQL to delete appointment from table
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
'Turn warning off, run SQL, turn them back on again
myDisplayInfoMessage "Appointment Deleted OK"
'If the user decides to delete the customer then record is deleted and a message is shown to prove that
Calendar3.SetFocus
'Sets the focus away to allow the rooms to be disabled
lstRoom1.Enabled = False
lstRoom2.Enabled = False
lstRoom3.Enabled = False
lstRoom4.Enabled = False
'Disables the rooms again
End If
End If
View 5 Replies
View Related
Oct 7, 2012
By the way, my FO line manager wants an IT report, i am wandering if there is any possibility to search and export users. The report should show in the status column who are disabled, who are enabled, date created and date expired in date column in active directory windows server 2003 environment?
View 1 Replies
View Related
Jul 2, 2013
We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been closed on all 5 clients. We do not have a user called 'Admin'. Because my issue occurs for all clients, it might be caused by some sort of programming error in the front end.A VBA bug (implicit comparison to a control in an If .. Then construct) caused this type of behaviour but was resolved in Access 2007.
View 12 Replies
View Related
