Search results

  1. A

    Table doesn't read combo box info correctly

    Many thanks indeed namliam I will try this one. take care Abbosy
  2. A

    Table doesn't read combo box info correctly

    Hi namliam, I'm sorry, I still don't know where exactly to do this if not in the relationships window. I'm still confused. Regards Abbosy
  3. A

    Table doesn't read combo box info correctly

    Thanks a lot namliam, Joining two tables is this happening in the relationships? If so, they are already joined, if no then where I need to do it and how? I really appreciate your help in this matter. Best regards Abbosy
  4. A

    Table doesn't read combo box info correctly

    The answer above is going what I wanted and everything is working correctly. There is another problem occurred here and that is when I try to filter in a query by any record set that is based on a combo is not returning anything. When I initially worked with the form, it saved the information as...
  5. A

    Table doesn't read combo box info correctly

    I have found the answer in the Thread called " "Text Value" to a Table from a Combobox instead of "ID" " and it did work for me very nicely. Regards to all Abbosy
  6. A

    Return "Text Value" to a Table from a Combobox instead of "ID"

    Re: Return "Text Value" to a Table from a Combobox instead of "ID" Thanks very much boblarson and veraloopy, You helped answering my post dabbed "Table doesn't read combo box info correctly" I changed the values in the query and everything is working the way I wanted it to do. Many thanks...
  7. A

    Table doesn't read combo box info correctly

    I have a form "FrmMaintenance" based on the query "QryMaintenance" that is taken information from the table "TblMaintenance". In the form, I have to pull the serial number of a machine from a drop down list which works perfectly fine in the form and it also updates other associated records...
  8. A

    return info to table after processing

    Hi there BlueIshDan, Thanks very much for your reply to the msg. I have tried this (and will keep trying) but for some reason it didn't work; may be it was something wrong in the format of one or more of the fields. There used to be a button to click on it and say thank you, but I couldn't...
  9. A

    return info to table after processing

    Hi there forum, I really need your assistance with this problem. :confused: I have a table (tblInstallations) which has records of date installed (for machines). It is calculating that "next due maintenance" is one year after installation. Sometimes we need to visit the site to maintain or...
  10. A

    Security on Attachment

    Thanks very much. I appreciate your help
  11. A

    Security on Attachment

    Hi namliam, I really appreciate your help and suggestion. This again can apply and be useful to people with read privilege who won't be able to bring this option to be unhidden. What about rest privileges owners? I was trying to set password on it and that worked nicely up until checking the...
  12. A

    Security on Attachment

    :( Hi there guys, I have added an attachment button to a form. Everything is working fine. I was just wondering if I can add a security like a password to this button (Attachment) that would prevent users without permission to get to see the attachment. When you click on the button you can...
  13. A

    Append just current record into a table

    Hi there again guys, When I move through the index on the CallOuts (One), i.e incrementing then it changes the serial number in table WholeHistory(Many); it shows how many serial numbers but it doesn't show rest of the fields. I put in CallOuts all the fields there, and in the WholeHistory...
  14. A

    Append just current record into a table

    Hi Muna, Thanks very much for your reply. This is a good question. How can I find out if it is? :confused: Thanks
  15. A

    Append just current record into a table

    :banghead:Hi guys again, The subform worked very well, but it didn't give me what I wanted. I linked serial numbers of the form (One) to the form (Many) and it as I wanted but its not like what I expected. What I wanted is to let's say put the serial number in the FrmCallOuts (the one side)...
  16. A

    Append just current record into a table

    I assume this should do. Thanks very much for your help
  17. A

    Append just current record into a table

    Because the first table (installations) from which all the information are taken into the second one (CallOuts). The installations has a serial number set to unique but the call outs is set to can be repeated (indexed duplicates yes). Obviously in the installations each machine has its own...
  18. A

    Append just current record into a table

    Hi there guys, I am trying to open a form with some records taken from one table, then alter couple of data in it and after that most importantly to append current records into a different table. The reason I need to append is that I need to keep track on every occurrence on same fields. It...
  19. A

    Updating Records between two tables

    Thanks very much plog
  20. A

    Updating Records between two tables

    It is a simple calculation that adds one year to the existing date of Maintenance and off course the calculations will be stored in the table "tblPreventativeMaintenance". Now when they go to table installations, I just need them to see that there is a date set for next service. Also when the...
Back
Top Bottom