distinction between using .text and .value in VBA access

Posted by every_answer_gets_a_point on Stack Overflow See other posts from Stack Overflow or by every_answer_gets_a_point
Published on 2010-05-16T14:55:24Z Indexed on 2010/05/16 15:00 UTC
Read the original article Hit count: 125

Filed under:

access

|

macros

|

vba

|

sql

i am passing the textbox1.text values into a query and sometimes into a string

sometimes i say this:

dim combor1 as string
combor1 = comboReason1.Text

how do i know when i should put combor1=comboreason1.value ??

also why do i need to set focus for a control to reference its property? that doesn't make sense to me

also when i set combor4 = comboReason4.Value and the .value is null, then i get an error about invalid use of null

please help!

© Stack Overflow or respective owner

Related posts about access

Postgres user drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
Postgres user/role drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
ASA hairpining: I basicaly want to allow 2 spokes to be able to communicate with each other.

as seen on Server Fault - Search for 'Server Fault'
ASA Spoke to Spoke Communication I have been looking at spke to spoke comms or "hairpining" for months and have posted on numerouse forums but to no avail. I have a Hub and spoke network where the HUB is an ASA Firewall version 8.2 * I basicaly want to allow 2 spokes to be able to communicate with… >>> More
.NET Access automation with Access 2007 Runtime

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble deploying .NET application which uses Microsoft Access automation. I've installed the Access 2007 Runtime and Primary Interop Assemblies (PIAs) on the target machine: Access 2007 Runtime Office 2007 PIAs However, when I try to create the ApplicationClass: Application access… >>> More
Cisco 800 series won't forward port

as seen on Server Fault - Search for 'Server Fault'
Hello ServerFault, I am trying to forward port 444 from my cisco router to my Web Server (192.168.0.2). As far as I can tell, my port forwarding is configured correctly, yet no traffic will pass through on port 444. Here is my config: ! version 12.3 service config no service pad service tcp-keepalives-in service… >>> More

Related posts about macros

"macros have been disabled" message in Word 2007 but no macros

as seen on Super User - Search for 'Super User'
Hi there, I open a .doc file in Word 2007 (sorry I am unable to supply the .doc) which pops up with a message above the document "Security warning: Macros have been disabled" but there are no macros shown in the macros listing and no functionality displayed in the VBScript editor. Why does Word… >>> More
Avoiding symbol capture when using macros to generate functions (or other macros)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm a bit confused as to exactly when symbol capture will occur with clojure macros. Suppose that I have a macro which defines a function from keywords. In this trivial example, (defmacro foo [keywd1 keywd2] `(defn ~(symbol (name keywd1)) [~(symbol (name keywd2))] (* 2 ~(symbol… >>> More
Macros's that define macros

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know how to pull off something like this... I have alot of repetitive macros as : - #define MYMACRO1(x) Do1(x) #define MYMACRO2(x,y) Do2(x, y) #define MYNEXTMACRO1(x) Do1(x) #define MYNEXTMACRO2(x,y) Do2(x, y) The code above works fine, but I want to write a macro… >>> More
makefile: how to call macros in macros

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have the following macros in my make file: pdf: // do something clean: // just another fancy thing No I want to declare a macro all: which include (or call) the makros above. The following thing doesn't work: all: pdf: clean: I don't want to repeat the code from pdf:… >>> More
Macros in macros (C++)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to put a macro in a macro in c++? Something like: #define Something\ #ifdef SomethingElse\ //do stuff \ #endif\ I tried and it didn't work so my guess is it doesn't work, unless there's some sort of syntax that can fix it? >>> More