Käynnissä

SQL Search utilties and display results

I need a small application (prefer as [url removed, login to view]) to search database and display documents, as indicated by the record. Then, it should display the matching documents.

Here is the high level spec.

There are 4 fields in the file:

1. Account Number (12345;55555;34248)

2. Customer Number (ABC123;AAA999)

3. Policy numbers (E807026;E807027)

4. DocumentPath (C:\My Document\Temp\[url removed, login to view])

The application should search for matching account number, customer number, policy number. It should allow for ((?) fix character wildcard search, (*) full wildcard & exact match).

• Fix Character allows user to enter a question mark (?) for any character that he/she isn’t sure about

• Full WildCard Search allows users to do a full wild card search, regardless of the number of missing character.

• Exact match allows users to search by exact match. Note that the filed contain multi-value, separated by semi-colon. So the search will be a wildcard search (value start/end with optional semi-colon “;” ignoring any blanks).

After the search completes, users get a list of matching search.

AccountNumber CustomerNumber PolicyNumber DateTimeStamp DocPath

12345;55555 ABC12345 E807026 05/07/2009 16:14 C:\[url removed, login to view]

12346 ZZZ999;A3;B4 E807027 06/07/2009 16:14 C:\[url removed, login to view]

The users click on the record, then the application display documents, as specified in the Document_Path field. The document is in PDF format. Database will be in Microsoft-Access.

If there is no match, the user gets the message. There should be a refresh button to allow user to enter new search criteria.

I will send file and sample record detail to bid winner. The bidding price includes the source code, which will become my property after the completion of the project.

Taidot: .NET, C-ohjelmointi, Java, SQL, Visual Basic

Näytä lisää: sql price, sql code pdf, search here, mark fields, high match, gets source code, displaying sql results, sql search java, sql microsoft access, on sql, microsoft project price, microsoft access sql, a3, wild code, sql microsoft, sql code, sql c, sql access, search pdf, search match, search file, pdf price list, display, access sql, access database java

About the Employer:
( 14 reviews ) Markham, Canada

Projektin tunnus: #464495

Myönnetty käyttäjälle:

guoxinliu917

Hello, I can do it for you. Thanks.

50 $ USD 2 päivässä
(90 arvostelua)
7.1

40 freelanceria on tarjonnut keskimäärin 128 $ tähän työhön

cliver

Hello, Please look at the PMB. Regards, Sergey

200 $ USD 1 päivässä
(26 arvostelua)
6.6
interpb

Hi friend Please check your PMB Thanks

200 $ USD 6 päivässä
(54 arvostelua)
6.1
sikandermandal

Please See PMB.

120 $ USD 1 päivässä
(28 arvostelua)
5.7
wsh2

1. How is the document database being built? And shouldn't this tool be a part of that process? 2. MsAccess provides some excellent, 'user friendly' search and filtering tools, have you considered using them? 3 Lisää

249.95 $ USD 5 päivässä
(23 arvostelua)
5.3
nmppatel

I am an IT professional with 10 yrs experience. I have very good experience with [url removed, login to view], Ms-Access. I will provide quick & professional service.

150 $ USD 2 päivässä
(31 arvostelua)
5.2
EspressoLogic

Please check PMB for details.

90 $ USD 5 päivässä
(14 arvostelua)
5.2
northwolves

I have best skills in this field,looking forward to working with you.

120 $ USD 3 päivässä
(39 arvostelua)
4.9
webwings08

please check pm...

200 $ USD 5 päivässä
(7 arvostelua)
4.6
outsourcedev

Check PM for more info..

170 $ USD 2 päivässä
(9 arvostelua)
4.7
snowwolf

check your pm for details

170 $ USD 2 päivässä
(9 arvostelua)
4.1
nordiym

I use .Net Framework 3.5.

200 $ USD 3 päivässä
(9 arvostelua)
4.0
invegood

Hello, I'm ready to help you. Best regards, Eugene

100 $ USD 2 päivässä
(2 arvostelua)
4.0
refractocd

Can be done using VB.NET. Please refer to PM

150 $ USD 6 päivässä
(13 arvostelua)
4.0
akshayfastin

Please check my PM for details.

200 $ USD 5 päivässä
(5 arvostelua)
3.8
johnsupakin

Hi, I can provide this simple solution within 5 (3 to 5 days) days. Good Experience in VB and SQL (VB/[url removed, login to view] and MS Access/MS SQL Server) I'll provide a very good User Interface for the search options and display op Lisää

225 $ USD 5 päivässä
(3 arvostelua)
3.6
skujuira

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

190 $ USD 5 päivässä
(5 arvostelua)
3.5
alm43

I can offer you a Delphi application. Your wishes are standard enough.

30 $ USD 1 päivässä
(14 arvostelua)
3.1
ProExpert

Hi, Please check PMB

30 $ USD 5 päivässä
(3 arvostelua)
2.2
sikandarnayyab

previously i have worked on such tasks, like auto search from google. etc

150 $ USD 7 päivässä
(1 arvostelu)
2.0
TipofIceberg

Please see your pmb. Regards.

80 $ USD 2 päivässä
(1 arvostelu)
1.0