Hi,

I have an Access database with a massive table of customer details e.g.

ACNumber CustFName CustSName Contact etc etc etc

What I want to do in Excel is have the user type the customers' ACNumber in a cell and automatically that row will be populated with the customer details. I can get this to work fine for one row with a parameter query. Unfortunately this isnt an option for more than one or two rows. And from day to day the number of rows needed will change.

I hope someone can help.

Do I do this through a User Defined Function or does anyone know?

My friend, help me about vb 6.0 excel as a database. i need your xample project finish, have capacity to save in excel when clicking a button vb 6.0 codes... it is my assignment in school my friend, actually im Pablito P. Jacquez from Philippines 2nd year student IT of SurTact Surigao City. The deadline of this project my friend is feb. 7, 2009 8am, but me and all of my classmeet not got finish this assignment and now sir told extend until tommorow 12noon. Hope you help me my friend... unfortunatelly i will send you like this problem because i know you you're expert programmer using vb 6.0... This is my email add my friend pjacquez68@yahoo.com. Send me you're little xample finish project in my email add my friend atleast have capacity to save only... Text1.text is Lastname, Text2.text is Firstname and Text3.text is Middlename, at we place into excel database when clicking Button my friend... thank you my friend... GOD BLESS YOU... plz my friend? I hope you sent me my friend, i trusting you my friend... thankzzzzzz

Unfortunately this isnt an option for more than one or two rows. And from day to day the number of rows needed will change hi maximusimo,

you can use this code to append data on last row

lastrow = Cells(Rows.Count, 1).End(xlUp).Row
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.