Hi Forum leader,
Sorry about that, I have no any intention to be rude and waste anyone time.
My database is not too restrict, just based on the reqirement, I didn't set a_number is PK, although it should be, but I just don't want it duplicated, except for those without a_number, can repeatly give the 000-000-000.
Anyway, thanks everyone here help me, bow~~bye~~...
jayjayplane
Last Activity: Oct 24 '08, 03:48 PM
Joined: Sep 25 '08
Location:
-
Yes, the a_number is not allow duplicate, but it is a possible that someone who without a_number, then have to give 000-000-000 to him/her, so there is possibility more than one person without a_number, that's why it only allow 000-000-000 duplicated.
anyone else can help me?Leave a comment:
-
And when I tried to modify the code as this:
when input the 000000000 in text field again and click the command to add new record, the 00000000 didn't be inserted again as duplicates, but went into the old a_number is 000000000 old record....Code:strsql2 = " WHERE A_NUMBER = '" & Me.txtSSN & "' And A_NUMBER <> '000000000'"
Leave a comment:
-
The logic is not right, it can't let 000000000 repeatly input, anybody else can help on this , many thanks!...Leave a comment:
-
how to limit the length of characters of one text field
I tried to limit one of my text field's that the length of input has to be 9 characters, I set the validation rule: =len(txtSSN)=9, and validation description: The field has to be 9 characters!
But the result is not my expected, whatever I inputted, it always give me: The field has to be 9 characters!
Anyone can help me on this issue? -
Thank you, I will try tomorrow....Leave a comment:
-
Sorry, I can't help, but would you like to share the code to change the back color of the whole records, I am also working on this part, but I don't know how.
Also help you keep the post up.Leave a comment:
-
Is It possible to bybass the special situation
I have one text box, and one command, text box for inputting 9 digitS number,,the command to check if the inputs are duplicated, if duplicated, then give error message, my code:
...Code:Private Sub Command42_Click() On Error GoTo Err_Command42_Click Dim strSQL As String Dim strsql2 As String Dim db As Database Dim strMsg As String Dim rs As DAO.Recordset -
Help on conditional insert statement using t-sql
I want to insert value into one temp table, but based on the value from another table, like:
select s2_sess_datetim e,s2_individual _session from lop_2008_stagin g
if s2_sess_datetim e is not null and s2_individual_s ession = '1'
begin
insert #intake_staging (a_number,sess_ datetime,citize nship,language, gender,
exp_rem,pot_rel ,site)
select a_number,s2_ses s_datetime,s2_n ationality1,s2_ language1,gende r,... -
compile error:Method or data member not found
I have two combo boxes on my form, let's say box1(s1_individ ual_session) and box2(s1_nationa lity1), initially I disable box2(gray-out). I want to select box1 value is "true" then enable the box2,
the code:
Private Sub s1_individual_s ession_AfterUpd ate()
If Me.s1_individua l_session.Value = True Then
Me.s1_nationali ty1.Enabled = True
Else
Me.s1_nationali ty1.Enabled... -
On the form the combo box individual_sess ion pulls the true/false values from the value list rather than from a table, but the underlying the table, I set individual_sess ion as text type, but on the form I set individual_sess ion as combo box that contains list value "True" and "False"
Thank you...Leave a comment:
-
Still gave me compile error message,
right now I set box2 nationality enable=no
and select box1 individual_sess ion "false" from drop down menu, box2 is gray as expected, but when I select box1 individual_sess ion "True", didn't enable the box2 as expected but gave me the compile error.
the code here is:
Private Sub s1_individual_s ession_Change()
If Me.s1_individua l_session.Value = "True"...Leave a comment:
-
Thanks beacon, it showed me something I wanted...
bow!...Leave a comment:
-
No, that's not my purpose, I show you part of my code to give you some clue to use the stLinkCriteria to get the dynamic result......Leave a comment:
-
but It gave me compile error:
method or data member not found and Me.Nationality. Enabled = True where "Enable" was highlighted...Leave a comment:
-
dynamic
I am trying to give you some clue, hopefully it is at the point...
This part of my project's VBA code:
Dim stLinkCriteria As String
...............
stLinkCriteria = "[A_NUMBER]=" & "'" & Me.txtSSN & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
.............
I have a text...Leave a comment:
-
data field validation
Thank you very much, yes, it is a form with some combo box, both individual_sess ion and nationality are combo boxes, where individual_sess ion can select value " true" or "false", and for nationality, the data source is from table nationailty, so there are lists of nationality to be chozen. But only when the user select individual_sess ion is "True", then nationality is avaible to be...Leave a comment:
-
the question right now can like this:
I have a couple of combo box fields, one of the field will pop up only based on the upper field value is "true", for example, field "individual_ses sion" and field "nationalit y", the nationality field will pop up and ready to choose the value only when individual_sesi on value is "true", otherwise the field nationality will be forced to fill blank....Leave a comment:
-
why nobody helped me today, i didn't explain the question very clear?
My supervisor didn't give me a lot of time to work on it, and I also tried many ways, but still didn't walk through...
Experts, please help....Leave a comment:
-
some mistake here, there are combo box for individual_sess ion and nationality rather than list field.
I am online waiting , anybody can help?Leave a comment:
No activity results to display
Leave a comment: