I am trying to set up a query by paramater to then base a report on.
For example, I would like to input a location name to get a query to only display the records for the specifiied location and the accompanying data for use in the report.
How do I do this?
I have tried using the [Enter .......] type command but I either get zero or I get the full list, which is no use.
I'm not sure if this is a syntax problem or not, but:
I am trying to design a parameter query using a form for entery. The trick is that I am trying to use a wildcard in order to select the data for one of two job sets.
My job number format looks like this: 06-07-123 or 07-01-006 I can get the query to work without the wildcard by using anexact number, but I am trying to pull all the jobs that begin with "06" or "07" (but not in the same query).
In my query, I direct the query to get the records based on the data from this field: Forms!frmDRSNoInput!txtDRS1.value
I have tried using the wildcard as follows: Like "[Forms]![frmDRSNOInupt]![txtDRS1].[Value]*"
Additionally, I experimented with different possibilities, but as you can see, I wound up here.
I have numerous reports based on queries with a criteria date select string. So when I Preview the report I first get asked "Enter start date:" etc.
In all reports I have entered a text label with date control source stating "=[Enter start date:]" to have the start date parameter value printed on the report. All straight forward up to now. Anyone have an idea why with some other reports when I enter the exact same code the report preview text label renders "#name?". I don't get it?? So I thought maybe I should change it to something completely different. "Start book date". I changed it for both query and report label and still get "#name?".
Completely clueless and I have rechecked them all. The labels are all consistent with the criteria string in the query.
Hello, is there any way I can have my single-parameter query bring up a lookup list of options from a table field rather than relying on the user to correctly type in the criteria? Then when this query runs I will know the user is picking one of the correct options from the lookup list.
I currently have a database with a few search forms. I recently attempted to add a box on one of my search forms to search 3 cells of a record for a key word. What happens is when I go to search, say for P0442, it does not bring up all of the records that contain that keyword in the 3 cells I have outlined. If I step down the code in the OR boxes of the query, it seems to work better but then for some reason my other search criteria , (Tracking number etc) does not work. I will upload the database for reference. I am currently working on the Search(View Only) and that is where you will find the query to work on.
I have a problem with my database I have a combo box that will search for my record. Actually its working I input the specific number it goes to the specific record. But I want, if there no existing record in my database it will display a Messagebox that "No record Found" I try to put a code in a macro builder in a after update property field but nothing happened.
Expression code that it will display the msgbox if there's no record found.
the given code from macro builder is attached. I try to have an if else statement but I dont know how to not equal that giver conditional expression.
I have recently purchased a spreadsheet from the county tax assessors office that I will use to search for comparable property values for properties I am looking to purchase. This spreadsheet has over 100k records in it. I have created a table for this in access. Now I am wanting to create a way to search for properties in a specific "Neighborhood #" that have been sold in the past 24 months. I am not versed in Access, so I will need a step by step approach.
Each record in my table contains a "Neighborhood #", "SALE_MM", "SALE_YY", and "SALE_PRICE". I would like for my search results to contain all of the fields for each record it finds.
very very new to access so if what im saying is way off or wrong, keep that in mind. i'm actually learning this as i go, tiral and error.
ok for my issue. i'm trying to create a search where i could look up someones history of drills, and tests by their ssn. i have a form made where the user will input personl info, date drills were completed, tests were passed,etc. i'm wondering if it's at all possible to search for an individuals "records" if they need to update a test they passed that they previously failed. so i guess search for a record for editing. i dont know too much about VB or if this sort of thing even requires the use of code. if more information is required, i will post what is needed like i said, i'm a n00bie at this. any and all help would be greatly appreciated. thanx.
I have a form / subform. The form has a memo field. I have 10,000 plus records in the Form table. Each time I make a correction in two or more of the fields, I get the error: The Search Key was not found in any record error. For instance, I can even manually tie a many to many relationship in a join table without an error by adding a new record at the table level but I can't do this in the form. In neither place can I change the memo field more than once without this error. What resets it so I can make one more change is to Compact & Repair Database. A hassle and then some. :(
I have 2 table in ms access (Table A and table B).I am doing a search function which able to search the record on this 2 different table. how to do that? how to set the source?
Here is the coding for me to search record just only from Table A but i would like to make it search on Table B as well.. :confused: Private Sub btnSearch_Click()
Me.frmsubTableA.Form.RecordSource = "SELECT * FROM TableAQuery1 " & BuildFilter
' Requery the subform Me.frmsubTableA.Requery End Sub
I just want to create a search on my form where i input a date, and then press a command button that will jump to the first occurence of that date in the table. I don't want a filter, since that just excludes all the other data without that date. I tried playing around with FindRecord and GoToRecord, but to no avail, due to my limited knowledge. =P Thanks in advance.
I have a search form containing an unbound text and three search button. You can search by customer Number, Last Name, or Order Number by entering customer#, last name, or order# and clicking on the appropriate button. The problem I'm having is to get the value (either customer Number, Last Name, or Order Number) from the unbound text called txtSearch to find a matching value then open the second form called frm_CustomerInformation containing those value.
This happens after a) I update an access Memo field, and b) query the record for re-display.
The only way I've found to resolve the problem is to compact and repair the db, but does anyone know what might be corrupting the data in the first place? The submitted text included html tags.
I am having today is that after making my database into an accde and putting it in a shared location for someone else to run it. The Error search key was not found in any record appears. Then macros single step, stop all macros appears and what ever I press from here crashes the database and it wont open.
May I know what is the easiest way to search for records using 2 fields wich are not primary keys? and then return a boolean value whether it is found or not...
These 2 fields are of integer type.
Recordset.Find can only find record with one field and not two.
I am trying to build a form that allows the user to INPUT stock as it arrives. This is simple with a product form that shows all the products in the table. I just go to the quantity field and change it.
But, I want to create a 'search' function in the field. I want to allow the user to type in the Product number. Then the Product name, Product Price and Quantity is AUTOMATICALLY displayed.
The user can then change this value (items in stock).
Another totally newbie question here but I'm still trying to figure a few things out. Leave it to me to dive head-first into something without first doing research.
In my database I have a main form where I enter records for customers. Now, I also have a second form that is used to search for records. In this second form I want to be able to first filter the record search with a drop down menu that searches by items such as address, customer name, or city, etc. That way if the person doing the search doesn't know the name of the person they can search by address or vica versa. Once the user selects the search type they enter the name, or address, or whatever they're basing their search on and then click on a "Search" button. I have this button working so that it opens a report with a table which shows all the records pertaining to that search.
My first question is how can I get this to work properly because right now I keep getting the results of past searches, in fact I think it gives me all the records rather than the ones I want.
Once I figure this out, with your help, I'll have another question for you. hehe
I have a continuous form based on a query. In the form footer I have placed a text box and a command button. One of the text boxes on the continuous form is bound to the VIN field in the query. I would like the user to be able to place the last 8 digits of a particular VIN in the text box in the footer and click the command button to bring that particular record to the top.....
I'm creating a database for work to do with health and safety. What I'm trying to do it create a form, where I search for a certain employee (by surname or id) to add a new record against that name.
I've got an employees table and a tool box talk table, they are linked by NI Number. This is what it looks so far (although the records are showing in the form).
I have a split database where the front-end links to tables in two different back-end files. (access 2010).Then, there is a lookup field in back-end#1 that looks-up a field in back-end#2. It's all been working. But... The customer wants to be able to store multiple values in that lookup. I went into back-end#1 and changed that field to allow Multiple Values and saved it. When I opened the front-end and clicked on that table I got "the search key was not found in any record" no matter what I tried.I was able to go back and delete that lookup field and recreate it w/o allowing multiple values and it's working.Is there any way to accomplish what it is that they need, the multiple values?
I have a main form "Furniture_CatCodeAssets" which shows detail specifics about certain furniture item codes (width, height, colour etc.). I have a subform "Furniture_AssetsSubform" which shows all of the asset numbers associated with that furniture item code.I have a combo box that allows you to filter by furniture category, that then updates a list box that shows only the item codes associated with that category. When an item code is selected in the list box the main form and the subform update to show what was selected. (I mention this only in case it is causing an interruption - they work perfectly.)
What I am trying to do now is add a text box and button that will allow you to search in the subform to find a specific asset number and go to that item code on the main form.
I have the following code on the command button: Set rst = Forms!furniture_CatCodeAsset.Furniture_AssetsSubfo rm.Form.RecordsetClone rst.FindFirst "[Asset Number]=" & Me.textSearch If Not rst.NoMatch Then Forms!furniture_CatCodeAsset!Furniture_AssetsSubfo rm.Form.Bookmark = rst.Bookmark Else MsgBox "No match found, please check your asset number and try again." End If Me.textSearch = Null rst.Close Set rst = Nothing
Which returns the message box that nothing was found even though I know I that asset number exists.
I have recently built a database to keep track of all the inventory counts for our technicians. This process was originally in Excel and they wanted to move it to Access in order to automate it. They have also decided that they still want to maintain the original Excel schedule by adding dates each time a step is completed. I currently have code that will go to an existing spreadsheet and add data from the database URL... I was wondering if there is a way to modify this code so that it will look for a specific name in the spreadsheet, go to the end of that row and enter today's date.If so, what modifications would need to be made to the code to get it to work?
I have a form with a Lookup method. I have it set as this:
Code: SearchStr = FilterSearch & "(tblCalls.CustFirstName LIKE " & "'" & txtSearchBox.Value & "*' OR tblCalls.CustLastName LIKE '" & txtSearchBox.Value & "*')"
This will allow the user to search for a record by first or last name. But if they try and search with both it will not return anything. I need to to be searchable by first, last, or both.
