I am going round in circles here; I have a form which has certain text fields that need to be populated before a user can click a command button named 'Record Movement' that opens up another form. What I want to do is disable the 'Record Movement' button until these fields are populated. I am using Access 2010.
View RepliesI have a command button which will work on a specified date of every year. After the user clicks it once (which will carry out calculations), I want this button to be disabled so that it is not available for second click. Is it possible?
View 1 Replies View RelatedI 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
Objective: After each field in my form is completed, I want my NewSave button to be enabled.
Problem: Created an if/then code that disables the button but never re enables it after conditions are met
Code:
Private Sub Form_Current()
Dim promptmsg As Long
If IsNull(Me.ContractValue) = False And IsNull(Me.ContractNumber) = False
And IsNull(Me.InvoiceDate) = False Then Me!NewSave_Button.Enable = True
[Code] .....
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 RelatedI want to be able to update a date field in my form with a command button based off the date the person picks off a combo box in my header... is this possible?
View 1 Replies View RelatedI 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 RelatedI 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...
I have a number of tables in my database, and they're linked in with a form. I'd like to have a field in a form that's populated automatically based on what's inputted in a different field.For example, I've got one table with names and descriptions on widgets (name in column A, description in column B).
Widget 1 This widget is blue
Widget 2 This widget is green
Widget 3 This widget is yellow
When I'm in my form, I want when I select Widget 1 to have the corresponding text (This widget is blue) appear in a field below.
I have an order form that auto-populates details from the customer table into adderss and contact controls. But I don't want it to auto-populate when the underlying order table already has data in the related fields. Here is the code I use on Load form event...
======
Private Sub Form_Load()
'Use this version if the ID is a number
Dim x As Variant
Dim strControl As String
Dim lngID As Long
'If parameters exist, use them
If Len(Me.OpenArgs) > 0 Then
[Code] ....
I have a form, combo box selection, when i make a selection, all the info is good on all my tabs, which holds the subform.My issue is, on one of the subform, it's a data entry form, where I want it to be on a new record page. instead it list all records. I want my users to see a blank page, but have one field populated. is this possible?
1) blank data entry page, but with a populated field?When a CU Name is selected,I want the (Enter Note) tab to go to a data entry or last page or new page.I have tried putting it to data entry form, but the CU Number will not populate.
I'm trying to have a button in a form that, when clicked, will time stamp a text box already formatted for time. But once the text box is filled with a time, the button then disables itself for that record.
If I switch to another record where the text box is empty, the button will enable itself without closing the form, but obviously re-disable itself if I go to a record the text box is filled.
I'm sure I could use conditional formatting for it, but I don't think I'm going about it the right way. I already got a basic button built to timestamp.
Basically I want to put a code in the "on load" event of a form that enables or disables navigation buttons based on a value in a table (the table has 1 record and 1 column).
So if the value is "A", I want to hide navigation buttons on load; if it is "B", I want to show navigation buttons on load.
I know I can set this property in each form, but I have a number of forms that I want to configure at the same time.
My problem is that I don't know how to reference the value in the table.
I have a form that has a listbox and a subform. The listbox lists names of events, start date and end date. The subform bellow reveals names of participants to the event that is clicked in the listbox. Against each participant's name is a button to delete the participant.How can I hide or disable the delete button if the start date of the event is past?
View 1 Replies View RelatedI have 3 macro importing 3 files, and then another button to process those data.
So, I need a function to enable/disable the button depending on the files have been imported or not.
Hi all
I have searched the forums and tried various options but I get an error message about the syntax.
The button is to run a SQL query to update a field by calculating on the value of a another field on the form. The query is
DoCmd.RunSQL "UPDATE BatchPayments SET BatchPayments.[GST Amount] = (BatchPayments.[Net Amount]*0.1) WHERE BatchPayments.BatchPaymentsID=" & Me.BatchPaymentsID&";"
The error message is a compile error where it is expecting a list separator or ).
Probably simple but it has got me beat.
Any help will be appreciated.
Regards
I got a form with a field called [copies on hand] so i made a command button and when i click the button, i want the value in the field [copies on hand] to be subtracted by one.....
The code i have thats not working is
Private Sub Command 25_Click()
If [copies_on_hand] >0 Then [copies_on_hand] = ([copies_on_hand]-1)
End Sub
We have an old laptop running XP.I have an old Access 2000 disc which I no longer use, and this has been loaded to that machine.I am trying to build a very simple database to keep track of the members hours.The table name is Main_Table, the fields are; [ID],[Name].[Hours].A form exists Sign In.On the Form,Sign In I need a Combo Box or List Box to select a record (name) then a command button which adds 2 hours to the number of hours already in the [Hours] field of that selected record, simple as that.I cant get anything to run
View 7 Replies View RelatedHi,
I have a form which lists Employees (flds EmployeeID (pk), Surname etc.) and a form listing Absences (flds AbsenceID(pk), EmployeeID(fk), StartDate...etc.).
from the employee form, I want to use a command button that will take me to the Abscences form but auto insert the EmployeeID and then I can fill out the rest.
I tried the go to form command for the button but its only looking for existing absences with that ID?
can anyone help please?
much gratitude!
regards all
Keji
What is the best way to get a Command Button to populate a field on a form with a value from a another table in the database?
View 3 Replies View RelatedI would like to make a command button to change the font in a text field on a form.
Can any one give me an example of the code that I would use to do this? I would greatly appriciat it.
I am setting up a "to_do" list in access. One of the field is the date the task was last completed. I want a button to update that date to the current date for the record that i am viewing on the form. Below is the code that I am using. When I click on my button, it updates the first record in my to-do table but not the current record displayed in my form.
Private Sub Cmd_Update_Click()
Dim DB As Database
Dim rs As Recordset
Dim i As Long
On Error GoTo Command4_Click_Error
Set DB = CurrentDb
[Code] ....
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
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
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 RelatedI 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.