Search results for query: *

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.

I have two reports which I want run automatically when I start my database. Once these reports are run I don't want them to run again on the same day if I exit the database and then start the database again. The code will have to be date based I believe and placed in the openform event in my...

I am mail merging a date from an access database to a word file. The problem is when the date is merged into word the format is month-date-year, I want the date to appear as date-month-year, can anyone tell me how to change the date to appear as I want. many thanks.

More information for Zion7 & MajP. The reason for the combo box is to limit the choice of milestones that can be selected (i.e there are only certain choices)The work flow is part of a professional services business where there are certain stages that need to be completed in a client matter...

I am working on a workflow for a project. I want to run code from say an exit or lost focus event on a combo box. The combo box allows you to choose the milestone that the project is up to. When the milestone is chosen and the user leaves the combo box I want code to run and change the combo box...