Search results for query: *

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...

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...

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.

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...

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.

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...