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!

  • Congratulations bkrike 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. Apschminkey

    How to conditionally print subreports

    I am making changes to a commercial laboratory LIMS system that our company uses to track and report test samples. We have a document called a “Lab Sheet” which is used to document various pieces of information before the data is entered into the computer. Currently, to print these lab sheets I...
  2. Apschminkey

    Text Search Facility on Form

    I have copied part of a text search facility from: http://www.microsoft-accesssolutions.co.uk/text_search.htm onto an application that I have been working on. Originally it searched a field called strStudentID for a particular string and then went to THAT record. I am using it to search a...
  3. Apschminkey

    Trying to make a shopping cart-like form

    I am trying to design a form which can be used to order supplies for our laboratory. I have a table which contains a list of lab supplies (vendor, description, price, catalog number etc). On the form, I would like to first select the vendor using a combo box (I can handle it to here). I would...
  4. Apschminkey

    Erratic Results from MS Access Query

    Our company runs a Foxpro database to track laboratory testing samples. I have developed an Access application which allows us to retrieve infromation from the Foxpro tables. It was pointed out to me today that if the same report is run multiple times, even just seconds apart, some of the data...
  5. Apschminkey

    Using Aggregate fields in an Access Report

    I have created a query which produces a list of customers and their sum-totals (Expr1: Sum([price])of sales for a given period of time (using "where"). The datasheet view gives me the correct results. If I create a report based on the above query, everything seems ok until Access tries to...
  6. Apschminkey

    Linking pictures to forms based on certain data values

    I have an Access form which we use to input contact information for various people in our marketing database. Each of these clients falls into a certain category which is recorded by clicking one box in the "Contact Type" group options box. The selections are stored as numeric data...
  7. Apschminkey

    Can an Access Application run without Access Windows

    Can someone tell me if it is possible to run an Access application as a stand-alone program without the various menus and "stuff" that comes up when you open the MS Access program? I'm not a REAL programmer so I apologize for not being able to speak the language well enough to ask the...
  8. Apschminkey

    How to count Number of records in group footer?

    I am trying to create a counter which will return the number of records which occur in a particular group. So far I hace created a text box called "Counter" and set the control source to =1. In the group footer, I have created a box where the control source is set to =sum([counter])...
  9. Apschminkey

    Cannot located requested xbase memo file.

    I am trying to write an access application to pull data from our Foxpro database system. Whenever I link to a .DBF file, and create a form, it tells me that it "Cannot locate requested xbase memo file". Can someone tell me how to fix this problem? I am using Access 2000.
  10. Apschminkey

    How can I count the occurances of a string in a report?

    I am setting up a report which summarizes company activity for each calendar month. It includes a list of "samples" which were processed as well as the "department" in which they were done and the "price" for each sample. What I would like to do is total the...

Part and Inventory Search

Back
Top