Search results

Mile-O-Phile, Multiple expressions can be used in a single line when seperated by commas - i.e. Case Is = datEaster - 2 ' do not increment Case Is = datEaster + 1 ' do not increment Case Is = datMayDay...

Thanks Colin, I'll check this out. I was trying it earlier today though & was getting strange results whereby the loop was incremented way beyond the amount of controls that there should have been in the collection?? If this is the way to go though so be it!! Thanks for the advise, Patrick.

Hi Colin, thanks for the reply, the thing is the fields aren't Necessarily "Required" it's moreso to aknowledge the fields that are left blank & perform an action if necessary (such as inserting a value programatically). Also I really don't like those nasty Access messages you get when you don't...

Hi all, What I'd like to do is: In the after update event of a certain field on my form, I'd like to validate other fields on the form before allowing the user continue. I don't want to go down the if [field].text = "" etc road as ther are a lot of fields on the form. What I'd like to do is...

Just compiled it locally & looks fine.. Do you know what line you are getting the error on? Also, just out of curiosity, try Dim db as DAO.Database & dim rs as DAO.RecordsSet instead of the current dim db as database & dim rs as Recordset

Theres a NotInList event for the Combo box, you can trap it here.

Try going into the code window, Go to Tools-> References. Look for Microsoft DAO 3.x object library & check it on in the list.

Hi Rob, Not certain but you could try CurrentUser = "YourUserName" in the Load event. CurrentUser is the Access variable where the username is stored. HTH, Patrick

The ampersand is the VBA Concatenation operator whereas the plus is the addition operator. Regards, Patrick

Hi, I have an invisible subform on my main form. The form is made visible based upon options selected in a data tree, i.e. if a certain node is clicked then set the recordsource of the subform & make it visible. What I want to do is: When a certain node on the tree is clicked, show the form &...

Does the user log in as RHO? This value is stored in the CurrentUser variable when a user logs in. If this is the case then the Forms filter property could be set accordingly.

The quickest solution I can think of would be: Your are probably determining the status to generate the report for via a control on a form - i.e. select the status from a combo box, click a button & the report is generated for the status selected in the combo. If this is the case, then I'd...

Hi arage, I'm not sure what you mean by the set import dialog box but it sounds like this is a common dialog control. Maybe you can create your own set import dialog by adding a common dialog control from the "include activex control" option. You can then set the dialog to look in a certain...

Sounds like Word isnt installed on the second machine. OLE means object linking & embedding, the object still needs Ms Word to work. Regards, Patrick

Not the best solution in the world but.. you could switch to design view then straight back to normal view using code - the user wouldnt know as it would be almost instant.

A fellow IrishMan?? You havent attached the database.

What exactly do you mean by a PopUp menu?

You could try: [YourFormName]!YourSubFormName.requery or try refresh

Rob, You have the patience of a saint BUT it still does the same thing. I'll have to take it apart & thoroughly debug it as it's really giving me a headache - on a Friday afternoon of all days!! If you have any suggestions as to a better way of approaching this (not enough space for a comment...

Thanks for your input Mile-O=Phile, I tried your suggestion but the form doesnt seem to be recognised by the Forms collection. I can only get access to it by explicitly referencing it as Form_[FormName]. Regards, Patrick