Search results

  1. C

    Creating a report based on crosstab query , variable columns

    Thanks for your reply i am very aware of what are you saying , but sadly the data base HAS to be this way ... the idea is to keep it a user friendly as much as possible since end user will have no idea how to create Queries and or reports .. so i have to give the user the ability to define his...
  2. C

    Creating a report based on crosstab query , variable columns

    Greetings i have been searching for a solution for hours ..but with no luck , i would really appreciate a help i have a crosstab query that will produce different results based on user's input .... so input A will give a query with 3 headings Q1, Q2, Q3 input B will give a query with 5...
  3. C

    copy records and related subrecords

    sorry for my late reply .. i got busy thank you all for your replies , i will take some time to check them later thanks
  4. C

    copy records and related subrecords

    Greetings all i am having a small problem i can't solve , i have been looking for an answer for a day but couldn't find any i have database build as a set of "Books" , each book has several drawings and each drawing contains several rooms (see attachment for relations details ) so i would...
  5. C

    AddContactFromOutlook command problem

    Greetings i am trying to use RunMenuCommand command : AddContactFromOutlook but i get this error message "The command or action AddFromOutlook inn't available now " on a demo access "project manager" it works but in my data base does not do you know how to solve this issue thanks
  6. C

    Conditional formatting, backcolor determined by color value stored in a cell

    thanks forgot to mention that is it a continues form ... so it has to do with conditional formatting what you suggested will change the color of the cell for all records what i want is to each record (Cell A) to have different back color depending on the correspondence color code cell...
  7. C

    Conditional formatting, backcolor determined by color value stored in a cell

    Greetings all i would like to know if this is possible using VBA ( or other method) i want to determine the back color o a cell based on a color value stored in another cell in other word backcolor of cell A = the value of cell B sooooo if i change the numbers of cell B (which is color...
  8. C

    how to give a user a limited time access to certain forms ?

    Thanks for you reply guys ... but it did not help ... thanks for the links , but again it did not work ! i kinda found a way to do it .. i am still working around it ...mean while , i would appreciate any help i can get Z
  9. C

    how to give a user a limited time access to certain forms ?

    Greetings every one !! it is my first time here i have a problem that i dont know how to solve ... i have database that i am working on , i want to give a user a time limited accsess ( one week ) to the reports section for example !! after a certain date he will require a password or the...
  10. C

    linking attachments using "DLookUp"

    Greetings .... i am new here ... hi every one ... i have a small question ... i made a data base to help running construction sites for our company ... one of the tables will contain the main information of the project ... name of project address Owner Main Contractor Consultant contractor...
Top Bottom