Recent content by OlcayM

Well, I found a solution on net. Just put "<br> instead of vbCrLf and voila. Sorry and Thanks...:)

SOLVED:VBA Code for vbCrLF for Memo RTF Field I have a wierd problem. Version: MS Access 2010. 1) A memo field with RTF enabled and Enter key behaviour as new line. Name: MemoField1 2) I have a button to add a new date to the beginning of MemoField1. Name: AddDateButton Code...

Allen Bowne Says That:) DLookup() can call the expression service to resolve an argument such as: DLookup("Surname", "Clients", "ClientID = [Forms].[Form1].[ClientID]") You can resolve the last issue by concatenating the value into the string: ELookup("Surname", "Clients", "ClientID = " &...

Thanks a lot UncleGizmo, You are absolutely right. I found the solution. May be it will help someone else also. The answer is API. It is below; OlcayM Author:Andrea Tincani Option Explicit 'API Declarations Public Declare Function CreateFile Lib "kernel32.dll" Alias "CreateFileA" (ByVal...

Hi All, I need to know the available com port numbers for a certain project. Just the prot numbers, like seen in device manager screen in system. And naturally I don't want to pay for an activex. Any ideas? TIA OlcayM

Hi, This link will help you a lot. http://support.microsoft.com/kb/311765 Olcaym

Hi, Some time ago, I used a software named "WEBDrive" for a similar problem. This software lets you MAP and IP as a drive like "F:\" . Then you work with your database like you are in a LAN. But, as far as I remember this had some restrictions. Otherwise, I believe that, it will take quite a...

Hi, If the name of the subform (name in the main form as subform , not the name of form itself seen as sourceobject) is "subfrm_datasheet_milestone" then But if the subform's own name is "subfrm_datasheet_milestone" but main form defines it as something else (like subFormA) then Please note...

"How to I duplicate though just the current record that the user is viewing?" This is not a problem Do you know how to create an append query? If not, send your database (if you feel comfortable and only the part with the problem) and I 'll try to solve and send back.

Hi, I recommend you another way of doing it 1) Make a query to append on the current record of main form, except link field. It seems you are assigning it. So during the run of the query, query must take the link field's value from somewhere you prefer (an unbound field in your form, or an...

There is a tiny problem Change "Function RndDwnII() As Double()" to "Function RndDwnII() As Double" HTH OlcayM

Hi, I know approx. nothing about ADO. I work wirh DAO and in access. But in your situation, I believe you first have to EDIT before line rsJobs.Fields("memo") = rsJobs.Fields("memo") & "My text here" OlcayM

I am really sorry, but I misunderstood. Mine is not a solution for your problem. OlcayM

Do you think rsJobs.find "JobReference= ' " & cstr(find) & "'" works? OlcayM

1) Create a form with a name "frmHidden" 2) Forms load event put anything you wish 3) Forms close event put anything you wish 4) Save & close form 5) Create a macro with the name "autoexec" 6) Use openform command in the macro for frmHidden 7) Set Window mode option "Hidden" 8) Save macro and...