Recent content by SidCharming

I found by using chr(13) it worked. Thanks for the tip, I will try that also. Sid from Minnesota

Mind if I add a twist to this... I have searched elsewhere and have not found a solution. How would I use the code above to replace or should I say place [carriage returns] using the find replace... I know I want [cr] after every ', ' {comma space} and the ASCII code for [cr]=13 Thanks Sid...

Same result as before... the value becomes '12/31/1899' when I use the rsCase("Compliance_FU6MFUDate") = Null rsCase.Update My guess is I need to capture the 12/31/1899 date and manipulate it in my records. Funny though empty going into the code and a date has to come out of it no matter...

I think I am on to something... You can not set a date field to a <blank> or NULL. I am finding that when set to Null or vbnull it always gives a value of '12/31/1899'. Any way to get around this? Sid from Minnesota

It is nullable in the table. I went in and manually deleted the value in a field with no problem. By default the value is set to 12/31/1899 to identify a known bad value. I want to remove it when identified as a definate blank field. Sid from Minnesota

I have... Dim rsCase As New ADODB.Recordset Dim dFollowUpDate as Date strSql="SELECT Compliance_SiteCodeUS, Compliance_RecordNo, Compliance_FU6MFUDate FROM tblCompliance" rsCase.Open strSql, CurrentProject.Connection, adOpenDynamic, adLockOptimistic Do Until rsCase.EOF dFollowUpDate =...

I have a general phylosophy to keep my queries simple in the effect that there is not more than one making the end result. In the case I am working on I have a table that I need to make a crosstab to get the patient on one row instead of numerous records. Example: tableFollowUp PATID...

I am helping myself and others at the same time... I am giving my 2 cents and looking for feedback at the same time. Kind of a different approach, but helpful (so far). Does the security wizard change the 'database' owner? because your method leaves the owner as 'admin', right? I don't want...

Okay, this is what I am finding: Build a private system.mdw (isolated from default Access installed) let's callit PrivateSystem.mdw. 1. Create a few accounts (User1, User2, Admin1, Admin2) 2. Create a new group: (DataEntry) Building a new secure db using the known good PrivateSystem.mdw. 1...

I have the separate mdw established and am using the shortcut I created to gain access to the mdb. Works great, but if I open the mdb directly (not using the shortcut) it opens fine. What am I doing wrong? I am missing something. Sid from Minnesota

Is there a tool that will take MS Access generated or manuall generated SQL code and format it neatly for printing? I am finding either I generate SQL code or have Access query do it for me. Once it has been executed as embedded data source in report it all crunches together and looks terrible...

I have a simular issue... In the code of a form (click event of a command button), I set a breakpoint for debugging purposes. After removing the breakpoint, it still stops there as if the breakpoint still existed. I tried recompiling and compacting/repairing, closing Access completely and...

I will try that also... thanks Sid from Minnesota

Thanks, I will give that a try... I am now excited to get home a PLAY... Sid from Minnesota

So would you not recommend a unidirectional antenna? Would there be any reason not to use one unidirectional antenna and one of the factory? Thanks for the parabolic reflector info. Sid from Minnesota