General

Using tables created in 2003 IN 2007
My office has recently upgraded to 2007. I enjoy new features such as the ability to highlight a few words within the table without the ENTIRE table's font changing; unfortunately, this only works in tables I have created since the upgrade. My old tables that were brought over from 2003 do not have this capabil... 2 Apr 2010 20:24

Macro Variables
‏‏كتب "Dorian" <Dorian(a)discussions.microsoft.com> في رسالة news:BCD036E5-BC6D-42A9-9450-BBF675418487(a)microsoft.com... You could display a form to collect the value for ID, then store that value in a global variable. Then all your queries could refer to the global variable via a function call w... 2 Apr 2010 17:05

Query to count between list of number (Predicting Start/End that may occur in data range)
I should have tested first. Here is a query that seems to work. My test table was named tNumbers and my field was named Counter. SELECT QStart.Counter as StartNumber, Min(qEnd.Counter) as EndNumber, Min(qEnd.Counter) - qStart.Counter + 1 as Amount FROM (SELECT A.Counter FROM tNumbers as A LEFT JO... 2 Apr 2010 17:05

ola
ola ... 2 Apr 2010 13:45

Duplicated emails
Instead of receiving 1 email for 1 message i am receiving 2 for each message. In other words my in coming messages are being duplicated. ... 2 Apr 2010 13:45

Outlook 2007 and Access
Is there a way to keep Outllok and Access in sync? Thanks in advance for the help ... 3 Apr 2010 07:10

Backing up data base
How can I make this automatic when the db is closed? ... 2 Apr 2010 18:12

Report has more records than source data
My source data is from a query that has 3 records (I made it small), but the report is duplicating one of the records giving me a total of 4 records. ... 2 Apr 2010 12:38

Access 2007 Paste Append Problem
When I am trying to paste append some data from Excel to a table in Access, some cells are added as blank cells. This happens only when the related column's field type is "Text", and the pasted values contains both text and number characters. I did not face with this problem when I am using Access 2003. ... 2 Apr 2010 09:18

Locking down a Program.
OK I am writing a program for a friend of mine as a favour. Her boss has dramatically increased her and coworkers reporting requirements without giving them any tools to do the job. This is my first Access Program. I want to lock down my code and prevent editing of the forms. What is the easiest way to ... 2 Apr 2010 10:24