Recent content by philtr

Solved it! Many thanks for you help ajetrumpet, works perfectly :D

I'm using access 2007 and have some date fields in my forms, i'd like to be able to blank out weekends and public holidays from the calender/date selector in these fields so theres no way those dates can be selected. Is this possible? Thanks.

Thats exactly what i'm after although i've had no luck getting it to work, i've tried the following code on the on click function for the field (ProjectID) I want it to link from Private Sub ProjectID_Click(Cancel As Integer) DoCmd.OpenForm "Work Orders", acNormal, , "ProjectID = " &...

Hi guys, I have a query embedded into a form called 'approved work orders', the results from the query are non editable in the form but i'd like the user to be able to click each record and open up my 'work orders' form where I can then edit the data. Any ideas? Is this even possible? Thanks.

I essentially want it to do exactly what the standard search on the navigation bar does at the bottom of a form, but search one specific field. So I don't want it to list a whole load of records, just jump to the record with the closest search term ideally.

Custom Search Feature I have a form which i've removed the record navigation from, but i'd like to be able to add a custom search option to specifically search the 'ProjectName' field, is there any way I can do this? Thanks in advance.

Excellent, thanks. One last request, is there any way I can force the user to have to enter data in the second text box after they've entered the data in the first one? The validation rule in the second text box only forces the user to enter the same data after the user has clicked in the second...

Fantastic, I managed to get DCrake's code working, although thank you both. Couple more issues I have are that it works for the first record but when I move to another record; the second text box remains visible. And the text entered in the first text box carries over to the next record, is...

What code would I need for the key press? Really new to VB so any help is appreciated :)

Thanks, i've got two text boxes now, with a validation rule. Is there any way I can hide the second text box until the user has entered data into the first and then hide the second text box again once the data has been validated?

I've got an attribute called GPS which is really important the user enters the data twice for verification before it can be inserted into the table. Also if the data doesn't match up an error message should be displayed and the user must then try again. Any ideas? thanks in advance. :)

Very new to MS Access so go easy ;) I've got two check boxes, one called Completed and the other called Infill, i'd like the Infill box to be locked or unabled unless the Completed box is ticked. Any method of doing this?