Search results

yes please.. if you have some samples of code for ado connection could be hellpfull for me.. thanks in advance

Any idea how to start text file on remote computer and to be seen on remote computer , not on mine...

I'd like to make noise to another computer, or start same sound file or simply to call another computer on lan or through vpn connected computer using vba... That will be nice if I can press button on access form and user on another computer hear some noise or to loo like it is call I...

it is working fine now.. thanks

I need to map drive on server which is password protected .... so i used this: persistent = false set objNetwork = WScript.CreateObject("WScript.Network") objNetwork.MapNetworkDrive "driveletter:", "\\server\sharename", persistent, "username", "password" but I get an Error 424 'object...

How I can check if connection to SQL server is established with VBA before the SQL is executed btw I use VPN connection to connect to sql server, and some times VPN connection is going down in middle of work and it is quite unconvinied

I want to connect to sql server using vba code THROUGH DAO without using odbc/dns I have this : Dim A As Database Dim B As TableDef Dim C As DAO.Recordset Dim mytable As String Dim constring As String Set B = A.CreateTableDef(mytable) B.connect = constring...

Finally I found solution.. it simple, so if someone need this here it is>>> 1.In Control Panel > Regional and language options> advanced tab choose the native language you want to use in language for non-unicode programs 2.In VBA editor choose tools>options>editor format> font which...

I found the way how to manage this issue , so if it is halpfull for someone here it is: Quote: Private Declare Function ActivateKeyboardLayout Lib _ "user32.dll" (ByVal myLanguage As Long, Flag As Boolean) As Long 'define your desired keyboardlanguage 'find your desired language at...

How to make vba to read and understand characters in other keyboard language e.g **************************************************** Private Sub A_AfterUpdate() If Not IsNull(Me.A) Then ' This is not understandable for vba and in editor is writen with ' unureadable characters If Trim(Me.A)...

Any idea how to change system keyboard lenguage with vba I tried changing keyboard property in the control property and it works but i need change in one control only, and if i change property it change for all contols after so i need code on exit control event to change the system keyboard...

sorry about my bad english :( anyway, there isn.t posibilities to choose pages when i open the thread but i found a way how to preview all replies I choose in display mode hibrid then linear mode and then I can read all repleis... I don't know why I can't see all replies whwn I open...

I'm not able to preview all replays to my posted threads in this site... for eg. if the tread has * replays i can see only a few of them... So i please some of the moderators to chack is there any problem with my account in this site Thanks a lot

Re: How to prevent from different date/time format on different pc You can force a format like this for your date/time field in a form or report... =Format([YourDateTimeField],"mm/dd/yyyy hh:nn:ss") but if format of [yourdatetimefield] is different from local date format...

that does not solve problem, i need to have my date format because a lot of command are based on one date format in code, so if i forse user to use other format it will make mass in all project ..... by the other side i can't force user to change his local date format because of my project to...

that's clear... but the problem is if i want to use date function on that format let's say that I've used this format : dd.mm.yyyy in some certain control and the local date format settings is: yyyy-mm-dd then if I use format(ctl,"ww") result is false or if i've write in table date in...

Any idea How to prevent from different date/time format on different pc I've heard that I should create my own system time function in VBA which will not depend from the local pc system date/time setting Regards

if i have subform shown as datasheet in the form, i like to have the last row to be in another color or to be shown as highlited or selected when the focus is outside of the subform

ok, thanks a lot and what about input mask..... when the entered value is different then it is required format defined in inpput mask how i can put my message ex : 000\-00000\-00;; if i enter 123-FGDSASG-00 I WANT TO HAVE MY MESSAGE

any idea how to get milliseconds in format time format(time(),"hhmmss.???")