ADezii, I appreciate your input and help.
Also I appreciate mcupito and Seth Shrock's time.
:)) !!
It works,
with dbComplexText / dbComplexLong / etc..
How wonderful,
thanks.
p.s.
What is dbComplex?
Michael R
Last Activity: Feb 10 '14, 11:28 AM
Joined: Nov 21 '06
Location:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin AccessWhen Access asks me: "You have changed the "New: lookup column to store multiple values. You will not be able to undo this change once you save the table"
"Do you want to change "New" lookup column to store multiple values?"
Either I choose "yes" or "no", the result is the same, that column also appears to be multivalued doesn't allow choosing multiple values.Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin AccessThere is probably some table property that needs to be applied in order for this to work, I just don't know which one.Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin Accessmcupito, I moved it outside With, you are right,
but the problem still remains...Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin AccessWell, thanks so much for your suggestion, Seth.
I've used the multi-value fields, and although it is not considered as a best practice, they served me well.
Also, the give my users the ability to multi-select values from combo-boxes, which is very UI-convinient, and is possible only through Multi Value Fields.Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin AccessIt occurs only when i view the recordset from double clicking the Table object on the Access Objects lists.
Also, even though viewing the table's fields properties through Access Objects list shows Allow Multiple Values property as True, it only presents a regular Combo Box in it's display control (both from a form or from table view) and not the Multi Combo Box that it suppose to present.Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin Accessnotice that in the AllowMultipleVa lues property I choose DDL as false.Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin Accessthis is my current code, after your suggestion:
...Code:Sub Test1() Dim db As dao.Database, tdf As dao.TableDef, fld As Field Set db = CurrentDb Set tdf = db.TableDefs("Contacts") With tdf Set fld = .CreateField("New3", dbText, 255) .Fields.Append fld fld.Properties.Append .CreateProperty("DisplayControl", dbInteger, acComboBox)Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin AccessI made the DDL false, and still get the same message after entering the altered table.Leave a comment:
-
Michael R replied to Creating a Multi Value Field through DAO works, but Access has problem saving itin AccessIt's a typo here, in the code I got it right.Leave a comment:
-
Michael R started a topic Creating a Multi Value Field through DAO works, but Access has problem saving itin AccessCreating a Multi Value Field through DAO works, but Access has problem saving it
Hi.
I'm using Access 2010 x86
I'm trying to create a Multi Value Field in a table using DAO, with the following code:
...Code:Sub Test1() Dim db As dao.Database, tdf As dao.TableDef, fld As Field Set db = CurrentDb Set tdf = db.TableDefs("Contacts") With tdf Set fld = .CreateField("New", dbText, 255) .Fields.Append fldLast edited by zmbd; Feb 9 '14, 12:12 AM. Reason: [z{for those that don't know x86 means the 32bit install (^_^) }] -
Michael R started a topic Looking for a way to get event's arguments without using [Event Procedure]in AccessLooking for a way to get event's arguments without using [Event Procedure]
Hello.
I need to get an event argument, for example, current button state, without using [Event Procedure] sub arguments.
Is it possible?
background: I have a big amount of similar controls and each one of them should react in a similar way on MouseDown event. I'm using "=MouseDownSub( "TextXX")" instead of [Event Procedure] in the MouseDown property for each control in controls Te... -
It works fine for me to!!
Thanks so much!! =]]]Leave a comment:
-
Thanks a lot for your reply, Rabbit.
background: I'm trying to create some drag'n'drop capabilities for my program with things to be activated while something is dragged, but not yet dropped, above a certain control
Can't do what you suggest because:
when the mouse key is being pressed, controls On Mouse Move events aren't getting registered.
I even tried to use GetCursorPositi on function http...Leave a comment:
-
How to detect On Mouse Move when mouse key is pressed?
Hello dear experts.
When there's a code on On Mouse Move event it activates as mouse is moved over that control. How is possible to activate a code when mouse is moved over that controlled but has its left-button pressed?
Thanks for your time!! -
I have a unique key, my date is a real date, I just gave a simplified example in order not to overload with too much detail.
I need the 3 lowest dates.
How can I use the subquery in order to get the result?Leave a comment:
-
How to select TOP X results of a field for each value of another field?
Hello!
There's something that seems quite simple to do, but I still don't understand how to do it:
I need to create a query from the following table:
Table1:
P: Date: CountOfMeetings :
1 01/12 4
1 02/12 0
1 03/12 2
1 04/12 0
1 05/12 3
1 06/12 2
1 07/12 2
2 01/12 3
2 02/12 2
2 07/12 3
2 12/12... -
Works well, thanks!
I guess you can't build everything with Access query builder.Leave a comment:
-
Complex(?) conditions query
Hello all.
I have a Jet SQL question:
I'm trying to write a query based on these 2 tables:
table1:
A: B:
1 1
2 1
3 1
4 1
5 1
1 2
2 2
3 2
4 2
5 2
table2:
C: D:
1 1
2 1
3 1
4 1
5 1
1 2
2 2
3 2
4 2
5 2
Now the query needs to show all the... -
FishVal, ADezii, thanks for the reply.
Second method works fine, gracios.Leave a comment:
No activity results to display
Leave a comment: