Add new field via Vba

[orange]

I agree with ItsMe and June. It sounds like you are not a database person and doing the best you can in the given situation.
In different words, it seems to me you are juggling about 15 balls in the air, and someone keeps adding more balls. At some point, it's all going to crash - regardless of how well-intended you are, or how much time and effort you can possibly dedicate.

There are a few options that may be applicable.

You can do what M$oft and large organizations do. (Actually any large project) That is, scope out a longer term plan of what functionality is required and what effort and skill sets are required to accomplish it. Then break the work into do-able chunks. This is equivalent to 'in release 1 we will deliver a,b and c'. Get something working that is manageable and fits with the bigger plan. Get another team (contract or hired consultant) to map out release2 and initiate development and a test plan. ....
You can't do everything all at once! Something has to be priority. Find it, communicate it and focus on it.
Readers here can help but we need to see what you are dealing with. The current ERD would be helpful; as would any documented requirements/specifications.
Get a Project Manager involved to plan, schedule and monitor tasks and resources.



You need a plan (or plans). What is/are the specifications of this Health and Nutrition Project?
What is the structure of the "Project team"? Who has responsibility for the overall plan?
Who is setting priorities and managing work loads? Who is handling communications between WHO officials, this project team and the users? Where is the database technical expertise coming from? Where is the subject matter specialist(s)?


In real life database, YOU DO NOT HAVE TO ADD NEW FIELDS TO OPERATIONAL TABLES PROGRAMMATICALLY ON A DAILY BASIS!

You have to get some help.....

[gstylianou]

Good morning to all

I will like to say many thanks to all of you guys regarding your important information. Forgot to tell you that, we are not a company but The Navy Seals here in Cyprus and personally i'm the one of these 14 users and of course one of these 14 trainers!

So, my friends whatever we doing about this database its totally by free of charge and the target is to help us about the best we can do with our soldiers and their healthy diet and nutrition.

Therefore, thanks again all of you for your direct reply. Spending some time last night and reading some articles i solve the issue using the following code

Option Compare Database
Option Explicit
Public Sub AddField()
Dim FieldTitle As String
Dim curDB As Object
Dim tblTest As Object
Dim NewField As Object
Set curDB = CurrentDb
Set tblTest = curDB.TableDefs("tbl_Test")
FieldTitle = "CustID"
Set NewField = tblTest.CreateField(FieldTitle, dbLong)
NewField.OrdinalPosition = 1
tblTest.Fields.Append Newfield
End Sub

Thanks again

[orange]

I'm glad you have your current db situation resolved. I'm going to list a few references that you might visit as and when necessary. Your description of your set up and issue seemed like a plea for info and advice which is what the readers responded to.

I suggest you learn some vba. Great reference is FunctionX VBA

--you should download and use these utilities
MZTools for VBA-- a free utility to help with error handling,documentation and much more
SmartIndenter -- free utility to help format your vba code

For database and table design, relationships etc this tutorial from RogersAccess Library is very good -but you have to work through it. There are many tutorials on the RogersAccessLibrary site.

See this link for Access functions, syntax and examples

Good luck.

[gstylianou]

Good morning my friend Orange.!!

First of all i would like ti thank you very much for the attached details regarding access and vba information. Believe me, its very useful for me and thank you again.

I will read some articles and if i will have any other issues i will let you know.

Thanks again

[orange]

Good stuff --hang in, readers/participants here are available to help.