General

Pivot fields
How do i pull two pivot value into there according text boxes i have this code strSQL = "TRANSFORM CCur(Nz(Sum([Amount]),0)) AS X" strSQL = strSQL & " SELECT [" & TempVars![Display] & "] as SalesGroupingField FROM [Sales Analysis] " strSQL = strSQL & " Where [Year]=" & TempVars![Year] strSQL ... 8 Apr 2010 09:30

Basic way to make basic databases work on Access2007?
I tried the Microsoft info on this questions and it was really worthless. Let's say a "little guy" makes some unsplit Access 2003 databases with Macros and code which a friend wants to run on Access 2007 without "security" related hassles, including without wanting to have to click through warnings every ti... 8 Apr 2010 12:37

How to start and Access DB from a bat-file
What would the command line be to start a specific Access DB from a bat-fil? -- Diane ... 19 Apr 2010 20:54

Add an incremental field to an existing table
I have a table with data in it, whihc now needs to have a unique ID added to each record. The ID must start at 2000000 and increment by 1 for each record. Can I achieve this, and if so how? Many TIA Duncs ... 27 Apr 2010 08:46

<Kein Betreff>
Fg ... 8 Apr 2010 05:05

VBA or sendkeys - mouse move and click
Hello everyone I hope you can help me with this. I have created an access form that opens a number of windows in internet explorer. I need to simulate a mouse move and left click to get from one active window to another. The amount of move is not that important as long as it's around 2 inches or so to the... 8 Apr 2010 03:59

Windows 7 f'd up my database
Im hoping someone can help me here. Yesterday i installed Windows 7 on one of the computers at my work, now when i try and access the database (access 2007 SP2), the forms arent working? All the data is still on the 'backend' of the database which is stored on another computer (running XP). I can still to querie... 11 Apr 2010 12:21

Test - Please Ignore.
One line test message body. ... 7 Apr 2010 22:32

m
zal ... 7 Apr 2010 21:26

Problem while trying to open access training course on microsoft w
Hello, I was taking the online training course on Access 2007 but whenever I download the access file required for practice, the page linked to it with the instructions does not come up. Is there anything wrong with the links located within the access file? Is Microsoft updating them? Or if not should it be a l... 7 Apr 2010 21:26