473,396 Members | 1,968 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to define rowsourcetype for a value list in vba?

111 100+
The seoncd line in following code is always red as it contains some error.
Expand|Select|Wrap|Line Numbers
  1.  Me.Combo31.RowSourceType = "Value list"
  2.         Me.Combo31.RowSource = "spvr";"mngr";"user"
Please help
Dec 8 '09 #1

✓ answered by ajalwaysus

Expand|Select|Wrap|Line Numbers
  1. Me.Combo31.RowSourceType = "Value list"
  2. Me.Combo31.RowSource = "spvr;mngr;user"
or
Expand|Select|Wrap|Line Numbers
  1. Me.Combo31.RowSourceType = "Value list"
  2. Me.Combo31.RowSource = "'spvr';'mngr';'user'"
This second one is untested, but the first one should work.

Let me know if this works,
-AJ

2 22762
ajalwaysus
266 Expert 100+
Expand|Select|Wrap|Line Numbers
  1. Me.Combo31.RowSourceType = "Value list"
  2. Me.Combo31.RowSource = "spvr;mngr;user"
or
Expand|Select|Wrap|Line Numbers
  1. Me.Combo31.RowSourceType = "Value list"
  2. Me.Combo31.RowSource = "'spvr';'mngr';'user'"
This second one is untested, but the first one should work.

Let me know if this works,
-AJ
Dec 8 '09 #2
AccessBeetle
111 100+
Both of them works. I tested.
Thanks much!! It really helped.
Dec 8 '09 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: ..:: sjf ::.. | last post by:
Hi all, I want to define 'in' operator (or any "magic" function) on list which returns True value if all of list (i.e. _list) elements appears in other list (i.e. L) in the same order and False...
3
by: axial | last post by:
Is there a way to define a variable by resolving other variables? I'm trying to build an "uber-variable" from user-selected components. I have control over the XML and can change it as needed. ...
7
by: Malcolm Cook | last post by:
Hi, I've created and installed a custom UDF to populate my combobox, and have defined it per :...
7
by: No Spam | last post by:
----snip #define POSITIVE_INTEGRATOR_SATURATION 0x03000000L // #define NEGATIVE_INTEGRATOR_SATURATION 0xFD000000L // long integrator; integrator=0;
4
by: Shaul Feldman | last post by:
Hello, I have something really awkward at work - fighting with CheckBoxList... How can I define CSS for ListItem in CheckBoxList programmatically. I add CheckBoxList's Items on the fly, something...
11
by: Frank Silvermann | last post by:
#define q p I must admit to a most elementary confusion. I have only ever used #define to, in point of fact, #redefine . The above is standard. Is the following: #define...
12
by: Just D | last post by:
All, It was possible before in Pascal, C++, etc. to define our custom data type or redefine the existing type, like in Turbo Pascal we could assume that shortint is int and use all references to...
14
by: raghu | last post by:
Hello I have a doubt plz clarify that #ifndef SYSTEM_H #define SYSTEM_H what will be the value of SYATEM_H after this #define statement and before that statement. Thanking you all Bye
0
by: Chris | last post by:
I have a list and it's rowsourcetype is set to the function get_databases_DIR. Function works without any problem in MDB, but not in MDE (nothing is returned). If Static was the problem, since I am...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.