Search results

  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

    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...
  3. 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 )...
  4. 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...
  5. 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...
  6. ahmedjamalaboelez

    Remote SqlServer Connection

    Hi Every Body, I really need help in this , I Have remote SQL Server 2017 Database on GEAR HOST , and i need Sample code to connect to this Database and Drop This data to Text boxes in my form , I appreciate your help to find sample code to connect to this remote database and select data and...
  7. ahmedjamalaboelez

    InitialiseEvents problem Plz Help

    Private Sub Form_Open(Cancel As Integer) InitialiseEvents Me End Sub Quesion ! when Run this Function on form all form ctrls affected but not Subform ctrls plz help ??????? what Could Change to apply it on Subform Ctrls ????? Public Function InitialiseEvents(frm As Access.Form) Dim...
Top Bottom