Help

Buttons
Okay, I have some buttons (images) that I got from (FREE) www.freebutton.com and OTHER free places. I put them on my switchboard to make the appearance better (it looks great!). Next to the button, I have the name of the form (i.e. expenses), but what i want to do is make it even easier for the user. Is there ... 25 Apr 2006 12:59

Problem with SetFocus
>From an Access form, I am trying to change the focus from a flex grid to a text box. Whenever I call the setfocus method for my text box, I receive the following error: Microsoft Office Access can't move the focus to the control txtJobNotes. What would prevent Access from changing the focus to the text box? Th... 19 Apr 2006 15:04

SQL
I'm new to Access (2000). I'd like to 1) be able to manipulate Access tables directly from SQL, and, more importantly, 2) use pre-existing Access databases to create MySQL and PostgreSQL databases without the use of translation software. How do I gain direct access to the SQL files? ... 2 Apr 2006 05:38

Email fonts
I have some code in a Access 2002 database that sends an email, using the SendObject command. Is there anyway to bold or underline a specific word in the body of the email. Below is a small snippet of my code: strMessageBody = "PLEASE DATE AND SIGN ALL DOCUMENTS" & _ vbCrLf & ... 6 Apr 2006 15:55

Small Calendar Question
I've been using calendar controls in a database used for recording incoming mail but one thing I'm not sure of is how to have the calendar control open with the date set at the current month/date. As it stands, the calendar always opens based on the creation date of the form/calendar control but it would be useful... 15 Mar 2006 19:05

Pivot Chart - inability to prevent rounding of data (Access 2003)
Hello, I've created a form that contains a single unbound combo box and two subforms. The two subforms display the results of a query (driven by the combo box selection) in both tabular and pivot chart formats. The problem that I'm having is that the Pivot Chart that I've created rounds all of the values down to... 16 Mar 2006 23:39

SQL DECODE FUNCTION
I have the following command. SELECT A.STORE_NAME, A.STORE_NUM, A.ZIP_CODE, B.EMPLOYEE_ID, B.GENDER, B.EMP_LEVEL, C.ITEM_CODE, DECODE(B.ITEM_CODE,1, 'CHICK_BURGERS') ITEM_DESCR, DECODE(B.ITEM_CODE,2, 'HAM_BURGERS') ITEM_DESCR, DECODE(B.ITEM_CODE,3, 'PIZZAS') ITEM_DESCR FROM STORE_DETAIL A, EMP_DETAIL B, ITEM... 3 Mar 2006 15:31

Conversion of an MS Access application
I have built an MS Access Application under MS Office XP (but I also own MS Office 2000). I have split the application in the pure database tables and all the queries, forms, reports and macro's. Now i want to use this application for different foundations in the Netherlands but I want to secure my application so... 1 Mar 2006 04:58

Automation operations
I have a Msaccess db that is giving the following error in Office 2003 but not in Office 2000: The object doesn't contain the Automation object 'RecordsetClone' You have tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method ava... 24 Feb 2006 09:08

total minutes in access 2003
I am trying to calculate the total minutes in a day that an employee provides services. When an employee works starts at 11 am in the morning and finishes at 12 am (midnight) it is calculating it as 12am start and 11 am finish with a total of 11 hours not the 13 it really is. I also need to print reports for tot... 22 Feb 2006 15:52