Search results

  1. M

    Not-able-to-print puzzle

    Hello, I have a local (C:\desktop) Access database which uses an ODBC connection for numerous queries/subreports which ultimately get pulled into a single overall main report. I am able to consistently print preview the main report. However, when I attempt to print (either to PDF or to...
  2. M

    dcount to find duplicates with ' (or ANY character)

    Hello, I am using the following to search for duplicate text strings in a before update event on a form. I just want to allow the user to be aware of the duplicate value...these values do not have to be unique. The user needs to be able to save duplicate values if they want. Private Sub...
  3. M

    newly added values in combo box

    Hello, I've searched all over for an answer to this to no avail...there MUST be a way to do this. I have a combo box that pulls account name data from tblAcctInfo. the combo box has an OnChange event which updates a textbox, txtAcctAddr. when i have a new account that i would like to be listed...
  4. M

    need to show subreport with no data

    good day, good people! i have a main report with several subreports. Some subreports have other nested subreports. all of the reports and subreports are based on queries. when a query returns no values, i would still like for the reports and subreports to display in print preview. (currently...
  5. M

    edit table based on query

    Hello folks, I’m hoping I can get some guidance from you good people. The short story is that I need a “checks” table that lets the user select check numbers that need to be printed. The "checks" table then feeds a report which lists all of the check info the user has selected. Once the check is...
  6. M

    DSUM criteria prob

    Hail and well met, friends! I am having a problem with DSUM criteria. I am new to working with databases and thoroughly confused by the use of quotes, dblquotes, brackets, and parentheses which I believe is the issue I am grappling with in this situation. I think that the answer is simple but I...
  7. M

    Noob I am

    Good day, friends. New to Access. Old hat and GIS and Excel. Currently attempting to develop a simple invoicing database. Hoping your knowledge will guide me. :confused:Mark:confused:
Top Bottom