Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snookduff
Starting Member
2 Posts |
 Posted - 2012-04-03 : 16:34:29
|
| I've searched and searched and can't find a good answer. I'm starting to think it's impossible and have to find another way to do this. That's where I need HELP... :) I'm converting my Access dbase to SQL. Has to run over a WAN now and Access just can't keep up. Well, on a form I had a command button that said Last Name. When it was pressed, a pop up window would come up and user would put last name and it would bring up the form with only that person's record. It doesn't look like SQL Server does this so what is the work around. I don't want to open the form with 200000 records and then have person search for last name. I don't see how user can pass a variable in a UDF either. How can my employees type in a name and have it only bring back that person's record for updating???? Sorry for something so simple, but I am reading the books and learning up on it. Just stumped and can't find an answer. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-03 : 17:17:17
|
| SQL Server is for storing your data.You'll need a front end tool to build a user interface for them to enter it.Some typical ones are ASP.NET, Java, VB.NET, C# and on and on. MS Access is an acceptable front end in many cases. |
 |
|
|
snookduff
Starting Member
2 Posts |
Posted - 2012-04-04 : 11:10:31
|
| Russell, Guess I should of said. I am using an Access Project for my front end, but you can't run a query with the old pop up window where the user can enter information such as last name to pull up a form with just that customer in the form. Unless I'm missing something about passing info to SQL Server. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Pop Up Window