Search results

Righto. Because of the confidential information in the database I'd be breaking the law sending out with real data so I've removed just about everything apart from the form and 2 fields where I have the question. Autoexec opens the form. Shift and open file bypasses this. 2 fields on the...

I know the event is firing because when I changed photo match to XXX in the event procedure I got an error message. I can click on photo match but nothing happens to photo required. The logic that I want to say is "If photo match = true then photo required = false" Not sure how to put a...

Thanks Bob - Still not working though. I've selected Event Procedure and the code reads as below (Note fields do have spaces) Private Sub photo_match_AfterUpdate() Me.[photo required] = Not Me.[Photo match] End Sub

Thanks for the quick reply Bob. I'm not sure what you mean by the control names though. I've entered Me.Photo Required = Not Me.Photo Match in the After Update box on the photo match properties and am getting the message "Cant find the macro me" thanks Stu

Hello all, got another problem that I'm sure you lot will sort in a flash. On a form I've got 2 yes/no fields. One called photo required and one called photo match. Photo required may be yes or no but will usually be yes. When a user clicks photo match as yes I want photo required to...

Morning o' wise ones I've got a form in a database but it wont respect required fields. If I close the form using the x in the top right hand corner everything works fine and I get the message that I have to put data in certain fields before closing. If I close the form using the button...

Spot on. How do I make the query updatable :)

Hello all, Hopefully this is a nice simple one for you clever people... I've got a form on a database and the paste function is disabled. Copy works ok and I can copy from a field to another application to I know thats ok. I cant see anything obvious on the form properties that would...

Cracked it - It was on the page footer and not the report footer - Thanks for your help :)

The field Days_Late is calculated automatically but on a form, not on the report. On the report its just inserted as any other field. Annoying thing is that when get Access to build a grouped report and select sum this field in the summary options it works and the formula looks the same - Just...

Afternoon all, Hopefully this is a nice simple one - Confusing the hell out of me. I've got a report with a column called Days_Late. At the bottom of the report I want to display the sum of the column. I've added a text box and in the control source entered =sum([days_late]) but that just...

Thank you everyone for your advice and I'll let you know how I get on

I think your right. I keep coming up against barriers when I try to store a + number. Another way I could do it would be to have a second field, X and say if source_web=-1 then set x to 1. I know this code isnt right but hopefully you can follow my logic enough to guide me. Thanks for your...

Another approach, running this after update on the field called source_web Gives me the error message Sub not defined. Can someone tell me what I've done wrong ? Stu Private Sub Source_Web_AfterUpdate() iff [Source_Web] = -1, 1, 0 End Sub

Thanks for the reply but I'm not an expert user and am not sure where to use this code. Stu

I'm making some progress and can get the data to export as -1 for yes adn 0 for no. As we want to use the data in excel -1 is no use. Is there any way I can change -1 for +1 ? Stu

Hello all, I've got a database running which has some text and some yes/no tick boxes. I want to export a repot to an excel file. I've created the report and have a control button on a form that sends the report to the file. All works wonderfully apart from the fact that none of the yes/no...