Search results

form????? Is this a sortcode for a form????? Because if it is that, you have to make a querry where you do the sort on. The same for a rapport. The code you wrote makes no logic to me at all.

change record Had to think about it for a moment, but think that I got what you want. I save the new number in a new colum, because the module that changes the value takes away the first caracter. So if you would save it in the same colom and run it again, you would take again a karakter...

length I think I know a solution, but I will have to try it first. But there is one importent question, is the lengt of the texst always the same. Like in your example, you have first a lettre, and then 6 numbers. If every record has one lettre and 6 numbers, then I can fix it. And would it not...

???? I don't follow you 100 procent in the explination of your problem. But if you post the database, I can have a look at it if you want to.

name field I'm not sure if I understand you correctly, but if you want to get the firstname and lastname in one field, you have to change your select statement to the following: SELECT [Members].[PersonID],[Members].[FirstName]&", "&[Members].[LastName] As Name FROM [Members] ORDER BY [LastName]

Report info I'm asuming that you have one table with the ID number, and one table with the rest of the information. And you don't want to display the ID number, but the info from the other table. If that is correct than you have to make a query, on witch you base your raport, don't take the...

Querys in VB You can write every Query in visuel basic, and use them that way where you want it (form, raport). This is a little bit to complex to explain here, just experiment. I write every db of mine with 0 querys, but make many querys in VB. If you have a query, you can see the SQL code...

activated command with del key On the form load you have to set the keypreview to true Then on the keydown you can define all keys and do an action. See example below. Hopefully is this to help for you Private Sub Form_Load() Me.KeyPreview = True End Sub Private Sub Form_KeyDown(KeyCode...