Simple transport company managment system

[Maple]

Hello, just got found this forums and this place seems to be righ one!


I'am really new one at MS Access and MVB, but +- good at PC/SOFT.
I have progress but also problems.

Got problem with

Private Sub txtName_Change()
Me.RegNr = txtName.Column(2)
Me.PVN = txtName.Column(3)
Me.Jur.Adr= txtName.Column(4)
Me.Bank  = txtName.Column(5)
Me.account  = txtName.Column(6) 
Me.Swift = txtName.Column(7)
End Sub

but autofill works only for combo box +1 field other still empty..
Attached word file with little description and screens of my idea's and this moment progress.
I will appreciate any suggestions!

[RuralGuy]

You should probably use the AfterUpdate event rather than the Change event.

[Maple]

Private Sub txtName_AfterUpdate()

Me.RegNr = txtName.Column(2)
Me.PVN = txtName.Column(3)
Me.JurAdr = txtName.Column(4)
Me.Bank = txtName.Column(5)
Me.account = txtName.Column(6)
Me.swift = txtName.Column(7)


End Sub

nothing changed

[orange]

Simple?
Transportation, shipping, routes, costs, cargo, customers, customs, packing slips, invoices,........ are all part of logistics. Logistics and inventory management often seem simple, but are far from trivial.

Do you have a description of the business for which you are developing this database?

Here is a link to a free Shipment Logistics data model from database answers.org

And here is a tutorial on database schemas

[andy49]

What's the source data for the combobox? A query? List?


Sent from my iPhone using Tapatalk

[Maple]

Thats the thing, i dont need such complete.
Its more like expedition (by having customers and selling their cargo for right company to have profit)
Thats why i just need company A and B, each one have their price, from which i have profit.
Automaticly made order for customer and one more for transport company.
And last form is invoice for customer.

[Maple]

Table/query

[RuralGuy]

nothing changed

Orange has some excellent advice but I suspect your txtName Combo does not have the values you need in the RowSource. What is your Column Count value and what do you have as the RowSource and Column Width values.

[Maple]

Orange has some excellent advice but I suspect your txtName Combo does not have the values you need in the RowSource. What is your Column Count value and what do you have as the RowSource and Column Width values.

Haven't even saw that option - Column Width, i dont think you ask about "0cm;2,542cm"

[andy49]

You only have two columns?


Sent from my iPhone using Tapatalk

[Maple]

more

[RuralGuy]

You will need *all* of the fields you want in the nRowSource of the cbo and the Column Count will need to include these fields. They do not need to be visible and you can set their width to 0cm.

[Maple]

SELECT companies.Nosaukums, companies.RegNr, companies.PVN, companies.JurAdr, companies.Bank, companies.account, companies.swift FROM companies;

If i try like this, only thing changes that now Company name shows wrong info!

[RuralGuy]

What is your current values for Column Count and Column Width?

[Maple]

Sorry for stupid question, where to check it to answer you correctly?