Search results

Hi All, I am hoping some kind person will be able to assist my learning curve. I have managed to get through the compile errors with my query but I am battling to get the loop to work correctly. Basically I have a table called tblIT0008WageTypeValues which holds constant values and looks like...

Hi All, Thanks for your comments. I have decided to use the Event Procedure with some VB code - instead of the Macro, but I still have the same problem. The subform still appears as a new window. I need to subform to appear on the bottom half of the screen. Both the subform and the form need to...

Hi All, I have a macro which runs from a form. The macro just opens up a subform. The problem is that the subform gets opened up in a new window. I have changed the property to modal, but this then still opens up the subform in a dialogue box. Basically I want to be able to view both the form...

Hi Ian, Thanks very much for answering my query and for writing the required code. Much appreciated. Cheers, Evan

Hi All, How can I report on records which have uppercase values in a record. The data I have in the table is a mixture of Titlecase and UPPERCASE. I need to report on the uppercase values. Thanks, Evan

Hi All, Can someone please let me know how I can search for foreign characters in a field. I am only expecting letters to be in the field, but the user may have entered another key by mistake. Keys such as :,@,~etc could have been entered by the user. Should I look for specific values where...