what can i delcare as a counter?

[smiler44]

what can I declare as a counter?

I have dim smith as counter but when I run the code I get an error saying compile error user defined type not defined.

what should the dim be?

thanks
smiler44

 

[speakers_86]

Counter is not a data type in access. You probably want as integer or as long. Also, why use variable name smith? Usually people use intI, lngI, or just i.

 

[jdraw]

Counter was (and still is) a data type used with SQL Create Table.

Here is info from FunctionX

To support this, Microsoft Access SQL supports two data types named COUNTER and AUTOINCREMENT. Here is an example of applying the COUNTER data type to a field:

Private Sub cmdTable_Click()
DoCmd.RunSQL "CREATE TABLE Contractors(" & _
"ContractorNo COUNTER, " & _
"FullName TEXT NOT NULL);"
End Sub

I just tested it

Sub testSQLx()
    Dim x As String
    x = "CREATE TABLE ContractorsXXTEST(" & _
        "ContractorNo COUNTER, " & _
        "FullName TEXT NOT NULL);"
   Dim db As DAO.Database
   Set db = CurrentDb
   db.Execute x, dbFailOnError
End Sub

Table design in attached jpg.

 

[speakers_86]

But he said he is doing

dim smith as counter

vba, not sql

 

[smiler44]

I am using smith and many other names so I know who's data I am picking up.
integer or long, ok i'll try long thanks. I recall reading somewhere there can be a problem using integer.

why does dim smith as counter give a problem?

thanks again
glassescase

 

[namliam]

Counter is not a data type in access.

Counter is not a data type in access.

 

[speakers_86]

Use Dim smith as integer or Dim smith as Long.

Interger will cause a problem if you expect the counter to get very large. In that case, use long. If you are not sure how big it would be use long. Be conservative and assume the counter will sometimes be larger than you expect unless you are sure. For more information, look up number types in MS Access and find out how large a number each data type can hold.

 

[smiler44]

thanks speakers-86, long did it. I will try to remember for the future

glassescase