Recent content by scasystems

Got a table with primary key ranging from 1 to 3000 Need to find unused numbers between 1 to 3000. How?

Johnwm Only just found out above giving stars. will do so in the future. Sorry for taking so long to reply. been busy

My point entirely!!!!!!! Since deploying our package onto various operating systems/office versions etc we ran into this problem. It has something to do with the version of mdac_typ.exe. I have another machine exact same specs and works fine. The only diffrence is this machine has mdac_typ.exe...

Developed a system using access. with vb front-end. Come against a problem where sql query is coming up with :- Function is not available in expressions What seems to be the problem is access is not recognizing basic expressions of left, mid, right, trim, date Have attempted various versions...

P.S. This has got to be the NO 1 site for finding answers to coding problems. Most of my queries have resulted in answers/solutions. The only one outstanding is the Binding to a DtPicker control? I have got around this by using a non visible text box which is bound to the date field. Not elegant...

The only third party software that we have purchased is mappoint for displaying locations of sites. I do not belive in purchasing third party code/controls I would rather have ALL the source code under my control. The information for coding, whatever the subject, can be found and incorporated...

StrongM Found code on the net about using the advapi32.dll, which has functions for among other things creating hash keys. I think it was in CodeArchive or VB2theMax sites. There is no uncrackable system out there. What we have done is make it VERY difficult for our clients to bypass. To be...

There is a serial number / pc name. So what I am doing (and its working fine)is using the filesystem object (as mentioned by paulbent (cheers)) and getting the serial number. If this is less than 3 chars then i use the computer name instead and incorporate this into the hash encryption cheers...

I wish to incorporate a licencing scheme. (already done this but using computer name) is there some way of getting the computer serial number to incorporate into the licence key

I am binding textboxes to a recordset and everyting is ok using this method Except when it comes to the DTPicker which doesn't bind it gives Run-time error 545 "Unable to bind to Field or Datamember 'Expiry_Date' I use the Tag field to set the Field_Name of the control to bind i.e...

cheers guys i feel like a fool!!! Already had done that in another section of code and forgot :) one of those days

I have a routine to set some object to another object. set a = b How can i check that the returned object is NOTHING ie.e if isNothing(a) then There are isNull, isEmpty etc for variants but no isnothing. I have got round this before but could do with a more elegant solution cheers

Run-time error '3075': IIf([Selected]![Product]=0,"?",IIf([Selected].[Ext_Product]="",Left([Products].[Name],3),[Selected].[Ext_Product])) & IIf('XX' Like 'X*','*','%') AS ProductX This error first came to light when being installed on an XP machine. We also have had...

Run-time error '3075': SQL within VB6 project IIf([Selected]![Product]=0,"?",IIf([Selected].[Ext_Product]="",Left([Products].[Name],3),[Selected].[Ext_Product])) & IIf('XX' Like 'X*','*','%') AS ProductX This error first came to light when being installed on an XP machine...

Sorted it. Re-Installed and now works fine Cheers anyway