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...
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...
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...
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...
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...
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...
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...
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])...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.