Search results

technicaly you are creating a bot script that acts based on same human logic of data manipulation :) what you miss would be copying first the variable from your form control on top of the script via : Me![ControlNameHere].SetFocus Me![ControlNameHere].SelText RunCommand acCmdCopy then on...

oh i see , u r quite confused .. ok let me put some fundamentals to your quest: 1 - they havent changed it , yet it might be that you have discovered some hidden bug that was solved in later releases (the story of my life) 2 -variables (Global / Public / Private) are all project specific (ie...

let me just hint you by an example how things work in vb regarding time , supposingly : call started #1/1/2008 11:59:00 AM# call ended #1/1/2008 12:04:00 PM# then a simple function such as : MsgBox Minute(#1/1/2008 12:04:00 PM# - #1/1/2008 11:59:00 AM#) would return the integer 5 also MsgBox...

ok let me clear what your problem is : You are currently accessing the same record twice , one time visualy through form and the other programaticaly through vba. how to solve this is simple , you need to halt the form record access during your programatical approach, how you do this vary...

try adding an Expression Field (virtual field) to your query , here is a bogus select statment stating how : Select [dateclosed] , [outcome] , Month([outcome]) As outcomemonth From YourTableNameHere; and then call apon it from open form criteria in like "[outcomemonth]=" & monthnumberhere

How i read the code is that his problem lays where he gets repeated identicle phone numbers yet the index (lcus_code) varies..and thats how he gets repetitions. now the question is .. why is he allowing the error then trying to clean it ? one simple strike shot to the case would be setting the...

hmm interesting usualy what comes after a dot in a construct like Forms!formname. is either a control name or a form property , i wonder how it works other than that. however i would suggest that you declare global variables (AKA Public Variables) in Modules for the mater of cross forms...

you first set a custom menu bar (the one you created) through : application.menubar = "CustomMenuBarNameHere" now several approaches as to how to complete the rest , despite the upcoming one is unconventional in visual basic world (as i inherited it from PowerBuilder world :) ) yet it's the...

ok a side notice about the initial problem of this thread , there are two versions of this popular script , the first is the one posted above the second is one almost identical but tend to retrieve computer name . now why the author has limited retrieved field to 255 charachter was a mere trial...

You are welcome , be kind to the world please :)

Here is a another bizare story i had with microsoft access i would like to share: There is this application i made where my custom right click menu has the sort ascending/descending buttons in . I use a setting where startup form calls other forms through search parameters acquired through...

Banana youuu :)

honey neither i read your post nore i am by any chance interested in debuging above code not even for money for the fact that i'm sure it must contain heaps of unoptimized syntax to reach above sum. but i came across the line you mentioned that your problem lays in case "fe " so i brawsed up...

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 If X = 1 or X = (CNT - 1) Then TARGET = Mid(infield, X, 8) If TARGET Like...

but the a kk401012345/ would still be a hit , i would suggest looking for something starting SO# better ? or is it inconsistant of them to type it ?

and why not 1093432 nore 1034567 ?

which of these are you looking up ?

would you just visualize your fantacies in an example ?

heh , i just researched , the above technique goes way back to the time of QBasic , my thats old :) anyway you are welcome

Banana i use a technique i created , the passwords user stores run through an algorythm that generates a long serial number , i made sure the equation cant be reversible by division and losing decimals in different sections that even i cant reconstruct passwords which i even save in a different...