Recent content by ahmedjamalaboelez

  1. ahmedjamalaboelez

    prohibit save records before click save button in multiSubforms in one form

    good day every one , :coffee: 1st , i really like the new cool design of the forums,and i really appreciate your help in the following discussion🥰 subject : - for each data table in my database i use 2 tables to prohibit automatic save , Ex. one is (users) and the second is (users-mod). - both...
  2. ahmedjamalaboelez

    SQL Server Query convert to access query

    I already tried this, but resulted error , not recognized Sql |Of Access
  3. ahmedjamalaboelez

    SQL Server Query convert to access query

    Gentlemen, Company (IT) team provide me with SQL Server Query which result in sales query , no errors while running on our MS SQL Server Machine , i already linked required tables in my access database because i need to make more advanced reports , but i can not write this kind of queries in...
  4. ahmedjamalaboelez

    loop through table records

    Mr. ArnelGp this is attached Picture for what i wanted to do in my sample access database and before i publish you just wrote the code , :eek: really Iam very happy to see the result :eek:: really thank you , and thanks to every one reply to my post or even take a look:):):):):)
  5. ahmedjamalaboelez

    loop through table records

    i can be a loyal servant for the man who give me benefit information, because i appreciate the people who have the knowledge,:) i will not post there "utter access"any more ,:banghead: and i'm not in hurry :eek: and i really tried to to work with the code but my knowledge with access vba is...
  6. ahmedjamalaboelez

    loop through table records

    boss , I'm not manipulating i just want to get help , and because i am in hurry to solve it i just post it there in utter access , i have no knowledge of "crossposting " , :banghead:
  7. ahmedjamalaboelez

    loop through table records

    Mr. Adam , i never intended to waste time of you , but i really want help in this issue to solve , i try to delete from Utter Access but i do not know how to delete it i can not find delete button :D , iam not a vba-programmer iam just access beginner , i just inventory accountant and i got...
  8. ahmedjamalaboelez

    loop through table records

    boss really i tried but i cannot , iam not that well knowing with vba , i used to do it manually before entering to company system , but it takes a lot of time especially if iam need to issue 100 items in one invoice
  9. ahmedjamalaboelez

    loop through table records

    Gentlemen, good day i need your help regarding attached database i have 3 tables 1 - invoice lines 2 - store available loots ( every loot has its own cost) 3 - invoice usage material when i click invoice post button , i need loop event , to create records in table (invoice usage materials )...
  10. ahmedjamalaboelez

    Secure my database

    good day my friends, I have an access database , i want to protect it , then i searched on the internet , i found some steps , but they still can connect to the database and import tables and data , the following steps i made - Cancel bypass Key ( Shift ) - Cancelling Special Keys - Hide...
  11. ahmedjamalaboelez

    Prohibit Auto Save of MS Access form Data

    I tried this , But I can work in sub form before it saves ??
  12. ahmedjamalaboelez

    Prohibit Auto Save of MS Access form Data

    Good Day Every one I have a form contains 2 sub forms in "data sheet"Layout , But if mistakenly update afield then leave field of couple of fields , data automatically updated in tables before i click save button , is there is any way to Just update if I clicked save button ? especially for...
  13. ahmedjamalaboelez

    Remote Access to Database

    Heather , I was suffering of the Same Problem long time ago , but The Good News, there's a possible way , its fast solution with stable performance , - Use LOGMEIN HAMATCHI VPN NETWORK , I already Use it , so MS access database can connect Through The Real IP Of The VPN Network Created By...
  14. ahmedjamalaboelez

    Slow performance over network advice required,

    I think you should use SQL Server , that will save time and information , migrate your back end to SQL server , and that's will be good solution ,
  15. ahmedjamalaboelez

    Remote SqlServer Connection

    RANMAN256, Thanks for reply , But i Already tried , but It Takes Much time to bring data in addition to drop in internet problems ,so if i can control opening the connection and close with code that will be easier. Thanks
Top Bottom