Recent content by ahmedjamalaboelez

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...

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

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...

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:):):):):)

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...

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:

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...

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

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 )...

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...

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

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...

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...

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 ,

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