Hi hope someone can help with this; Access 2003
I am starting a new database and I am try to create a unique part number for items what i want to do is firstly enter a 8 digit code (alpha numerical) and then have a final auto generated 3 digit number but i would like it to start from 001 and countup in 1 for each combination of the 8 digit code.
to re cap the 8 digit code may be duplicated but not with the same 3 digit;...
petemul
Last Activity: Jan 24 '08, 10:26 AM
Joined: Oct 5 '07
Location:
-
Yes I did - changed it and it works!!!
Thank you for persistance... -
Nico
Forgive my ignorance but in this example are you wwriting this code in a new module? or in an event procedure or in the query its self?
To be honest I think I should just forget this as I think my serious lack of programing skills may be wasting your time!
I think I need to go and have some training as opposed to self taught
Thanks
PT...Leave a comment:
-
Linq,
What I have done is created GetLineNumber() in a module. Then on the subform I have placed a text box in in the control source I have used the expression builder to use the function "GetLineNumber( )" which is now available to select. The expression gives
GetLineNumber(< <F>>,<<KeyName> >,<<KeyValue> >)
I then put in the relevant fields and then the problem starts....Leave a comment:
-
The changes you have noticed are from the VB script of the sample database that this command was working in. I thought the diffences in versions may make a difference so I have tried both. I just didn't realise I'd left the old version in my database when i copied and pasted my vb on this page.
I have to be honest and say I now very little about VB so technically its a bit above me.
Thanks for your time
...Leave a comment:
-
Thanks for that - still have the same error though. I've typing it in VB as opposed to cut and paste in case other errors had transferred over.
Must be an issue some where else might try making a small simple database and seeing if it works there. I let you know the outcome.Leave a comment:
-
Yes, that was my inital thought but when I put a name in there I get the error "The object does not contain the automation object 'GetLineNumber' .
I have tried every verison of form names, query name (of which the form is based), table name.
In the example form I saw this on it was actual [Form] that used not the form name.
http://support.microsoft.com/kb/325236/en-us
is the link to...Leave a comment:
-
Ok
Purchase order line number - I am trying to auto number the line items on a subform.
I have used this module to obtain the function GetLineNumber( )
[CODE=vb]Option Compare Database
Option Explicit
'============== =============== =============== =============== =
' The following function is used by the subLineNumber form
'============== =============== =============== =============== =...Leave a comment:
-
Thanks - as you have prob notice I'm new to this. The database i'm working in is microsoft Access 2003.Leave a comment:
-
Get Line Number ()
Hi all,
I am having a problem with a PO database. I am trying to create a field that auto generates a PO line number. I have create a module (given in microsoft office help). When I try to use this function in a text box on the sub form I get an error " the object doesnot contain the automation object "Get Line Number" and #Name? is displayed.
the command in the control source is =GetLineNumber([Form],"ID",[ID])...
No activity results to display
Leave a comment: