ExamGuru IT/.Net Guru : Microsoft Access Help on microsoft.public.dotnet.distributed

.NETGURU

Microsoft Access Help

Messages

Related Types

This message was discovered on microsoft.public.dotnet.distributed_apps.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Post a new message to this list...

Brian Leung via .Net Guru (VIP)

(Type your message here)
Hi,
I'm building a database for one of my projects. Its a pretty simple database, with an Entry Form for people to enter data about their visit. Every time someone comes to visit, they record the visit. This data gets stored in a table, and has attributes like Case Number, Visit Number, Case Description, Case Person, Business Unit, and just other attributes about the person that is visiting. I was wondering if there was an Access function, that can look up a Case Number, and give all the details about the person automatically, without having to type in all the information again if its the person's second visit.

So if someone put in a case number in the CaseNumber textbox on the Entry form that was already recorded, it would automatically look up the details of that case number, and input all the data into the appropriate control boxes on the Entry form. This would save a lot of time for the person entering in all the data.

so I was looking at all the macros available and all the functions, but I can't seem to get it.

Can anyone help me?

Thanks!

--------------------------------
From: Brian Leung

-----------------------
Posted by a user from .Net Guru (http://www.dot-net-guru.com/)

<Id>+CRccwokh0GOK0iT8j5WzQ==</Id>

Reply to this message...

James Ankrom

Here's a good start... albeit not exactly the answer. Following this, try
posting to a microsoft access newsgroup for better answers.

http://support.microsoft.com/default.aspx?scid=kb;en-us;209537

"Brian Leung via .Net Guru" <Click here to reveal e-mail address> wrote in message
news:%Click here to reveal e-mail address...
(Type your message here)
Hi,
I'm building a database for one of my projects. Its a pretty simple
database, with an Entry Form for people to enter data about their visit.
Every time someone comes to visit, they record the visit. This data gets
stored in a table, and has attributes like Case Number, Visit Number, Case
Description, Case Person, Business Unit, and just other attributes about the
person that is visiting. I was wondering if there was an Access function,
that can look up a Case Number, and give all the details about the person
automatically, without having to type in all the information again if its
the person's second visit.

So if someone put in a case number in the CaseNumber textbox on the Entry
form that was already recorded, it would automatically look up the details
of that case number, and input all the data into the appropriate control
boxes on the Entry form. This would save a lot of time for the person
entering in all the data.

so I was looking at all the macros available and all the functions, but I
can't seem to get it.

Can anyone help me?

Thanks!

--------------------------------
From: Brian Leung

-----------------------
Posted by a user from .Net Guru (http://www.dot-net-guru.com/)

<Id>+CRccwokh0GOK0iT8j5WzQ==</Id>

Reply to this message...

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification