Hi Guys and Girls,
Does anyone know if it is possible to have a button assigned a value from a table/query record, (I need to use a touchscreen so can't use a combobox.)
eg button one = record 1, button2 = record 2 etc when pressed the value of the record is passed to another field.
thanks for any help.
Hi all,
I'm struggling with a small issue that has to be quite simple.
I have a form called "Project Main" with a label called "Check".
There is a sub form called "PM Main" with a button "Button1".
What I want to do is to have the label "Check" change color when the button "Button1" is clicked. The color change is record specific, so here is what I have done:
-Created a table [Updated] that contains the project number [ID#] and a yes/no field [PM Updated]
-Now I need to be able to change that value (yes/no) when the button "Button1" is clicked.
-Then I need to have the main form "Project Main" check to see what the value of the [updated] table is.
-Then I need to have code to update the color of label "Check"
Does this make sense or am I making more complicated than it is?
Mafhobb
All,
Can anyone please tell me why this button is greyed out as I can't create a new table!?
Thanks.
I am looking for a way to attach X amount of pictures to a record. I want to use a command button that opens an explorer to choose X amount of files. I don't want to just open a folder because that won't return the file location.
How to open an "attachment explorer"?
Access 2007
This may seem a very simple question, but I really don't know how to do it. Basically, I want to MessageBox contents of a table with a button. I have a table called Map, and has two fiels: Column Number and Description. When a button is pressed, then I want a messagebox to come up and show the column number and the description of a single field. Although I know it is very wrong, here is the code I used for this (r![column Number] = 4 is meant to be the forth column number in the table):
Dim d As Database
Set d = CurrentDb
Dim r As Recordset
Set r = d.OpenRecordset("Map")
r![column Number] = 4
MsgBox "Column No: " & r![column Number] & ". Description: " & (r![Description])
By the way, there are seperate buttons for seperate fields. It is DAO as well
Thanx in advance
Is there a way to have a command button on a form, when pressed change all fields in a Table to show unchecked? I am using a Table that has nothing but Yes/No fields in it. If this is possible, what might the code look like? Table name is "InputH-1".
You guys/girls are awesome! Thanks in advance for all your help!
Hi There
I am wandering if anyone has a solution to this problem i has basically have 2 tables 1 called departments, with the fields: Dep No, Dep Name, then i have another table called Items, with the fields: Item No. Item Name, Item Price, Department.
What i want to do is create say 10 command buttons and create an array of them i know sort of how to do it in visual basic and all the 10 command buttons name is the same and an aray is created but i dont know how to do it in access i know that it doesnt let you create an array but i have seen it done somehow in a project that i came across.
so basically what i would want to have done is on the form load the 10 department buttons captions are loaded from the table departments and when a department button is clicked its is linked to items where i ahve created say 20 command buttons called items.
I dont know it it makes sense what i have written but any help on this matter would be very apreciated it pr if anyone knows of any examples as i have been stuck on it a while
Many Thanks
Option Button Description table
I would like to create a table containing description value of my option button group.
This is my description table:
tblLenkeDESC
IDLenkeDescLenkeDESC
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6
And this is my table containing selected option from the form:
tblLenke
IDIDNameLenke
114
225
336
441
552
How can I associate description with the selected options?
Many thanks,
Debbie
the wizard does not have a button to open tables...i have been using this code to open forms...what needs to be changed in order to make it open tables?
Private Sub Command5_Click()
On Error GoTo Err_Command5_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "intakeMatrix"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command5_Click:
Exit Sub
Err_Command5_Click:
MsgBox Err.Description
Resume Exit_Command5_Click
End Sub
Hi everyone, I am new to this so bear with me.
I currently have a form with textboxes and 2 combo boxes. I have a submit button at the bottom of the page and would like this to take all the infomation from the form and add to a master table.
I was hoping to be able to create a pop up message to say "This item has been added to the database"
Can anyone help point me in the right direction?
Many Thanks!
Hi everyone, I am new to this so bear with me.
I currently have a form with textboxes and 2 combo boxes. I have a submit button at the bottom of the page and would like this to take all the infomation from the form and add to a master table.
I was hoping to be able to create a pop up message to say "This item has been added to the database"
Can anyone help point me in the right direction?
Many Thanks!
Can I use a command button to display my table? If so, what code needs to be used?
View 2 Replies View RelatedDear All:
I would like to use a command button on a form to open a table. The name of the table is called "MAJORCODE"
Any suggestions?
Many thanks,
Dion
I have a form wich users input information into and it goes in one table. Several buttons on my form send a report from that table to people.
What I need to to is that every time one of these buttons are pressed and a report is sent, a timestamp and wich button was pressed needs to be recorded in another table in the same database.
This is because I need to record to whom each report was sent and when.
I am wondering, is it possible to have a were condition for a button to a table? I want to click the button, close the form I have, and open up my sales table, and have it have a were condition to be like what I have for my form
Code:
="[EventID]=" & [lstShows]
I have that for the form, and it works, I am just not sure if I can use that for a Table. that "code" us being used in a openform macro. If there isnt a way to use a macro, how about VBA code?
The purpose of this database is to have a simple form that inputs data into a table. There is a subform view on the form so they are able to see their data that was submitted into the table.
Problem:I have made an attempt at making a Delete Row button. The idea behind this is to allow them to select a row on the subform view and then delete it from the table.
Form = frmEvaluationForm
Subform = frmReviewSubForm
Table = tblEvaluationDatabase
figuring out what is causing this error 3075 (syntax error in query expre. Is there a more specific way to delete a row that has been selected?
Access 2007
Code:
Private Sub cmdDelete_Click()
'check existing selected record
If Not (Me.frmReviewSubForm.Form.Recordset.EOF And Me.frmReviewSubForm.Form.Recordset.BOF) Then
'confirm delete
If MsgBox("Delete this record?", vbQuestion + vbYesNo, "Delete") = vbYes Then
'delete now
CurrentDb.Execute "DELETE * FROM tblEvaluationDatabase WHERE CAccount = " & Me.txtCAccount
'refresh data in list
Me.frmReviewSubForm.Form.Requery
End If
End If
End Sub
I want to make option button in access to allow user choose status like: Single, Married and Widower
Single
Married
Widower
When user choose the value must save into table. How to do this?
I want the caption for buttons in my Form to be pulled from a record in a table. Additionally, I want the name of the related form or report opened from the button to be pulled from the same record. I've been looking into this and it seems like using DAO is one option,I've already go the table set up, that was easy enough.
View 7 Replies View RelatedHi,
I would like to export a table formed by a Query into a excel sheet with a Click of a Customized button. can Anyone help me how to do that.
I can do that by going to file and export to excel sheet but i need it to be done with a button of my own .
I have 2 tables, one has a list of comments indexed by numbers.
The second table will be populated with numbers that correspond to the first table based on usage of the form that I'm about to describe.
The form contains several check boxes. Each corresponds to a comment from the first table. If 3 of the check boxes are selected when the command button is pressed, I want three separate new record entries to go into the second table and the data that I want entered is the text in the label that is next to each check box on the form. After the records are added to the table, I'd like to reset the check boxes.
I simply cannot figure out how to code the button to do this.
Hi All
I'm trying to set up a form to log my clinical placement, and the number of time i undertake a procedure.
I want to have a list of a few procedure(fields) and then button next to each one in a form which will increment the number by one
How do i go about doing so?
I'm currently making an Experience Statement for my company. In one of the forms I've created I an Industry sort that is weighted and connected to a table so that it'll show a report based on the numbers provided IE. 1-5 One being shown first and a blank statement not showing on the report at all.
I have the report function working correctly the only thing I would like is a cmd button that clears sort table of numbers so that it doesn't show anything and can start fresh. What VBA code shall I use?
I was thinking something along the lines of this, but it's not working.
Dim s as String
s = "UPDATE All_Projects_Sort_Table SET Industry Sort = Null;"
CurrentDb.Execute s
Requery
Attached are some images ...
I have a table in wich I have stored numbers and i want to subtract them using vba.
example
Table1
ID number
1 20
2 40
textbox(ID):2 texbox(value):5 button(subtract)
So when i click button i want to subtract record with id 2 (40-5=35) and i want the new value to rewrite the previous one in the table.
result:
Table1
ID number
1 20
2 35
I want to know if it's possible to do this in vba.
I have three cascading combo boxes. How can I program a button to record the PK's from these combos into a table, but only if those values don't already exist.The 3 combos are circled in red and I want to record those values into tblJewelryInventory (circled in dark blue).
View 14 Replies View RelatedSo, I have a form [frmmembers] which will enable the table [tblmembers] to be updated when a button is pressed. When the button is pressed, it will enable the fields "First Name", "Last Name", and "Password" to be updated.
At the moment, the data changes without pressing the button (as soon as it is entered into the text boxes on the form), which means that a password could be accidentally changed and could prevent the user being able to enter the system (which requires their personal MemberID and Password).
Is there a way of making it so that the data inserted into the text boxes on the form will only change the data in the table after the update button is pressed?
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 Related