General :: Create A Form That Allows To Search For Particular Quote Numbers
Jul 8, 2013
I am creating an access database to store customer details as well as quote information. I have created a form to input quote details that our office can complete when a customer calls to complete a quote. I need to create a form that opens as a new form every time we click on the form to input a new quotation. How do I do this? At the moment when I click on the form, the form opens but the details of the last quotation are stored on the open form.
I have no training in access at all and am self taught so far so by no means an expert.I also want to create a form that allows you to search for particular quote numbers, so if someone calls and asks about a particular quote number we click on a page that says 'search quotes', input the quote number and the form opens with all the details of that quote.
View Replies
ADVERTISEMENT
Feb 23, 2013
i orginally thought i should do this in excel but i think when the dataset becomes larger and i want to eventually get it on the web - i thought its access i need?
i have created a mini dataset as an exmaple of what im trying to explain..i have in first column the objects, and columns after this are the elements needed to make the object (i have just labelled the element titles a b c etc - there will be LOTS of elements once i get the dataset created). so if i had a red blue green cream elements - a search would bring back both lights and lamps that i am able to make.
object A B C D E F G H
lights red blue green cream
lamp red blue green cream
garage red blue green cream yellow brown purple pink
house orange white green blue red black
garden orange white green blue red
garden house orange white green blue red
is there a way of creating a search lookup to this kind of information? a form which you type the criteria in and it brings back what you can make? if i was one element away from an object could I use a wildcard function to say, if you had black you could make a house?? etc
View 3 Replies
View Related
Jul 10, 2012
i need to create a system that can search data using keyword.so i want to create search button that i will create it at form. currently i have 1 table and in that table i have 10 fields which are project_name, doc_ref_no, doc_title, volume, book_no, author, doc_status, box_barcode, filling_location, doc_availability.
i have create 2 forms, one form for user to add new record and another one is to search record. the user can search by enter project name, doc title, volume and box barcode. for project name and volume, i use combo box and for doc title and box barcode i'm using text box.
i want to create search function that can detect from user keyword and even user did not fill in all the form, the system still can search the record.
View 5 Replies
View Related
Oct 10, 2014
I have been tasked to create a Web Search Emulation of some sort. I'm wondering if I could do it with Access. I'm thinking if I create a start page with a search field where the user can enter any word they would like (specifically a job search) and then link that field to a query that would look/search for that word in a table that has loads of entries to see if anything is found and if there is list the titles of the results in a clickable ListBox. Then, if they click something in the list, it would open another form with the details linked to that list item.
View 2 Replies
View Related
Aug 12, 2014
I'm having multiple problems with my database like things such as -
i'm currently working on the Query 2 - On the Phone database (ignore Query 1) and i want to search for multiple plot numbers preferably in one parameter prompt with a comma to seperate numbers. (this could be a multitude of numbers so i would like to be able to input as many as needed). Also when i do search on this query since the Criteria is a 'Between' Value i would expect everything between the 2 numbers input to show up - but a lot of numbers out of the range show up too - why is this? (The Numbers are like "69 to 136" and they will show up - but 1-69 and 136-170 would too
I would also like to implement the search results from Query 2 into the Form i currently have made but it just opens up a access table when the search is made?
i cannot link my database as it is too big for the server - But here are the Criteria for Query 2:
Plot No - (criteria = Between [Enter First Plot No:] And [Enter Last Plot No:])
Site - (criteria = Like "*" & [Enter Site:] & "*")
Product - (criteria = Like "*" & [Enter Product:] & "*"
The Query is the one im most concerned about , i can live without a form.
View 14 Replies
View Related
Aug 13, 2014
I have a web database that I am trying to create a search feature for just 2 of the fields. The search is for a certain date and also a shop are the 2 fields I would like to have the search run for.
Once the search has been run I would like to generate it into a report.
I have already created the report/ form and the query. I am not sure where I need to go from here. I have created the from with the date and also a combo box for the list of the shops and then a button that says search that will go to the report. I just need it to show all the particular items that show the date and or shop. If you leave them both blank it will run a report and show everything. Then if you just put a date in it will run a report with just that date or the same with the shop.
View 9 Replies
View Related
Feb 12, 2006
hello, i know i have seen example from here, nome of them seems to help. My is just a simple search.
i have 4 tables: Artist Name, title, country and location
all i want is create a form that has a search. I want to type the artist name and it lists the country of the artist. How to i do this. I create the command button and text box but it just does not work.
This is the code i use on the command.
Quote: Private Sub ButtonSearchForRecords_Click()
Dim StringQuery As String
Dim StringWhere As String
StringWhere = ""
If Not (TextBoxSearchName = "") Then
StringWhere = StringWhere & "AND [Name] = '" & TextBoxSearchName & "' "
End If
StringWhere = Right$(StringWhere, Abs(Len(StringWhere) - 4))
StringQuery = "SELECT [Name], [Title], [Country], [Location] " _
& "FROM [2-75TH SCAR] WHERE " & StringWhere _
& "ORDER BY [Name], [Country]"
Me.ListBoxRecordsFoundInSearch = StringQuery
Me.ListBoxRecordsFoundInSearch.Requery
End Sub
View 1 Replies
View Related
May 18, 2005
Hi,
I am a total newbie to access.
We have a small business and i do all the admin. I've created a database of all our contacts (name, address, phone number, fax number, etc) and i've managed to create a form that allows me to enter the data into that instead of directly into the database window.
The last thing i want to do is create a search form or add a button to my existing data entry form that will allow me to type in a contacts name, address, or any other thing about them i remember at the time, and be taken straight to that entry. Once this is done that is all i need to know for the moment.
I've tried an example i found on microsoft's site but can't get it to work properly.
Can anybody help. I'd imagine this is very very simple but i can not get the answer myself.
Thanks.
View 5 Replies
View Related
May 12, 2005
I am using msAccess to develop a small application.
I have 2 tables, student and course, and
I need to create a form with 3 fields -
by_id, by_date, by_course_id
This form can generate a view only table according to the field the user entered.
Can anyone help me on this?
What's the step to do so?
Thnx
View 3 Replies
View Related
Dec 11, 2013
I need to make a search form in MS Access:
I have a table with columns:
Login, First Name, Last Name
I need to create a form with one text box and a Search button.When i enter the Login in text and click the button it should give me the details.I am able to do it with single Login being entered.But the catch here is i want to enter multiple Login in the single text box and search and it should give me the result.
View 1 Replies
View Related
Sep 25, 2013
I've built a PostgreSQL database for some ecology data and am trying to use MS Access 2010 to make a front-end for it.
I've created a form to display site data; it includes such fields as site ID, site name, county, state, landscape, etc. (There are more, but if I can get the idea down with a couple of these, I should be good to handle the rest). One can click through the form and see 14 pages of site details, which is fine because there are 14 sites.
What I want to do now is make a search form in which one can enter values for site ID, site name, county, etc, and somehow get the pages of the display form that match those values. It's not terribly important to me how that output looks - whether it's a list of matches that allows for clicking on a match and showing just one page of the display form, or whether it's a filtered subset of the display form pages that one still clicks through to view them all.
if there is code to write, where do I type it? Do I start my search form by making a form with the search fields as values, or is there some other way? How do I make those search fields into search boxes rather than display boxes?
View 14 Replies
View Related
Feb 17, 2005
I have been trying to create a Quote form in my Database. I have a list of products, each product then has a table that details prices based on quantity breaks (i.e 500 to 999 and 1000 to 1999 etc.).
In my Form I am unable to create a subform in datasheet view that will enable me to select a product from a combo, type in a quantity and for the price to be displayed based on the quantity?
Has anyone managed to achieve this? I would love to see the code and put it into practice.
Many thanks
Nik
View 1 Replies
View Related
Mar 16, 2005
I have uploaded an example of my database
As you can see there are two tables and two forms.
What i want is for a user to view or enter data for a record on the first form.
And then when they are done they click the button to open up form2.
What i want to happen is for the company name/id from the record in form1 to be searched for when form2 opens and to display only the data for that record when opened. If no data exists for that record in form2/table2 then for it too create a record for that company when form2 is opened from form1
hope this makes sense and you can help
Please note this is just an example so if there is wrong naming conventions and such please ignore if there is as i just wanted to display quickly what i want to acheive
View 13 Replies
View Related
Nov 4, 2013
I want to create a form to search my parts.example I typed in a part number 123 , the other text box also will come out the detail about the part 123.
View 2 Replies
View Related
Jul 7, 2014
This is what the search box must do:
- Searches 3 fields (StudentID, FirstName, LastName) and jumps to the relevant record.
The closer to the search box in the navigation bar below, the better, so this is what I would really like too.
- A repeat click would take me to the next result/record (if any) with the same criteria
- Instant search as soon as I start typing
View 11 Replies
View Related
Sep 21, 2012
I have a form and when it's opened you get 3 different search questions to answer or leave blank. My question is.... If a search parameter is entered but no results are found to match it, how do I create an error message telling the requestor "No Data Found"?
View 7 Replies
View Related
Jul 12, 2012
i already built reset button with this code but it is not working. i'm use this code;
Private Sub clearbtn_Click()
Me!qproject1 = " "
Me!qdoc1 = " "
Me!qvolume1 = " "
Me!qbox1 = " "
End Sub
it's any error in this code..??
View 2 Replies
View Related
May 5, 2015
I am trying to create a query that takes values from a search form and provides records. I was having issues with getting results when some boxes on the form were left blank. I found a solution to that and it worked with a small number of fields. However when I make the full form query (about 8-10 fields) and run it says the query is too complex. I wrote the sql as I could not get designer to do what I wanted. Attached is the sql that works and that which is "too complex".
View 9 Replies
View Related
May 28, 2013
I currently have a database which contains various information for part returns. Among this information is contained a parts tracking number, VIN Number, and Date Code. I want to have a small dialogue box (Form) where a user can enter a tracking number, (or a date code or VIN if tracking number unavailable) to search for a record containing that tracking number. I have already created a replica of my new part entry form to view parts in read only mode only.how to create small form to search for record based off criteria then open the replica form i have made to that record?
View 6 Replies
View Related
Aug 19, 2014
I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?
View 1 Replies
View Related
Mar 23, 2005
Basically I want to run a query that adds an index number against each record returned, however I want the index number to reset every time a name in a field changes e.g.
Date Name Index
01/01/05 Smith 1
01/01/05 Smith 2
02/01/05 Smith 3
04/01/05 Smith 4
01/01/05 Jones 1
03/01/05 Jones 2
01/01/05 Davies 1
02/01/05 Davies 2
06/01/05 Davies 3
07/01/05 Davies 4
As you can see the index is reset at each change of name.
Is this possible ?
View 10 Replies
View Related
Aug 10, 2013
I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.
View 4 Replies
View Related
Mar 25, 2006
Hi
Is there anyone who knows how to help me with this matter.
I have a form that I can search for first and last name in.
But when I try to do the same with the field for Social sequrity number I don't get it to work.
Can anyone have a look at this attached zip database and help me?
Sorry for the social sequrity number beeing named "personnummer" (it's in swedish.
//Mikael
View 2 Replies
View Related
Apr 25, 2013
I need to create a MemberID field that autonumbers and uses a prefix.
EG: YearJoined+0001
I want this as a the PK as well.I tried a default value Year(Now())&format([ID],"0000") but it gives me errors.
View 7 Replies
View Related
May 18, 2013
Id like to create a search field on a form, with a similar function to the standard Access 'find and replace' function. Only id like it to be alot more simple than the Access find and replace form.What i have is a Asset DB for the IT assets in the company i work for. We have a lot of phones, printers, computers and about 120 Laptops. The laptops are quite often reconfigured and given to new users, so the laptop details dont change but the user and software config does. I need to keep track of what software is installed where, for licensing reasons.
What i have is a simple form with the laptop name, serial number, operating system, software, location etc etc. What i would like to be able to do is, type a laptop name into a Txt field, hit a search button, then have the fields of the form populated with the laptops current config and then be able to edit the details from inside the form. ive tried using a combo box but i have more than 20 fields that need filling, so anybody whos used the 'me.txtboxname.value = me.combobox.column (1)' may know that you can only use 20 columns.
The default Access 'Find and Replace' system works fine but i dont want users to have to use it. I also dont want them to have to navigate through records using record selectors.
View 5 Replies
View Related
Aug 2, 2014
What I am trying to do, is create a time billing form to track time spent on different tasks, with the following items in a neat form, in this format:
1) Client
2) Employee
3) Rate/hour
4) Date
5) StartTime
6) EndTime
7) BillableHours (*)
I am able to make a form that correctly works lets the user enter records for 1-6, with the user pressing crtl+shft+; to give the correct starttime, and then at the end of the task, the user can press the same and register the end of the task.
My problem is that I can't work out how to calculate 7) as one needs to input some VBA code that converts date/time to numeric values, allowing you to calculate time difference. However, I simply don't know; a) the proper 'code' that will calculate the time different between 5) and 6). I saw that it was perhaps the dateDiff command? And b) where I would even put that code into, i.e. the exact location where one goes to and types the code into... Is it a query? Do you set it to a Calculated value in the table editor?
View 7 Replies
View Related
