Search results

  1. O

    If "Text"

    hello guys , i have a simple question and i hope to find a solution here , I Have Column named location which contains payment method (Bank "Then Bank Name)Or(Cash) i excel i used to do it as follows (If Location="Bank *","Bank","Cash") but in access i faced a problem in (*) i dont knw how...
  2. O

    Linked table issues

    Could you tell me how to protect db from clicking?
  3. O

    Linked table issues

    I dont want to link from data to salaries, cuz i wanna the data from (data) be protected, by another me the salaries user not be able to data from (data) db I think u named it back end or front end smth like that
  4. O

    Linked table issues

    Hey guys, I have a simple question, Can i link a linked table to database, To be more specific, i have a db named (data), i linked it to another db named (linked 1), i wanna to link (linked 1) to the third db (salaries), So is there any way to do that?
  5. O

    How to lock linked table

    Could you tell me what u mean by linked with MS SQL?
  6. O

    How to lock linked table

    Hello Guys, I have an inquiry and i hope that anyone can help me, I have a database and i import another database file as a(linked table), My question is there anway to protect or lock the linked table only (in another way to be read only data) Thanks in advance
  7. O

    Small issue in attached DB

    Thanks bro for your response , could you give me a specific code to copy it , because iam a beginner user in access
  8. O

    Small issue in attached DB

    Hello Guys , i have this small database with a users table and form , also account numbers form , all i need is a tool in (Acc Number query & Dimmed Acc Number ) Forms in Cells ( Entered by & Modified by ) shows which user has entered or modified account numbers i attach the database to be...
  9. O

    Build Query Headrs based on Table Cells

    Thanks Uncle for your support and collaboration , it will be a great favor if you create that video , Thanks again bro :)
  10. O

    Build Query Headrs based on Table Cells

    i Wanna to thank you for ur great efforts with me , Thx :)
  11. O

    Build Query Headrs based on Table Cells

    I Create it in both ways , Vertical and horizontal , i know that its kind of annoying but iam seeking your help guys to be able to finalize this issue
  12. O

    Build Query Headrs based on Table Cells

    hello , thanks for your answer , i bought that tool and iwatched the video , but i think that it wont help me to do what i need . :( , i think that its a hopeless case , iam so beginner in access , if you can guide me how to create what i need using transpose tool plz tell me :)
  13. O

    Build Query Headrs based on Table Cells

    Iam sorry for not being clear, all i need is a tool to generate a query with items for every company, For example : when i choose XE, it generates query with salary items i assigned to XE only Is that possible
  14. O

    Build Query Headrs based on Table Cells

    Hello Guys , I have a question and i hope to find a solution here , iam working to create a database to help my in my work , all i need is i have a lot of companies codes in a table each company has a specific items for example (Xerox : Basic Salary & Meal Allowance &Incentive) if i create a...
  15. O

    Increase Append & Update query columns

    Hello guys, I have a question and hope to find answer here, i have a query consists of around 50 column, when i create append or update query and start to select fields to uodate its only allow to append 36 columns. Is there any ways to increase coloumns numbers in the update query to able me to...
  16. O

    Filter report

    Filter report Hello Guys, I have a query with a data( employee name, bank name, company code) i wanna to create a report with a filter by company code and bank name.. To be more detailed i need every bank name to be in an individual report page. Is that possible
  17. O

    Filter report

    Hello Guys, I have a query with a data( employee name, bank name, company code) i wanna to create a report with a filter by company code and bank name.. To be more detailed i need every bank name to be in an individual report page. Is that possible
  18. O

    Filter query based on combo box

    Hello guys, i wanna to ask you a simple question, I have a combo box consists of a data linked from a company codes query, i wanna to create a button when i click on it its open my main query.(which consists of alot of companies codes.) bases on the input i choose from my combo list. For...
  19. O

    Combo list filter

    U mean, shall i use apply filter or set filter or select objective?
  20. O

    Combo list filter

    Hello guys, i wanna to ask you a simple question, I have a combo box consists of a data linked from a company codes query, i wanna to create a button when i click on it its open my main query.(which consists of alot of companies codes.) bases on the input i choose from my combo list. For...
Top Bottom