Search results

hi using this on a form on load event it poping error class does not support ... interface.. else on another pc with same os is running fine with no error.. the code is below Option Compare Database Public Function LogIN() Dim TempID As String Dim TempID2 As Long TempID = UserOnName TempID2...

heheheheheh :D its not the matter of FE and DE i think,, because when i am running this DB on that particular pc then module is not working even then...

In fact I just checked in that way that i took copy of DB from my mast location and paste that in user pc whereas the windows is same win 7 64 then i noticed that the vba is not calling from there as well.

It is stored in my Drive "E" It is single DB not splited one I have shared it with user (only one) who is access my shared folder in drive E through ethernet cable not wifi, he is opening the DB by a shortcut given to him from the master file in the shared folder

Hi, I am having a DB at my PC in drive D, iam using it fine, else the user is also using it fine but a form is associated with VBA and that is not runnging from user pc, i have shared db in shared folder and connectiion is through ethernet cable.

Somebody told me about asynch option would that help ?

Thanks for your precious Time dear.. I am telling you the fact that i have changed some thing in the code through immense googling... i am such a newbie in vba that i cant write cant edit thats why you .. :banghead: bcz i didnt got what you actually looking for.. it we really pleasure trip if...

Thanks for your time really!! here is the code... Public Function SendSMS_Text(message As String, number As String) Dim myURL As String Dim winHttpReq As Object message = Forms!send_sms.message number = Forms!send_sms.number Set winHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1") myURL...

Thanks i created a command buddon and put this on on click event everything is ok but when i click this it tooks almost 20 seconds to clear and during this i cannot click anywhere in access DB means showing busy.. or taking time is there any way to speed this up..

Great i got it and its working.. one thing is making trouble that when clicking command button it takes almost 1-2 minutes to work means it is sending sms but the whole database stuck for 1-2 minutes and you cant open close anything.. any idea for this..

how to call this function please elloborate i am stuck with it

Please tell me where to locate this in form.. Result = SendSMS_Text(Me.Message,Me.Number)

Apology straight a way!!! Any how i am very new to the VB and have some comitment from friend to make a project.. in that instance i made few different but same somehow posts in frustration or in hurry... sorry and thanks for all your support....

Hi Correct and apology straight a way!!! My dear friend and senior, i am really very newbie in VBA and i have taken a project from my school teacher, in that instant i know i created different but similar threads,, i really say thanks to all of you for your such support i am already have done...

Great it is working for me... please advise me how to fast this process as it seems to slow.. secondly i need to ask that i want this API to read "Message" from my Form textbox "Message" and mobile from my form SendSMS text box "Number"

here is the function Option Compare Database Function OpenDocument(ByVal strURLLink As String) As Boolean On Error GoTo Catch '' This opens the link in the default program or web browser of your computer. Application.FollowHyperlink (strURLLink) OpenDocument...

means run command of API

Any other option as this sms provider is my local and its my choice .. could you tell me another option to just execute web site on back end

I have a API given by my SMS service provider, now i added this API in DB with command button this web page is opening correctly and sending sms, now; i want if i click button so the sms must be sent but i dont want to open page more simple how to hide opening web page through this vba

//sendpk.com/api/sms.php?username=xxxx&password=xxx&sender=BrandName&mobile=xxx&message=TestSMS[/url] here above is the link i am sending sms... now i have a form named "Send_SMS" with two text boxes one is named "Number" where i am entering number (text field), second named as "Message"...