Any character / delimiter Access 97 / SQL 7

Problem: Currently using double-quotes as SQL field delimiters. New requirement demands that essentially any ASCII character be entered into field in SQL Server table. Existing form has problems with an entry such as [4"5fh!+] because the double-quote in the string is interpreted as a delimiter. Solution: Seeking MS Access 97 form for handling data entry of any character string into SQL Server 7 database. Examples of entries that must work include: - Joe's "Pizza Emporium" - +=348&6 - "Well'2987# Notes: I can modify the code for my app once I receive it, and therefore request that the problem be addressed by coding for a fictional example, as follows: 1) Access 97 Form called frmCorn and frmCornEntry attached to table tblCorn in SQL Server 7 database called Farm. 2) frmCorn displays all entries (* from tblCorn). 3) frmCornEntry provides for data entry and editing of entries in tblCorn. 4) SQL fields: - CornID int Identity PK - Corntxt1 varchar (15) - must handle any character - Corntxt2 varchar (15) - must not allow null values - CornNotes 5) frmCornEntry must provide error handling/message when error occurs - for both string probs (Corntxt1) and null (Corntxt2).

## Deliverables

Access 97 database file (mdb) with forms and access to code in design view. Should be attached by default to table/database referenced by name listed in description. I will handle actual SQL table setup, etc.

## Platform

Any of the following: WIndows 95/98/NT/2000

Compétences : Ingénierie, Microsoft Access, MySQL, PHP, Architecture Logicielle, Tests de Logiciels, SQL

en voir plus : the string problem, string problems, sql data entry form, php data entry form example, ms access form data entry, ms access data entry forms, ms access data entry form examples, ms access data entry form, engineering forms, data entry form design examples, app character design, access database data entry form, ms access sql, problems of data entry, s joe, pizza app, notes editing, name farm, ms sql server setup, data entry SQL

Concernant l'employeur :
( 316 commentaires ) United States

Nº du projet : #2921738

Décerné à:


See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 14 jours
(215 Commentaires)

2 freelance font une offre moyenne de $34 pour ce travail


See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(153 Commentaires)