Recent content by yetstar

Ah, well the form goes into the future as well, so the last date would be the last date in the table (which is about 2 years into the future!) BUT I've just thought, if I limit the dates shown in the query that the form comes from to today()+7 or something, this should suffice.....we dont need...

Hi all I've trawled the posts and cant find anything relating to this, so would appreciate any help massively :) I have a form which is used to show whether certain people are present on certain days, using a simple date/staff/tick box format. (See example) I'm trying to have a form open at...

Worked it out :) Checkit..... Private Sub cmdAddRecord_Click() If Me.Status.Value = "Closed" Then If Me.P_Ref.Value & "" = "" Then MsgBox "Please ensure the P Ref field is complete", vbInformation Exit Sub Else If Me.No_Users_Reported_Affected.Value & "" = "" Then MsgBox "Please ensure the...

:( So I try completing the form leaving one field blank. Great, it gives me the relevant message. I fill in the required field, and click the next record button........and nothing happens. Can anyone see where I'm going wrong? Here's the code: Private Sub cmdCloseForm_Click() If...

Thanks for all the replies guys, I'll have a look now and check it out (and yeah it seems so simple when you put it like that!) Dead on Linq, but when it was in the Form_BeforeUpdate event, it seemed that the code would either stop the update, ask for the relevant fields to be updated and then...

I've got this code from searching through the threads here, but when I use it, the relevant messageboxes pop up, great, but then the form wont go to the next record....it just remains stationary. Any ideas? I think my Else's and my Endifs are in the wrong place. I've been pulling my hair out...

Hi all I'm having this exact same problem - the form has a validation requirement of 'IS NOT NULL' yet when the user closes down the form it closes happily without showing my statement :mad: The table field is set to not required, because there is an input form where the user inputs the...

HA! It was the space in the [Business Unit] that was causing the problem there! Nice one my man! Many thanks for your help :) :cool:

Ok, I'm still getting an error saying 'You canceled the previous operation' (Access cant spell cancelled!) There is already a 'not in list' procedure on the combo box so I'll remove that and try again. Also, shouldnt there be a Dim BusUnitstr as String?

Wazz, you are a star - I'll check it out and get back to you mate, thanks again :) (I thought I was doing unnecessary query opening!) :rolleyes:

:( I've tried swapping the query to the main table (I'm not sure the query is necessary with a DLookup) and changing the Me.CboCombo1 to the full name of the form but still, all I get is the query opening then the message You cancelled the previous operation Any ideas? Private Sub...

Thats lookin good Wazz, I'll try it out and let you know mate. (And yep, the ref is unique ;) ) Thanks a mil for your help :)

Here's where I am with the code (trying the DLookup function!) It runs the query, then closes it instantly without opening any forms :( Can anyone identify where the error is? Private Sub cmdUpdateRecord_Click() On Error GoTo Err_cmdUpdateRecord_Click Dim stDocName As String Dim...

Hmm...I dont think this will work. Once the query results are returned, I need to then open 1 of 4 forms based on a particular column within the results. I cant see how a DLookup would do that? What I need is some code or something that will basically say: IF query result is "D", open form D...

Thanks Wazz, I'll have a look around the net for some info on DLookups (havent used them before but I'm sure they arent too hard....) I'll let you know how I get on :)