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 Rhinorhino 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: *

  • Users: BRIANVH
  • Content: Threads
  • Order by date
  1. BRIANVH

    Basic VBA Question - Adding a field

    I am attempting a minor modification to VBA code used in an Access 2000 report, but I know little about VBA code. I added a field to a query used in the report, and I attempted to modify the VBA code in the report to use the new field. In this case, the VBA code just controls whether a logo is...
  2. BRIANVH

    Intermittant ODBC Connection error

    I have an Excel 2000 spreadsheet that gets external data from an MS Access 2000 query. The MS Access query gets some data from Access tables and some data from an ODBC data source with tables linked to Access. This all works fine some of the time. However, some of the time we get the...
  3. BRIANVH

    On-Open Macro in Excel 2000

    I'm working on an Excel Template that gets external data via an ODBC query. That part is working fine. I'm trying to make the template refresh the ODBC data (run the query) automatically when the Excel file is first opened. I am thinking I need an Excel macro that is set up to run when the...
  4. BRIANVH

    USING MS QUERY IN EXCEL

    Is there a way to have a cell in Excel control the criteria used in Microsoft query to pull data into Excel from a MS Access table (Office 2000)? In this case, only one record (row of data) is needed from the Access table for each Excel file. There will be many Excel files, created by copying...
  5. BRIANVH

    Descending Sort with Positive and Negative Numbers - Access 2000

    For some reason, my report is putting negative numbers at the top of the list in a column that is sorted descending and contains both negative and positive numbers. This is a sales by customer report sorted so the customers with the highest sales come at the top of the report. I modifed the...
  6. BRIANVH

    Form Header Data Entry

    Is there a way to allow data entry into the header of a form, or is the header strictly for printing?
  7. BRIANVH

    ODBC Link Table in Access - Changing Database

    Access 2000 I have a new server that will be dedicated to our ERP database (sqlbase), and I have a test copy of my database functioning on the new server. Now I am trying to get my existing Access Reports working off the test database on the new server. I tried changing (and also deleting and...
  8. BRIANVH

    RUNNING TOTAL

    Is there any way to calculate a running total in a query or report? My data has a beginning balance, planned usage by job, and planned purchases by Purchase order, that are unioned to a "Quantity" field. Somehow I need to calculate the projected inventory balance as of each date...
  9. BRIANVH

    Space character in Code 39

    I am a barcode novice trying to get a code 39 font to work in an Access Report. Everything seems to be working OK, except I can't read any barcode that contains a space character (there is a blank gap in the printed barcode). The report pulls from a large existing database that contains space...
  10. BRIANVH

    CONDITIONAL PRINTING OF OLE UNBOUND OBJECT

    I'M TRYING TO CREATE A REPORT TO GENERATE LABELS. THE COMPANY LOGO (AN OLE UNBOUND OBJECT) MUST ONLY BE SHOWN IF SPECIFIED CRITERIA ARE SATISFIED, OTHERWISE I WANT TO PRINT A TEXT FIELD (THE DEALERS NAME). IF THAT IS NOT POSSIBLE, HOW CAN I MAKE THE LOGO ONLY BE VISIBLE IF SPECIFIED CRITERIA...

Part and Inventory Search

Back
Top