Potential Applicants

[C#''er]

I have created a form to log and schedule potential applicants for tests.
There will eventually be hundreds of testing locations and each applicant
will be placed in the location closest to them based on their zip (or rather,
that is what I would like to happen). I don't even know where to start in
Access. Can someone help. Im a novice in VB but pretty experienced in C#.

 

[Tom van Stiphout]

On Thu, 8 Jan 2009 06:26:01 -0800, C#''er

You have some decisions to make. Why not create a webapp or winforms
app so you can use your familiar programming environment? The database
can be Access.

Closest location calculation is pretty easy. The typical approach is
that you know longitude and lattitude of all locations (Google Earth
can help with that), long and latt of all zipcodes (a zipcode database
can help with that) and then use some trigonometry to find the
shortest distance as a crow flies.

-Tom.
Microsoft Access MVP

 

[C#''er]

Is there a way I could create a winform using C# in Access? If so, how would
I do that? Im bound by logistics to using access.

 

[Douglas J. Steele]

Access only supports VBA.

When you say you're "bound by logistics to using access", what do you really
mean by that? There's a difference between Access (the development
environment in which the forms, reports, macros and modules exist) and Jet
(the database engine). You can store your data in an MDB (or ACCDB) file and
get at it using many different platforms, including C#.