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

Lauren Quantrell

12-20-2007 03: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 03: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 02: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 12:53 PM
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 11: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 11: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 10: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 08: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 08:54 AM
anthony

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

MLH

12-20-2007 08: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 05:26 AM
Dedalus

http://getpaidforeveryvistor.googlepages.com/home is the new way for publishers to get paid off per visitor on there website... So every visitor you...

t8bpfc1f

12-20-2007 01:46 AM
t8bpfc1f

fredg <fgutkind (AT) example (DOT) invalid> wrote: : On 19 Dec 2007 16:16:57 GMT, Thelma Roslyn Lubkin wrote: :> I did some work with Access .mdb's...

Thelma Roslyn Lubkin

12-19-2007 11:14 PM
Salad

I'm attempting to implement User-level security on an Access 2003 database in Access 2000 format and have hit a brick wall. I created a Workgroup...

Don Calloway

12-19-2007 10:36 PM
Tom van Stiphout

I'm using A97 import data wizard to import text file N2 a table. The text file is a DIR listing produced by running dir jdc*.* /s > c:\JDCs.txt The...

MLH

12-19-2007 08:18 PM
Chuck Grimsby

hello, does anyone know how to convert Access 2000 .MDA files to the Access 2007 equivalent? ive been able to convert .MDB files to .ACCDB, but not...

SpaceMarine

12-19-2007 07:14 PM
SpaceMarine

Tweak your software and operating system easily and safety http://software-hacks.blogspot.com/

456

12-19-2007 05:12 PM
456

Ok, here is the deal, I am trying to speed up a few queries because another user who was trying to delete ALL records from a table used the following...

AP

12-19-2007 04:49 PM
lyle

Hi, I'm currently designing a database for a construction co and learning how to use access on the fly. I'm having a few problems with the re- use...

christopher.catlin@gmail.com

12-19-2007 04:14 PM
hunterb91@gmail.com

hello i have a huge dataset that i am trying to summarize into one simple report / pivot table / query. i have tried everything i know to get it to...

DawnTreader

12-19-2007 02:55 PM
Rich P

In my database I have a 'control table' in which basic info is stored about the application, for instance the application's path and the name of the...

12-19-2007 02:05 PM
lyle

My Customers/Sales/Contacts management database interface is modeled as if Customers are objects, Sales are objects owned by Customer objects, etc. ...

JohnH

12-19-2007 01:26 PM
JohnH

i have been writing an app for my work for 18 months now, in a fairly organic manner! my boss has never used a computerised system and i have been...

BobbyDazzler

12-19-2007 11:20 AM
anthony

I have an Access Table with following columns: GID (auto number) PID number TreeID Text ItemName Text This table consists of records in the...

RP

12-19-2007 07:21 AM
Allen Browne

Does anybody have print screens of steps for installing Access Runtime 2007 ? Thanks a lot in advance!

Chris

12-19-2007 03:41 AM
Chris

Hi, Working with a database that's new to me and they have a make table query that creates a variety of fields, a handful of which are designated as...

mfsforums@gmail.com

12-18-2007 07:28 PM
helenwheelss@yahoo.com.au

fredg <fgutkind (AT) example (DOT) invalid> wrote: 2003-11-08 is always yyyy-mm-dd. It's quite unambiguous. Tony -- Tony Toews, Microsoft Access...

Jerry West

12-18-2007 06:42 PM
Tony Toews [MVP]

Hello all I have a client who is wanting me to develop an Access DB or VB app that is basically a fairly simple call tracking system. They are...

chanat99@gmail.com

12-18-2007 06:40 PM
Tony Toews [MVP]

Here is the code up to the relevant point. When I try to obtain rst.edit, I am only offered rst.editmode Dim DB As Database Dim RST As Recordset Dim...

anthony

12-18-2007 06:34 PM
Tony Toews [MVP]

Hi, I'm trying to create a simple data entry database that has yearly / monthly forms for which I want 6 different update fields. I have a...

timothy.burt@gmail.com

12-18-2007 04:54 PM
Larry Linson

I need a little guidance here. I have set up a table for job estimates with a large number of data fields. On the estimate form is a command button...

Kevin

12-18-2007 12:06 PM
Phil Stanton

List of free people search engines -- people search, white page, background check, people finder, find people, public record, lookup phone number,...

george

12-18-2007 10:57 AM
george

this is probably very simple but I don't know. Is there a way to prevent two people from signing on to an Access Application using the some login...

eighthman11

12-18-2007 08:38 AM
eighthman11

I want to add a Photo to a field so a face can be added to a contact person. Is there an easy way to do this perhaps using a WebCam or cheap...

Scott

12-18-2007 03:32 AM
Scott

Hi guys, just really want to know if someone can help me with a query. I have the following table 1 ...

winggy.wiggy@gmail.com

12-18-2007 01:17 AM
Allen Browne

On 16 Dec 2007 22:35:07 GMT, "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Yes - sorry, I meant Access 97 Thanks for the...

JakeD

12-17-2007 08:39 PM
Paul Brady

Is there any way that individual words or phrases can be formatted within a memo field? Obviously, the whole field can have formatting applied but...

anthony

12-17-2007 07:29 PM
Allen Browne

Hello, I was wondering if anyone could help me. I have an access form with tabbed pages on it. I would like the colour of the tab name to...

DNolan

12-17-2007 03:23 PM
DNolan

I have a form that I have subforms in. I have set up relationships between all tables for cascading delete so that once I delete from the main table...

spcscooter via AccessMonster.com

12-17-2007 11:22 AM
spcscooter via AccessMonster.com

If the RecordSource for subform SF on main form MF is a query and I change one of the field values in the subform control from 75 to say - 13 and...

MLH

12-17-2007 11:14 AM
Tom van Stiphout

Hello everyone, quick question. I have an Access application (Access 2003) which has link tables to a SQL server. When you do anything on the...

eighthman11

12-17-2007 09:25 AM
eighthman11

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Yeah, so long as you understand that this will only keep out the...

zdenko

12-16-2007 09:17 AM
Gerry Hatrick

Hello, i encountered a little problem. bear in mind that i am an amateur in this access thing so... Anyways, here is the problem. I have a...

peraklo@gmail.com

12-16-2007 08:53 AM
Bob Quintal

I have searched high and low for a sample for this, and I just can't find any. Sorry for the length! Background Information The issue revolves...

Elfae

12-16-2007 08:48 AM
Bob Quintal

Hi everybody, I have problem of coding the parameter query which does a cumulative sum of quantity of a group of same chemical item. I get error...

forcefield via AccessMonster.com

12-16-2007 06:03 AM
forcefield via AccessMonster.com

Hi, I'm having the following problem. I have a table that contains information about books people read, i.e. each row has two columns, people id and...

abraham.pinsker@gmail.com

12-16-2007 05:51 AM
Allen Browne

Suggest any best tool for creating ER tool from the database ?

Ravi

12-15-2007 07:50 PM
Klaus Oberdalhoff

In my report I have a calculated field that counts the number of records of the underlying table, =Count(). This field is placed in the report's...

12-15-2007 11:13 AM

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: <shrug> But what else are you going to do if you ever need to? I used to...

Patrick A

12-15-2007 12:48 AM
Tony Toews [MVP]

On 14 Dec 2007 20:53:11 GMT, "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Thanks David. I'll give this a try the next time...

ManningFan

12-15-2007 12:15 AM
christianlott1@yahoo.com