I have created a subform that has as its control source a select query. The
subform is linked to the main form. Currenlty, the only way in which I am
able to view the subform is horizontal veiw. I have to scroll accross the
page as the records are listed adjacent to each other. ...

I am very very very new to Access and need some help.
I have a simple database with 3 tables and 1 lookup table that I just
started working on. I would like to make the primary key on the main table
the "ProjectID", the format needs to be XXXX-XXX. I would like for the first

We just recently upsized our tables to SQL and everything is working as it
should with one exception.  When the operators enter a new record that would
cause a duplicate key, instead of telling them via an error box, it acts like
it takes the data but does not really add it to ...

Having  a problem getting this to work.  I tried isnull to show 0 value when
a count (per year) was none... any ideas?  (this is my last case try)
select 'Year - Count' =
case when count(distinct casekey) = 0 then Cast(year(filedate) as

I know that the solution to my question maybe very simple but I cannot figure
it out.
Using Access Xp. Users print their daily reports from Access F/E application
, no problem here. However, users go to Word to print certain forms

I have recently split my access database using Albert Kallal's excellent
article and as suggested have FE on each workstation .mde.
I have also copied several Word documents linked to the database to each
workstation assuming that this would be necessary and that these could be

i'm having some trouble sending the data i got from a query to a the report..
i have a form where i can input de month and year i want to query from the
data base.. Then i have this button:
Private Sub visual_Click()

I have a laptop with an access database (front-end / back-end setup)
that functions properly until you try to search using the combo box.
As
soon as you hit Tab or Enter it says "Microsoft Access has encountered

hi, what are you doing?

any one knows how to add-in or improt SQRT and ATAN2 functions to MS Access
2007?
iam trying to build expression in the Ms access Queries but it fail coz no
SQRT\ATAN2?

ºÇºÇ Ë­À´°ïÎÒ°¡?

Can anybody tell me how to find / use the double underscore option in Access
2007?
Thanks
Sharon

I am not sure what you are trying to do with this

as it will not do anything

 I have a hot potato to consult you all.
I have to do some monthly Charts. First, I will downloading the data of
this period and transform it into access format as a Table. To avoid re-write
the queries based on the table, I named the Tables as Current & Previous. The

ÄϲýÖиߵµ»¯×±Æ·µÄµ÷²éÎʾí1¡¢Äú¹ºÂò»¯×±Æ·Ê±¸ü¹ØÐÄÉÌÆ·µÄÄÄЩÌص㣺£¨  £©£¨×î
¶àÑ¡¶þÏ     A¡¢¿îʽ¡¢ÔìÐÍ B¡¢É̳¡ÊÛºó·þÎñ C¡¢¼Û¸ñ¡¡¡¡ D¡¢Æ·ÅÆ E¡¢ÖÊÁ¿¡¢ÖÊ
¸Ð2¡¢ÄúÄ¿Ç°µÄÔÂƽ¾ùÊÕÈë´¦ÔÚ£¨  £©¶Î    A¡¢1000-2000   B¡¢2000-3000  C¡¢3000
ÒÔÉÏ 2¡¢Äúƽ³£¹ºÂò»¯×±Æ·ÄܽÓÊܵļ۸ñÒ»°ãÊÇ£¨   ...