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

Run-Time error -2147352567

MGrowneyARSI
I am Trying to run a few dlookups on open of my form and as well as after update of my lookup. anyway when I tryed to put the dlookups in the on open event of the form I got the run time "You can't assign a value to this object" on the first dlookup which is needed for the last three to run. so i figured that I could try puting them in the on load event however they did not return any values when I tried to run a msgbox i got an error "you can't have a null value" or somthing allong those lines so I was wondering if someone could point me in the right direction here i know it's somthing stupid simple. Thanks in advance.

and here is the code

Me.Employee_ID = DLookup("[Employee_ID]", "Appraisal", "[App_ID]" = "[Forms]![ThreeSity_Appraisal]![App_ID]")
Me.User_Name = DLookup("[User_Name]", "Appraisal", "[App_ID]" = "[Forms]![ThreeSity_Appraisal]![App_ID]")
Me.Employee_Type = DLookup("[Employee_Type]", "Employee", "[Employee_ID]" = "[Forms]![ThreeSity_Appraisal]![Employee_ID]")
Me.Job_Title = DLookup("[Job_Title]", "Employee", "[Employee_ID]" = "[Forms]![ThreeSity_Appraisal]![Employee_ID]")
Me.Combo93 = DLookup("[Full_Name]", "[Full_Name]", "[Employee_ID] =" & "[Forms]![ThreeSixty_Appraisal]![Employee_ID]")
Aug 17 '07 #1
2 4404
Well I found a work around that should do it thank anyway
Aug 17 '07 #2
sorry i thought i was in the forums section
Aug 17 '07 #3

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

Similar topics

5
by: Bob Bamberg | last post by:
Hello All, I have been trying without luck to get some information on debugging the Runtime Error R6025 - Pure Virtual Function Call. I am working in C++ and have only one class that is derived...
0
by: Kamal Dhingra | last post by:
Hi Guys, I am developing an asp.net application .In error handling , I have 2 web.congif files ,one is in Web(which is the virtual directory) ,other i have created in a folder in Web/Admin. The...
7
by: wmkew | last post by:
Hello everyone I'm encountering a R6002 Runtime error and several bugs when trying to generate a simple Managed C++ application with .NET 2003. The main problem seems to arise from linking with...
7
by: yuanlinjiang | last post by:
I am working on converting a win32 console application from VC6 to VC7. My version is Microsoft Development Environment 2003 version 7.1.3088. The code works fine on VC6. it is a console...
2
by: Aleksandar | last post by:
Hi, I need to convert set of Java classes exported from IBM Modeling environment to C# for implementation. When I invoke JCLA conversion from File->Open->Convert in Visual Studio 2005 it starts...
8
by: g_man | last post by:
I am trying trap Runtime error 3022 (duplicates) in the click event of a command button that closes the form. I have code in the Form_Error event that does a good job of providing a more meaningful...
7
by: John | last post by:
Hi Everyone, I'm having this extremely annoying problem with Internet Explorer 6, giving me an error message saying "unknown runtime error" whenever I try to alter the contents of a <divelement...
1
by: HotKgon | last post by:
When I try and run a code, I get: Run-time Error '-2147352567 (80020009)': The data has been changed. My code is: Dim rsSF12 As DAO.Recordset Dim SF12Score As Double
3
by: Jim Armstrong | last post by:
Hello all - This is driving me crazy. I have a table called tblClients - very simple, has the following fields: taxID (PK) ClientName SalesName The main form of my application allows a...
2
by: blogman | last post by:
I am getting a Visual studio 2008 IDE application R6034 runtime error. This means that the IDE application is raising the error not the application I am building. This means that Microsoft did not...
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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
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...

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.