473,322 Members | 1,510 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.

Why does DLookup not work in Windows 7?

I have an mdb that I am running in Vista/Access 2007 and it was working fine. I moved everything to Windows 7 and the database is working well except (so far) some DLookup commands that are coming up with blanks instead of the data (a first and last name) expected. Anyone know why? Thanks.
Nov 1 '10 #1
4 2855
Stewart Ross
2,545 Expert Mod 2GB
Hi Bob. There is no reason I can think of that relates to the move itself. I've not had any issues with Dlookup under A2007 on a Win 7 platform at all.

It may be that a more likely problem is with the Where clause of the DLookup, if there is one.

Could you post the details of your DLookup statement, please?

-Stewart
Nov 2 '10 #2
[code]
=DLookUp("[Lastname]","Client Information","[Client ID]=[Forms]![Amount Form]![Client ID]")+", "+DLookUp("[Firstname]","Client Information","[Client ID]=[Forms]![Amount Form]![Client ID]")
[code]
On an Access form to print the last name then first name of the specific client id...
Thanks.
Nov 2 '10 #3
Megalog
378 Expert 256MB
Try replacing + with &, you're adding the values together instead of appending string values.

Expand|Select|Wrap|Line Numbers
  1. =DLookUp("[Lastname]","Client Information","[Client ID]=[Forms]![Amount Form]![Client ID]") & ", " & DLookUp("[Firstname]","Client Information","[Client ID]=[Forms]![Amount Form]![Client ID]")
Nov 2 '10 #4
Thank you so far. I replaced "+" with "&" and no difference. But I am learning: it is not that it doesn't work--the form is calculating and then the names appear. It just took so long I thought the function didn't work. Therefore, the problem is that, for some reason, it takes significantly longer to process in Win 7 than Vista or XP. Any thoughts as to why? Or how I can fix it or speed it up? Thanks.
Nov 2 '10 #5

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

Similar topics

0
by: Nonoy of Philippines | last post by:
Hello, guys... I'm just starting to develop web applications and I have this problem regarding Session objects At some parts of my application, I open modal dialog window which also opens...
1
by: zEE | last post by:
How to close all the child windows when parent window get closed? in ASP.net application through scripting..
0
by: srsasi | last post by:
Dear All In VC++ 6.0 i wanted to disable the operation "closing the MFC windows when the Esc is pressed". Please provide me with some pieces of codes. Thanks in advance
2
by: nvs | last post by:
Hi All, My Access 2003 Application was created on MS XP and worked perfectly. After installing it on Vista I have noticed that DLookUp function does not work on Forms. It generates Error inside...
3
by: Olegus | last post by:
My Windows application if running on Vista crashed on the next statements( with ----in the front): if (!EventLog.SourceExists(Event.EventLogSource))...
0
by: =?Utf-8?B?bWo=?= | last post by:
Hello, I am planning on developing a windows service in C# using VS 2005 on a Vista 32bit operating system. I am going to be deploying this windows service on a 2003 server in our Production...
5
by: ink | last post by:
Hi all, I cant seem to debug my windows service on my Vista machine. It seems it has something to do with 0 Session. What I would normally do is add the following code to my OnStart() but it...
1
by: Visitbazaar Info | last post by:
-- Internet - Take Advantage of Multiple Windows When Surfing SUMMARY: Stop jumping back and forth between index pages by using several browser windows. Why use one web browser window when...
1
by: =?Utf-8?B?a2l0dHlrYXQ2MA==?= | last post by:
I bought a new computer 3 weeks ago.I am use to using XP and outlook express and never had trouble sending emails,but with this one I cant send a email with a sml attatchment on it,my server keeps...
2
by: secutos | last post by:
Hello everybody. Specifications Operating System: Windows XP and Vista Language: C# .NET Version: 3.5 Problem I am constantly transferring data using HTTP, I need to access a website in...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.