in access97, this statement opens the report at 100% DoCmd.OpenReport "rptAuditPurWrongWhse", acViewPreview but in access2007, it only opens at 69%...

Roger

08-18-2010 02:53 PM
Roger

I have done a search and not come up with much of an answer. I work for an agency that provides therapy services to children with special needs. ...

Tim Dunne

08-18-2010 12:45 PM
timmg

hi i have a table containing a list of components and the status table index, fldcomponnum , fldstatus the index is an autonumber the...

kevcar40

08-18-2010 09:48 AM
kevcar40

Title:- Performance Testing Architect Duration:- multi-year Location:- Rockville, MD. This role involves creating performance testing strategies...

Maple MRS

08-18-2010 08:54 AM
Maple MRS

I am using version 12.0.6535.5005 of the msaccess.exe executable on a Windows 7 64-bit computer. Every time I open and exit Access, the GUI will be...

Vincent

08-17-2010 06:52 PM
Stuart McCall

Java Developer Location: NYC, NJ Duration: 6+ Months Rate: $35/Hr Minimum of 5+ years experience in Software Development - Experience in HTML, XML,...

Maple MRS

08-17-2010 05:10 PM
Maple MRS

Hi All, My tables are linked to a Backend called DMS.mdb in: S:\General\Databases\DMS\DMS.mdb Could someone give me a function which would return...

Barry Edmund Wright

08-17-2010 02:54 PM
a a r o n _ k e m p f

I am trying to prevent end users from being able to use the SHIFT key to bypass the Autoexec and see the data tables. I used following code from...

Jim Mandala

08-17-2010 02:49 PM
Salad

I've got as little form that will list all the references a database has selected in a textbox, because we all know that when you...

ManningFan

08-17-2010 01:19 PM
ManningFan

Hi Everyone, I am working on a couple of angles to export a report directly to powerpoint, and so far it seems that the approach Stephen Lebans...

The Frog

08-17-2010 03:24 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Hello. I have a SQLServer table with a varchar(max) column which I link to in Access. In design view, Access shows the column as having a Text data...

Darrell Burns

08-17-2010 03:23 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I am starting to see this in anything new we build. Everything that is already built is working fine. Is this some security update on the machines...

sparks

08-17-2010 03:22 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I'm not certain if there is a "best" way to handle this, but I wish to display a "please wait" dialog on the screen before a report is...

Vincent

08-17-2010 03:21 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I am using Access 2003. Try to link to a Unicode csv file supplied by a website host. The result is a linked table with one field named...

Mike P

08-17-2010 03:19 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

For dollar/cents amounts in the billions I've been going on the assumption that Double is the only game in town. Ditto share amounts in the billions...

(PeteCresswell)

08-17-2010 03:18 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I have an Access based system that includes Access programs run automatically by the Windows scheduler. One runs every morning to download xml data...

Bob Alston

08-17-2010 03:13 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Job: Mainframe Tester Location: Valleyforge, PA Duration: 6 Months Have 6+ yrs of testing experience Have mainframe testing experience ( mainframe...

Maple MRS

08-16-2010 10:20 PM
Tom van Stiphout

How do you convert a Access 2002-2003 database file to a Access 2010 file format? According to Microsoft...

jfcby

08-16-2010 03:45 PM
David W. Fenton

In 2003 application, I have a table with an OLE field containing Word documents. I display that OLE field in a form, and I want to allow users to...

pemigh

08-16-2010 01:22 PM
pemigh

I would like to call an external program from a button in Access - I have one set up at the moment but it calls a program.exe type file - I...

Isis

08-16-2010 12:49 PM
Salad

Hi, since some time i struggle with errror 3167 in an ac2003 form based on multiple tables. In Ac2000 , I haven't any troubles with this...

Pol

08-15-2010 04:38 PM
David W. Fenton

I have hundreds of dbf files to import from a folder to a table in access 2003 and or 2007. At present I import each file as a table then copy and...

Aileen Turner

08-15-2010 04:35 PM
David W. Fenton

I'm making a query where I want to create a new column with a value based on another columns content The source will contain either of 4 3-letter...

Thomas Andersson

08-15-2010 01:49 PM
Chuck Grimsby

I really need some help here. I'ce created a perl script that collect a lot of data for me and stores in a tab delimitered txt file that I want to...

Thomas Andersson

08-15-2010 01:28 PM
Chuck Grimsby

Hi all. I run A2010 on a separate PC which has Windows (XP) automatic updates switched on. A couple of days ago I had a telephone call...

jbguernsey

08-13-2010 11:17 PM
David W. Fenton

Hi again everyone, I am hoping that there might be an easy way to achieve this before I go and create bucket loads of queries. I have a need to...

The Frog

08-13-2010 06:47 PM
James A. Fortune

I want to write a line of code to check the version of MS Access being used by my clients, some of which have multiple versions installed. I am...

Bob Darlington

08-12-2010 10:00 PM
JohnC

I got quite used to using this Add-In for Access97. I haven't been able to find an Access2007 version as of yet. Anyone know if this is...

Don Leverton

08-12-2010 07:21 PM
Douglas J. Steele

Hi! I'm making a for for logging awards for players and I want it to show the award images as I select the award. I use two tables (the log and the...

Thomas Andersson

08-12-2010 03:54 PM
Salad

Access XP. My form has tabs, two of them have a subform (frmCarDet that can be edited or not, and frmEventLog always editable). When there is a...

saintor1@hotmail.com

08-12-2010 03:19 PM
saintor1@hotmail.com

Hi All, I know there are so many questions on this issue but mine is just a little different. What I am trying to establish is the following: The...

Co

08-12-2010 09:30 AM
Jon Lewis

Title:- Oracle PL/SQL Location:- Toronto, ON, Canada Duration: 6+ Months We are looking for a Oracle Database Programmer with programming...

Maple MRS

08-11-2010 06:34 PM
Maple MRS

I am using a combo box that has a control source of a text field of size 50. I also am using a value list with "val1", "Val2", "val3" values for...

Ken

08-11-2010 11:45 AM
Salad

The Frog wrote: Just curious. Is this for a report or form? If report you could use a running sum to break on bands and not bother with it.

The Frog

08-10-2010 11:44 AM
Salad

I have a query that checks various conditions from tables and then output a list of names, what I want is for each name to max show up 2 times. Is...

Thomas Andersson

08-10-2010 08:31 AM
John Spencer

I have several tables which have imported data for a back end datafile, these can be simplified as: Syscode NumOfD 101 34647 101 ...

bezz

08-09-2010 03:51 PM
Salad

Hello, I was wondering what the most efficient way of capturing check box values from those records in a form which are checked so that I can use the...

Kev

08-09-2010 09:26 AM
John Spencer

Basically of you look thro' Access on Google you'll gather that nobody quite understands why error 1517 should arise. - I'm talking about Access 2000...

elg

08-07-2010 05:14 PM
David W. Fenton

in access2007, I'm trying to open a second MDB using this code that works in access97 Dim obj As Access.Application On Error GoTo fErr Set obj =...

Roger

08-06-2010 01:09 PM
David W. Fenton

Hi! I have two tables in a databse, one storing player related data and one containg mission data. I need a column to auto update with the last...

Thomas Andersson

08-05-2010 09:48 PM
Bob Quintal

I have just taken over an Access database. Each client PC has the Access 2003 runtime on it. When the DB is launched I get the following...

Paul H

08-05-2010 07:25 PM
Tony Toews

"Brian Austin" <bbaustin1 (AT) att (DOT) net> wrote They did take advantage of owning the Rushmore technology by including it in the Jet database...

Salad

08-05-2010 06:17 PM
Access Developer

Title: Hyperion Financial management (HFM) Location: Jersey City, NJ Duration: 6 Months Minimum Required Skills: HFM Architect, Hyperion,...

Maple MRS

08-05-2010 02:31 PM
Maple MRS

I have a continuous form. I can select a number of records by clicking on a record selector and then shift-clicking on another one. The whole group...

Jim Devenish

08-05-2010 02:26 PM
Jim Devenish

it appears that access2007 has a built-in calendar that is displayed when a date based control gets focus is there a way to disable this feature my...

Roger

08-04-2010 07:48 AM
Michiel Rapati-Kekkonen

Users who wish to use a program developed in 2003 are now having to purchase 2010. Will the 2003 program run on 2010 just as easily as it does on...

Tomahawk Lady

08-04-2010 02:19 AM
Cheryl Aprato

Ab Initio ETL Specialist Location: Richmond, VA Duration: 1 year Description/Required Skills: - Master Level ETL Specialist to manage...

Maple MRS

08-02-2010 03:21 PM
Maple MRS

I have used Mr Kallal word merge in the past and found it to be a great thing. I am doing a new one and have a couple of questions. I have 5...

sparks

08-02-2010 10:58 AM
sparks

Access 2010 having got this super RTF memofild, how do I Email it as the body. The formated text is in a bound form EMailText and a bound field...

Phil

08-02-2010 04:23 AM
Phil

Hi. a couple of questions about creating an access (2007) table with a multi-column unique constraint. I know how do the above using an SQL statement...

Ron

08-01-2010 05:59 PM
Ron