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...

In case anyone ever wants to know the answer to this, its really simple and I feel dumb for not figuring it out before i posted. In the properties menu of the list box you want the field names to be displayed in 'Row Source Type' choose 'Field List' and 'Row Source' the table the fields are from.

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

Oh, and Access 2002 SP1

It is a set amount, I think there is like 8... ROAD CIRCLE DRIVE WAY COURT RUN LANE PIKE and STREET

Im not too familiar with VB programming, so I wouldn't know how to code that.

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...

That concept seems like it will work. How do I retrieve the house number if I am not sure how long it will be. It could be 1-4 characters long. Is there a way to retrieve anything right of the second "-"?

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...

Well here is the problem with what you did. 1) I tried putting everything into the details section with pagebreaks, but it is too long to fit in the space allocated for the details page, so I had to make 2 reports into it. 2) I am not using a form so I cant put code behind a command button. For...

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...