Recent content by sivani_007

that's great It works now. thank you so much for your help

i keerp getting an error "could not delete from specified tables" I have a table with this data Main table bub|12345|1 bub|45678|2 bub|91011|3 Child Table bub|45678|2 result in Main table bub|12345|1 bub|91011|3 match from child table and delete from main table.. but i...

I have found the example of DoCmd.TransferText acExportDelim, "Standard Output", _ "External Report", "C:\Txtfiles\April.doc" but how can I export multiple query using that method , I have 72 files to export to text files.. this code works perfect to excute append query set rst =...

sorry I am new to vba.. can you please provide an example of how I can export 72 files query result in text files.. thanks

hi there, I was wondering if you can help me. this work great for me but is there anyway I can output all my queries result to text file. all my queries end with Export. Hope you can help. thanks

hi there, i used this function but i get this error Microsoft visual basic for application with cross and white background and it only has two button OK and HELP, doesn't matter which one i select it doesn't do anything .. how can i resolve this issue? thanks

hi there, I have now solved the problem i have copied the labels in excel and created the append query to append individual region to a main table and i have got the result i wanted.. Works just like i wanted.. thank you all for your inputs..

hi there,, it would be great if someone could give me step by step on how to create append query on this as i am very basic in ms access. thanks

hi there, Many thanks for your input i will have a go at append query and see how it goes..

Hello there, Wondering if anyone can please help me to figure out how i can normalized this data which has been imported from excel to ms access. Channel IslandsMalta UAE JordanSingapore 0% 0% 0% 0% 0% 0% 4% 5% 5% 5% 0% 12% 6% 6% 6% 0% 12% 10% 10% 10% 9% 12% 12% 12% 12% 12% 12% 12% 12% 12%...