Search results for query: *

On a form I have a combo box that lists counties. My next box list townships that are in the listed counties. Is there a way to limit the list you see in the 2nd box to only show you what townships are in the county that you selected from the first box? What I am trying to accomplish is if...

Yes, you are correct. I am searching on a single field to populate the form with the table data. I have moved the search box to the form header, but how do I get the tab stop to begin in the search box in the form header and not in the form detail when the form is opened.

Not being proficient at Access yet, could that be included in this event procedure: Private Sub SEARCH_CONTACT_Click() On Error GoTo Err_SEARCH_CONTACT_Click Dim stDocName As String stDocName = "SEARCH" DoCmd.RunMacro stDocName Exit_SEARCH_CONTACT_Click...

What is the easiest way to clear a form? I have a form with a search box. The search button runs a macro to pull in the information that fills out the form. If you do another search, I would like the form to clear before the search is made. I've tried the "setvalue" function of the...

I had the same problem with a report that I had made and the only way I could repair it was to copy and paste the report and delete the original. Hope it works for you.

Is there a way to use criteria with the Date() function so that it will show only the last 2 digits of the year on a form?

Thanks Jump That was the easiest and it worked!

Is it possible to make Access sequentially number new records inputed to a database thru a form without using auto-number. I have an AS400 database that I want to convert to Access. There are over 38,000 records with a unique contact number, but Access will not let me change the data type of...

On my form , I have a search button so that you can call up a certain record number and look at it's information. The search is performed by a macro on the button. But I only want certain people to be able to change any information they see. If I allow "no edits" to this field I cannot...

For some reason, now when I try to preview my report I get a message box that states..."The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank". And when printed, I get 2 pages with the second page blank. I checked...

I beleive I have it working. I placed the Dim appAccess as Access.Application as you stated. But it still ran the same. Opened quickly then closed. I then removed the same statement from the Dblclick event and it worked. Where ever I have the first section pointed...It will show those databases...

I have been able to get the first section of code to work by changing the .LookIn to my drive and file location. The form will pull in the databases in that location. Now....when I double clicked any database I received an "error 429". I click debug and the 4th line of the second...

As I understand it, I need to create individual command buttons on the form for each database. But I'm confused as to why I then need a list box on the form.

Can someone help me pull in information from a table that is older than 30 days from the current date. I need the criteria to use in a query. I want to find records that are older than 30 days.

Is it possible to build a switchboard to open different databases?. We have several seperate databases that we would like to create a central access point, but can it be done in a switchboard? If not, can it be done another way?

In my report I have 6 columns of information that is totaled at the bottomed of the report. The report gets a date range from a form, so the totals will vary depending on the dates you select. The report will always be contained on one page. But when you open the report the total number of pages...

=DSum("[total affected]","all outages board summary","[event]='bad underground' And [Outage Type]='L'"). I'm using the above expression in a report to look at a query to find the total number of customers affected by this particular type of event. There are about a...

I've created a report that is based on a query. In this query I'm pulling in a table field called "events". There are a total of 18 differnet type of events in this field. I've listed those events on the report, but now I'm trying to get a total count of each event during a stated...