Search results

  1. D

    How to secure application ?

    I'm almost finished software, and I have to deploy now. I'm wondering, what is the best way to secure software ? Is MDE secure enough ? Or, is it possible, just like in VB , to create "dll" file, and to put code in dll file, and call it from forms, reports ? thanks in adv
  2. D

    SQL Express and MS Access

    ..pretty tough .. I have tried to use Access XP with SQL Express 2005, and, after 3 days, and a lot of read article on the web, where Microsoft even doesnt support Visual Studio 2003 with Express 2005, I decided to go back on : Access 2003 + SQL 20005 . It goes much faster, you can see all...
  3. D

    Send Matrix to SQL ??

    Access + SQL Keith G: yes, I use this combination : MS Access 2003 as Front End + SQL Server 2000 as Back End. I'm trying to make OOP application in Access, and .. it works up to now :) .. not all the features you can see in .NET, but, classes, inheritance, works fine .. So, now i do have ...
  4. D

    Send Matrix to SQL ??

    Does anybody has idea for following : I should send matrix to SQL from Microsoft Access For example : One Person has more Certificates , and table PersonCertificates looks like this: PersonID ----- EducationInstitutionID ------ Certificate 1 ---------- 1----------------------...
  5. D

    Insert null values into Date and Integer data type

    Problem solved Mark, Instead of using Dim PensionerFromDate as Date I used : Dim PensionerFromDate as Variant !!! and now, everything works fine PensionerFromDate = IIf(IsNull(Me.txtPDPensionerFromDate) ,NULL, Me.txtPDPensionerFromDate) Thanks a lot to Alan, from Forum ...
  6. D

    Insert null values into Date and Integer data type

    yes, Mark, you're right .. I don't have to have " = True" .. but anyhow, even if I put PensionerFromDate = IIf(IsNull(Me.txtPDPensionerFromDate) , vbNull, Me.txtPDPensionerFromDate) it stores some crazy date into the table. Not NULL Now, I tried also with "IsDate" function ... but...
  7. D

    Insert null values into Date and Integer data type

    still Nothing Thank you Mark, but for first Case (null into Date ) , just vbNull pass code, but, in field save no NULL , but 12/31/1899 :confused: for second Case (null into Integer) , VBA treats VBNull as constant, and puts "1" into Integer field, instaed of NULL .. :confused: ... can't...
  8. D

    Insert null values into Date and Integer data type

    Hello guys, Does anybode has any idea, of how to do that ? I can do it very easy in VB.NET, or C#, but in Access I give up. So, I have to take data from the form , and send it to Sub. With data type of String , I have no any problem, use Nz funciton, end everything, goes well. But with Date...
  9. D

    Send Null values in Date and Integer data type ???

    Hello guys, Does anybode has any idea, of how to do that ? I can do it very easy in VB.NET, or C#, but in Access I give up. So, I have to take data from the form , and send it to Sub. With data type of String , I have no any problem, use Nz funciton, end everything, goes well. But with...
Back
Top Bottom