User Profile

Stephen Parker · Nov 29 '10, 02:15 AM

123456789.

Stephen Parker · Nov 29 '10, 01:56 AM

With the limited information provided the following function should be easily modified to achieve the desired results regardless of wether or not you keep the values in two seperate fields or one single field:

Code:

Option Compare Database
Option Explicit

Public Function GenerateUniqueSerialNumber() As String

    On Error GoTo GenerateUniqueSerialNumber_Error
    
    Dim lngREC

...

Stephen Parker · Nov 28 '10, 08:44 PM

One more question: When you say "Valid is a seperate generator for letters and numbers, in different fields" are you saying that the value has to be in two seperate fields or that it can be in two seperate fields?

Stephen Parker · Nov 28 '10, 08:39 PM

123456789.

Stephen Parker · Nov 28 '10, 06:58 PM

Here is some basic air code you can customize to accomplish your task.

Code:

'NOTE: The following code requires a reference to "Microsoft DAO Object Library"

Dim strSQL As String
Dim daoDBS As DAO.database
Dim daoREC As DAO.Recordset

Set daoDBS = CodeDb
strSQL = "SELECT ColumnA, ColumnB, ColumnC, FROM TableA WHERE Recordset = MySearchCriteria"
Set daoREC = daoDBS.OpenRecordset(strSQL)

...

Stephen Parker · Nov 28 '10, 06:41 PM

Assuming that the rest of your SQL works the way you want it to then it appears as though you simply need to isolate the sum statement. In other words maybe try to perform the sum then join it to the rest of the select statement to prevent the calculation from multiplying on each email. That is to say if it is neccessary that you have all of the multiple emails returned by the query and isolating a unique instance is no optional then maybe try something...

Stephen Parker · Nov 28 '10, 06:24 PM

Can you provide any more information? You say each field in the table is that correct or did you mean each row / record? Is there a specific reason you have to have it in the described format of "two letters and 6 numbers"? Just curious as that sounds very strange. I see you have a lot of views with zero replies. It may be better if there was more information to work with to better understand what you are trying to accomplish. Take Care...

Stephen Parker · Nov 28 '10, 06:19 PM

123456789.

Stephen Parker · Nov 28 '10, 01:06 AM

123456789.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Refresh a form from another database?