Gerhard
Last Activity: Feb 28 '11, 04:58 PM
Joined: Feb 27 '07
Location:
-
I Guess the best way to go forward is to avoid comboboxes where LimitToList = No. Thus way the combobox always find a valid row in it's list, which ensures that the AfterUpdate event runs smoothly. -
Yes thanks. Why haven't anybody give you credit for it yet? Well done!
OK here is where I am:
Sorry to say but I'm now even a bit more confused.
You must see this to believe it.
I have eliminated everything in the mdb and reduced the combobox to only two columns to try to keep everything as simple as possible and I have left only one textbox called TextA. The idea is that when the user selects a...Leave a comment:
-
Found it under recordset > Items. Will come back.Leave a comment:
-
I'm able to see the value of my combobox's 1stColumn in the "Locals" pane under "Oldvalue" and "value", but I can't find the values of the 2nd and 3rdColumns. Where must I look?Leave a comment:
-
Yes, but the problem is that it appears that not all the code in the AfterUpdate event executed after a successful update.Leave a comment:
-
Hallo
Yes, I have quite a lengthy peace of code in the main form's On Current event, but that is not the problem, because I copied the combobox and the two text boxes to a new blank form with nothing else on it. But the problem keeps on repeating itself.
Must I email you a copy of the mdb with everything removed except for this one little form and the small table for the combobox's Row Source?
I got a...Leave a comment:
-
Gerhard replied to Append Query gives "validation rule violations" after text was edited in Comboboxin AccessThanx
I got it sorted out.Leave a comment:
-
Combobox AfterUpdate Bizarre
This is bizarre... Im having problems with the combobox AfterUpdate event:
Im running Access 2003.
I created an unbound combobox with 3 columns on a form.
The Row Source is from a table.
Bound Column = 1 and LimitToList = No,,, thus the user can edit the data in the 1st-Column after they selected one of the rows in the combobox.
However, I want to save the data of 2nd-Column and 3rd-Column,... -
Gerhard started a topic Append Query gives "validation rule violations" after text was edited in Comboboxin AccessAppend Query gives "validation rule violations" after text was edited in Combobox
Hi
I have a combobox on a form which gets it's Row Source from a table.
I then use an Append Query to save the selected data in the combobox to a file.
Everything works fine.
The Combobox's "Limit to List" property is set to No, thus the user can edit the text in the combobox.
However, the append query gives a "validation rule violations" if you change the text in the combobox.... -
Thanx Nico.
That will help.
Regards
GerhardLeave a comment:
-
Hi Nico
The response is marked by ***>""
3. In the report itself, how do I check the value of the column headings. E.g. if I use the CourseID in the column heading, how do I extract it in the report - so that I can use it to look up the Course's description as well?
==> The concatenated field becomes the column heading, thus the value should show as required. Problem will be the assignment of the...Leave a comment:
-
Hi Nico.
Let me get this straight...
1. Are you saying that I don't have a choice, but to use the Course, Subject, Date combination as column header? In other words,,, there is no way to transpose the data in Access or VB.
2. So this means the report has to run several times until all Dates have been included. How would you do this?
3. In the report itself, how do I check the value of the...Leave a comment:
-
Major Crosstab
Hi there, I need a little help please.
I need to create the following report for a medical training school:
Course Name:.......... ............... .....Course1... ............... .............Co urse2
Subject Name:.......... ..Subject1....S ubject2....Subj ect3.......Subj ect4..Subject5
Date:.......... ............... ..1/1..2/1....1/1..2/1..5/1....8/1..9/1............1/1......13/1..2/2
Periods for Student1:...5.. ...2.......1... ..1.....8...... .5....2........ .......0....... ....3.....1... -
Hi
I have the same problem. My Update Query only Lookup the first value and puts the result in all updated records, instead of looking up the value for each record that needs to be updated.Leave a comment:
-
Thanx I'll use it.Leave a comment:
-
Ps. You should include DoCmd.SetWarnin gs False and DoCmd.SetWarnin gs True only when you are sure that your Query works fine.Leave a comment:
-
Yes, you do need to put some code in the button's On Click event.
Try this code:
DoCmd.SetWarnin gs False
DoCmd.OpenQuery "Query Name"
DoCmd.SetWarnin gs TrueLeave a comment:
-
Report text box borders automatically reset to solid
I created a database in Access 2000 on my PC.
I copied it to a laptop which runs Access 2003 and XP.
I opened the database on the laptop and printed some reports, but the borders of all text boxes on the reports were then somehow reset to “solid”, while I had it “transparent” on the PC.
I changed it back to transparent and I’m not going to try to replicate it again; just wondered if anybody had the same problem.... -
Clever Irish. And they can play rugby too!Leave a comment:
-
Thank you ya beauty! It works.
But tell me, why is it necessary to specify the format in the query if you use “[Forms]![FormName]![ControlName]"?Leave a comment:
No activity results to display
Leave a comment: