excel vba worksheet design - 2007

>>>I have seen a work sheet design where it appears as a blank page with no cell borders. - just black sheet
where you can put form control etc. something similar to the file attached. - input tab

For this effect, Simply Click on

Excel 2003

Menu Tools~~> Options: Under View Tab, uncheck "Gridlines"

Excel 2007

View Tab~~> uncheck "Gridlines"

Let me go through your sheet to answer the 2nd question :)

Sid

Thanks alot sid.
Can you please provide me with an example form which is inserting data in access table? an example or a tutorial would be good.

Sure. However it will taken me quite some time to create a sample for you. I would recommend you to see this link which already has an example :)

Topic:Export data from Excel to Access (ADO) using VBA in Microsoft Excel
Link: http://www.exceltip.com/st/Export_data_from_Excel_to_Access_%28ADO%29_using_VBA_in_Microsoft_Excel/425.html

Give it a try.

Sid

thanks again.
I appretiate your help and it sort of tell you how to do it.
But it would be very helpful if we could find a excel example that shows you how to. :/
Problem is I have very little time and need to do alot.
I should already alocate the points to you. this is simply the favour.

Thanks

Sammer, it is not about points :)

Ok. Do you have any Access database ready with you?

Sid

yes

Great. Can you upload the database without any thing in it so that I can use that to create a sample for you. It will save me time to create one from scratch.

Sid

Please find the attached db

Thanks
dummy-db.zip

Gimme an hour max. It will be done much earlier than that though :)

Sid

It doesn't have any tables?

Sid

sorry I though you wanted it empty.
Here is another copy with a table called software.

dummy-db.zip

>>>sorry I though you wanted it empty.

Yes but I wanted the table structure :)

This also doesn't have a table structure.

Ok leave it. I am creating one from scratch.

Sid

sorry :/ you are dealing with a kid

But I thank you for all the effort and if you are going to make an example then please do it both ways.
That is import/export.
I am sure I will b able to figure out few thing if I have one working example

Thanks alot.
Adding values seem to work fine.
But I added a record under 'sam'
the program crashes when I try to retrieve 'sam'
No error - excel stop responding
Sam.zip

Oops my mistake.

Add this line after "End If" in line 26 of the 2nd code.

.MoveNext

Select allOpen in new window

Here is the updated file. Also note that if you have entered "sam" then you will have to look for "sam" and not "SAM" or "Sam".

If you don't want it to be case sensitive then change the line

If .Fields("FirstName") = Range("E1").Value Then

to

If UCASE(.Fields("FirstName")) = UCASE(Range("E1").Value Then)

Select allOpen in new window

HTH

Sid
Sameer.xlsm

:) thanks
One very last and simple. How do you set the code edit to display line numbers
I have tried view -> couldnt find anything

I wish I could alocate more point.
Thanks alot for your help. I guess I am going to calling you whole week. :)

You cannot in VBA. At least I am not aware of.

When I mentioned line number above I was referring to the line number which EE displayed in the post :)

Sid

Is there a way to request your attention to a question another time?
Or any way I could contact you for help - I will make sure I dont bother you to much

Sure I was just wondering if you could. - I have fixed the code according to your instructions and works fine :)

>>>Is there a way to request your attention to a question another time?
Or any way I could contact you for help - I will make sure I dont bother you to much

Sure just ask a related question.

Sid

thats very helpful.
Here we go then. :)