Need help with MS Access

smoke
By smoke

I am not very good with this access krap so i'd really appreciate someone helping me out in this.

I'm working on a database, and for some reason cant get it to search for desired records in the database. I mean i want a form to look up certain words and list it out for me. Is that possible?

Eg: If i have a list of companies that are issued temporary entry permits and i want to know which companies permits will be expiring in the month of March, i want a search to find me all company names and list them in one report with the expiry date.

Ok i know that its going to be easy for some of you out there but Ms Access is just not my thing :P

Help please, thank you, mention not.

By anonymous• 11 years 12 months ago.
anonymous

Any one Needs MS Access Customized Programs for personal/Co. use. (Less than QR1000 depending upon the database). Contact me on paulcherianc@gmail.com

By smoke• 12 years 5 months ago.
smoke

Thanks guys sorry but i just looked in here today :) will try out the suggestions but whoever designed Access didnt do it keeping idiots like me in mind :P

Good Fortune always comes knocking at your door...when you are sh*tting in the toilet!! :)

_[]~«ŠѪΘҜΞ»~[]_

 

By Salmamohd• 12 years 5 months ago.
Salmamohd

Smokeyyyy i had the same prob:(

Just search in Google n ull find videos n details;)

Helped me out hope u learn tooo:)

By anonymous• 12 years 5 months ago.
anonymous

Smoke ...Press F1 and read the help section on search...lol

This sort-according-to-date is easily done in Excel.

I have no idea about Access though

By jaz-09• 12 years 5 months ago.
jaz-09

http://www.databasedev.co.uk/queries.html

By qatarisun• 12 years 5 months ago.
Rating: 4/5
qatarisun

i would love to help you, but i am not sure what exactly you are looking for..

*********************

"What lies behind us and what lies before us are small compared to what lies within us."

Oliver Wendell Holmes

By naniababa• 12 years 5 months ago.
Rating: 4/5
naniababa

Search MS Access Books on Google...............

By somwerNdmiddle• 12 years 5 months ago.
Rating: 5/5
somwerNdmiddle

try this smoke.

highlight March 2010 or 03/2010 (whatever date format your Access has)and click the FILTER sign (thunder sign on the toolbar) and you'll find what you're looking for.

As for the report, i just highlight all that were filtered and copy/paste in Excel

(this is what i usually do with MS Access)

hope this helps

www.live365.com/stations/thevault85

By smoke• 12 years 5 months ago.
smoke

I was about to call 999 i'm sure they will have an answer to my problem :P

Good Fortune always comes knocking at your door...when you are sh*tting in the toilet!! :)

_[]~«ŠѪΘҜΞ»~[]_

 

By Pajju• 12 years 5 months ago.
Pajju

smoke plz contact 1234

By smoke• 12 years 5 months ago.
smoke

NO one? You all suck at Ms Access too dont you? :P

Good Fortune always comes knocking at your door...when you are sh*tting in the toilet!! :)

_[]~«ŠѪΘҜΞ»~[]_

 

Log in or register to post comments

More from Qatar Living

Trendy ice creams to try in Qatar

Trendy ice creams to try in Qatar

This summer 2022, try out the most trending ice creams in Qatar. Check out the ones listed here!
Things you can buy at Dragon Mart

Things you can buy at Dragon Mart

Right from a pin to a variety of unique furniture, Dragon Mart has it all. Visit Dragon mart this Eid Al Adha 2022 and shop to your heart's delight.
Restaurants with live music in Qatar

Restaurants with live music in Qatar

With the gastronomical journey elevating its standards in the country, we're always on the look for new and exciting finds in Qatar. Good food, good company, and good music is a combo that we all love - here's a round-up of some restaurants in Qatar that play live music
5 Air Conditioned Open Spaces in Doha

5 Air Conditioned Open Spaces in Doha

Qatar is one of the world's fastest-warming regions with fierce heat. With temperatures soaring to (enter temp) usually, certain activities tend to become a tedious task - especially if outdoors. But, life must go on and we are witnessing Qatar aim to air-condition the outdoor marketplaces, streets, and even outdoor malls, so we can enjoy a nice breeze during activities. Here are some spots to keep an eye out for especially during the summer.
Go swimming in your local pool in Qatar

Go swimming in your local pool in Qatar

Beat the heat this summer and enjoy your holidays in these swimming pools in Qatar
Places to buy fruit cakes in Qatar

Places to buy fruit cakes in Qatar

Wondering where to buy the best fruit cakes in Qatar? Here are some of the best places you can get fruit cakes from.
Entertainment centers for kids in Qatar

Entertainment centers for kids in Qatar

Wondering where to take your kids this summer? Here's a fun list of entertainment centers for kids in Qatar!
Reasons to visit Al Wakra Central Market in Qatar

Reasons to visit Al Wakra Central Market in Qatar

The Al Wakra Central Market offers livestock and fodder, in addition to a variety of traditional items, fruits & vegetables, accessories, and so much more!