Database Access Search

[abdullahsikandar]

Hello everyone,

I am new on this forum and new to the access as well, Please help me out on database Search form.

I need to make a search form where i can search from the database access and generate the report in Excel.

for example in a form there are 4 fields, I can search by field by field and press submit button then if there is no record it will pop up that no record found if there is a record so it will generate an excel sheet with formatting.

Thanks

[burrina]

So then you want to Export that data into Excel correct? If so, then use the Export feature.

[abdullahsikandar]

So then you want to Export that data into Excel correct? If so, then use the Export feature.

Well yes, But i need a path a button to save it and export it automatically. Anyhow that can be done by using export method too. You are right.

[burrina]

Example: TheFile = "c:\temp\MyReport-" & TheDate & ".xls"

[abdullahsikandar]

Yeah ... Thats what i want but how do i search? i mean what will be the algorithm for searching in database? on user form.

[burrina]

I am not following you.You say you already have a search combo that works, Yes? If not, then create one using the wizard.

[abdullahsikandar]

Sorry Sir,

I need to make the whole form for this searching criteria as i wrote an example. I need a VBA code behind that for searching.

[burrina]

You want me to design a form for you? Do you have a Database created already? Can you upload a demo copy?

[abdullahsikandar]

I don`t have that copy right now .. I am making it can you give me an example for the code.

For instance there are 2 columns in database

Name Age

ab 22
cc 34
dd 44
ssa 12


User form for searching:

Name:ab
Age: 22

Then the result would be created in Excel sheet with that result.