We just upgraded to Access 2003 and I am creating a new database and in my Form... I was trying to set the REQUIRED FIELD PROPERTY to YES, but when I click the Properties of each field, it's not listed.
Has this been removed?
We just upgraded to Access 2003 and I am creating a new database and in my Form... I was trying to set the REQUIRED FIELD PROPERTY to YES, but when I click the Properties of each field, it's not listed.
Has this feature been removed?
I am trying to change a field to be required. I know where it is...
(Navigation Pane > Design View > Select field I want required > Properties Pane > General Tab > set Required property to Yes)
But I don't see that General Tab at the bottom of my page.
The closest thing I have to properties is on the right-hand side. It opens when I right-click, then hit Properties. It displays...
Format | Data | Event | Other | All... but that's it...
[URL]
How do I set the Required property for field that already exists via SQL. I'm thinking along the lines of: ALTER TABLE table1 ALTER COLUMN field1 text(50) NOT REQUIRED.
But this doesn't work, any clues?
I have created a report but discovered that I need to add a couple more fields.
I created a query for the one field and the other field I added to the existing queries.
Neither field is listed in the "add existing fields" drop down list. The fields have been added to the corresponding forms and tables.
How can I add these two fields without creating a whole new report?
I have no experience with Access Modules which I think I need to find all the queries that reference a field, in this example: LAWSON_LHSEMPDEMO.R_STATUS
I would like for the module to list all the queries for me that reference this table and field of "LAWSON_LHSEMPDEMO.R_STATUS"
Is there an easy way to do this?
I have a numeric field (long integer) in a table. I've set the format to fixed. No matter what I set the decimal places to, auto, 0 or 2, when I enter a value of 0.71, it displays as 1.00
In my form, I've also set the field property to fixed, but it displays the value as 1.
I would like to change the property of a text box to Visible and Required when a user chooses a specific value in a drop down box of a different text box. Is this possible using a macro or some other way?
Thank you,
Deana
I am trying to do something that I would think is very simple but I'm having a hard time with it. I have a form that consists of questions that the user is needed to answer. It displays the question, a combobox where the User can select 'Yes' or 'No', and a textbox where the user can input their comments. What I would like to do it the following: if the user selects 'Yes' as an answer, I want the corresponding comments box to be required.
View 10 Replies View RelatedHi. I want to have all my fields on my form to be required and so that the user cant close the form if they are empty (error message). In the table properties I have them set to Required an have tried putting in a validation rule of IS NOT NULL but it still dont work. any help appreciated. thanks
View 1 Replies View RelatedHi. I want to have all my fields on my form to be required and so that the user cant close the form if they are empty (error message). In the table properties I have them set to Required an have tried putting in a validation rule of IS NOT NULL but it still dont work. any help appreciated. thanks
View 1 Replies View RelatedI have a table named: tblStudents
I have a fields named Course and Basic Code Enforcement
Within the properties for Basic Code Enforcement, I have this as a Lookup row source:
SELECT IIf([Course]="Residential Inspector Multi-Discipline",1,"") AS Expr1 FROM tblStudents;
It is also set as Listbox, Table/Query
The main goal is to have the field RBasic Code Enforcemente show a 1 if the Course field is Residential Inspector Multi-Discipline. I have been at this all morning and I can not figure this out.
Thanks in advance for any help.
Dan
Quick question for you.
I know how to set a required field, but how do I edit two field so that they are dependant on each other? IE. How do I set my form to make FIELD1 required ONLY if FIELD2 is empty and vice versa?
Thanks very much and I hope I've explained myself correctly.
I can not for the life of me figure out how to make one field required. The name of the field on the form is Selectee. Can someone help?
View 2 Replies View RelatedAfter some suggestions, I have a form with combo boxes, the combo boxes are set to enabled "no", but become enabled by an after update command on another field.
The after update command works perfectly, however once enabled I need to ensure data is selected, as opposed to leaving blank.
Any ideas on the best/easiest way?
I have a form that users update, but they continue to leave this one field blank and I have to go behind them to enter this date.
Field Name: OrigProcDt
This is a date field
I don't want this field to be a required field in the table, because it won't stop it anyways.
The record is already added by the clerical staff, the other users just update the record when it's time to.
The problem is that they need to enter a date in this field before leaving the record they are updating.
Any help would be appreciated.
Some records that users are inputting through a form are coming back blank in fields that are required. how do I fix?
View 3 Replies View RelatedI have made a form based on related tables. it requires me to fill out every field, which I don't want. I didn't make them required. Why does it do that?
View 3 Replies View RelatedMy access db is used to compile payroll time records bi weekly. The Work Hours table is used to hold two weeks of time records then they are archived to a history table. Each week has its own week ending date. I have been updating the default value of the week ending manually in the table field property in the table's design view. Is there a way to have a macro update this default value?
The current process is, open table in design view, update week ending default value, enter payroll time then change default value again for second week ending, enter payroll time. Report hours to accountant, archive table to history table.
How can I use the validation rule to set field to required instead of checking required field, because I wish to customize the prompt message.
Thanks.
Hello everyone
I am wanting to pull out only the month part from a date field, 11/10/2005.
In the query I have made an expression to pull the month, eg 10 for October.
I need to convert this number of the month to the Title of the Month.
I made a combo box on the report based on the Expression and in the row source put
1,"January", 2,"February",3, "March", 4,"Apri", 5,"May", 6,"June", 7,"July", 8,"August", 9, "September", 10, "October", 11, "November", 12, "December"
Unfortunately it still comes out with the number of the month.
Can anyone tell me please where I am going wrong.
Thank You in advance.
I have form "Project Log" for my table "Orders". One field "OrderTakenBy" ( text field) is a required field in the table.
In the field properities of OrderTakenBy in the Before Update event I have used the following code:
Private Sub OrderTakenBy_BeforeUpdate(Cancel As Integer)
Dim strMsg As String, strTitle As String
Dim intStyle As Integer
If IsNull(Me!OrderTakenBy) Or Me!OrderTakenBy = "" Then
strMsg = "You must enter your name."
strTitle = "Field Required"
intStyle = vbOKOnly
MsgBox strMsg, intStyle, strTitle
Cancel = True
End If
End Sub
When I first tested it, after trying to leave the field without making an entry-it worked great. Now it seems to have stopped working, I get no message when I leave the field empty.
I need help with a required field that has different character lengths.
I have an input mask that covers the first 7 characters, however, the users are still entering the incorrect policy numbers, I need to put a stop to it.
I have 3 different policy number lengths involved, 7, 8 and 9.
They are different kinds as well, alpha, alpha/numeric and numeric.
Example below:
P###### - 7 characters
02###### - 8 characters
02M##### - 8 characters
NX####### - 9 characters
HX###### - 8 characters
HXL##### - 8 characters
HXM##### - 8 characters
My question is this -- do I have to create 7 different forms or can I program it to accept only the certain (policy#) characters above. Or can I create a query to insert into my form.
Any help is appreciated, Thanks as always.
What i want to do is if a user forgets to put lets say Address or Zip
Will not allow user to save record but instead will highlight the text boxs
that are required. Once data is put in will allow user to save record.
Any ideas
I need help with a required field that has different character lengths.
I have an input mask that covers the first 7 characters, however, the users are still entering the incorrect policy numbers, I need to put a stop to it.
I have 3 different policy number lengths involved, 7, 8 and 9.
They are different kinds as well, alpha, alpha/numeric and numeric.
Example below:
P###### - 7 characters
02###### - 8 characters
02M##### - 8 characters
NX####### - 9 characters
HX###### - 8 characters
HXL##### - 8 characters
HXM##### - 8 characters
My question is this -- do I have to create 7 different forms or can I program it to accept only the certain (policy#) characters above. Or can I create a query to insert into my form.
Any help is appreciated, Thanks as always.
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
' This procedure checks to see if the data on the form has
' changed. If the data has changed, the procedure prompts the
' user to continue with the save operation or to cancel it. Then
' the action that triggered the BeforeUpdate event is completed.
Dim Ctl As Control
On Error GoTo Err_BeforeUpdate
[code]....
THis code avoids a form being closed if a required field (with tag "*") is not filled. How can I expand it to fields on a subform?Another "issue", how can I personalize the error messages :
1) Can't save record at this time ... (required fields in my table)
2) Multicolumn index causes an error message "Ca't save because of duplicate value in primary key, index ...