Hi - I have code (below) that ran as recently as Monday. We decided to change the location for the output reports, and now the code errors (13 Type...

sara

12-28-2007 07:36 AM
sara

On Dec 27, 3:24 pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: MouseOver was useful but I don't use it much (at all?)...

Bob Quintal

12-27-2007 05:07 PM
Bob Quintal

mirandacascade (AT) yahoo (DOT) com wrote: I don't think it's at all obvious, but you maybe you can help yourself keep at least part of it...

Salad

12-27-2007 10:18 AM
Marshall Barton

I have an existing orders database that was created here in the UK and is designed to accommodate UK Sterling. The customer will now be trading in...

Paul H

12-27-2007 08:29 AM
Baz

You'd say "go to hell" but there is no such thing despite these Tutankhamuns imams have been looking for ages.

signfrom@gmail.com

12-27-2007 07:29 AM
signfrom@gmail.com

I've been busy converting an existing 2003 database into 2007 by dint of creating a new accdb database and importing the objects into it. Everything...

anthony

12-27-2007 04:17 AM
anthony

Hello, I'm using MS Access 2003 for a software program I'm creating. The program makes use of some complicated queries that I'm storing inside the...

wak@wakproductions.com

12-26-2007 07:52 PM
wak@wakproductions.com

I want to merge data to a Word doc from an Access query. The query does exist and contains data, but the Word data source locator DOESN'T SHOW THE...

Jking482

12-26-2007 06:15 PM
Fred Zuckerman

Hell All, My database has 3 tables Client, Devices and Job Client and Device has One-to-Many Relationship Client and Job has One-to-Many...

Matuag

12-26-2007 12:46 PM
Matuag

To scan through a table and edit values I can use OpenRecordset with: 1. Dim rst As Object etc., or 2. Dim rst As DAO.Recordset etc. Is there a...

12-26-2007 04:04 AM

In an Access 2000 database in Access 2003 (Dutch) I have the following code: Option Compare Database Option Explicit Public Sub...

12-25-2007 03:50 PM

Here's a great video that explains why there are sometimes glitches when using Vista with various versions of...

Neil

12-25-2007 12:10 AM
Neil

I just installed MS Access 2007. Is there any way to turn off the confirmation of action queries in 2007 ? -- Message posted via...

destinman via AccessMonster.com

12-23-2007 07:11 PM
Allen Browne

hi, I am looking to replace the navigation buttons at the bottom of a subform with tabs. I want the tab control to automatically create a tab for...

andrewbda

12-23-2007 03:05 PM
DawnTreader

Am having a problem usink AK2 exporting a report to an RTF file. The Access report has most fields and sections set to CanShrink and CanGrow. The...

News

12-23-2007 02:16 PM
Phil Stanton

I have a report that I have been working on. It depends upon a query, which depends upon two other queries. Everything was working fine, I verified...

mcolson

12-23-2007 10:00 AM
mcolson

Hi Is it possible to import the emails in the cc field from outlook directly to an access table. Help will be appreciated Thanks Alfred

Alfred

12-23-2007 01:49 AM
Alfred

On Dec 22, 10:59 am, Ian <ian.sex... (AT) ntlworld (DOT) com> wrote: I think you will have to have a web site to host the "web based...

lyle

12-22-2007 09:04 PM
lyle

Hi, I need a recommendation when to add a record to a junction table that complements a many to many relationship. There will be a Contacts form,...

Henry Stockbridge

12-22-2007 07:44 PM
Henry Stockbridge

I'm developing a tool that creates a spreadsheet, writes data from several Access queries to ranges in the spreadsheet. That part works. What I...

Bob Quintal

12-22-2007 03:57 PM
Bob Quintal

Back in August I posted the following: I'm seeing the following problem in a database running under Access 2007 regardless of if it is Access 2003...

Wayne

12-22-2007 01:31 PM
Wayne

Hi, David David W. Fenton wrote: I think there were some remarkable issues fixed with SP3 - 100 percent CPU usage - incorrect value returned by...

Tom Louchbaum

12-22-2007 12:10 PM
duanemoore@yahoo.com

Hi, I want to hire a Bangkok based access pro to rewrite an existing custom access application and turn it into a professional tool. It manages...

Greg

12-22-2007 09:08 AM
Greg

On Fri, 21 Dec 2007 08:45:14 -0800 (PST), mirandacascade (AT) yahoo (DOT) com wrote: You can use Eval to to do this. If strColumn3 = "PopulateXYZ"...

Wayne Gillespie

12-22-2007 07:52 AM
Stuart McCall

I have downloaded a great pop up calendar (that doesn't use ActiveX Controls) from http://allenbrowne.com/ser-51.html. Actually it onvolves...

larry.dahlgren@telus.com

12-21-2007 10:09 PM
Tom van Stiphout

Is it possible or feasible to load one version of Access (2003) and the new version (2007) on the same hard drive and run appliecations on each...

destinman via AccessMonster.com

12-21-2007 08:32 PM
destinman via AccessMonster.com

Good afternoon everyone, I have created a very robust front end for my backend database that is essentially an all-round office database used for...

Tim Ricard

12-21-2007 07:27 PM
Tony Toews [MVP]

Is it possible or feasible to load one version of Access (2003) and the new version (2007) on the same hard drive and run appliecations on each...

destinman via AccessMonster.com

12-21-2007 06:28 PM
destinman via AccessMonster.com

I tables in Sql, which I am linking to in Access. I have a couple of fields which are using the data type "text". Why are these appearing as the...

mcolson

12-21-2007 03:04 PM
Rich P

Hello, I have a table that shows: Serial Number Date...

colemanj4

12-21-2007 02:41 PM
colemanj4

Hi all, what function or code i should write in order to get the number of records/rows in the form application?

thread

12-21-2007 01:35 PM
Salad

I have multiple Access databases which are interrelated but not linked. One main database is being used to create bids to general contractors (we are...

kathryn woning via AccessMonster.com

12-21-2007 12:28 PM
kathryn woning via AccessMonster.com

The scope of a boolean query displays -1 or 0. You can modoficare to show a checkbox?

nicolacantalupo@libero.it

12-21-2007 07:44 AM
Allen Browne

I made some grammatical error! You can change the type of a field of a query? And control it is displayed? Example: checkbox if the type is boolean?

nicolacantalupo@libero.it

12-21-2007 07:36 AM
nicolacantalupo@libero.it

Hi, Please excuse the basic question, but I am new to access. I have just changed a machine form NT4 to win2000 and moved an Access 2000 database...

geoffers

12-21-2007 05:21 AM
Stuart McCall

Hello... I'm new to MS SQL, so please be nice... LOLOL I decided to go from Access 2003 with the MS SQL Express Edition (I really don't need all...

Fenix Bird

12-20-2007 11:42 PM
lyle

I have code that current sends spreadsheets by email from a user's Outlook. I need to modify the code to send the email from their group email box,...

seanhirshberg@yahoo.com

12-20-2007 09:05 PM
Tony Toews [MVP]

I am trying to use windows scheduler to compact a database. In the task run line I have the following: "C:\Program Files\Microsoft Office\OFFICE11...

DSSMaster

12-20-2007 07:15 PM
Chuck Grimsby

Hi all-- Does anyone have any insight as to how I might create a search form that allows a user to select criteria based on any related table in the...

jcf378@gmail.com

12-20-2007 06:30 PM
Allen Browne

I have a table looks like this: PKID SomeData SomeMoreData IntegerValue 1 Stuff More Stuff 300 2 Cool ...

Lauren Quantrell

12-20-2007 02:44 PM
Rich P

If I want to retrieve a full version information for an ms access databases, I use (from vb6 code) the "Access.Application" object and SysCmd method....

Dedalus

12-20-2007 02:42 PM
Klaus Oberdalhoff

Hello everybody I'm trying to find how to know if there is a current transaction (after using DBEngine.BeginTrans). Is there a property or function...

darwinbaldrich@gmail.com

12-20-2007 01:53 PM
darwinbaldrich@gmail.com

Hello All, These one may be a bit tricky, and what I'd like to do may not even be possible. I would love to hear any ideas you guys have for...

Dave

12-20-2007 11:53 AM
Lauren Quantrell

Hi, The organisation I work for is on the verge of buying Microsoft Office 2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our...

Bobby

12-20-2007 10:54 AM
anthony

I have suddenly gotten several replication conflicts where in the winning conflict box, the following is shown: "This row contains data that...

Bob Alston

12-20-2007 10:46 AM
Bob Alston

Hello, I have a question about some MS Access issue I am having. My goal is to make a field that will list any revisions to the data that have been...

Brian

12-20-2007 09:16 AM
Allen Browne

am currently working on a project which the main application we intended to use has fell through, so we have falled back on Access to work through...

simon.vito@googlemail.com

12-20-2007 07:56 AM
Tom van Stiphout

I have an old database which started out life in the Access 2 days! It's full of lots of stuff which I'm not convinced is relevant any longer. Would...

anthony

12-20-2007 07:54 AM
anthony

I have the following saved UNION query named qryPeople2NameInNPaperAd: SELECT & " " & & " " & & " " & & ", " & & " " & AS Item,...

MLH

12-20-2007 07:20 AM
MLH

If I want to retrieve a full version information for an ms access databases, I use (from vb6 code) the "Access.Application" object and SysCmd method....

Dedalus

12-20-2007 04:26 AM
Dedalus