Search results

Thanks so much Paul. It worked great.

Can anyone help on this please?

I would do that but where do I put that in the Macros section of Access? I am not using written code. I am using the Macro items that are in Access already. In other words, if you hit design on macros in Access, it will give a sequence of items you can enter. How can I enter an IF statement...

Hi, I am using MS access 2010. I have a form which has buttons on it running macros. I need the software to check a field on that same form for its value when the user clicks on the macro button. I need to macro button to be unavailalbe or not to run if the field does not equal the certain...

Hello everyone, Im running a parameter query and I need it to show all records if left blank by the user. I can achieve this but I cannot achieve it for more than one parameter. How do i go about this? Basically, if the user enters a value for the first parameter and enters nothing on the...

rural guy, thanks for the link. I tried it again and it worked like a charm.

it is a very simple database that includes one table and one query. there are no forms. is there a place in the query design?

thanks ruralguy. sorry for double posting. the article is very helpful though are you able to tell me where to post the coding in Access? thanks again

I am working on a project for school and need some serious help. I have one table that I have been working off so this should hopefully be really easy for a lot of you. The project is about a hotel business. The tables consists of a guest name, room name, arrival date, departure date. The...