Search results

I have a form that has three dropdown choices. All the choices are fields from the same table. My search works if all three boxes are used, how do I make the fields optional so if a person only wants to search on one or two of the choices it will run the search??? I tried to do this is vba...

Is this possible? I want to create a combo box that list all the field names of a certain table. The purpose of this is to create a select query where the user can choose what fields are to match up in between two tables one being static and the fields from the other being dynamic to see if...

I have two tables with an ID field in both and a last name field in both. I want to compare the two tables and see if the last name fields are similar in both tables by ID (the ID is unique). In one table the last name is one word whereas in the other table the last name field has (lastname...

When i import reports into a different access file, all the functions such as Date(), Trim(), and Format() do not work. Anyone know a fix to this??? -Kate

I am updating one table with data from another which works fine using append and update queries. But I was to change all the 'ROAD' AND 'CIRCLE' etc names in the address fields to abbreviations, such as 'RD' and 'CR'. I know this is super easy in different update queries, but is there a way...

Ok this is kinda tricky... I have ID fields for houses, example 67-4-48 1)first number corresponding to city 67-4-49 2)second to street 67-4-50 3)and third to actual house 67-4-51 (In that format.) I want to be able to run a search on them say houses in...

I have a table with over 12,000 rows. In this table there is a date field. The dates range from 1973 - 1999. I want to add another field, almost like an autonumer field, but I want the numbers to start over for ever date. So 1973 will have 1+, 1974 will have 1+, etc... Is there any easy way...

I want to create a query that retrieves all records (name and address fields) that fall between a given date range. Some of the records will show up more than once. I want the query to only return the record one time. The problem is that the users who entered the addresses didnt enter them...

I have two tables that are linked in a many to one relationship. They are linked by ID number. I want to create a report from the main table then show all the value that go with it in the many table. For example, In the main table I have: ID = 1 Name = Kate Address =...

When you have a dropdown box for a field in a table how do you make it that only values that are in that dropdown box can be entered in that table. Right now my table works so that you can either pick something from the dropdown box or type in your own. I dont want my users to be able to type...

I have a really long report that wouldn't fit into one report file, so I had to break it up into two reports. When I preview the main one and hit print I want it to print both the main report and the other one that is a related to it. I tried creating a macro but then when I hit print it only...

Is it possible to only lock only one table in a database, either to be not viewable at all or passworded. Or is it all or nothing?

I have two tables. One is a permit table and the other is a fee table. The permit table contains all the data about each permit and the fees table contains all the fees broken down. So for each permit you can have 3 records of fees in the fees table. The report I want to create would contain...

I have a main form with a combo box on it that has ID numbers in it. On a subform I have a results datasheet. When a person chooses a new option in the combo box, the results change using me.requery. My only problem is that the first record in the query is always displayed no matter what the...

Im trying to create and update query that will extract the state out of an address field, the address field containing "city state" (no comma). I have been messing with the instr, left, etc.. functions and I cannot seem to get it right. The closest I have gotten is using ...

Im trying to combine 3 databases into one. Everything works fine when imported in, such as the queries and reports. But none of my forms work. I get a Network connection lost error for some. And others my code behind my events is lost in the import. What am I doing wrong?

Say my control for a textbox is : = "Title" & Date() How do I get it to show up on 2 lines, is there a 'next line' keyword? I want my output to look like this: Title Date (I know this would be really simple if I just made 2 separate boxes, lable and text, but my control is actually...

I have numerous reports that are used for different clients. At the top of each report is says the client's name. Everytime I run the reports for a new client I need to go into each report and change the name which takes about 2 hours. Is there a way to make some type of global change...

Im running a query that sums the costs occuring from 1/1/2003 to a year entered by the user in a form. So right now the critieria in my query looks like this: between #1/1/2003# and [forms][myForm][date2] Which works fine. But i want the query to work for any year, right now it will work for...

I want my report to show zero values for all values there is no data for. Problem is that when my queries return no value there is no row at all, so i have no null values to work with. (this problem is in the summary fields, where there is no data for the month the report is generated for)