473,322 Members | 1,232 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,322 software developers and data experts.

Strings Using Concatenated Fields

I am trying to prevent employees from referencing their own loans.

Here's the VBA Code:

Dim strApplicant As String
strApplicant = "dbo_snapshot_loan_app.applcnt_first_nm & "" &
dbo_snapshot_loan_app.applcnt_last_nm"

If (strApplicant = CurrentUser()) Then
MsgBox "You cannot view your own loan.", vbCancel
End If

Not working -- what am I doing wrong?

Thanks!

amy
===

May 24 '06 #1
3 1194
Why not just send it as a RTF file. Use the Access send object command
and do something like this

DoCmd.SendObject acSendreport, "eportname", acFormatrtf, _
"email addresses", , , "subject name", , False

May 24 '06 #2
am*******@verizon.net wrote in
news:11**********************@38g2000cwa.googlegro ups.com:
I am trying to prevent employees from referencing their own
loans.

Here's the VBA Code:

Dim strApplicant As String
strApplicant = "dbo_snapshot_loan_app.applcnt_first_nm & "" &
dbo_snapshot_loan_app.applcnt_last_nm"
'adding these two lines will tell you, just open the immediate
window {Ctrl-G}:and compare the two values.
Debug.Print strApplicant
debug.Print CurrentUser()
If (strApplicant = CurrentUser()) Then
MsgBox "You cannot view your own loan.", vbCancel
End If

Not working -- what am I doing wrong?

Thanks!

amy
===


--
Bob Quintal

PA is y I've altered my email address.
May 24 '06 #3
I probably didn't explain myself too well here.

What I am getting returned from a query is a LIST of records, which may
or may not contain an employee's loan. How do I insure that the ONE
RECORD that might match the Employee's Name is Not Visible?

Thanks!

Amy
===

May 25 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: M Wells | last post by:
Hi All, I have what seems to me to be a difficult query request for a database I've inherited. I have a table that has a varchar(2000) column that is used to store system and user messages...
2
by: B Love | last post by:
Hello Group, I have 2 text fields that I would like to concatenate for use in a table. One field is an ordinary text box. The other is a simple combo box which I use to select one of about ten...
9
by: Dr. StrangeLove | last post by:
Greetings, Let say we want to split column 'list' in table lists into separate rows using the comma as the delimiter. Table lists id list 1 aa,bbb,c 2 e,f,gggg,hh 3 ii,kk 4 m
2
by: sparks | last post by:
ok I was trying to do something real simple I thought Me.Clinic.DefaultValue = Me.Clinic.Value I got error either ! or . misused or not found...something like that I thought ok how can you not...
1
by: cornedbeef007-groups | last post by:
I have built a database for dog pedigrees. I want to be able to display the siblings for a dog on it's pedigree. I am able to find the names in my database, and at present return them from a UDF...
4
by: nass | last post by:
hello everyone, i have a bit of problem reading char * strings from a buffer (a shared memory, pointed to by 'file_memory'). basically i have a structure in memory 'ShMem' that can be accessed by...
14
by: avanti | last post by:
Hi, I need to generate random alphanumeric password strings for the users in my application using Javascript. Are there any links that will have pointers on the same? Thanks, Avanti
0
by: tokuzumi | last post by:
I have a gridview where I am trying to validate two concatenated fields with two other concatenated fields. The fields I concatenate build a date/time string. Each set of fields has a dropdown,...
8
by: banderson | last post by:
Hello, I have a combo box in which I want to display multiple fields by concatenating the fields together. If one of those concatenated fields is Null, then the combo box does not show anything. To...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.