Recent content by TipsyWolf

thank you very much, Sir !

thank you very much @LarryE ! i really apricate your effort and time u spent on it !

WOoooOW!! let me test it in a few hours :)

thank you guys for your advices. its always good to have expert advices. some of them i use , some of the dont because of my skills. but i just completed a huge work for me ! i managed to import 4 Excel tabs to Access with all PKs generated correctly. HUGE work for me and i woouldn't even...

guys ! i found the way to make it with 1 click ! so i created 4 queries. i tried to merge them into 1 query but failed. i found this vba and change it so it would fit me Private Sub SYNC_test_Click() On Error GoTo ErrorHandler ' Start transaction DBEngine.BeginTrans '...

but how ? i can't sync if i keep sequential autonumber. at least using append as i have 4-5 tables are linked oh, wow. really . will play with it.

unfortunately sql server is out of my league... too complex for me. it requires programming skills which i obviously dont have. i can't even handle access its 10% capabilities i just tried to sync data using append from 4 tables in a sequence it should be. main table, sub table 2x subsub...

do u think random long integer isn't enough ? i looked to remind myself whats long integer is ... it means negative 2b up to 2b.. that is 4b... it has almost no chances to catch duplicated ID with small team. i was thinking to make autonumber random for online and offline backend and try sync...

quantity - there are 15 frontends but only few of them will be doing offline entry data. and rate would be once per month, so its not frequently and i plan it to be like backup plan. no, 1 entry affects 5 tables so far. later it could be up to 10

no, my offline bd is not meant for editing existing records. i would like to make it very simple for 100% replication without any error \ collusions. so no editing to existing records. i would even prefer to keep offline backend completely empty so i \ my user dont mess with existing records...

hey guys ! I have a split db with around 12 tables and im wounding what's best solution for offline use and later sync with minimum actions. im picturing it like i would keep my offline backend empty. when im offline - add records to many tables. once im online, "sync" so all my new records...

yes, if i call him or standing just in front of him - i would use his name and middle name. middle name is MUST to give him a sign of respect. no doctors, no misters. just his name and name of his father. he can be a doctor, but its nothing more than just his job title that's it. Father's name...

we dont use it really in my country \ culture so this would be useless in this db.

i tired almost dozens of design structure and this works for me like it should with no mass records in query because i did bad job with relationship set up.

i will try to change field type where its possible to optimize it. when i know its responses like 1 to 9, i set it as "byte" so it doesnt take too much space and run queries faster i guess.