Search results

hi i have created a button by a wizard in access 2007 on a form populated by a query, i have added a button so that it opens my invoice however when we click the button nothing happens but my all my other buttons work here is the code: Private Sub Command17_Click() On Error GoTo...

it solved the solution when it was basic, and still does but i would rather it be applied to the combo box which doesnt work

i have created an invoice and i want to create a sum of all the individual costs which are generated to form grand total i tried sum([total cost]) but it doesnt work [total cost] is the field i am adding up

I am having great trouble with this I have created a compare query which has tells me whether there is a clash or not but what i really need is a way in my form once i have selected the date only the available products for that day are displayed (i.e. booked out products not shown products...

cheers works perfectly

i dont know realy what it says new to access and not much clue

I am trying to create a report which summarises information collected in my form i hace created a query which combines all the information however once i insert a query table into the design view and select the field i want when i run the query it comes up with multiple copies of the same...

NoClash: ([tbBooking_1].[Booking Date]<>[tbBooking].[Bookingdate]) i have now entered that and now have it working. however in the table it puts -1 for true and 0 for false what do i add to it so i can make it say clash or no clash??

yes that has helped me alot so far but they have this on that website NoClash: ([tblEvent_1].[Start] >= [tblEvent].[End]) which i understand but how would i go about that they cannot equal each other what do i use

i did not put it in a new field, i have now put it in a field but it comes up with up with #Error

what does the PickAnyName: mean because copied pasted in and came up with an error message saying you may have entered an invalid identifier ir typed parenttheses following the null constant highlighting the first bracket?

tried doing that put =IIf([surface type]=1,"grass",0) but didnt work :-/

I have gone into query design and want to know what function i use so that if value =1 in my table that it changes to so that grass is displayed

how do i create parameter query so that if i select a date that it shows all the relevant information what is required, so it can be printed out for my daily deliveries

hi im very new to access how do i once i have selected a date in the field on my form. how do i make it so that the same product cannot be double therefore dispears or cannot be selected from the drop down list for a particular date which the product already booked out for, i know i have to use...

In the design view of the tables at the bottom i have put validation in, with a personalised message too. How can i enter another validation and another tailored message as this is what is needed, how do i do length check too??

hey hey alice, i need to do the same too :P

as is when you create a new record and only enter certain data into the fields and miss some fields out it gives an error message that a value must be entered

2007 the newest one

in the design view of a table on the general tab when i click validation rule so that the expression builder appears. what do i type in so that presence check occurs and i can get an error message saying enter a value also how do i apply length check. hayden