Search results

I just need to rant a little, I have this little old code which sits innocently smack i the middle of a critical procedure in my db. Public Function GetBEFolder(pTableName As String) As String Dim strFullPath As String Dim I As Long strFullPath =...

This is not a problem but an observation, sometimes Access throws you an unexpected curveball. This time the problem circles around Jet/Ace and float numbers. Dim s As String Dim x as Double x = 125.25 s = " Insert into MyTable (MyNumber) Values ( " & x & ")" Currentdb.Execute s, dbFailOnError...

I have come across a weird result by using Val(). ex: Val("12535 A1") results in 12535 which is what I expect but if I use Val("12353 D1") or Val("12353 E1") I get 123530 All other Letters Val("12353 ?1) gets the correct result, any thoughts on this? JR

I have a form which is is used to lookup customer information. This form is open in dialog mode so my users can select the correct customer and transfer data to my dataentry form. The problem I have is that this form should be availible on other forms, so in the OpenArg's argument I pass the...