Search results

try this , i'm not famillier with such technique of coding but here goes : Public Function FindAndCapturePO(infield As String) As String Dim X As Integer Dim CNT As Integer Dim TARGET As String CNT = Len(infield) - 6 X = 0 Start: If X < CNT Then X = X + 1 Else: GoTo ENDIT End If TARGET =...

what kind of data is stored in this variable field ? could you give an example ?

putting it like that its an intirely different question!

Assumic your input text box is named "CombNum" then the code would be : If IsNumber(Me![CombNum]) Then If Len(Me![CombNum]) = 7 and (Cstr(Left(Me![CombNum],2)) = "10" Or Cstr(Left(Me![CombNum],2)) = "20" Or Cstr(Left(Me![CombNum],2)) = "80") Then MsgBox "You Win" Else MsgBox...

When you're talking windows your keyword for search should be : API now the API you are looking for is called Win32_Process here is a quickie of how things are : yet i would suggest more self study , it's beyond this forum's scope.

tsk tsk dont nobody search the forum ? http://www.access-programmers.co.uk/forums/showthread.php?t=156370&highlight=exe+trick

Brian , the code was simply to learn from and to cover a dare :)

Here is a trick I like to call "Secretery Trick" because this is exactly what it is :) Have you tried coding a security module for MS Access ? What's a security module about ? Exactly , Authentication and Logging Events . How often do you use time stamps in logging your events .. ok...

ok let me post it in a new thread ;)

my .. stripping out my security module would need heck of a time :) i am an i.s manager of a software development firm , so can you imagine the amount of tackles the internal system gets everyday ? :D , the system is at war with over 70 programmers and technician with wet dreams of possibilty of...

feel free to , there is nothing wrong with extra knowledge (to me and viewers :) ). yet hear this funny story : when i designed my first project i wrote my own security and that was merily because i was good with vb and never knew about mdw approach , Untill one day a guru like person i met on...

heh glad to help , along with sudoko

Banana ,,, you mentioned erlier a dictionary attack , deary password recoverers just decrypt mdws as smooth as opening a text file , some even retrieves PID. datAdrinalin , 99% of access users learn mdw setbacks the hardway , i bet even you had to learn all about wid and all the other blas...

oh for me its plain easy how to secure my app i rely on backend security (constructed views with specific user rights) and customely designed userlevel security (vba / custom password encryption algorythms) along with mde compilation while stripping out hash that could be rebuelt into code...

While brawsing this forum i came across an advice by someone regarding switching between 2 system.mdw files in order to import objects across two different database with each relying on different system.mdw file. Now what was interesting was that the advisor came to adress the subject as a...

Re: Creating and managing DSN-less connections Amazing Banana ! you actually never opened MSysObjects table and looked for yourself ? ever wondered how access stores connection strings and passwords to linked tables ? simply in Connect field in plain text in MSysObjects. the methode stated...

hi ajetrumpet cstr wouldnt change much , concatinating strings to integers is always smooth when you start by a string , so no need to add extra bytes to the code :) as for the loop interesting isnt it how a a perfectly scripted loop wouldnt run :) i tried several other loops until this new...

ok then try changing loop methode, example : Private Sub Command0_Click() Dim objXL As Object Dim xlWB As Object Dim xlWS As Object Set objXL = CreateObject("Excel.Application") objXL.Visible = True Set xlWB = objXL.Workbooks.Open("C:\Amex\Bisconer.xls") Set xlWS =...

well its essential for the select statment but irrelivent for fields declaration but the user suggested it so i decided to carry along. why you'd ask ? every user has his signature in coding which appears clearly in multiple choiced syntaxes and optional arguments , introducing new syntax...

Re: 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application") further more why an antivirus would intervene with outlook is that worms rely heavily on outlook.automation object in their infection spread process . so it might be as a precaution that some antiviruses would...