hcs consulting group.
we make complex systems simple

typing work from home for students

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)
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

'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 like string$() 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

Service Unavailable

Service Unavailable

HTTP Error 503. The service is unavailable.