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

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

FINALLY IT WORKS A BIG THANKS TO YOU. Your help has been very important. (I also unchecked the ADO feature in tools/references).

I use the 2000 and the line that is highlighted is rst.edit (the word edit is highlighted) Microsoft DAO 3.6 object library is checked and Ms ActiveX Data Objects 2.1 Library). Thanks again

Thanks again for your time. It seems I need a lot of work with VB I still have problem I added the line : rst.edit but now I get this message : compile error, method or data member not found What am I doing wrong ? What do I need to have in Tools/References menu ? I still get the type...

Thanks alot for your help but Now I get a type mismatch error I include the complete sub for advice : Private Sub Command5_Click() Dim db As database, rst As Recordset Dim strsql As String Dim criteria As String On Error GoTo Err_Command5_Click If IsNull(from) Or IsNull(Me!to) Then MsgBox...

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