Recent content by shadowmaster

hi. lets say that u have a folder contain photos or songs or what ever. and this folder is located in ur hard drive. now can u make a back up copy for this folder from access? i mean run an access form that contain code to back up this folder to another location thanks

man am in hurry :D and here is the code i found Dim intLoop As Integer Dim strMemo As String Dim strOutput As String Dim varLines As Variant strMemo = Me.MyMemoField varLines = Split(strMemo, vbCrLf) If IsNull(varLines) = False Then For intLoop = LBound(varLines) To...

sorry am using access 2003 and here is a sample

hi all i have 2 forms - main and sub_ the main form have a memo field called ph include date follow by some data. am trying to extract the memo field into the sub form. that every line in the memo field will extract to 2 parts the date part and rest of data part. i found some code that count...

u can do this by VBA code DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

thanks bob thats logic but the reason why i did the tables like this is the old data. there was an old access application with around 19000 records for a GP private clinic. and the old data ooh (dont let me start). so i cannot make an auto number fields cause we need the old data to have the...

it really shows that i need help so any Ideas?

Good day all. am a beginner in access and here is what am facing. in the pic attached is 6 tables u will figure it when u see it. the 3 tables in the bottom had data that will be repeated. patient for example can have too many visit and so on. the Issue is what is the right relation between...

thanks DCrake appreciate ur response. if i load the tables with few data would it be possible to help me? thanks again

Hello everyone, i made small access 2003 application, it contains 6 tables 3 of them had a primary key which called "patientno", the other 3 contain the same field name but not as a primary key. the main form i have is called "Patient info" it contains 3 sub forms (the ones with out the primary...