General :: How To Access 2007 / 2010 Colour Picker

May 1, 2013

I've been updating the look of some of my db's and am trying to access the new style colour picker per Office 2007/10.

Up to now I have been using

Private Declare Function ChooseColorAPI Lib "comdlg32.dll" Alias "ChooseColorA" (pCHOOSECOLOR As ChooseColor) As Long

which displays the pre 2007 style.

I've looked all over the web but cannot find anything relating to the current style (other than using it from the ribbon or control properties), so not sure if I should be looking for a different function or a change to the ChooseColor type values.

All db's are running 32bit access and at the moment 32bit OS but will no doubt have OS upgrades to 64bit soon.

View Replies


ADVERTISEMENT

Forms :: Disable Date Picker In Access 2010

Mar 6, 2014

disable the data picker for every field on every form in my application - without doing it the long winded way of manually turning it off for every field?

View 2 Replies View Related

Access 2007 / Date Picker Doesn't Appear

Aug 7, 2010

I've got the data type set to Time/Date and the Properties of the date picker set to, 'Yes, for Dates' but it still doesn't appear in my table column.

How do you add it to a form? (Access 2007)

View 9 Replies View Related

Forms :: Disable Date Picker In Access 2010 Runtime?

Jul 10, 2013

I have an application created in A2003, but my client's machines nearly all use A2010 runtime. How I can disable the Date Picker completely on all forms as I have no need for it. Obviously I can't access the 2010 property sheets to disable it that way.

View 2 Replies View Related

Colour Picker

Jan 31, 2006

Im using a colour picker to change the colour of a text box on click. I need to store the colour in the text box. At the moment it changes the colour of the text box in every record. How can I overcome this? Thanks!

View 2 Replies View Related

General :: How To Use Automation To Run Word 2010 Mail Merge From Access 2010

Nov 26, 2013

I have a MS Access 2010 application when the User opens form CONTACTS Form

◦User finds single record to be used CONTACTID is identifier to be used for selection
◦User clicks button to open form frm_MAIL_MERGE
◦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID.
◦User selects single .dotm file for merge
◦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number
◦User enters CONTACTID to be used for the mail merge
◦User selects SUBMIT
◦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID
◦Merged document is saved on the user Desktop as xxx.docx

View 10 Replies View Related

General :: Possible To Have Value In Excel 2010 Cell Used To Update Access 2010 Database

Apr 4, 2013

Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?

For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.

View 1 Replies View Related

General :: Calendar Synchronization - Access 2010 To Outlook 2010

Mar 23, 2015

I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?

Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.

View 2 Replies View Related

Modules & VBA :: Replace Function In Access 2007 For HTML Email In Outlook 2010

Aug 4, 2014

My company recently upgraded our MS Office from 2007 to 2010 (except for Access).

Previously, when I had Access 2007 and Outlook 2007, I had a process that generated 50+ dynamic emails from an Outlook template file (.oft).

The code would loop through a listbox and replace the template's default text to a string of text specific to the selection in the listbox by utilizing the Replace() function on the MailItem .HTMLBody.

Since the upgrade to Outlook 2010, the code is able to run, however, the Replace() function is no longer working; Instead, each email that is generated maintains the template's default text.

The only thing that is not working is the Replace() function, all other aspects of the code work fine.

I've provided a simplified version of the code below:

Dim myOlApp As Outlook.Application
Dim objMailMessage As MailItem
Dim stBody As String
Set myOlApp = Outlook.Application
Set objMailMessage = myOlApp.CreateItemFromTemplate("C:UsersDesktop emplate.oft")

[Code] .....

I've recreated the template file in Outlook 2010, thinking that the template created with Outlook 2007 would be the culprit, but to no avail.

What could have changed from Outlook 2007 to Outlook 2010 that would render my previously valid code ineffective?

Are there certain references I need to enable in both Access and Outlook to allow VBA in Access modify the content in an Outlook email?

View 12 Replies View Related

General :: Access Import Changes Colour From Blue To Red?

Dec 7, 2012

I tried splitting my main database in Access 2010 but came up with a 'subscript out of range' error, so in order to solve this, I've imported all my database objects into a new database. The splitting process (and other problems like web incompatibility) issue is now solved and works fine, but for some weird reason, all the objects that are one particular shade of blue in the forms and reports (shape fill, outlines, text colour) have changed to red.

Blue: Accent 1, Darker 25% (the colour i want)
Red: Accent 2, Darker 25% (the colour it changes to)

There is no code anywhere that specifies these colours in any sense, and even importing single forms at a time as a test yields the same result. I could change them all back manually to the right blue, but seeing as there are around 900 forms and reports, each with multiple labels/shapes etc...well you get the point.

View 1 Replies View Related

Program Working In Access 2007 Not Working In Access 2010 Due To Missing OCX File

Dec 27, 2014

I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.

The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?

View 1 Replies View Related

General :: Changing Font Colour Of One Record In Access Database

Jan 12, 2015

I would like to get a third party to edit a database and record those edits by changing the colour of the font. I know this can be done in layout mode, but it changes the font in all records, I only wish to change the font colour in one record, how I can do this, without changing all the records in the database.

View 3 Replies View Related

Queries :: Access 2007 / 2010 - Combining Two Queries Into One?

Jan 24, 2014

I have two queries, one base upon the other. I would like to combine them (If Possible) into one query so I can embed them into a form or report. I have tried without success at finding the answer on the forum as well as searching the web.

The table lists employee numbers and dates they worked. I need a count of how many employees worked each year, based upon the paycheck date, not the actual date worked. Pay check dates are two weeks apart. An extreme example, is the first pay check date of 2010 was on 1/1/2010, but all the days worked were in 2009, this would have to be included in 2010 not 2009(See the query for further date calculation understanding). Anyway, the date calculations are not the issue here.

I only have one table, so if I am not mistaken, I can't use the WHERE (SELECT... JOIN) feature. I also was unsuccessful at using SQL DISTINCT.

I am running ACCESS 2010 Tables are ACCESS 2007.

OS is Windows 7 Ultimate.

I have included a same database with the queries. qryEmployeesAnually2 is the results I am trying to achieve.

View 7 Replies View Related

General :: Access 2010 And Access 2003 On Same Desktop?

Mar 5, 2013

is there a way to have both Access 2010 and 2003 exist peacefully on the same desktop. My company uses Office 2010, but my department has an Access 2003 application. As a result, I have to have A2003 on my desktop and use it quite frequently for this one application.

I have some small databases that I really want to move onto A2010 so we can take advantage of SharePoint functions, etc. Is there anytning I can do to be sure that the .mdb and .mde open in A2003 and the new .accdb opens in A2010, without getting errors and the Windows installer going through the Office installation process for the respective version? I've gone to the file locations and set the "Open with" setting to the respective version.

View 4 Replies View Related

General :: Access 2010 - Status Bar Not Visible?

Aug 15, 2014

I am using Access 2010. I Have the 'Display Status Bar' box ticked in Application Options but the Status Bar is not being displayed.

View 8 Replies View Related

General :: Editing MDB File With Access 2010

Nov 15, 2012

Any issues with using Access 2010 to edit an mdb file..I know there are backward incompatibility issues with 2007 and 2010, but these are both accdb formats.

View 1 Replies View Related

General :: Get Rid Of Dialog Box When Closing Access 2010

Oct 21, 2013

I have a Access 2010 DB. The mainform have a subform with one table alone.

I have a button who close Access when the user are finish on the mainform. Still I have the upper right corner X-button who also closing the app.

My problem is that when the user use the X-button then a dialog box appear and ask for saving the changes for the table in the subform on the main form. The user must then do the choise 'yes' , 'no' , 'Cancel'.

There is no need for this dialog box, (I take care if it's necessary earlier) but I can't get rid of it.

View 12 Replies View Related

General :: MS Access 2010 Cannot Remove Password

Apr 23, 2014

I have MS Access 2010. I cant remove password because when I open in exclusive mode, file, info, there is no decrypt password option.

View 1 Replies View Related

General :: Hide File Tab In Access 2010

Jan 25, 2013

I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. How to get rid of the default File tab or at least disable it?

View 8 Replies View Related

General :: Access 2010 - Database Only Working In PC?

Aug 27, 2014

I am Using Access 2010 Version. I have created a Database which consists of Linked Tables (from remote Server), Queries and a Form.

I am using Form to search the required Data. Every thing is working in My PC. But, when the Database file is trying to open from my colleague PC. It is not working. I mean, The Form is opening but when I click the Button nothing is happening. My Colleague is using 2007 Version of MS Access.

View 5 Replies View Related

General :: Assign Stock To Customers In Access 2010

Jul 28, 2014

In MS Access i want to be able log jobs and be able to assign my stock to the jobs i have logged is this possible ? how to create a database to log jobs but how can i make it so when i add stock to the job it will remove it from my stock pool and assign it to the customer thus taking it out of stock.

View 3 Replies View Related

General :: Spell Check In MS Access 2010 Runtime

Sep 16, 2013

When distributing a program using 2010 runtime, I find that the spell check doesn't work. Is there a spell-check .dll or is there anyway I can get a spell checker?I have several memo fields with long report-type data entry which is being keyed by mutants. Spell checking is essential to get an intelligible report.

View 1 Replies View Related

General :: Access 2010 - Search Key Was Not Found In Any Record

Dec 10, 2014

I have a split database with several attachment fields that work fine.

When I try to create a new attachment field in the BE, upon opening the FE, I get the following error: "The search key was not found in any record."

I have tried several ways: first create the attachment entry in the BE, then I can't open the FE. Create it first in the FE, leave it unbound and then create it in the BE - same error.

View 1 Replies View Related

General :: Enter Parameter Value Error On Access 2010

Jul 20, 2012

I continue to get this "Enter Parameter Value" on my access and I can't figure out how to fix it. I have access 2010..

"Field1. Filename"

View 1 Replies View Related

General :: How To Split Hyphen From Text In Access 2010

May 4, 2015

I have been doing an exercise to split the data from the list of the information into column A, B & C. Unfortunately the data value that i have consist of several set of data format therefore it create an issue for me to separate the information in Access 2010 easily.

eg.

Original Data Field
FLRY-B-0.75-L-GY
FLRY-4.0-V-R
VTAC-GY 19X20
COT-F2-5-DL

Actual Data To Populate Into Column A, B & C should be the following :

A
FLRY-B
FRY
VTAC-GY
COT-F2

B
0.75
4
19X20
5

C
L-GY
V-R
(No data captured for this column)
DL

View 14 Replies View Related

General :: Importing XML File Into Access 2010 With XSL Via Transform?

Dec 9, 2012

I'm having difficulty getting my import to work... when i call on the original XML file I get too many tables... when i call on the XML file using the transform function of Access with the XSL file it gives me only two tables "body" and "tr". Body contains the value "Weather" and tr contains the value "Day".

Import the day as month/day/year into a field "Day" in access table "WeatherSFCAL"

Import the Fahrenheit temp from the high section into the field "High" in access table "WeatherSFCAL"

Import the Fahrenheit temp from the low section into the field "Low" in access table "WeatherSFCAL"

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved