Greyed-Out New Table Button?
Jun 14, 2007All,
Can anyone please tell me why this button is greyed out as I can't create a new table!?
Thanks.
ADVERTISEMENT
Permissions Greyed Out
Jul 22, 2005Hi,
I have secured a DB and everything is tickety boo except for the fact that I want to be able to administer permissions from the FE (MDE) and the modify permissions button that i have put on a custom toolbar is greyed out when I log in?
I have full admin rights on my group and own all the objects and Access lets me assign all the permissions if I enable the shift bypass and enter the development MDB that way but that's quite a bit of hassle if I want to just change a permission or two.
Can anyone tell me why it won't let me change them?
Thanks, Tom
General :: Greyed Out Objects In Database
Sep 23, 2013I have greyed out objects in my Access database. I didn't create them and don't know what they are. I tried to delete them but couldn't. Why did they come to my database -or they were already there but now they are appeared- and how can I get rid of them?
View 3 Replies View RelatedRelationship Window, Enforce Referential Integrity Greyed Out
Mar 29, 2007Hello..
I have a simple database of 4 tables.
luTblJobTitle
JobTitleID (pk)
JobTitle
luTblReason
ReasonID(pk)
Reason
tblDateReason
DateReasonID(pk)
EntryNumber(fk)
Date
Reason
Entered
tblEmpMain
EntryNumber(pk)
EmployeeNumber
Etc//
I have a 1 to many setup between tblEmpMain and tblDateReason.
When I try to setup the relationship between the "reason" field in tblDateReason and luTblReason, Referential Integrity along with the other two check boxes are greyed out.
It still shows one to many but it will not let me enforce referential intergrity.
Why is this? Did I setup the database wrong? Or am I trying to do something I shouldn't be doing??
I have attached the db.. It is split with both the backend and the front end.
R~
Forms :: Hiding Parts Of A Form Or Making Them Greyed Out?
May 15, 2014hiding parts of a form if a option button is selected. There are two option buttons and two parts to the form. I would like each part of the form greyed out or made invisible depending on which radio option button is selected.
View 14 Replies View RelatedButton Value From Table
May 23, 2005Hi 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.
Button Changing Value On Table
Aug 14, 2007Hi 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
Button To Add Attachments To A Table
Jul 30, 2014I 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
How To MessageBox Contents Of A Table With A Button
Feb 27, 2007This 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
Command Button Clearing Table?
Apr 27, 2007Is 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!
Button Captions And Details From Table
Sep 18, 2007Hi 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
Nov 13, 2007Option 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
Control Button To Open Table.
Jul 26, 2005the 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
How Do I Use Submit Button To Add Details To A Table?
Jan 10, 2006Hi 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!
How Do I Use Submit Button To Add Details To A Table?
Jan 10, 2006Hi 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!
Using A Command Button To Display A Table
Sep 3, 2004Can I use a command button to display my table? If so, what code needs to be used?
View 2 Replies View RelatedUsing Command Button To Open Table
Aug 26, 2005Dear 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
General :: Button To Add New Record To Another Table
Jan 19, 2015I 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.
Tables :: Possible To Have A Were Condition For A Button To A Table?
May 23, 2015I 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?
Forms :: Delete Row From Table Button?
Jul 16, 2013The 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
How To Use Option Button To Store Value Into Table
Dec 9, 2013I 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?
Using Table Data As Button Captions
Nov 13, 2011I 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 RelatedExport A Table To Excel By Click Of A Button
Aug 12, 2007Hi,
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 .
Coding Command Button To Add A Few New Records To A Table
Nov 2, 2006I 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.
Editing Table Data From Within A Form Using A Button
Jun 12, 2007Hi 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?
Modules & VBA :: CMD Button To Clear A Table Column
Mar 26, 2015I'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 ...