Change background color of query results from access in worksheet
I have Excel 2007 and selected Date => From Access and then navigated to an
Access DB and selected a query. I chose "Table" view. The query results now
appear in my worksheet which is great. However, I want to change the
background. Right now it alternatives by row between a light blue and a
darker blue. I want the results to have a white background with black
borders but have been unable to change the format. If I go to Home and
select No fill for a color background nothing happens. Is there a way to
change the query results?
Could be the r...When converting MDE
Assuming most people aready have Office 2000, so I want to create an MDE . I
understand we should use Access 2000 to make MDE.
Since I do have Access 2002 or Office XP, how can I make MDE ver.2000
The other question, suppose I have Access 2000 and I successfully made MDE
ver200, can this MDE be opened by Acess 2002 and higher?
H. Frank Situmorang
You must have Access 2000 to create an Access 2000 MDE.
Yes: an Access 2000 MDE can be used in all later versions.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/ti...Database Files Directory
I have created a database and everything is working fine. I just would like
to access directory contents and displayed then in a form. For example I
have records that I have saved/scan to a particular directory now I would
like to see then on the bottom of the form. Can someone help me with this.
Thanks in advance,
List files recursively - List files in a folder and subfolders
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than...How can I convert text to all lowercase?
How can I convert text to all lowercase?
I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?
If not with Excel, how about Word, DOS, any other way.
I'm using Excel 7.0 (Office 95).
Thanks in advance!
Take a look at David McRitchie's Lower() Macro (I believe it will
work in XL7):
In article <firstname.lastname@example.org>,
email@example.com (HBYardSale) wrote:
> How can I convert text to all lowercase?
&g...How do I create a database from an Excel form?
Hello Everybody -
I need to see if Excel can be used to create a mailing list database from an
Excel form. If so...how do I go about doing this? The list will need to
include the name of the company, contact person, and address.
Thanks in advance for all of your help! It is greatly appreciated!
Here are a couple of links:
The first is from David McRitchie and the second is by Beth Melton and Dave
> Hello Everybody -
> I need to see if Excel can be used...Converting decimals to Time
For thousands of rows, time has been entered as 10.15 or 9.30. These are
correct times, as in quarter-past-ten and nine thirty. To perform
calculations, I obviously need to have a : (semi-colon) not a . (full-stop)
Find and replace won't work because 9.3 (nine thirty) comes up as 9:03.
I can write a macro, but trying to avoid since it's for someone else.
Microsoft MVP - Excel
"Piers 2k" <firstname.lastname@example.org> wrote in message news:uTDz539DHHA.1748@TK2MSFTNGP02.p...which xml access type?
I'm developing an ASP.NET web app and i'm retrieving some data from xml
My question is, if an xml file is going to be accessed a page is loaded,
1. use an in-memory XmlDocument (created each time the page is accessed); or
2. use a forward-only XmlTextReader object (created each time the pages is
Thanks very much in advance,
If the XML file doesn't change frequently, and it's not a HUGE file, you
should cache it programmatically with the Cache property on Page, set a
dependency on the physical file (if it may change at all), and use...Why Can't I Access Internet Links
I use Windows XP and IE 7 and suddenly one day I was unable to access
internet links that were sent to me thru regular emails to my
Microsoft Outlook. Any idea how to fix it? Thanks.
What happens when you try? Any error messages?
Hal Hostetler, CPBE -- email@example.com
Senior Engineer/MIS -- MS MVP-Print/Imaging -- WA7BGX
http://www.kvoa.com -- "When News breaks, we fix it!"
KVOA Television, Tucson, AZ. NBC Channel 4
Live at Hot Licks - www.badnewsbluesband.com
"amirstal" <firstname.lastname@example.org> wrote in message
news:d7decb35-157c-4438-82bd-24a2536d347f@m36g2...can't access public folders with OWA
I have Windows Server 2003 and Exchange Server 2003 Installed
everything works fine, except when trying to access Public folders via
Outlook Web Access, after going to the location its asks for username
and password - this works ok and the folder is displayed, but when
trying to add a folder or post a note or do anything I get:
You are not authorized to view this page
You might not have permission to view this directory or page using the
credentials you supplied.
I have tested on client machines, remote machine and the exchange
server as administrator with no luck.
does anyone have any...Auto insert worksheets for multiple page imports
I have an Access database that has a query run to create a
separate page with different Vendor Account number and
related billing account information for each. The vendor
requires this in Excel format but a separate worksheet for
each billing account.
Ex. ABC company has 10 billing accounts with information.
They want 10 different worksheets with the specific
information on each.
I know how to export to Excel but it won't create sep.
worksheets for each page created.
Can this be done?
Here's my recommendation:
Download the entire file from access to one excel file and sheet n...Continuous Pages
I created a simple report that has a Report Header, Detail and Report Footer
section. My report should only be 1 page but it goes on continuously to no
end. Can anyone tell me what I'm doing wrong? The page is formatted on a 8.5
x 11 page landscaped. Any help is greatly appreciated. Thank you in advance.
In the report properties change from continuous to page report and set
ForceNewPage (right click on the body of the report) to after section.
> I created a simple report that has a Report Header, Detail and Report Footer
> section. My report should o...SBS2008
Have a customer who has a telephone system that uses an IMAP connectionj to
the users Inbox to pick up voicemails.
Since upgrading from Exchange 2003 (SBS2003) to Exchange 2007 (SBS2008) this
has stopped working.
Users userrnames and passwords are still the same.
I've setup Outlook to make an IMAP connection to their mailbox but this
doesn't appear to work, I guess this is why their telephone can't logon
I just get a box come up prompting for a username and password ??
Is their more to it in Exchange 2007 than just doing the regular Outlook
IMAP set...Convert Publisher letterhead to Word
How do I convert my letterhead creaded in Publisher to Word or other word
processing software, e.g., OpenOffice, so that I may create text in the
letterhead to email to clients/customers? You may reply privately to
email@example.com if you wish. Thank you.
Right-click the creation, save as picture.
This tutorial is perfect for what you want to do
"JoOffice" <JoOffice@discussions.microsoft.com> wrote in message
> How ...Deployment over Citrix not working in Access
pls see my post from yesterday below. Am I in the wrong group to get an
answer on this?
I have an application that I have developed with extensive support from this
group. I just want to say thank you for all your help.
Now, my app is deployed over a Citrix network and I keep having these weird
1) on trying to add a record to a particular form (fsubDevices) I get the
following msg: Error 3201 (you cannot add or change a record because a
related record is required in table 'tblVisit.') in procedure
cboDeviceLUno_AfterUpdate of VBA document Form_fsu...can't convert jpg or other into publisher
I reinstalled publisher after reformatting my xp Dell. Now publisher will not
convert image into the page where I want a picture. I can scan one in, but
can't import clip art or a picture located elsewhere. I can import a picture
into word. I reinstalled publisher again and same thing. I put it on a
friends computer and everything works fine - I'm puzzled. What are they
referring to when it's saying can't convert the image - also mentions a
I need help.
Importing from where? Are you using the Clip Gallery or Organizer?
If you are trying to import ...Access 2007 Runtime with OLE Object
I have form control bound to an OLE Object. The users are told to right
click the OLE object on the form and make a reference by link, but the users
are not able to right click on the OLE bound control when they are using 2007
How can I allow the users to make a reference to an OLE Object when they are
using 2007 Runtime?
IT Guy From Arkansas
Maybe there's another way .. is there a way to let the user browse to the
location of the file and then put the location as a hyperlink in a table
...RFID Use with Access
I am looking to find the steps necessary to make Access ready to interface
RFID information captured from passive RFID devices.
I would appreciate anyone in the group sharing this how-to with me.
Zachry1 <Zachry1@discussions.microsoft.com> wrote:
>I am looking to find the steps necessary to make Access ready to interface
>RFID information captured from passive RFID devices.
You should really be looking to the vendor of the RFID capture
devices. They should have DLLs/OCXs which you can install and sample
code. VB 6 code usually works just fine in Access.
Tony Toews...Spending by Category Report on Home Page
I have Customized my Spending by Category Report to not include Taxes and
some other stuff (under the Reports tab).
However, I also have the Spending by Category report show up on my Home
Page. This report does not include the customizations I made under Reports,
so it shows ALL categories.
Anyone know how to make the Home Page report be the same as the other one?
The report on the home page is not customizeable. I believe this is rather
meant to give you a general overview of your spending. Infact if you watch
closely at regular intervals the all the homepage charts ...Delete jpg file based on Access field contents
What would be the best way to have access delete a bunch of jpg's?
I have two tables in mdb format, the main table has 36000 records. When I am
done with a record, I move it to a Deleted Record table (using a query and a
macro). There are about 1300 of the deleted records that have an associated
jpg file. The file size is around 100k, so I have around 130 meg of files
cluttering up my laptop. I will never look at the jpg's again. I know it's
not a lot of space, but why not have some code get rid of them?
So, should I use a button on a regularly accessed Fo...When I insert new pages the fonts on the existing pages change
I have a 28 page document that I am trying to insert new pages into. When I
insert the new pages, Publisher changes the font on all the existing pages -
quite a mess. How can I avoid this??
On Wed, 28 Dec 2005 17:39:03 +0000, Jim wrote
(in article <A9F6706D-208F-4FB4-BECD-70077760824A@microsoft.com>):
> I have a 28 page document that I am trying to insert new pages into. When I
> insert the new pages, Publisher changes the font on all the existing pages -
> quite a mess. How can I avoid this??
Unlink the boxes. If the boxes are linked then the font will change globall...Convert Word Table -> Excel without merged cells?
Whenver I copy/paste tables from word to excel, I get merged cells in
Excel whenever there are line breaks in the word table cells. How can
I avoid this?
Saved from a previous post:
If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.
One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.
I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)...Converting an Excel List into Access
I am unable to import a specific excel document into
Access. I have done countless other imports and never
encountered an error. What are some possible reasons for
being unable to import the file?
Yes all that shows up is: "An error occured while trying
to import(directory path here). The file was not imported"
>What happens when you try to import it? Is there an error
>> I am unable to import a specific excel document into
>> Access. I have done countless other imports and never
>> encountered...Help with Hurricane Database
I work at the Corporate office of a fast food chain. We have almost 1000
stores in 10 states - mostly in the South. We have many stores in the
hurricane zones. During Rita and Katrina we decided we needed a better way
to track how our stores are affected and what help we could provide. I've
designed a database to do this.
I have three main tables:
fldUnit - the unit number assigned to the store
fldPr...front page 06-07-10
I have lost my include files and now have no headers or includes. What can I
How did you lose them?
"gaye" <firstname.lastname@example.org> wrote in message
:I have lost my include files and now have no headers or includes. What can
Have you previously published the website to a server on the internet? If so, get the files from the server.
Open the remote site in FrontPage and publish back to your PC - but do not do this if the includes are missing on the remote site.
...Remote Access for CRM 3.0 Sales for Outlook
I'm using Outlook with RPC over HTTP and I'm looking for a good way to use
CRM 3.0 for Laptops over the web. I'd like to avoid VPN at this stage and
it's vital that these sync up often because we are using the service module
heavily. I would also like to get it to run on PC's not joined to the
domain. Does anyone have any tips for doing either of these?
The app does not work with an RPC over HTTP connecion. There is more to it
than just the Exchange connection as the app needs to communicate with the
CRM Server as well. You might be able to figure it out, but ther...