|hcs consulting group.|
|we make complex systems simple|
recently a question was asked on the msdn access developer forum how to create an access web form that allows searching of people's names when the name is miss-spelled. by the way, the msdn forum is a great community place to ask questions and get help using access. you can find this access forum on the microsoft developer network here:
while for many, the idea of an intelligent search form in access that allows fuzzy name matching sounds like real magic. to us folks who been around a long time we instantly recognize this as a soundex type of search.
while we are not going to build the next great search engine in access, it is rather easy to build a search based on names that sound the same. the end result is a search form that behaves much like using any modern search engine on the web where exact name spelling matches are not required for the search.
the solution for this magic centers around using code that converts a person's name into a soundex code. we then save this soundex code into another column in the table. it then becomes a simple matter to search names on this soundex column. search results will thus match on how names sound, not how names are spelled.
there are likely more variations of soundex code to be found on the web then are flavors of ice cream. you are thus much free to go out and choose one of the many examples of soundex coding systems. it goes without saying that the classic soundex routines have been much changed and improved over the years. however, the basic soundex code will suffice for our needs and is what i used for this example.
prior to access 2010, to maintain such a list of soundex codes we would have to use after update events in form's code. however, if you then write some vba code, or created additional forms that edits that data, then again additional code would be required in the application to again update and maintain those soundex search values.
with the arrival of database triggers in access 2010, all forms and code will benefit from one copy of our centralized bit of code as a stored table procedure.
part time weekend accounting jobsChapter 4: Challenges of Online Part-Time Job Work at Home Promotiononline typing jobs without investment
the beauty of one centralized copy of our code really makes this task oh so easy. any vba dao update code, sql update (action) queries, editing data with a form, even editing data with a web form will in all cases trigger our one copy of table code to run.
an additional benefit of centralized code is a separation of user interface you build from that of the application code and business rules. you are well free to build client forms, web forms, or even write vba dao update code without a worry. i find this a near magical development experience as now all you have to do is just have fun building and painting your forms. in other words separation of these tasks makes the development process more enjoyable for me. in fact since you dealing with just code or just creating a user interface, then i find this reduces my mental workload when developing software. it is this reduced mental workload that likely explains why i find developing applications this way more enjoyable.
the first task here is to find some soundex code. i just happen to have some soundex code i wrote in access vba code more than 10 years ago.
part time weekend remote jobsPart 2: How to find data entry jobs at home without investment?at home customer service jobs part time
there not really a whole lot of code here sans the comments. i am pasting this older code as is. you can much skim and scroll over this code quickly for now.
function strsoundex(strsource as variant) as variant ' ' produces a code based on the "soundex" method ' ' ' parms: ' strsource passed string ' ' ' written by albert d. kallal ' ' ' see page 392 of knuths' book 'sorting and searching', volume 3 of 'the ' art of computer programming", addison/wesley publisher. ' ' method used: ' 1. change all lowercase to uppercase ' 2. retain first letter of input string (must be alpha) ' 3. ignore the letters a, e, h, i, o, u, w, y, and any other ' non-alphabetic characters: ' 4. subsitiute the following ' 1 = b f p v ' 2 = c g j k q s x z ' 3 = d t ' 4 = l ' 5 = m n ' 6 = r ' 5. ignore identical letters next to each other ' 6. add trailing zeros if the length is less than "max.soundlen" ' characters (in this example it is 4 numeric + 1 alpha = 5). ' stop when the string reaches max.soundlen (ie:truncate the rest) ' 'start:-------------------------------------------------------------------- ' if isnull(strsource) = true then strsoundex = null exit function end if const maxsoundlen as integer = 4 ' max length of resulting soundex code dim transtable as string dim offset as integer ' offset for easy table translates dim sourcelen as integer dim charptr as integer dim testchar as string dim lastchar as string dim intlookup as integer dim strdigit as string ' conversion table ' [abcdefghijklmnopqrstuvwxyz] transtable = "01230120022455012623010202" offset = asc("a") - 1 ' offset for easy table translates ' ' note: for "aehiouwy" are ignored by translating to zero ' strsource = ucase(strsource) ' convert string to uppercase sourcelen = len(strsource) ' find/set string length to process strsoundex = left$(strsource, 1) ' get/set first character lastchar = strsoundex charptr = 2 ' we skiped the first char above do while (charptr <= sourcelen) and (len(strsoundex) < maxsoundlen) ' testchar = mid$(strsource, charptr, 1) ' get 1 char to test ' ' if different than last character, then process ' if testchar <> lastchar then ' intlookup = asc(testchar) - offset if (intlookup > 0) and (intlookup <= 26) then strdigit = mid$(transtable, intlookup, 1) ' table translate to soundex if strdigit <> "0" then strsoundex = strsoundex & strdigit lastchar = testchar end if end if end if ' charptr = charptr + 1 ' move on to next character loop 'strsoundex = left(strsoundex & "00000", maxsoundlen) ' pad with trailing zeros (5 chars) end function
while access web services allows a mix of client vba and web macro based forms, the web forms can't use vba code. we thus will need to re-write the above vba code as access macro code. i on purpose posted the above vba code since i want readers to get a feel for how i went about converting the above code to run in the access web environment.
a quick look at the above code shows a lot of classic vba functions. i see ucase$(), string$() (create string of repeating characters) left$(), mid$(). i even see asc$() being used. golly, asc$ ?, that is an function i not used in many years! the asc$() converts a single character into a ascii number. for example, the letter a will return the number 65.
amazon part time jobs for studentsAnother option for working from home without any investment is by becoming a transcriptionist. Transcriptionists are responsible for transcribing audio or video recordings into written documents. This can include anything from interviews and lectures to legal proceedings and medical reports. Websites like TranscribeMe and GoTranscript offer transcription jobs that you can do from home. While some websites may require you to take a transcription test before you start working, there are many opportunities for beginners.part time data entry jobs home
part time work from home for housewivesTranscriptioninternet part time jobs from home
in fact, just looking at the above soundex code harks me back to the old days of typing in basic code. i have fond memories using these basic functions (pun intended) when i was young. if any of you remember typing in basic code from some byte magazine before the internet age, you remember well what i am talking about. at least now in this internet age, i provide a download at the end of this article and save you the trouble of having to type in this code.
i well remember the pleasure of discovering functions like mid$() or asc$() back in those old days. i had no idea that so many years later i would be using that same knowledge of these functions to create code that will run on a web site! yet, this is exactly what access web services allows me to do.
part time remote jobs that pay wellOnline surveys are a simple way to make money online that doesn't require any investment in promotion. As an online survey taker, you'll be responsible for taking surveys for companies and providing feedback. You can find online survey jobs on platforms like Swagbucks, Survey Junkie, and Toluna.online customer service jobs part time
full time work from homeOnline Store Ownerfull time remote work
fortunately, looking at the access data macro function set, i see every one of the above classic vba functions used in that soundex code is available for access web services. this means i can near read and translate the vba code line for line into macro code. assuming you have duel monitor nice and handy, i going to type and convert this code right into the editor on the fly. ok, here i go...
full time stay at home jobsFlexibility: Remote work allows individuals to work from anywhere, which can be especially beneficial for students who need to balance their work schedule with their school work and other commitments.best part time jobs near me
online part time jobs for students in mobile without investmentSection 1: Types of Online Part-Time Jobsfull time online jobs from home
opps! there is a feature missing i need here! the data macro is missing a for/next loop. ok, this is where we get a bit creative. by creative this is a fancy term we professional developers use when we sugar coat what we technically call a kluge.
part time jobs work from home no experienceIf you enjoy customer service, you can work as a virtual call center agent. Many companies hire remote call center agents to handle customer service inquiries over the phone. You can find virtual call center jobs on websites like Liveops, Arise, and Working Solutions. To become a virtual call center agent, you need to have good communication skills, a quiet workspace, and a reliable internet connection.online part time jobs no experience
amazon part timePart 3: How to Get Started with Online Part-Time Job Work at Home Promotionfull time remote
for this looping requirement i substituted a for/each record loop. this loop is based on a tblmonths table with 12 records. this is a month picker table i often use in applications for combo boxes to pick month as text, but return 1-12 as a number.
i also just happen to need a for/next loop that runs for about the first 12 characters of a person's name for conversion into soundex code. so, i can well say this creative table loop trick (kluge) fits well within the current design i have.
easy remote part time jobsAs an online bookkeeper, you will be responsible for maintaining financial records for various clients. You can find online bookkeeping jobs on various online job boards and websites.amazon hiring part time
the resulting macro code much reads very much like the vba code on a line for line basis. i was able to re-type each line of vba into macro code by eye sight on the fly. the comments were cut + pasted. in less than 20 minutes, i thus had:
this macro code is saved as what we call a named table macro. in access web development you can often think of named table macros as your replacements for code modules. this code just sits there and will not run unless called from a form, a web form or a table trigger. if you are new to access web development, then you find that named data macros are where a large portion of your common web application code will reside.
online part time jobs from homeVirtual assistants (VA) provide administrative support to clients remotely. The job duties of a VA can include data entry, scheduling appointments, email management, social media management, and customer service. You can find VA jobs on freelance platforms or by reaching out to business owners who may need your services.temporary summer jobs
indeed part time evening jobsApart from technical skills, there are some soft skills required for data entry jobs. Good communication skills, time management skills, and teamwork are some of the essential soft skills required for data entry jobs. Attention to detail, problem-solving skills, and the ability to work under pressure are also important skills for data entry jobs.simple work from home part time jobs
with our soundex routine done, the next step is to create one of those neat-o table triggers that calls the above code to convert the person's first name into soundex during data entry.
here is the table trigger code in the table after update event. this code calls the above soundex code and the returned soundex value is saved into a new column in the customers table.
part time remote jobs las vegasOffer referral bonusesamazon driver part time
What job is best for onlineChapter 1: What is Online Part-Time Job Work at Home Promotion?amazon jobs near me part time
online part time jobs work from home for students- You can have more balance and happiness in your life. Working from home part-time can help you achieve a better balance between your work and personal life. You can have more time and energy for your family, friends, hobbies, and passions. You can also avoid the stress and distractions of a traditional workplace, such as office politics, noise, interruptions, and conflicts. You can create a comfortable and personalized work environment that suits your style and preferences. Working from home part-time can also give you more freedom and autonomy to pursue your goals and dreams.part time work for students
full time online jobs no experienceOpportunities: There are countless online part-time jobs available, so you can find one that fits your skills and interests. Whether you�re a writer, graphic designer, or customer service expert, there�s a job out there for you.online remote jobs part time
remote jobs from home full timeChapter 2: Types of Online Part-Time Job Work at Home Promotion Jobspart time it jobs remote
part time jobs from home no experienceOnline Graphic Designonline typing jobs from home
no experience data entry jobs from home part timeVirtual assistance is another popular work-at-home part-time job that does not require any investment. In this chapter, we will discuss how to become a successful virtual assistant and promote your services. We will also provide tips on how to find clients and negotiate rates.weekend part time
part time writing jobs remoteIf you have design skills, then becoming a graphic designer could be an excellent part-time job. You can design logos, brochures, social media graphics, and other visual content for clients. You can find work on websites such as 99designs, Fiverr, and Freelancer. To be successful, you will need to have excellent design skills, be able to work with clients to understand their needs, and be able to meet deadlines.good part time remote jobs
i also cut + pasted the above code to the table's on-insert event. eagle eyes will not the above log event, and that just some debugging code i had not removed as of yet.
simple part time job at homeData Entry: As a data entry specialist, you can enter data into databases, spreadsheets, and other applications. You can find data entry jobs on websites such as Indeed, Glassdoor, and LinkedIn.online part time jobs data entry
ok, that really quite much all we need here.
Which type of job is best for a housewifeAnother popular part-time job for students is tutoring. If you excel in a particular subject, you can offer your services as a tutor. You can do this independently, or you can sign up with a tutoring company like Tutor.com or Chegg Tutors. Tutoring is not only a great way to earn money, but it can also help you solidify your own understanding of the subject.amazon part time jobs
next, i simply used the wizard to create a multiple items form (continues form). drop in an un-bound text box for searching + a search button, and we get:drop in an un-bound text box for searching + a search button, and we get:
work at home for housewifeSet up a comfortable workspace: Make sure your workspace is comfortable and free from distractionsonline part time jobs work home without investment
note in above, you can see the name i typed in, and the results after hitting the search button. the results matche similar sounding names. so, cindy, and cyndi, cynda were all matched in this search here.
best full time work from home jobsWeb developmentfull time work from home jobs with benefits
data encoder part time job home basedFor those interested in education, there may be part-time jobs available as a tutor or teaching assistant at local schools or learning centers. These jobs can provide valuable experience in education, and may be especially appealing to students pursuing a degree in teaching.What can I do to work from home on my own time
the code behind the search button on the above web form is just this little bit:
we take the value of the un-bound search box and call the soundex routine. we then set a filter based on the returned value from the soundex routine. note that both the table trigger and the web form call the same soundex routine.
using functions likestring$() and asc$() have been real staples of my computing career over so many years. in fact, i used these functions in classic basic, foxpro, pascal and on more systems then i can remember. i can now add access web data macros to my long list of platforms where these little function friends have followed me over so many years.
while access web services entails learning many new concepts, the bulk of this solution was based on leveraging past access skills and code.
simply, easy, and fun this solution was to build. and, this solution was a real break from those massive frame works that so much of the computing landscape requites to build a simple hello world program.
seeing such wonderful results run on the web for so little effort made me feel young and induced that long forgotten sensation and love of computers i not felt since typing in my first few lines of basic code into an 8bit computer.
this was really fun, and i hope you enjoy this code sample as much as i enjoyed creating it!
internet based part time jobsAs an AI language model, I can certainly provide you with some ideas for online part-time jobs that don't require any investment in publicity and promotion. However, I must clarify that the length of the response will not be 10,000 words, as it is not necessary to provide that much information.easy jobs to do from home part time
you can download the sample application here - access soundex example
this sample access 2010 web database runs fine in the access desktop client. you can even import the sample table into a non web database, and the soundex macro code will copy along for the ride. i also included a non web based edition of the search form. so this soundex example will work equally fine in client (non web) access applications.
easy remote part time jobsGetting started with online part-time job work at home promotion can be a bit daunting, but with the right approach, you can be successful. Here are some tips to help you get started:genuine data entry jobs without investment
part time typing jobs onlineBenefits of Working for Amazon:evening data entry jobs
work from home jobs no experience part timeManaging your time is essential when working from home, and in this chapter, we'll explore the best time management techniques to help you stay focused and productive. We'll also cover the importance of taking breaks and maintaining a healthy work-life balance.part time bookkeeper remote
part time weekend workSocial Media Manager:typing work from home