I've got an A2K database with a link to a table in another A2K
database. This linked table contains SSN formatted with the SSN input
mask. I'm trying to use a dlookup using this linked table. The
criteria is matching this linked SSN with an SSN that the user will
input. I have an input mask on the SSN field (on the form only) but
the dlookup is not working. I've tried the following 2 criterias:
strCriteria = conQuote & _
Mid(Me.txtSSN, 1, 3) & "-" & Mid(Me.txtSSN, 4, 2) & "-" &
Mid(Me.txtSSN, 6, 4) & conQuote
....and...
strCriteria = conQuote & Me.txtSSN & conQuote
The dlookup returns null every time. txtSSN is a bound field with no
input mask in the table....do I have to have the input mask in the
table too?
Thanks for any help or advice. 2 2852
Ellen Manning wrote: I've got an A2K database with a link to a table in another A2K database. This linked table contains SSN formatted with the SSN input mask. I'm trying to use a dlookup using this linked table. The criteria is matching this linked SSN with an SSN that the user will input. I have an input mask on the SSN field (on the form only) but the dlookup is not working. I've tried the following 2 criterias:
strCriteria = conQuote & _ Mid(Me.txtSSN, 1, 3) & "-" & Mid(Me.txtSSN, 4, 2) & "-" & Mid(Me.txtSSN, 6, 4) & conQuote
...and...
strCriteria = conQuote & Me.txtSSN & conQuote
The dlookup returns null every time. txtSSN is a bound field with no input mask in the table....do I have to have the input mask in the table too?
Thanks for any help or advice.
Me.SSN = Dlookup("SSN","YourTableName","[SSN] = " & strCriteria)
Me.SSN = Dlookup("SSN","YourTableName","[SSN] = '" Me.txtSSN & "'")
Me.SSN = Dlookup("SSN","YourTableName","[SSN] = "" Me.txtSSN & """)
Oops. I forgot the "SSN = ". Thanks and Sorry...should have caught that.
Salad <oi*@vinegar.com> wrote in message news:<_H*****************@newsread2.news.pas.earth link.net>... Ellen Manning wrote:
I've got an A2K database with a link to a table in another A2K database. This linked table contains SSN formatted with the SSN input mask. I'm trying to use a dlookup using this linked table. The criteria is matching this linked SSN with an SSN that the user will input. I have an input mask on the SSN field (on the form only) but the dlookup is not working. I've tried the following 2 criterias:
strCriteria = conQuote & _ Mid(Me.txtSSN, 1, 3) & "-" & Mid(Me.txtSSN, 4, 2) & "-" & Mid(Me.txtSSN, 6, 4) & conQuote
...and...
strCriteria = conQuote & Me.txtSSN & conQuote
The dlookup returns null every time. txtSSN is a bound field with no input mask in the table....do I have to have the input mask in the table too?
Thanks for any help or advice.
Me.SSN = Dlookup("SSN","YourTableName","[SSN] = " & strCriteria) Me.SSN = Dlookup("SSN","YourTableName","[SSN] = '" Me.txtSSN & "'") Me.SSN = Dlookup("SSN","YourTableName","[SSN] = "" Me.txtSSN & """) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: dude |
last post by:
hello
how would i make an input mask that only makes the first letter a
capitol one?
i've been playing around and testing various masks, also tried the
wizard, but i've had no luck.
could...
|
by: Ellen Manning |
last post by:
I've got an A2K database with a link to a table in another A2K
database. This linked table contains SSN formatted with the SSN input
mask. I'm trying to use a dlookup using this linked table. ...
|
by: Paul |
last post by:
hi,
is there an input mask i could use on a report to do the following:
(1) if i enter "THISISATEST" on my form, i want
the text box on my report to display: "T H I S I S A T E S T".
(2) if...
|
by: johnp |
last post by:
Hi,
Our Tech department updated users to Office 2003 this week. Now the
input mask in one of the applications is showing up as:
(###) ###-###
The input mask wizard works correctly when I...
|
by: F. Michael Miller |
last post by:
I have a db with Access front end, sql back, linked tables. I need to be
able to change input masks at the table level in code.
Any ideas?
Thanks!
| |
by: AA Arens |
last post by:
When I want the first character of a field to be Uppercased, I need to
make an input mask, like >L< followed by ??????? for example. But this
mask creates ____ in an unfilled field, which I don't...
|
by: msnews.microsoft.com |
last post by:
Hello.
How can I set input mask for TextBox?
Or can I use for mask input some other control?
|
by: ad |
last post by:
I want to limit the input of usr to 0..9 or a..z
How can I do that?
|
by: desklamp |
last post by:
I'm a total Access newbie, please bear with me! Using Win2K/Access 2003.
I'm trying to create a table in which I can store IP addresses and other information. According to Microsoft, there is no...
|
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...
|
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...
| |
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...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |