Searching A Database; Newbie Question
Mar 13, 2008
Hi there,
I am designing a search tool for a database table which has attributes such as part number, manufacturer's part number, description, etc. Each item in the database has all these attributes associated with it.
When I search, I am trying to allow a popup to occur when I want to access a modified report that has my search results computed. I created a query and a report, added some SQL code to it, etc. I can basically click the report and have my inquiry window come up asking for the part number, but I'm not sure if it's associated with my database because when I put in the #, the report comes up blank.
I right-clicked my Report and look under "Objects that I depend on" and my Queries tree is full of dependencies that point me to my database table. There is, however, still no report with any substance that I can pull up no matter what part # I put in.
Does anyone know what's going on? I know this is really easy and it's driving me crazy cause I've never used Access before. I don't necessarily have time for tutorials and any lesson enrollment since it's for work, and my profession has absolutely nothing to do with this. Ha.
Thanks for any help you may be able to offer.
Richard
View Replies
ADVERTISEMENT
May 10, 2005
I have built a basic database to hold details on all my computer books and software as i hundereds of them.
I have built a table with text, number and memo fields which i want to be able to search.
What i would like is a form where you can enter details into various fields (eg Title, Author, a field to search all fields, etc) and then display the results in a table in the form below it. Then when the record is double-clicked it opens the record ina new form displaying more details.
Is there a way to do it as i have spent months trying to figure it out and trying to include the sample databases?
I have attached my database so any help will be appreciated.
Thanks,
Aden
View 2 Replies
View Related
May 27, 2005
hi
does anybody done this project that posted below in little more advanced mode ?!
http://www.access-programmers.co.uk/forums/showthread.php?t=79612
View 1 Replies
View Related
Sep 27, 2004
I have a small search page that is very precise. ie. it returns the first record that is the same.
Is there anyway I can make a search form that is a bit fuzzy. ie if i had a field dedicated to the make of a vehicle can I filter it out for that make of vehicle. I've been using a filter, but it all seems rather messie.
Help
Regards
Asperation
PS, on the upside if there is anyone that needs help making a precise search page im happy to paste the code.
View 6 Replies
View Related
Oct 9, 2012
my database lag whenever i start searching, not really bad but i could notice that it blinks whenever i press a key on my keyboard. computer has a big ram (4gb), i5, with 500gb HDD... lots of free space. the database file is only 6.9MB..maybe there is a code that disable or makes the blinking unnoticed?
View 3 Replies
View Related
Apr 12, 2012
I was wondering if there is a program that allows you to do a search of your database.
For example, if i wanted to find out where im using certain queries, is there a way to do a "ctrl+F" for access ?
View 2 Replies
View Related
Apr 15, 2006
I have an old database that would come in handy as a membership roster, but if someone drops out, how do I delete them from the database? I tried deleting the fields, but the blank form is still there. Also, I would sure like to add a search feature so I could go directly to an individual without scrolling through all the names. Can anyone shed some light on this?
Thanks
I've included a link to it below:
http://blindactions.com/temp/ALR.zip
View 5 Replies
View Related
Aug 23, 2011
I have a requirement of searching the database based on 3 columns. I have attached the search form and the code.
Private Sub cmdSearch_Click()
Dim strSQLHead As String
Dim strSQLWhere As String
Dim strSQLOrderBy As String
Dim strSQL As String
Dim strJoin As String
[Code] .....
View 12 Replies
View Related
May 26, 2006
I have attacked quite a few guides ( Dummies & Absolute Beginners ) on how to build a database of my gardening clients, but have run into a problem that they can't seem to resolve. Is there anyone out there who can help me with "referential integrity" and trying to link relationships between the various tables I have created.
View 3 Replies
View Related
Jun 13, 2013
I have a database and would like to search history of some fields but they are autonumber and it won't let me search them.
The fields in question are on the form Workorder:
WorkorderID
CustomerID
View 10 Replies
View Related
Apr 4, 2014
I already have many table for each month , JanuaryT-DisemberT. I'm using simple form to key in data inside that table. Inside to that table (JanuaryT-DisemberT) have project number data i want to notice pop up when i try key in if that project number not valid..
example
JanuariT
Name -Project Cod- Validation
John -2012ABC - Not valid
Michel-2013WER-Valid
Mike-2014TERG-Valid
FebruariT
Name -Project Cod- Validation
Ann -2011AAA - Not valid
Sam-2012BCB-Valid
Tony-2013TEC-Valid
What i want to do is when i want to key in data in MacT using Form with ADD butoon, some notice will come out if .... for example : Daniel-2011AAA or Jony-2012ABC the notice will come out " THIS PROJECT COD NOT VALID, PLEASE CHOOSE ANOTHER COD". it something like notice to tell me that project cod already not valid yet. It look like "automatic searching" data for every table. It Is possible to do like this?
View 6 Replies
View Related
Nov 1, 2005
Hello,
Hoping some one could assist me? I am busy designing a database which I am going to put in access.
I have designed the tables and am now not sure how to link them. I was given an excell spreadsheet with headings and am now trying to make this into a database. Example : I was given Co-ordinator Name - Which I now split up into:
Co_First_Name
Co-Last_Name
Co_Initials
Co_Area_Code
Co_Tel_Number
Co_Mobile
Co_Email
Now there other fields like this , for example Regional Manager Name - which I have split up as above into a seperate table.
These fields all relate back to one Code - Called District
There are also a fields which needs to show the a fee required the fee paid and fee outstanding/balance .
The rest of the information required I can create check boxes for , I hope!
Anyway my question is how do a relate all these different tables together?
This is my mental block. And the check box tha information - is it stored a another table? I hope I am explaining my self correctly and I hope some one can make sense of my question
View 4 Replies
View Related
Oct 24, 2004
I am developing a database for a friend and have all the relationships,
tables, forms, queries and reports working well. I used the orders template to
build this and just made a few changes. I have an orders form with an orders details
subform that works beautifully. There is also customers table, employee table,
products and inventory table. The inventory table has product ID, units in stock and reorder level
as the only fields. I need an easy way to have the orders detail form decrease inventory as
items are ordered and also some sort of way to enter restock. Can anyone offer advice that a
beginner can understand in regard to this?
I wrote an update query that he can run that will subtract the qty ordered from the units on stock
for orders with order date >= whatever date he enters, but if he enters a date he's previously updated it will update those records again. I think this is not a good way to go but the only way I could accomplish. I have him using the same order entry form with customer name Restock to add items to inventory by putting an if then else statement in the before mentioned update query. This just adds to inventory if customer name="Restock" else the qty ordered is inventory units in stock -qty ordered.
I'm sure someone can suggest a better way. A friend mentioned dsum function but can't explain how to apply it in this instance. Thanks so much!!!!
View 1 Replies
View Related
Feb 18, 2015
I am looking to transfer a number of spreadsheets that I use to track IP Addresses to an Access Database, I have set up the tables and fields, what I would like to do is search for unused IP Addresses from populated table/fields.
View 2 Replies
View Related
Jun 25, 2007
Hi, I have two questions which i dont think are two far apart, hence same thread.
First is, how do i make a search text box, that when i click a button searches for what is in that text box, rather than bringing up the find box. It is alright but it always compares it to what was last tabbed, or is the selected tab, and i want it always to compare to another textbox called company name.
secondly. I am often entering entries to the database with the same details. but a different name, how can i have it so that i enter say 4 or 5 names which starts 4 or 5 new records, but then places the rest of the details across all the new records.
THANKS
aLEX
View 2 Replies
View Related
Jul 22, 2005
Hi All,
I have a database which has 9,00,000 zip codes.... when i am searching for a particular zip code it's taking some time.... can anyone tell me how can i speed up the process.........
CoolNax
View 2 Replies
View Related
Apr 11, 2006
Hey all.
I have a database but want to create a Search function.
I want the search function to read a drop down box for a table name, then read two text box's for search criteria then search the table and displat results.
My knowledge of Microsoft Access is limited.
I think I have the theory behind it but not the know how for the coding.
So far I have been able to get it too look at the List Box for the table name then when I hit the search button ive set it to just open the table for now.
but cant get any further, any help would be greatly appreciated.
Thanks in advance.
View 7 Replies
View Related
May 7, 2005
Hi,
I have a command button (SEARCHING). I want to Press F12 as a function key instead of pressing on the command button. Any help pls...???????
Sysop470
View 1 Replies
View Related
Jun 27, 2005
I need some assistance in searching for a recorded by employee name with the click of a button. There could be more than one record for each employee name so i need a way that once the records are found they can be displayed to the user? ANY help is greatly apprieciated!!!!
THANKS
View 6 Replies
View Related
Apr 15, 2006
I want to run a query where I can enter two dates ( On on form ) and have a report show the results.
I know I can write the dates in the criteria field in a query, but I want to be able to enter the dates on a form and do it this way.
Please help, anything will help me, I hope. :confused:
Thanks
View 2 Replies
View Related
Sep 8, 2005
Hi there
In my form every time i click on the search button a box pops out and asks me if i want to continue or accpet the change. the funny thing is i just search and nothing else.
thanks
i attached a screen shot to help
View 1 Replies
View Related
May 12, 2006
Hello, I'm trying to search an entry of a recordset with VBA
The entry can only be found by searching 3 field values. In my case the correct entry can only be found if the data in the field Date, No_Employe and No_Project all match the data of the entry I want.
Findnext doesn't work, it only access one field and I need three.
Seek doesn't work since it need to search a key, and neither Date, No_Employe or No_Project are keys.
How can I proceed ?
Should I use multiples Findnext ( how do I do that ? ) ?
EDIT :
Also please note that I'm searching for 400-500 entries in a row, so speed is an issue.
View 1 Replies
View Related
Dec 11, 2006
Hi All,
I have a small yet important question to ask. I have a text box on a form, that text box accepts a product number that the user wants to modify. I want to be able to do the following:
- If the product number does not exist, prompt with an error message (this part is not a problem).
- If the product number does exist, populate the text boxes on the form with the respective data. ex: Product number 512547. Does exist, hence: (TB = textbox)
Prd. No.TB = 512547
Rec'd Date.TB = 10/10/2006
Comments.TB= blah blah blah, etc.
I am simply trying to pull information from a table into text boxes on a form using a text box.
THANKS A MILLION!
View 1 Replies
View Related
Aug 7, 2007
In my Access DB, I have a field named ‘REFNO’. This contains reference numbers of some communications. I have a Combo Box to search records with this ‘REFNO.’ It so happened that there were two communications with the same REFNO. When I typed the wanted number in the Combo Box, only one record was displayed in the form which was not the one I wanted. I was able to see the other record by opening the table. Is there a way to display the next record with the same number in the form with the Combo Box? Grateful for help.
View 1 Replies
View Related
Feb 23, 2005
I have a parent table called patient info. and a child table called fills. The database in the future will become very large, and will be difficult to find a particular patient in the parent table to update fills in the child table. How can I search through the parent table with ease so that I can update fills?
Thanks for those who help!
View 1 Replies
View Related
Oct 1, 2005
I have a database and I made a query to search records. The query worked perfectly, but now the only problem is that if a search has an ID number that is bigger than 239, the results will not be displayed. The query will be empty! :S
What is the problem with my query?
Thanks in advance
Aber^28
View 2 Replies
View Related
