Microsoft visual basic hates me

[a1chatfield]

I am trying to make a form where i can input an ID number and the computer will track the date and time of the input. I also need it to take the ID number and match it up wit a person in Microsoft Access. I can match up the ID number with the person but every time I try and make functions that apply to an entire row i mess it up somehow. I just need to be able to make a function repeat as long as people keep inputting their ID's. I could really use some help im completely lost using macros.

 

[xenou]

Hi,

1) Welcome. Visual Basic probably doesn't actually hate you. It's merely being stubborn.
2) What do you mean by applying a function to an entire row?
3) You've posted in an Excel forum. Are you using Excel and Access or only Access?
4) Take your time and start slow, one thing at a time. Mastery of Excel, Access, and VB takes months (or years).
5) For better results posting, provide a small set of sample data, an example of the desired result, and the code you are using that doesn't work (if it's not too long).

 

[a1chatfield]

I need to apply this function to column C, and i need it to continue to repeat every time someone enters their ID number in column A.

=LOOKUP(Sheet2!A:A,Sheet10!F:F,Sheet10!D:D)

What I'm doing is looking up the Name of the Person, the ID number in column A belongs to.

 

[xenou]

Simplest (without vba) is to put the formula in the column already (for a good three or four times as many rows as you actually think you'd use):

=If(IsNa(VLOOKUP(Sheet2!A:A,Sheet10!F:F,Sheet10!D:D,False)),"",VLOOKUP(Sheet2!A:A,Sheet10!F:F,Sheet10!D:D,False))

It's better to use VLookup than Lookup so that you don't get any misleading matches when ID's don't exist in the lookup table.