Search results for query: *

Hello, I recently purchased Visual FoxPro 6.0 Professional Edition via E-bay. I did a custom install, selected everything possible, but when I run it, there are no help files. Those options under the "Help" button are grayed out... unaccessible. Any ideas why? Thanks Joe

Thanks folks... I know nothing about Access/VBA I noticed the "rst" in front of "MEMBERS" and thot it necessary for the recordset. I assumed the "tbl" in front of "MEMBERS" was necessary to indicate this was a table. Wrong Assumption!!!! Thanks again...

Here's the code I was given for Access 2000 to: Sort a membership file by Lastname, Firstname & Suffix -- Spin thru the file and renumber the Membership number -- Sub Renumber_Members() Dim MemberNumber as Long Dim rstMEMBERS As New ADODB.Recordset Dim strSQL As String Dim cn1 As New...

Thanks... I should have explained further. Each month I add new members. They want an alphabetical list AND they want to renumber the membership number so they only need one list. One that is in alphabetical and numerical order. You gave me what exactly I needed. Thank you very much.

It could be your cloumn is not wide enough. Try widening the column containing the autonumber. Place your cursor on the dividing line between this column and the adjacent column to the right. Hold down the left mouse button & drag the column line to the right.

I'm a programmer, but have no knowledge of Access/VBA I have a database "Members" (Access 2000). I want to sort by it by Lastname, Firstname & Suffix (Jr, Sr). I then want to go to the first record, place the value 1 in the field MemNum, then move to the next record, increment the...