Search results

I have a table contacts with field email which hold contacts email addresses. How do i create a command button so that on click it takes all the email address from the contacts tables and transfers them to outlook in the To: address field.

I am having a problem using a combo box to pass over a parameter for my query. My query does not seem to be picking up the value from the combo box on the form. I have created a Contacts table within that there is a field City as a text box so the user can imput any value. I've created...

I have an option group with two options form1 and form2. What do i have to do to use a command button to open form1 or form2 depending on the selection from the option group.

How do i create a parameter to use a combo box instead of just typing a value in my sql statement to run a report. I know you can do it from a combo box on a form that the parameter in the sql statement point to but i just want to do this from the sql query itself. This is the sql statement...

Hi Im fairly new to access and am trying to find out how to create a form that searches a table using multiple fields. I have Contacts table with the fields (Organisation, Address, Street, Town, Postcode, Telephone No, Main Activity, Secondary Activity). I have created a Search form which i...

I have create these two count querys that count the no of booking in January and the other no of bookings in Febuary SELECT Count([Booking Order].[Booking No]) AS [CountOfBooking No] FROM [Booking Order] WHERE ((([Booking Order].[Start Date])>#12/31/2006# And ([Booking Order].[Start...

I am trying to create a query that will count the number of bookings in january and a seperate count for the number of bookings in february from a table called booking order. im using the start date as the date to tell which month the booking was in. This is what i have come up with but it...

i have a field total cost on my form. In a new text field on my form i want to calculate the the total cost -10% but not to sure how to go about this.

On my booking order subform (subform of booking form linked by booking no) i have booking no, property no, price per day, no of days, total cost and total property cost. All my fields are numeric and the total coat and total property cost are situated in the subfooter of the form and grouping is...

On my booking order subform (subform of booking form linked by booking no) i have booking no, property no, price per day, no of days, total cost and total property cost. total cost shows the price for that property no depending on amount of days total cost is worked out: =[price per day]*[no of...

Hi I have a start date on a form. The fields data type is short date I need to create a validation rule so that when a user enters a date it can only be a saturday date which is entered. Thanks for your help

I have created a query that will pull the price of a property into the cost field combo box on a booking order subform depending on the values of the start date and property number enter onto the same form. The query gets the price from the property price table matching on the property no i've...

Hi i am having problem creating a query that will pull the price of a property into the price field on to a booking order form depending on the values of the start date and property number enter onto the same form. i have a two tables property price and booking order. Fields in the property...

Hi I have created a database to take bookings for holiday properties but can't figure out how to stop the properties from being booked over the same period. I have a table called booking order with the fields Booking no, property no, start date and end date. On the equivilant form for a...