Search results for query: *

I am trying to develop a database for keeping my microbiological results. My question is how to provide the user with the ability to define all the fields that he wants to be on a report at runtime. What I need (I think) is this: By pressing a button a form appears with all the available...

I need help how to design an invoice for customers applying for chemical analysis Each customer has specific price for each chemical substance Each customer can apply for certain chemical substances I have a table where the analysis is recorded : customer name, date, code of analysis...

I have a form which displays data from a specific query. What I need is to have an extra field on that form (calculated field but I don't need the value to be strored), which will show a specific value depending on the previous field (the previous field may have 10 different values) Is it...

I have developed an application in Access 2000 to record all the microbiological data for a laboratory. What I need now is to calculate the cost for each analysis (each analysis is consisted from many parameters with different cost for each customer. What I have so far is : Customer table ...

Please I need help with db security. I work in a chemistry lab and I have developed a small database in order to record all the experimental values from the lab work. I have placed this ms access file in a shared directory in a windows 2000 server. I have given permissions (directory)to 3...

Please help I have a table where I enter information about a specific microbiological analysis, tblDigmatol (DigmatolID, CustomerID, Date, etc) What I need is to have a calculated field in that table consisted from the above 3 fields together in one word (eg DigmatolID=23, CustomerID=AFGT...

I'm having a difficult time to make a text box to show the customer name from a table. I have two tables tblCustomer (CustomerID, CustomerName, etc) tblDigmatol (DigmatolID, CustomerID, etc) and I use a form (frmDigmatol) to enter data for each new analysis (to tblDigmatol table). The form...

I have a table where I put microbiological results. My problem is that for a specific field, which is number data type, I want to have the possibility of entering the value <1 or a specific word. Is it possible to use a validation rule in order to allow the specific text? What are the...

I use access 2000 and I have developed a specific application for recording and printing microbiological results from experiments. I use a specific form in the lab in order to record the results and then to enter them into the db. IS THERE A POSSIBILITY OF USING A SCANNER, TO SCAN THE FORM AND...

Please help ! I need help to identify records in a table as printed. I have a table with all the microbiological results from experiments. There is a form which I use to enter the results to the table. There is also a form with 2 combo boxes where I can select the number of experiments (from...