Recent content by manoskok

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...

Dear GingerR Thanks a lot for your message. I have tried the iif statement and works fine for 2 options. My problem though is more complicated : During the recording of the data I have 20 different types of food which is easy to select from a combo box and then the data is stored in the...

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...

Thanks a lot for your help on this. My idea was to have the db to construct automatically a specific field in order to identify each analysis in addition to the table primary field (DigmatolID). Thanks again.

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...

It's working Thanks a lot for your help.

Thanks for your answer. I did that but I don't know how to set it up in order to show the correct CustomerName for each CustomerID. The CustomerID has control source the tblDigmatol. While the combobox has to take the CustomerID from the tblDigmatol and find the Corresponding Customer Name...

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...

Thanks for the help. Is there an easier way, because I have more than 20 fields in the table ?

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...

Thank you all for the help. I will try to get some information about OCR. I don't know how easy is to scan a form and then use it as a template, for scanning hand writing.

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...