Hello everyone!

VasiuF

Member
Local time
Today, 20:33
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
 
Welcome aboard!
 
Hi Florin. Welcome to AWF!
 
Hello, Florin. We are glad to let in anyone who wants help.
 
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
 
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.
 
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.
 
welcome carl!
you can also create your own intro post.
 
Welcome Florin, I've just joined the group as well. Its been very helpful :)
 
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
 
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)
 
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.
 
you are right, now I understand :)
my problem was actually the construction of the filter in the VBA

Thanks anyway for the details (y)
 
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 ...
 
oh, visual FoxPro.
I used to program with that, it's 1 competitor of Access then.
MS brought and just shelf it. competition done!
 
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

Back
Top Bottom