Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mksmall

    Getting a combo box to auto fill next text box?

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

    CLEARING FORMS

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

    CLEARING FORMS

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

    CLEARING FORMS

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

    Report Margin Problem - Extra Blank Page

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

    Date() Function

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

    Numbering without "Auto-Number"

    Thanks Jump That was the easiest and it worked!
  8. Mksmall

    Numbering without "Auto-Number"

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

    NOT ALLOWING EDITS IN A FORM

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

    REPORT SECTION WIDTH

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

    Switchboard Building

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

    Switchboard Building

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

    Switchboard Building

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

    FINDING RECORDS BY DATE

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

    Switchboard Building

    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?
  16. Mksmall

    Access prints more than 1page

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

    Getting Acces to display "0"

    =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...
  18. Mksmall

    creating a statement to count in a report

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

Part and Inventory Search

Back
Top