Search results

Thank you very much sir albert. I have read your article and it did give me insight into what WAN can do and not do. I have suggested my business area to get me an SQL server ((after reading your articel))which would be reliable and to use the upsizing wizard (i use access 2003) and if not i...

Thank you for all your replies and so prompt. It give me a fair idea and of course i am studying your link for better understanding. Just one more question 1 If i create a space on the server and give access to that drive which is access across all groups (approx 30 users across 7 countries-...

Yeah it is very true of what you said. It has also helped me grow and keep my job during these tought times. Thank you all the people and the people who keep this site going and managing. Thanks a ton.

Hi albert , i have been reading your posts for some time now.i was also about to email today when ifound your post here. i was reading an article about splitting the database which people forget often to use. The article was awesome and thank you for putting up for people like us. NOw i have...

Hi darbid, I too come in the same league as you. Well i also found out a similar situation. I was doing my bit of research. If we have an SQL server then i can use the upsizing wizard to convert my mdb to sql and then distribute my mde to other people who will use it. I think it is the same...

Hi Darbid, My requirements (i need to put in the business case ) are a web server, and possibley a web page desingner. Is that all i require or anything else that i would be requiring for me to host my db on the web or on our company internet. Also after i complete my requirmentns i will need...

Hi Rommelgenlight, i think the link helps me. i am still trying it out. Just another question. Do you think it is a good idea to split the db and try out the said things in the link? Hi darbid, I will buy that book and see how much it can help and thanq for ur suggestion. Hi simon, I...

yes you are right saying that the updated data is to be required immediealty and that is what we are working at as that would decrease the time required to wait. We do have internet (our company has a dedicated connection). So can i paste the db in a folder and use it. Would it work or is there...

Hi All, I have a created a db which if it can be used by other countries (offices of the same organisation) would be very effective. The workflow requires other people in other countries to act on the db which would in turn be acted on by the people i work from. There is a common network drive...

hi what you said is right. i have written this code earlier. i did try using your code but for me .to etc... are not supported. I also am not aware if lotus supports .html or not? Finally i wrote a code similar to the one you supplied and it is working but body problem still persists. i am...

.CursorLocation = adUseServer .Open Str, CurrentProject.Connection, 3, 3 what do these steps actually do? i would love toknow them before i use.

i am getting the ouput as follows: field 1 field2 field3 field4 abcd 1234 oollok 5412 i want the above result to have rows and coloums. That would help. i have no idea how to output in HTML. tried but failed. i am putting my code below. If you can help that would be great. Also if the...

we can do that but the problem would be that you can get in text format and it would never contain rows and coloums. If that is ok let me know will paste the code. Here is the explanation. in the body of the email mention all the fields of the query you want to run with spaces in between. it...

how do i attach an result of a query without saving it anywhere. I mean once this is run i want also an query to run and attach it in lotus as an attachment automatically. Any Ideas?

Hi , Thank you for all the links. I thelps. But the main problem i am facing is unable to create rows and colums for the data that is being pasted on the body of the email in lotus. If any one can help pls???

hi all, i am trying to send emails through lotus frm access. I have been able to input in the body of the lotus the query results but i would like it have coloums and rows. I have no idea how to do this. i did a bit of reasearch and found that html would allow me but i could not figure how to...

that is how my management wants. THey are not interested in attaching but if possible to be able to send them in lotus with formatting

hi i am using lotus notes. when i tried your codes it says dataobject not found. i did some change like Dim olApp As Lotusnotes.Application but still the error persists. what i want is i have written a code where it runs a query and attaches the results but i want it formatted like in a table...

hi all, i figured out how to send emails to mulitple receipents but i would like to know why it is not sending out the mail. it stays in the mail and we have to click manually to send it. i am trying to send it through lotus notes. please find attached the code i have used.

hi, me too sorry. I designed the macro in macro express. Do you want me to post that code? i assume that would make no difference. That macro gets triggered with a hotkey called F2 or anything. I have also found a way to send email throug access with required data in it but i have few problems...