lave om i en formular

Hvis du f.eks har en tekstboks af typen Tal, og du vil tælle antal poster i Tabel1 ser det således ud i feltets postkilde:

=DCount("*";"Tabel1")

Hvis du vil have tilføjet en forklarende tekst kan det se ud sådan:

="Der er:" & DCount("*";"Tabel1")

Husk at tekst skal være i "", og bind dine udtryk sammen med &

if the field is BOUND to a field in a table then you will get an error if you try entering text. If the field is not BOUND to a table then you can enter what you like.

what are you trying to do?

jeg har nogle talværdier fra en gruppeboks
som jeg gene ville have vist som noget andet.

hvis man kan lave dem inden jeg gemmer dem i min tabel ville det være endnu bedere.
feks: 1 fra min gruppeboks bliver gemt som null
      2 fra min gruppeboks bliver gemt som St Tv
      3 --------------"--------------- som St M
      4 --------------"--------------- som st Th

r_becker, I think your best bet i sto normalize your database!

You have a table with primary key (values 1 to 4)
Then a text field containing the text value. THen if you continue using the group box you can alter the form to show an extra field containing the text.
You will need to alter the record source for the form to a query which contains the extra text field

This is the new table
1, Null
2, St Tv
3, St M
4, St Th

Feltet i tabellen der modtager værdien skal være en tekstboks. Træk feltet ind i din forespørgsel / formular. Når du laver din gruppeboks skal du lade gruppeboksen returnere værdien til dette felt. I Gruppeboksen laver du denne kode i VedKlik:

Select Case Ramme2
Case Is = 1
Me.felt1 = "St. tv"
Case Is = 2
Me.felt1 = "St. th"
Case Is = 3
Me.felt1 = "1. tv"
End Select

Kan sende en testdb. Læg din e-mail

i sto normalize = is to normalize

At the moment you have a numeric field containing the value selected from the Group Box. Make the new table as I mention, and then alter the field containing the value from the group box from a numeric value to a Lookup. This makes a relationship from the original table to the new table which contains the text values.

Hope it all makes sence!

mugs> your answer WILL give r_becker what she wants, but it isnt th ecorrect way to do things. You will be creating redundance which is what relationla databases tries to avoid :o)

mugs Rickie@skeeknejde.dk som zip

terry ikke rigtigt (o;


rickie

terry > Your are 100% right.
I have seen the DB, and I have for some dayes ago told the user, that he should redesign the db.

I have sent a db conjerning my answer, and again told him, that he should think using your solution. Here the text from My e-mail:

Jeg har jo din e-mail.
Men jeg ville nok overveje terry's forslag, men det kræver lidt mere
kendskab til VBA.
/mugs

mugs>After seeing the dB can you tell me if it should be resonably easy to make the alterations (new table) as I suggest or not? I dont want to commit myslef if it would take ages to alter :o)

r_becker, I would be prepared to take a look at the dB and make the alterations if its something which isnt going to take too long. Otherwise I would use mugs' idea.

terry > I think it will take just a few minutes.

As far as I remenber the DB is Access2000 og XP. I have access97, and when I opened the DB, there was a few malfunctions I think was from the "konvertering"

terry  hvis du vil så må du meget gerne se den, hvis du mener det vil tage for lang tid kan du jo bare sige det og så må jeg jo prøve det som mugs siger.
Rickie

OK, eksperten@santhell.dk

I need to know which form to look at.

mugs>your going to have to get hold of XP :o)

er sendt
går lige ned og for noget at æde

I have received your dB. Will get back as soon as possible, but first I'm just going to have something to eat :o)

point til Terry
det var lige det sådan jeg hade tænkt det skulle være
hvordan fik du den til at fylde så lidt.

well I tried to compress the dB but got an error. So I made a new dB and copied all objects into it.

Hope you can see how it works.

If you want to ALTER data in the grid then you will need to change the "etage" field to a combo so that you can choose which type you want.