Dear reader, In the open event of a report you can change the RecordSource of the report for instance: Dim db As DataBase Dim Rst1 As...

Simon van Beek

01-29-2009 03:29 PM
Simon van Beek

I have 4 Access production tables each with two production indicators and each with an employeeID and a WeekOfYear (eg 2008-09) field. I want to...

KC-Mass

01-29-2009 03:27 PM
Rich P

Hi, as an example If (KeyCode >= vbKeyA And KeyCode <= vbKeyZ) seeing that there are vbkey? for the keyboard keys (as in vbKeyA, etc....) What is...

bobh

01-29-2009 11:29 AM
bobh

I think if you give it about 31 seconds worth of thought, that you can see that it's *possible* (not actual; but possible) that an application like...

Earl Anderson

01-28-2009 10:43 PM
Neil

I have just tried out the A2003 run-time for the first time and it seems that the /Wrkgrp and /ini command line parameters are being ignored. Is...

Les Desser

01-28-2009 09:45 AM
Les Desser

Hi there, I am interested in getting the mouses coordinates on the form. I am able to do this with the mousemove event but when the mouse...

Mat

01-28-2009 02:04 AM
Mat

Am in I.T. & experienced with Access devel. but am stumped on this: Starting some weeks ago, am encountering Access v2000 MDB's that I cannot double...

don.fleming@pse.com

01-27-2009 07:22 PM
Phil Stanton

Hi All, I trying to setup a validation rule on a table field and I don't seem to be able to get it to work. I have the field define as number so...

bobh

01-27-2009 05:16 PM
paii, Ron

I am trying to create a report that will print a series of entries for a given Account Number on a page. However, I don't want to have to type in...

iwasinnihon

01-27-2009 02:21 PM
Salad

I think if you are performing web operations on a production server you should use a server based database like sql server instead of a file based...

Rich P

01-27-2009 11:19 AM
Rich P

Hi, I have a list of date/times people visited a clinic stored in a query. I'm trying to write another query based on it to filter a list of unique...

Cron

01-27-2009 09:53 AM
Cron

I can not say enough about HOW STUPID people are in excel. I wish this piece of crap had never been invented. I have spent 3 days converting text...

sparks

01-27-2009 08:51 AM
sparks

Thanks Robert Each form has a unique Query for its record source. Each query references the EmployeeTable and SickListTable. Greg

Greg (codepug@gmail.com)

01-26-2009 11:41 PM
tina

I have a subform, (Subform1) from which I open another form (Form1) to a specific record, however, once I have opened Form1 I cannot scroll through...

rwpearson@clear.net.nz

01-26-2009 10:01 PM
Tom van Stiphout

Hi, I'm getting the "Query is too complex" error in Access 2007. I'm new to Access and am trying to move all my pricing calculations from excel to...

Will

01-26-2009 07:18 PM
Salad

Hello everyone, I am trying to create a report that has a number of graphs within it. But rather than place these graphs in the header or footer I...

Nick 'The Database Guy'

01-26-2009 06:18 PM
Salad

Something is just not right and I can not figure it out, I need help the below is a line from a Do Loop routine I have and I'm trying to check how...

bobh

01-26-2009 04:50 PM
bobh

Hi I regularly import excel worksheets into my Access 2000 DB using "File... get external data..." Recently however, every time i try to import a...

paul

01-26-2009 04:41 PM
robert.waters

Hi, I'd like to know if this query below is feasible in one single SQL statement. If not, I'll have to merge 2 sets of table and I'd like to avoid...

circuit_breaker@canada.com

01-26-2009 03:05 PM
Rich P

Hi all I have a database in Aceess 2003 and my company is upgraded it by 2007. In the database there is a report with the graph. It looks fine in...

Naushad

01-26-2009 07:25 AM
Rick Brandt

MYRTYNEITÄ ydinherraskaisia. YLE 8.5.2008. Haastateltavan energiaherran suusta: "Olemme joutuneet huomaamaan, ettemme kovista yrityksistämme...

Joonas Puhakka

01-26-2009 02:18 AM
Neil

Hi all I hav designed a databas in Access 2003. My Company is upgraded it by Access 2007. In the database there is a report, containing a graph that...

Naushad

01-26-2009 01:09 AM
Naushad

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Presumably there's a not in "I wouldn't ever have tables with a PK,...

colin spalding

01-26-2009 12:05 AM
Tony Toews [MVP]

Hi All I know this might not make much sense, but I'm hoping you can help! I have a table consisting of the following: StudentID StudentName ...

Laphan

01-25-2009 07:05 PM
tina

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote I probably could, if I dug hard enough, find a diskette containing the example...

lyle fairfield

01-25-2009 01:04 PM
Paul

Hello Everyone, I'm suffering trying to get a Query Criteria working. My job is to offer two unbound controls on a form...

elias.farah@scw.com.au

01-25-2009 01:00 AM
Allen Browne

What is the most sensible way of synchronizing a mainform with an embedded subform. The mainform will be used to create a new sickleave record and...

Greg (codepug@gmail.com)

01-24-2009 11:17 PM
robert.waters

I recently split my Access 2000 File Format database application at work, that previously resided on a shared server and was being accessed in...

Donald Calloway

01-24-2009 10:13 AM
Salad

Hi, I have a table which contains 2 fields, Initials and Full Name. On my input form I have 2 fields, Initials and Full Name. I want users to be...

Paul

01-24-2009 07:56 AM
Rick Brandt

A97 I tried running DoCmd.RunCommand acCmdCompileAndSaveAllModules from within a procedure in a global module. It fails with a 2046 error. Is it not...

MLH

01-24-2009 07:33 AM
MLH

I have a continuous report where I want to get the address into 1 line by reducing the font size as necessary. Stephen Lebans has a routine called...

Phil Stanton

01-24-2009 06:49 AM
Phil Stanton

Hello I have a problem. I have two tables one tCustomer , second tOrder. tCustomer : IDCustomer tOrder : IDOrder FKCustomer

grim

01-24-2009 02:05 AM
robert.waters

I am trying to build a table based on the values in another one. At the same time I have to parse out the multi values in their text field to make...

sparks

01-23-2009 02:08 PM
sparks

Well I get some data that they need imported into access. I am sure that anyone who has done this knows what I am going to ask. yes blue means ...

sparks

01-23-2009 11:29 AM
Rich P

Hi All, I not understanding why this is not working If Len(InStr(1, MyRec!CmpltdUnits, ".")) = 0 Then cmpltdunits is a double datatype(fieldsize)...

bobh

01-23-2009 11:17 AM
bobh

Is there a way to preventing Access from automatically rewriting a query? I wrote an update query to update five fields if any of four fields in a...

Sheldon

01-23-2009 10:16 AM
Sheldon

Business Warehouse – Retail Goods Wholesale Wholesale Trading Supply Hong Kong (Asia), United Kingdom, & U.S.A. Trade Confederation Chain in...

Global Trade

01-22-2009 06:28 PM
Larry Linson

We are seeking for find sustainability in awareness to donations and sponsoring for leading our team to a advertisement paid professional division in...

Industrial Engineering

01-22-2009 06:24 PM
Larry Linson

We have a problem where, for example, on a "Continuous Forms" form we have a control on the footer like =Sum() and it shows as blank (permanently...

Les Desser

01-22-2009 06:23 PM
Les Desser

Howdy! I have a question regarding the performance of opening a recordset via 2 different methods. Are there any performance differences between...

Vincent

01-22-2009 04:34 PM
troy23

On Jan 18, 9:00*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Still no further forward with this. Whenever I access a form...

jon@norchard.com

01-22-2009 02:45 PM
Billy Joe L

I have a subform with the following code that i want to lock the fields in the current form if a field (text182) is -1 and keep it unlocked if it is...

kolsby@gmail.com

01-22-2009 02:36 PM
kolsby@gmail.com

Yesterday I came accross an interesting Access installation where one PC had full rights over the Access application (shiftkey to bypass startup...

iano

01-22-2009 01:06 PM
iano

All, I have a spreasheet that comes from one of our systems every other week. Say it contains a record for each bowler, with their ID and then...

GM7

01-22-2009 09:12 AM
GM7

Hi, i have a table called op number contain all the ops on the line I have a crosstab query that returns faults against op...

kevcar40

01-22-2009 08:44 AM
paii, Ron

I have a front end / back end application which is distributed among about ten remote laptops. The application is secured with an mdw. It has...

Gus

01-21-2009 09:52 PM
brady

I have a report. I want to place the total number of calls but this is for every 10th record. So I want the total number of records to show in a...

zufie

01-21-2009 07:55 PM
Larry Linson

Have a form that has a source of approx 9000 records. When I open it, I would like to open it on a specific initial record, a person's data. ...

Bob Alston

01-21-2009 06:11 PM
Bob Alston

Dear experts, This is what my bosses want me to program and I wanted to see if you thought it was feasible. All the faxes come into a file on the...

musicloverlch

01-21-2009 12:41 PM
robert.waters

Hi I have a database with an MS SQL back end and now have a requirement to store electronic copies of documents within the database. I know SQL can...

Gary

01-21-2009 12:34 PM
robert.waters