Home >FAQ >Folder HelpDesk kalmstrom.com site map icon Site map  

kalmstrom.com FAQ – Folder HelpDesk


Category Folder HelpDesk

Type Features

Problem Can the Ticket Number be edited to start with a particular number?

Can the Ticket Number be edited to start with a particular number?

The Ticket Number is based on a Auto Counter field in Access. Thus, the only way of changing the number sequence is to manually go into the Access database and add the required number of rows in the tblTickets table.

Thereafter you would of course need to remove those rows, because you would not want all of those rows in your statistics.

For SQL you have to edit the PFHDDB.sql for that and then create a database based on that script.

Examples: "CREATE TABLE [dbo].[tblTickets] ( [intTicketID] [int] IDENTITY ( 1, 1) NOT NULL ,....."

is changed into "CREATE TABLE [dbo].[tblTickets] ( [intTicketID] [int] IDENTITY ( 1000, 1) NOT NULL ,...."
Products Buy FAQ Services Apps Tips Education Contact About Us Blog

  Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved