Hi, I've been very frustrated for 2 days trying to make this work. I started with a built-in template "Projects" that came with Access 2007. On the "Employee List" I can click on any cell and bring up the Employee Detail" corresponding to that particular cell. That works fine. I want to be able to open "Employee Detail" when I click on a cell in "Project Detail". I got to the point that "Employee Detail" opens but only to the frst record. PLEASE help!
Here’s the code for double clicking on any cell in “employee list”. This works!
Function macro5()
DoCmd.OpenForm "Employee Details", acNormal, "", "[ID]=" & .ID, , acDialog
TempVars.Add "CurrentID" , "[ID]"
DoCmd.Requery ""
DoCmd.SearchFor Record , "", acFirst, "[ID]=" & TempVars!Curren tID
TempVars.Remove "CurrentID"
Exit Function
Here is the VBA Code for double clicking on the “Principal in Charge”. I added the message box to see which record is shown.
Dim curr_rec As String
Private Sub Principal_in_Ch arge_DblClick(C ancel As Integer)
curr_rec = [Principal in charge]
DoCmd.OpenForm FormName:="empl oyee details"
Forms![employee details].SetFocus
DoCmd.GoToRecor d , , acGoTo, curr_rec
MsgBox (curr_rec)
End Sub
0  1669  Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: PaulR |
last post by:
We have seen this a lot, but have just experienced the opposite to what
we have always seen previously, so this has prompted me to ask a high
level - why do we get this behaviour?
If we re-write queries in the following pattern (simplified)
select ...
from table1 t1 inner join table2 t2 on (t1.pk = t2.fk)
inner join table3 t3 on (t3.fk = t2.pk)
|
by: Mike Labosh |
last post by:
Code is easy. These are two OOP design issues that I am chewing on. Coming
from classic VB, I'm not great at OO design. I prefer to write mile long
spaghetti methods in a Temp module, and then refactor them.
Issue # 1
I have an Employee class that represents the state of an Employee record,
and an EmployeeListItem class that represents Employee stuff to be loaded
into a ListBox, e.g. EmployeeID, FirstName, LastName, ReadOnly...
|
by: Marco Castro |
last post by:
I tried to google for information of what the output of the "LIST" command
means but couldn't find any articles that tell me exactly what every
character means. I can figure out most of it, its only the first 12
characters where you see stuff like +rwx and so on that I am having trouble
with. Does anyone know of a website that explains in detail what all of the
values mean? Thanks.
|
by: tinman |
last post by:
Hi....
Would appreciate some advice on how to achieve the following in an OOP
manner:
Supposed, I have the following object model:
Employee
|
| - - Projects
|
by: mabond |
last post by:
Hi all
This question is one of "theory" rather than a search for the specifics of a
solution. I need some pointers as to how to proceed with my project.
Here goes.
My application allows the user to select from menu options. Some of the
menus allow the user, via an options form, to select parameters for the
display of reports. Those parameters will include things like the date range,
| | |
by: Rico |
last post by:
Hello,
Is there any way to get rid of or replacing the error message that pops up
when you enter a combo box item that isn't in the list? I've tried using
the Not In List event, but there is still an Access error that is raised.
Any ideas?
Thanks!
Rick
|
by: Bob |
last post by:
I have an Access application where I need to automatically forward
emails to a group of 12 salespeople as soon as they arrive. The first
email needs to go to the first salesperson on the list, the second
email to the second salesperson on the list until I get to the end of
the list, then start over. I also need to be able to exclude
salespeople on their day off. The email portion of the application
will be using a rule in Outlook 2003...
|
by: WaterWalk |
last post by:
I've just read an article "Building Robust System" by Gerald Jay
Sussman. The article is here:
http://swiss.csail.mit.edu/classes/symbolic/spring07/readings/robust-systems.pdf
In it there is a footprint which says:
"Indeed, one often hears arguments against building exibility into an
engineered sys-
tem. For example, in the philosophy of the computer language Python it
is claimed:
\There should be one|and preferably only one|obvious...
|
by: Stefano Tonello |
last post by:
Hi all,
I need to call windows' "open with" dialog from my C# windows form
application. After the user selects application, control must return to
me (I have to launch directly the process).
I found this solution:
http://www.codeproject.com/KB/shell/openwith.aspx
but it's not good for me since it will execute the process directly.
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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 we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
