Letter By Letter Search Through A Table

Aug 21, 2005

ok here is what i want.. imagine a search box, just an empty text box that allows the user to type things into it...

there will be a simple table from the database behind it, here is the typical structure of a record

<Country>Poland
<Price1>60
<Price2>85
<Price3>95

in this table there will be say a 1000 of these records...
my user is going to have to quickly search through these records while on the phone to a customer, and quote one of the relevant prices associated with that country

what i would like is this most convenient system..
as the user types in the letter 'P' just below all the records with countries that begin with 'P' are displayed (with a scroll down arrow if needed)..as well as the 3 relevant prices with that record

if they then type an 'O' into the box (which will now hold 'Po') all the records with countries beginin with 'Po' will be displayed (eg Poland)

if they delete the 'o'. once again the displayed records below the box will return to just the countries begginin with 'p'

all that is needed is for the records to be displayed, thats it.. but the adding and deleting of the letters within the text search box will need to instantly manipulate this list..

i have posted on other forums, and have been told this can be acheived in access, is it hard?

View Replies


ADVERTISEMENT

Storing The First Letter Of First Name, First Letter Of Last Name And Data Of Birth

Feb 19, 2006

Hi,

I'm designing a database in which the primary key is a combination of the first letter of first name, the first letter of last name and the date of birth.

How can I do that?

Regards,
CS

View 8 Replies View Related

Search Result Based On The First Letter Of A Field

Sep 29, 2006

Hello,

I need to create a query that will seach through a column and only return a result with product codes starting with A.

An example of a product code is AA0000034567.... however there is no realy consistancy. Some start with the AA and some don't. Some have 5 zeros before the numbers start others may only have 1, 2, 3, or 4 zeros before the number.... There are approx 76,000 product codes in total.

My end goal is to create a query to find all the records that have a product code starting with A so that I can eventually delete the AA00000 portion of the code and strip the number back to the point where the 34567 starts.

I figured that by separating out the product codes that start with AA would be a good start.

If any one has any suggestions please let me know.

Peter Vav

View 4 Replies View Related

Queries :: Search A Field For A Lowercase Letter

Jul 1, 2013

Is it possible to search a field for a Lowercase letter.All data should be capital, but occasionally a user may ann a record in lowercase, and was looking for a query to pull back all records in lowercase

View 2 Replies View Related

Forms :: Search Form Creating Error When Type First Letter As Lower Case I

Oct 6, 2014

When I type the first letter I into the search text area I get the following error

Run-time error '2110'
Microsoft Access can't move the focus to the control SearchResults

Most of the code is below

QRY-SearchAll
SELECT Clients.ClientId, Clients.ClientFileNumber, Clients.ClientShortFileNo, Clients.Salutation, Clients.FirstName, Clients.LastName, [Group Branches].BranchCode, Clients.Phone, Clients.Mobile, Clients.Fax, Clients.BpayRef, Clients.TradingAs, Clients.EntityType, Clients.ABN, Clients.ACN, Clients.Address1, Clients.Address2, Clients.Town, Clients.State, Clients.PostCode, Clients.Country, Clients.Email, Clients.ClientGroup, Clients.DateCreated, Clients.Notes, Clients.LastModified, Clients.UserCode, Clients.BdmCode, Clients.CollLongNo, Clients.CollShortNo,

[Code] ....

View 1 Replies View Related

Letter Help

May 14, 2007

hi,
Im creating a letter. It is based on a query. I have some details that I'd like to display , one on it's own line. I cant print them out now, but they dont all fall on their own separate lines. How should I do that? If I put a carriage control at the end of each detail line, will it know to print each of the fields on its own line? I need advice . I tried doing a subreport -type letter, but it looks weird!

thanks!

View 1 Replies View Related

Letter Feeding From DB

Oct 16, 2007

having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it?

cheers

View 9 Replies View Related

Starting Letter

Jun 15, 2005

I want a criteris in access to get the records having field 2 starting with "num". Num is example. I want to do withdifferent letters.

number
numbiur
numg
numds

the first three letter should be num in this example. i want for different words i.e, i need to enter the paramter message box.

View 2 Replies View Related

Letter And Query

Oct 12, 2007

Hi,
I'm fairly new to Access. I have few questions.

How to set up database so it searches through my table, finds the name and inputs it into letter in a space I want?

Where does this letter suppose to be located in the file?

Thank you

IOI

View 2 Replies View Related

Does Not Start With A Letter

Oct 15, 2007

Hi All:given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number?I first trimmed the field to eliminate blank characters and then I used the Not Like "A - Z" but it still gives me jobs with letters at the beginning of the name.thanks for all your help in advance. :D

View 1 Replies View Related

Display Only One Letter

Jun 29, 2006

I am trying to get the firstname to only display the first letter in a report.

I have put this format in the control source =Left([firstname],1)

When I run the report I get error in the firstname field.

Any suggestion.

Thanks

View 2 Replies View Related

How Send The Letter

Dec 31, 2004

Hello all:



In order to set up an multi-receiver email program with ASP/AccessDB,

I downloaded “Beginners ASP mailing list program” “newsletter.zip”



After unzipped it, it contains 11 files. I put them all in the wwwroot of IIS.

I have made the address database “newsletter.mdb” successfully. The next

step is to send letter.



First using “newslettercreat.htm” to write a letter and then press “submit”.

After submitting, it prompt a IE page with address “newlettercreat.asp”, but

says: “The page cannot be displayed” and with following

information:

---------------------------------------------------

Technical Information (for support personnel)
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string
/newslettercreate.asp, line 22So, the letter can not be sent.

What is the ERROR of “Server object, ASP 0177 (0x800401F3) Invalid class string” ?

My OS is winXP pro, email program is Outlook Express. Who could help l me solve
this problem? Thanks!

View 1 Replies View Related

Edit A Report Letter

Oct 26, 2005

i'm trying to work with this database.
i want to know how to change a few things
we have a command button that generates a letter
i need to edit that letter as it contains names and numbers no longer in the office

is there a way i could find that letter

i tried to have sent to a .rtf file which i could modify, but that's tolerable for a dozen of recipient not 2 to 3 hundreds


thanks

View 5 Replies View Related

Generating A Letter From MS Access

Jun 20, 2006

I need to generate a pre-formatted letter from within MS Access, where the name, address and other information will be pulled from the current record on an Access Form.
Basically it is like a welcome letter I could send to any new client I enter into the data base. Since I am doing one letter at the time, mail merge in MS Word is not an option
What would be the easiest way to do this?
Thanks

View 9 Replies View Related

Letter Storage & Retrieval

Nov 6, 2006

I am not sure whether this is a problem with MS Access, Visual Basic or Windows.

I have taken over supporting & developing an MS Access 2000 DB for a small charity & am not an Access expert or a programmer. The Application includes processing to create, amend & store retrieve standard letters based on a Word document called MyMerge.doc. The operating systems is Windows XP for the PCs with a MS Server 2003.

Each letter is allocated a number ‘CallID’ which is used to retrieve the letters later. The letter text is in MessageC.

The VB code to store the letters (Save As) is

Dim strTest As String, db As DAO.Database
Dim td As DAO.TableDef
Set db = CurrentDb
For Each td In db.TableDefs
If Len(td.Connect) > 0 Then MessageE = Mid(Left(td.Connect, InStrRev(td.Connect, "") - 1), 11)
GoTo jumpout
Next
jumpout:
MessageC = "%fa" & MessageE & "Db Letters" & MessageC & " " & (CStr(Forms!Contacts![PostalCode])) & " " & Trim(DLookup("[TitleType]", "Title Types", "[TitleTypeID] = Forms!Contacts![TitleTypeID]") & " " & Forms!Contacts![FirstName] & " " & Forms!Contacts![LastName])
objWord.Application.Activate
SendKeys MessageC

The VB code to retrieve the letters is

Dim MessageE As String, db As DAO.Database
Dim td As DAO.TableDef
Set db = CurrentDb
For Each td In db.TableDefs
If Len(td.Connect) > 0 Then MessageE = Mid(Left(td.Connect, InStrRev(td.Connect, "") - 1), 11)
GoTo jumpout
Next
jumpout:
Dim WordApp As Word.Application
Set WordApp = CreateObject("Word.Application")
WordApp.Visible = True
WordApp.Application.Activate
MessageE = "%fo" & MessageE & "Db Letters*" & CallID & "*.doc"
SendKeys MessageE
Set WordApp = Nothing
GoTo Exit_Command53_Click

The success rate varies from PC to PC and user to user. It will work with one letter and not the next. It is very difficult to identify a pattern. When the Save As does not offer the expected name & path, the Application (or operating system?) offers to save ‘MyMerge’ to the user’s My Documents folder.

In that case I tell the users to correct the path themselves and save the document under the CallID. Theoretically, retrieval should work since this uses the CallID and wild cards. Sometimes it does but often it will instead retrieve a document in the user’s My Documents folder. If it does go to the right folder, you sometimes have to replace the last wild card with ‘.doc’. I have tried replacing the last wild card in the VB code with ‘.doc’ but this does not work!

Finally, I alone get the message ‘Save failed due to out of memory or disk space’, neither of which is true. This makes it very difficult to continue investigating the problem. If I use a copy of the DB on my hard drive rather than the network I can save but not retrieve.

View 2 Replies View Related

Form Letter Ideas

Feb 5, 2007

I want to pick everyone's brain on this one, because I'm not sure what I want to do can be done very easily.

I have a database that tracks client information for insurance policies. I'm going to be giving it to other agents, many who are very computer illiterate. One of the requested functions is for them to be able to create form letters from the database.

So, I'd like some ideas on how to do that. Ideally, I'd like for there to be a form that someone could load some letter templates, but also tweak them or even create new ones that can be saved. It would also need to have "merge fields" much like you would in Microsoft Word. Basically since every agent will want to have their own letters, it needs to be easily editable.

Is there an easy way for a computer illiterate person to just select "interest letter," change some wording, and have it merge into a report? Or, is there an easy way for someone to get access to the merge fields if they were to do a Word mail merge? I don't really want people trying to find the right tables/queries amidst all the different tables in the database.

Or, throw out some other ideas. I'm open for most anything. Thanks in advance.

View 4 Replies View Related

Append A Letter To Autonumber?

Feb 2, 2005

Is it possible to append a letter to the front of an autonumber (which is also my primary key). eg: E568
:rolleyes:

View 9 Replies View Related

How To Get Data With A Starting Letter.

Jun 14, 2005

I want a criteris in access to get the records having field2 starting with "num".

number
numbiur
numg
numds
the first three letter should be num

View 1 Replies View Related

Query To Look At The 3rd Letter In A Field

Sep 1, 2005

Hi, anyone know if it possibe to create a field within a query that looks at a 3 letter number code in a field of a table named "employee master" to see if the last number is an "I" or not. So for example a number code in a field named "Department" is "KTI". I would like to display "indirect" in that field if it contains a "I" in the 3rd letter of the number. And display "direct" if the third letter is a "D" intstead, tried doing IF statements but not sure how to go about it, any help would be great.

View 5 Replies View Related

How To Cut Second And Third Letter In One Column Records

Nov 2, 2005

Hi!
I have one column with text field
I would like to know how to cut for. example 2nd and 3 letter in records collected in this column?
Thanks in advance for any examples

View 1 Replies View Related

Add A Letter To The Beginning Of Field

Dec 4, 2005

When I run a query I want to preceed the result of one of the fields with the letter V.

ie. the field reads GH567Y and I want it to read VGH567Y

Thanks

View 1 Replies View Related

Membership Renewal Letter.

Mar 6, 2006

Ok the database that i have contain all the details about customers including thier joining date. I want to make a query that will produce relevant information for use on a membership renewal letter, It should show only members due for renewal on 1st of may
(there are 3 renewal dates per year. 1st jan , 1st may and 1st sept. I need to assume that the next renewal month of membership for those joining between those months will be the next renewal date. Example if you join in June your renewal date would be 1st september)

Could you please explain how i could do this in easy to understand language as i am no expert with access.

Thanks

View 1 Replies View Related

Qry To Find Strings With Len=10 And No Same Letter Twice ...

Apr 5, 2006

I have a two tables with about 44.000 words that I need to search.

I need to find words that are exactly 10 characters AND where each letter is only represented once ...

Anyone that has an idea how to write that query?

Any help would be highly appreciated.
Thanks from cold Denmark,

Steff

View 1 Replies View Related

First Letter Should Be A Capital, The Rest Not

May 31, 2006

Hi,

I have a set of data and some are in capitals and some are not. This set of data is meant to be used for a mailing, and the home style of my company only allows the first letter to be a capital, the rest should be normal letters. Anyone have an idea how I can arrange this?

Thanks in advance!

View 4 Replies View Related

Need To Create A Form Letter....

Nov 17, 2004

I need to add a basic button on a form that would populate the current on-screen data in a form letter. The fields I have are name, address, city state zip and amount. I currently have the basic buttons on my form - Search, Next, Previous,Add, Delete Print Current Record.
Thanks in advance for your assistance.

View 1 Replies View Related

Not Include Codes That Have A Letter On The Right

Jan 17, 2005

I have a list of codes:

K101
K101A
K101B
K101C
K101D
K101E
L101
L101A
L101B
L101C
L101D

I want a query that displays all codes that dont have a letter on the right.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved