Searching A Part Of Record..

May 27, 2007

Hello. Im new here and also new to both Visual Basic and Access so please be patient with me :)

I've downloaded SearchDB.zip uploaded by agehoops. Its works exactly like its supposed to but I need to update it a bit.

Im making a MovieDatabase and have a table with Orginaltitle, SwedishTitle, Director, Actors and so on. When I search in "Director" for "Francis Ford Coppola" or just "Francis" the movies which is related to him comes up. But when I search for "Ford Coppola" or only "Coppola" nothing comes up. I want the user to have that possibilty to search using the last part of the name too. Is that possible?

When searching with the binocolor icon it works fine when chosing "part of record", i think thats the english translation for "Del av fält". I have a swedish acces version so im not so sure but anyhow I think you understand what I mean.

To sum it up I want the ability to search writing only a part of what the record contain including the last part and not only the first part like it is right now.

Appreciate any help!

Regards,
SoloJuve

View Replies


ADVERTISEMENT

Forms :: Input Mask - Searching With Part Number

Nov 6, 2013

I want create a from with a "Part Number" text box .

After I enter a Part Number into the text box ,

other text box at below will automatic come out the detail about the Part Number I typed in .

Extra :

my part number is something like this : 00-00000-00 ,

how to convert to input mask ?

View 1 Replies View Related

Tricky Question - Form Part Data Entry, Part Not

Dec 16, 2004

I have what I think is a difficult problem to overcome...

I am designing a form to create an invoice. The user will select a workstream and a date range in form frmInvByHrs. Within this I want two sub-forms, one is frmInvByHrsTsht and the other is frmInvByHrsBill. I want the first one to display all the staff and their hours done, and the second one to be in data entry mode where you can enter the hours you want to bill. Each sub-form is based on a separate query.

Is it possible to do this? ie. to have one sub-form in data entry mode, and the other not? It seems to me that the data entry mode is controlled by the MAIN form regardless of the sub-form settings!

If this is not possible, do you know how I can acheive this?

Thanks

S

View 1 Replies View Related

Table Fields -to- Part Of A Record

Jul 22, 2005

Hi,
I think I know my way around a database, but my new employer has me doing kart-wheels. There is an Excel sheet of values which I have imported to Access tables, the table contains ledger values on it and the account numbers are in the fields as column headers.

I want to reflect those field values as part of the actual record in a summary query.

I think this can be done with just a few steps without creating more than one table or query???

Please help. :cool:

View 7 Replies View Related

Copy Part Of A Record As Value In Another Field

Dec 14, 2006

Im using the UPDATE Query in Access

UPDATE MAT_Clean SET FCODE = 'BC', NOTES = 'HC RAMP'
WHERE FCODE='BC HC RAMP';

Instead of typing what needs to go into NOTES everytime, how can I specify whatever comes after 'BC' to go into NOTES? Use 'BC *'?

Thanks!

View 5 Replies View Related

Searching For A Record

Jun 28, 2006

i have a form which hold the data about a pc

i want to be able to bring up information about what software is on that pc

the software of each pc in a seperate table.

i was wondering is it possible for me to look through my pc's and click on a particular pc and be able to find the info about what software is on that pc.

View 2 Replies View Related

Tables :: Change Record That Is Part Of Composite Key?

Feb 26, 2015

I am creating a database that tracks the selling of products amongst other things.

The user will enter in an order and may delay invoicing until the customer approves the quote - at which time the order is turned into an invoice.

In the transactions table the OrderID, ProductID and CustomerID constitute a composite key.

I want to be able to view the order and change it by either deleting or adding ordered items (obviously prior to invoicing) but because the ProductID is part of the composite key I cannot delete a line item.

Perhaps the solution is to remove ProductID from the index or is there a better way?

View 8 Replies View Related

Remove Only Part Of Record Using Unmatched Query?

Aug 13, 2013

I am needing to compare some information in a way I cant with the normal Unmatched Query.

I have 2 tables with the fields:

| PHONE1 | PHONE2 | FIRST | LAST |

What I need to do is have Table 2 check against Table 1 to see if any of the 'PHONE1' records match 'PHONE1' or 'PHONE2,' and if they do have them remove just the information from PHONE1, not the entire record.

Then I would have to repeat the process to do this with PHONE2. Having it check against 'PHONE1' and 'PHONE2' in Table1.

If both PHONE1 and PHONE2 have a match, the entire record would be deleted. If not, it would keep whichever did not match.

I am currently having to do this manually, because if I just run an Unmatched Query it gets rid of the whole record regardless of if PHONE2 is a good number or not.

If any more information is needed, let me know. Like I said, Im relatively new to working in Access and dont know much.

All of the fields are 'TEXT' type.

Access 2003 on Windows XP.

View 8 Replies View Related

Searching Record In Subform

Feb 8, 2005

Hi there,

i've read most of the articles in this form about searching for records in a subform. I've envclosed a picture witch displays my problem:
-i would like to find a record"(invoice)" in the subform"facturen" with a searchbutton. As you can see, i've already made a searchbutton named"zoek cliënt", but i can only find records within the main form "debiteuren". Can somebody help me with the code for the searchbutton?

Thanks in advance.

Greetings,

Stephan

View 1 Replies View Related

Reports :: Table With Data - Unique Part Of A Record

May 28, 2013

I have a table with data like this

Field_1,Field_2,Field_3
A,B,5
A,B,3
A,C,7
A,C,6
X,Y,4
X,Y,3

I need a report where I can only see

A,B,5
A,C,7
X,Y,4

That is Group by Field_1 and only show the records which has Field_2 with the max. value of Field_3

View 1 Replies View Related

Date Problem - Part Constant - Part Now()

Nov 3, 2006

Hi everyone,

I have refined my query from previous threads to involved a module function. This calculates more acurately no of working days between dates and takes into account a holidays table. (All credit to Arvin Meyer on the module:) )
However because the Leave Year starts at the 1 July and finishes 30 Jun I need to compose the date for any current year Year(Now())

Enclosed scrdmp shows my query design. I can easily get it to work as you see it, but obviously as each year rolls over, the year needs to change.

Have looked at many posts but can't find what I'm looking for. This one will get me over the hurdle.

Many thanks,

View 6 Replies View Related

Searching A Recordset Starting From The Last Record To The First

Apr 23, 2008

First I will open a form and choose a salesman. Then based on the salesman selected I want to open a recordset and start searching for the last record for the salesman selected. When the record is found some of the information from that record is pulled on the form.

View 9 Replies View Related

Searching Particular Record To Edit In Form

Jul 19, 2005

I have a form that assigns an Auto Reference Number to each record. Now the records are later edited. Is there a way that I can have the user enter the Reference number and come directly to that particular record that needs to be changed in the form. Like a dialog box that asks Enter Reference Number or something.

View 2 Replies View Related

Searching For Record By Multiple Fields

Sep 9, 2006

Hi,

Not sure where to put this, but as I want the information to be shown in form view, I guess this is the bext place to start.

In breif, I have created a database, in which infomation on machinery is held.

The problem I am having (atm), is I have to create a function, which I want to be presented in form form, where by each item can be searched by it's RequestID (unique) or the customer who owns it, so that its current location can be attached (or viewed).

I'm not sure whether i've worded this well, so to sumerise:

I need a form with 3 fields, RequestID, Customer and Location.

Where by I input the RequestID, which brings up the Customer and Location, or input Customer which brings up the RequestID and Location (obviously there will be mulitple results from Customer search).

Again, I hope I haven't confused anyone because it's pretty simple what i'm trying to say, but....

Thanks, Ben

View 1 Replies View Related

Modules & VBA :: Searching For Record Using Multiple Criteria

Aug 2, 2013

I have a form where a user enters data. One of the things the user enters is a "lot size". I need this lot size field to be checked against a query in the database to determine if the quantity is acceptable or not.

The order number in this query is in certain cases missing a leading zero, so I need to truncate this from the user entered form field.Finally I want the user to be notified if they are trying to exceed the lot size in the query.My code is as follows:

Code:
Public Function RemoveFirstChar(RemFstChar As String) As String
Dim TempString As String
TempString = RemFstChar
If Left(RemFstChar, 1) = "0" Then
If Len(RemFstChar) > 1 Then
TempString = Right(RemFstChar, Len(RemFstChar) - 1)
End If
End If

[code]....

View 14 Replies View Related

My First Database Part II

Mar 13, 2006

I am having more trouble with the old database I am trying to make.

Can someone have a look if I attach it?

I don't think the ID fields in each of the three tables are working togehter.

Shouldnt they be the same ID number of each record for that person across the three tables?

Thanks.

View 2 Replies View Related

Part Number DB

Aug 8, 2006

I am trying to create a Part Number Database and want it to start at 100000 instead of 1. Can someone tell me how I can get Access to start there?

TIA.

View 4 Replies View Related

Try To Figure Out What The Last Part Of This Does....

Apr 7, 2008

First time on here and I am looking assistance with the last part of this code. Can someone tell me what this is looking for thanks...


ExlFile.Application.activeworkbook.SaveAs "........Compliance Reports" & Rtn & BU & "-" & Cat & ".xls

View 2 Replies View Related

Updating Only Part Of The Value

Jun 29, 2006

I have a field called images and its name is like abc0001, abc0002 etc, i want to update all the abc to abcd0001, abcd0002 etc, how can I do this using update query or is there any other way to do this, thanks for any help...

View 1 Replies View Related

Displaying Only Part Of A Field

Jul 23, 2005

On a report I have a field that has a value that can be anywhere from 15 to 25 char. Can I set up the report field to only display the 1st 10 char. ?

jon

View 9 Replies View Related

Search On Part Of A Number

Jan 16, 2006

I have a data base with the field named "PartNumber" this is a 13 diget number. How can I search on the last 7 digets only

View 2 Replies View Related

Excel In Access --- Part 2

Feb 13, 2008

Excel in Access (Part 1) (http://www.access-programmers.co.uk/forums/showthread.php?p=671226)
Excel in Access (Part 3) (http://www.access-programmers.co.uk/forums/showthread.php?t=143970)

Video Version HERE: (http://www.access-programmers.co.uk/forums/showthread.php?t=144045)

How to use the Normalization Form (http://www.access-programmers.co.uk/forums/showthread.php?t=143983)

In Excel in Access (Part 1), we went from this:

http://i185.photobucket.com/albums/x317/UncleGizmo/StudentTableBoolean_2.png

To this:

http://i185.photobucket.com/albums/x317/UncleGizmo/StudentTableTransposed2.png

This was achieved with a form based tool available to DOWNLOAD here. (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=20619&d=1202664804)

See instructions on its use here: (http://www.access-programmers.co.uk/forums/showthread.php?t=143983)

However you may be looking at the new resultant table and wondering what on earth to do with it. I hope to take you through the process of making it into something useful in this thread.

The first thing you will notice is that where the check box is not checked, then that whole row is redundant, for instance there’s no need to record that ID number “1” --- “Has Not” taken Maths, English, Geography, Physics etc, it would suffice just to record the subjects that have been taken , In this case Biology, PT and Social. Looking at those entries in particular, then a general rule of logic can be defined, “delete all the rows where the check boxes are false”.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1b.png

Once you have deleted all of those rows,

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1c.png

then it becomes obvious that the check boxes themselves which now “All” contain a true value are also redundant, they can be deleted just leaving you the text entry identifying the subject taken by each student.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1d.png

Using the “relational” properties of the database that is one more thing you can do which will improve efficiency and that is to replace each text entry --- Maths, English, Geography, Physics etc, with a number linking that field to a look up table.

First of all you need to create a look up table; this can be done by applying a create table query to extract just the unique values for the “subject” There is a video showing how to do this here: (At time index 1min) (http://www.viddler.com/explore/TonyHine/videos/67/fullscreen)

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1e.png

This unique list should be called “tblSubject” this table is not quite finished, you need to add an identity column to the left of the text representing the individual subject, this identity will then appear in the previous table.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1f.png

Once you have completed the “look up table” you then need to replace the entries in the student subject table “tblStudentSubject” where it shows subject in text form with the number representing the link to the look up table. This is the query:

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1g.png

And here is the new column created:

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1h.png

This way your design changes to the table are making it much more efficient, holding the same information but with less data.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1k.png

View 4 Replies View Related

Excel In Access --- Part 3

Feb 19, 2008

Excel in Access (Part 1) (http://www.access-programmers.co.uk/forums/showthread.php?p=671226)
Excel in Access (Part 2) (http://www.access-programmers.co.uk/forums/showthread.php?t=143607)

Video Version HERE: (http://msaccesshintsandtips.ning.com/profiles/blog/show?id=948619%3ABlogPost%3A7031)

How to use the Normalization Form (http://www.access-programmers.co.uk/forums/showthread.php?t=143983)

Using the normalization form --- Download Here (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=20619&d=1202664804) we converted part of a spreadsheet type table into the beginnings of a relational table.

From this table we derived a “look up table” now giving us a total of three tables, the remains of the first table, “tblStudent” (the student names), the next table “tblStudentSubject” stores the subject(s) related to each student, and finally a third table, “tblSubject” a “look-up table” to store the actual subject description.

http://i185.photobucket.com/albums/x317/UncleGizmo/ThreeTables.png

From the table “tblStudentSubject” we created a form in datasheet view:

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm.png

Now all we need do is combine this datasheet view form with a form based on the students list, and this will give us a form for correctly displaying the student names and the subject(S) the student is taking in one Form:

Using the wizard create a basic form from the student table and name it “frmStudent” arrange its size so it has some open space as shown.

http://i185.photobucket.com/albums/x317/UncleGizmo/StudentForm.png


Now open “frmStudent” in design view

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_1.png

And drag the subform “sfrmlStudentSubject” into the clear area on the student form “frmStudent”

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_2.png

You may wish to delete the text box, you don’t have to but I usually find it looks better without it.

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_3.png

Size the form to suit

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_4.png


Now save the form and have a look, you will notice that it incorrectly shows all of the records in the subform,

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_5.png

Now the next bit is tricky, for two reasons, the form isn’t really on top of the other form, it actually sits in a subform window and you need to gain access to the properties of this subform window by clicking on the tiny line that you can just see around your subform. This can be a difficult task to master first time.

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_6.png

Now open the “subform field linker” dialog box by clicking on the ellipsis (…)

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_7.png


Phone: +44 1635 522233
Mobile: +44 7747 018875
Email: email@tonyhine.co.uk

Web: http://msaccesshintsandtips.ning.com

View 1 Replies View Related

Filtering Out Part Of A Field

Apr 7, 2008

Hi,

Apologies, I have no idea if this should go in reports, queries, macros or modules and VBA as I'm a bit stuck but hopefully it's fairly simple.

I've been teaching myself access and it's been going well. What I have now been asked to do is produce a report that generates the shift patterns for everyone in the office as an HTML document. Now, the data is all exported from another program and I've had no problem getting the data into access easily. The problem I have is the format some of the data is in.

The major one that I need to solve is showing what time people are meant to take their lunch break each day. The field for break is filled in in the following format.

07/04/2008 12:45:00

Now, I have the date from elsewhere so I really don't want the date to show up so I need something that removes the date from this field. Is this going to be easy to do? (Ideally I'd like it so that the above example actually just returned 12:45 but if it has the 00 on the end that would not be the end of the world)

Apologies if this is in the wrong part of your forum.

View 3 Replies View Related

Remove Part Of A String

Feb 7, 2005

Hi folks,
I have a table with the words "Church of (whatever)" in one of the records. I am attempting to do an update query to remove the "Church of" part but leave the remaining part of the string. I am using a combination of Format and left but am not having any look. Any suggestion are much appreciated.
Thanks
Colin.

View 2 Replies View Related

Search Part Of Name Field

Jul 23, 2005

Hi Guys!

I'm working on this database in which I have 2 forms:

one form has personal information (PersonalInfo)
and the other one is a search form (Search)

In the search form I have a field in which I want to type any part of the Name field in PersonalInfo form and I want to retrieve all the records that have this part of the name.

Here is what I tried:

In the PersonalInfo form, I want to the criteria of the NameField and typed the following:

Like %[Forms]![Search]![SearchField]%

but it didn't work.

Any help will be very much appreciated.

Regards,
CS.

View 4 Replies View Related







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