I forbindelse med en adressedatabase med ca 400 forekomster ønsker jeg at kunne navigere i forekomsterne i en oversigt hvor jeg kan se alle forekomsterne fx. i alfabetisk rækkefølge efter efternavn og samtidig kan springe - fx til bogstavet 'g' nemt. Efterfølgende vil jeg kunne springe til formularen for at ændre i forkomsten.
Årsagen er, at jeg ofte skal tjekke, om de adresser jeg skriver ind i basen står i den i forvejen. Det kan være en smule besværligt pga. små forskellig i stavning af efternavn mv.
This is just a suggestion. You could the tree view control to show all letters of the alphabet and in under each letter youhave the names which start with the letter. Then when you click on the name the information is displaye din a form (maybe a sub form) where you can make your alterations.
Another idea is to have a number of buttons on e for each letter of the alphabet. Then when you click on a button you alter the record source for a form selecting only those which strart with that letter.
well I hope you can understand this or you have problems.
OK we will try and keep it simple.
make a form using the wizard and choose your tabel containing your adresse data as the record source.
Make this a Continuous Form or a data sheet to show ALL records. Now add a button to the form header and make the Caption (text) = A At the same time add another button with the caption B
Now in the on Click event for BOTH buttons add =SelectRecords() EXACTLY as I wrote "=SelectRecords()"
Now add a text field and name it txtChar, this canbe hidden when it is all working.
Now you need to add this to the forms code
Function SelectRecords()
On Error Resume Next Me.txtChar = Me.Controls(Screen.ActiveControl.Name).Caption
Me.Requery
End Function
Now you need to alter the forms record source to something like this
SELECT *, Format(Left([efternavn ],1),">") AS firstchar FROM YourTable WHERE (((Format(Left([efternavn ],1),">"))=[Forms]![TheNameOfTheForm]![txtChar]));
YourTable is the name of the table TheNameOfTheForm thi sis the name of the form
oledr dont you think its about time you closed this question, we cant wait until you learn Access :o)
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.