Recent content by yont11

Thanks PHV, I will give it a try.

I am completing analysis on a SQL database where the date for transactions is split between 3 fields. One field has year, one has month, one has day. I have linked into the SQL database using Access 2003. My question is how do I in an Access query join these three fields into one field to create...

Thanks Missinglinq I will give it a try. Cheers.

Hi missingling, Says it can't find the field. The field is sitting on another page. Thanks.

Thanks PHV & TheAceMan1 for your help. I'll keep working on it. Cheers.

PHV tried what you said with the following: Me![Tabctl0].Value = 1 'Goto Page 2 it gave me a message Can't find the field 'Tabctl0' referred to in your expression.

PHV it is a Tabcontrol with 3 tabs.

I am having trouble getting the GoToPage command to work. I have a single form with 3 tab controls. In an on exit event I want the focus to go from one tab control to another. I have used the code: Forms!Switchboard.GotoPage 2 to move to the tab control I want but I keep getting the error...

Thanks CMP & Remou. Does exactly what I wanted.

I have a hyperlink button on a form that when clicked takes the user to a folder on a shared drive where they can choose a mail merge precedent letter. Is there a way to do this through VBA code without using a hyperlink? Thanks.

Use the Access NZ function e.g NZ([MynumberField],0) this converts the Null value to zero.

Thanks Zion7 I will give it a try.

I am attempting to use code to tell me who is logged on to a shared database. It is set up so that the result is sent to a list box. The problem is it is only returning one user even if there are 5 users logged on. The code I am using is below. Can anyone see why it is not listing all users...

Thanks PHV.

PHV can you point me in the right direction on the code to achieve this? Thanks.