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!

Register Log in
  • Congratulations Chriss Miller 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. manoskok

    select report fields at runtime

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

    How to make an invoice

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

    update a field during run time

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

    update a field during run time

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

    How to evaluate the total cost ?

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

    help - security

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

    How to add 3 fields into a new field ?

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

    How to add 3 fields into a new field ?

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

    Text Box Query

    It's working Thanks a lot for your help.
  10. manoskok

    Text Box Query

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

    Text Box Query

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

    Is it possible to have numbers and text as Field data type

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

    Is it possible to have numbers and text as Field data type

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

    HOW TO USE A SCANNER TO ENTER DATA TO TABLE ?

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

    HOW TO USE A SCANNER TO ENTER DATA TO TABLE ?

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

    how to tell a record in a table is printed

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

    how to tell a record in a table is printed

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

    how to tell a record in a table is printed

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

    how to tell a record in a table is printed

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

    how to tell a record in a table is printed

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

Part and Inventory Search

Back
Top