Hello everyone! (1 Viewer)

VasiuF

Member
Local time
Today, 09:44
Joined
Apr 1, 2020
Messages
42
I'm new here a and i'm from the Romania, so sorry for the bad english . I'm new in Acces .
Thanks for letting me in!
Florin
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 00:44
Joined
Aug 30, 2003
Messages
36,118
Welcome aboard!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 00:44
Joined
Oct 29, 2018
Messages
21,358
Hi Florin. Welcome to AWF!
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 02:44
Joined
Feb 28, 2001
Messages
27,001
Hello, Florin. We are glad to let in anyone who wants help.
 

VasiuF

Member
Local time
Today, 09:44
Joined
Apr 1, 2020
Messages
42
Hello,
I have a table with filds like matrn, matern ,note1, note2 (matrn number, matern number)
criteria= "matrn = 1234 and matern = 456789"
i want to make an multiple fields index with matrn and matern to use in a Dlookup like this:
Dlookup("index","table","criteria")
can help me ?
thank's
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:44
Joined
May 7, 2009
Messages
19,169
no offence but it's hard to imagine what you request.
suggest you write it on a notepad in Romania language then copy and paste to online translator.
paste the english part to this forum.

nicio infracțiune, dar este greu de imaginat ce solicitați. Vă sugerăm să-l scrieți pe un bloc de notițe în limba română, apoi copiați și lipiți la traducătorul online. lipiți partea engleză pe acest forum.
 

carlrun

New member
Local time
Today, 09:44
Joined
Apr 2, 2020
Messages
1
Hi all I am not new to Access. I came from the Paradox clan and before than Dbase. When Paradox died I got onto Access. Only now though have I been delving into VBA. Very impressed but this is going to be a long journey as I am not a full time developer and have a business of my own.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:44
Joined
May 7, 2009
Messages
19,169
welcome carl!
you can also create your own intro post.
 

GeordieH

New member
Local time
Today, 07:44
Joined
Mar 31, 2020
Messages
25
Welcome Florin, I've just joined the group as well. Its been very helpful :)
 

VasiuF

Member
Local time
Today, 09:44
Joined
Apr 1, 2020
Messages
42
Hi,
I have a table (codpers, codmateria, notes1, notes2)
I have a string variable
FILTER = "codpers = 1234 and codmateria = 456789"
I want to create an index (note_ind) of two fields - codpers and codmaterials - for use in a Dlookup
as follows:
Dlookup ("note_ind", "table", "FILTER")

Thanks
 

VasiuF

Member
Local time
Today, 09:44
Joined
Apr 1, 2020
Messages
42
Basically, I don't know how to use the index in the Dlookup () function so that I identify a unique record in the table composed of the 2 fields (codpers and codmateria)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:44
Joined
May 7, 2009
Messages
19,169
you have misconception of what is an index.
you create an index to speed up your search, as an example using dlookup.
you create two indexes, one for codpers and the other for codmateria field.

the syntax for dlookup() function:

dlookup([the field to return]", "[the table]", "[the filter/criteria]")

for example you want to return the Notes1 field whose record has codper=1234 and codmateria=456789:

dlookup("[notes1]", "theTableName", "codper=1234 and codmateria=456789")

if the criteria is found on at least a record, it will return the Notes1 for that record.
otherwise the return value of dlookup will be Null.
 

VasiuF

Member
Local time
Today, 09:44
Joined
Apr 1, 2020
Messages
42
you are right, now I understand :)
my problem was actually the construction of the filter in the VBA

Thanks anyway for the details (y)
 

VasiuF

Member
Local time
Today, 09:44
Joined
Apr 1, 2020
Messages
42
I worked a little more on visual fox pro and now I started working with access, I have to get used to the addressing mode ...
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:44
Joined
May 7, 2009
Messages
19,169
oh, visual FoxPro.
I used to program with that, it's 1 competitor of Access then.
MS brought and just shelf it. competition done!
 

strive4peace

AWF VIP
Local time
Today, 02:44
Joined
Apr 3, 2020
Messages
1,003
Welcome, Florin! I just found your question. Don't worry about your English, it is fine. As people help, you can see what else they need to know and write more. I admire you for being able to use another spoken language good enough to participate
 

Users who are viewing this thread

Top Bottom