Hi Gang I'm starting to plan an searh like/read only application for a group in our company. Every 3 weeks to a month they want to update...

Andy

03-10-2009 02:21 AM
Mr.Frog.to.you@googlemail.com

Is there any conceivable way that this can be done? Namely, the ability to create one pdf file for EVERY RECORD of an Access report. So, for...

Vincent

03-09-2009 08:37 PM
Vincent

I need a query grouping some data in classes. E.g.: Having this data ______________ gendre | tall M | 1.78 F | 1.67 M | 1.75 M | 1.72 F | ...

regrat

03-09-2009 07:30 PM
Builder

My Access 2000 application works fine on Windows 2000, but when using the same application on Windows XP with Access 2000 it's a problem. It loads...

Greg (codepug@gmail.com)

03-09-2009 04:53 PM
Greg (codepug@gmail.com)

Access 2003. My problem is that if I use a 9 point truetype font, some textboxes on my reports are truncated on the right, i.e., they will drop a...

BruceB

03-08-2009 07:28 PM
BruceB

This guy breaks a string apart on a space ' ', and returns up to 8 columns. I used an address field as the input, but it could be adapted for...

Builder

03-08-2009 05:23 PM
Builder

Good evening David, thanks a lot for your reply and your kind help. Was pretty despaired - not to say - frustrated. Had been away with my family...

Robert Schott

03-08-2009 02:32 PM
Robert Schott

The database I am designing is a backup to another program which tracks calls. Mine is a cut-down version meant to be used when the main program...

macoldtimer

03-07-2009 10:36 PM
Salad

I've begun using the "Disable By Pass" & mde method for security, instead of Access security (.mdw). It seems to be working fine. But I have one...

zuckermanf@gmail.com

03-07-2009 08:05 PM
Albert D. Kallal

Draft paper submission is extended (will not be extended further): EISWT-09 *Apologies if you receive multiple copies of this email. Please forward...

devipsrs@gmail.com

03-07-2009 05:39 PM
devipsrs@gmail.com

Public Function dateFormatting(inDate As Date) As String 'SHOW ELAPSED MINUTES, HOURS, DAYS SINCE DATE Dim dblVal As Double dblVal =...

Builder

03-07-2009 10:35 AM
lyle fairfield

I have a form that once I double click a field opens another form with more information about the same field. But I couldn’t make the filter work so...

Sarmaan

03-06-2009 07:16 PM
Phil Stanton

Background Standard split FE and BE, there are 2x back ends, one contains all the data tables, the other contains a lot of reports that were...

Mike

03-06-2009 07:02 PM
Mike

What is the best way to secure a multi-user access database? Here is the issue. Customer is wanting to allow ALL users into the database, but...

harris@compu-type.net

03-06-2009 04:51 PM
MGFoster

Scenario: Main Form - Two subforms (identical in structure, though pulling data from different sources for comparison). If data is different I...

sol.shapiro@odot.state.or.us

03-06-2009 03:45 PM
Salad

I have an app built using Access 2003 sp3. One client, using ccess 2003 sp3 cannot display one of the subforms in one tab of the main form. ...

Bob Alston

03-06-2009 10:59 AM
Bob Alston

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote in news:Xns9BC5CC0AFC64Bf99a49ed1d0c49c5bbb2 (AT) 74 (DOT) 209.136.82: Thanks...

doncee

03-06-2009 06:54 AM
doncee

I've been sent a database containing a form which apparently stopped working after a Compact and Repair was run on it. I believe the database was...

D.Stone@ed.ac.uk

03-06-2009 06:25 AM
Rick Brandt

I've been given an Access database (unknown version but not probably not 2008) but I'm unable to open it due to the error in the subject. As...

Jim

03-06-2009 01:14 AM
Jim

Hi i am using microsoft access on a network Several users in several departments could entered data into the database what i would like to do is get...

kevcar40

03-05-2009 02:08 PM
woodglass

Hi Guys, I would like to ask your advice on approaching a problem before I attempt to build anything. The scenario is that every month we have a...

The Frog

03-05-2009 01:32 PM
Tony Toews [MVP]

I created a DLL in VB6 with checkboxes & option buttons. When calling this DLL in Office 2007, option buttons on frames became black. When I call...

chrisdev3@gmail.com

03-05-2009 05:27 AM
chrisdev3@gmail.com

My clients have Office 2007 Enterprise Edition. When they try to open an ACCDE copy of my Access 2007 database, they often get a message saying "this...

evenlater

03-05-2009 02:16 AM
Allen Browne

HI all, I have solved a problem using a join between a query and a table, however i need to use the sql, so must convert the qlery in to sql. Heres...

Gerry

03-05-2009 02:08 AM
Allen Browne

I have programmatically added some new fields to a table, but one of the fields I added needs to be the first column because the table is exported...

Jim

03-04-2009 04:18 PM
lyle fairfield

Hello, I am using this code that I got from the forum on an 'UNDO' button on a form which contains text boxes, combo boxes and three subforms. ...

franc sutherland

03-04-2009 10:44 AM
Robert Schott

All, I have the following code in the OnEnter event of a sub-form (Cover Options) in my Main form. It "gets" information from 2 other sub-forms...

Patrick A

03-04-2009 10:41 AM
Patrick A

In Datasheet view the mouse pointer automatically changes to down arrows and adjustable column pointers when moving over header controls. But these...

Lauren Quantrell

03-04-2009 10:18 AM
Lauren Quantrell

David, The connection work fine and many thanks for your input. I now have another problem which most likely relates to Code Pages. In my...

john@kosmosbusiness.com

03-04-2009 06:28 AM
john@kosmosbusiness.com

My dentist application (www.VisualDentist.com) supports Greek and recently we bowed to demands from dentists and have included an SMS sending...

john@kosmosbusiness.com

03-04-2009 06:24 AM
john@kosmosbusiness.com

Hi, I have a report that is sourced by a complicated dynamically generated search query. Everything works as planned, however now I would like to...

Cron

03-04-2009 04:07 AM
Kinch

If I have a form with a tab control containing 5 tabs, and subforms in each of these tabs. The subforms are controlled by child/master links. When...

Astley Le Jasper

03-04-2009 03:32 AM
Astley Le Jasper

Can anyone help? We have been using a database for several years (MS Access 2003). The tables are set up in a database on our server, and we have...

Matt

03-04-2009 03:01 AM
Phil Stanton

Hi I have just started using Access 2007. The database window is gone and the navigation pane is interfering with my form layout. Preliminary...

Mat

03-03-2009 04:53 PM
Wayne

When I click on the delete button....it deletes the record but does not clear the unbound fields.

audrey.nsh@gmail.com

03-03-2009 03:02 PM
Salad

I have a field that I want to update every time a record is updated. I have a continuous form, so I can't use the dirty form method. I want to be...

troy_lee@comcast.net

03-03-2009 01:55 PM
troy_lee@comcast.net

I seem to recall that VBA has a variable that I can use at any time in my code to check the return code of the most recent action. Does anyone...

Sheldon

03-03-2009 09:04 AM
Sheldon Potolsky

I have the following code on all of my forms: Private Sub Form_Activate() DoCmd.ShowToolbar "Form View", acToolbarNo DoCmd.ShowToolbar "Menu Bar",...

audrey.nsh@gmail.com

03-03-2009 03:47 AM
Phil Stanton

I have an app where I download a lot of data from a sTATS system and make it available for read-only reference. The only process that ever updates...

Bob Alston

03-02-2009 10:16 PM
Salad

On Mar 2, 5:14*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: That explains everything.

Kev

03-02-2009 10:02 PM
lyle fairfield

Hi, I have a main form and a sub form. The main form is where the user enters the total amount of an invoice and the subform is where the user puts...

audrey.nsh@gmail.com

03-02-2009 07:38 PM
audrey.nsh@gmail.com

I have a client who is using Windows Vista in a 32-bit environment She installed our Access2003 application on the pc (it is installed under Program...

PW

03-02-2009 05:06 PM
PW

Is Access capable of optimizing the following query? I simply want to return an empty recordset that spans multiple tables: "SELECT Info1A, Info2B,...

Vincent

03-02-2009 04:22 PM
Vincent

How to I get a report to skip printing a page if the condition I've put in is true, eg If IsNull(Me.txtField) Then don't print this page but keep...

anthony

03-01-2009 10:18 AM
anthony

On Mar 1, 8:28*am, mirandacasc... (AT) yahoo (DOT) com wrote: I don't know Access 97. See if your version of TransferSpreadsheet has a Range...

hans.updyke@gmail.com

03-01-2009 10:10 AM
hans.updyke@gmail.com

Dear reader, How to stop a VBA procedure after a form is set open with: DoCmd.OpenForm ("FormName"). After this instruction the VBA procedure is...

Simon van Beek

02-28-2009 12:31 PM
lyle fairfield

I noted with interest Albert Kallel's response to my question about Mail merge on 26th Feb. I Am sure he is right, but I am having problems. So in...

Phil Stanton

02-28-2009 10:17 AM
Phil Stanton

The Access 2003 / SQL Server 2008 Express app I've created performs well over a VPN, except for the main form which has uses tabs, with multiple...

Astley Le Jasper

02-28-2009 09:53 AM
Astley Le Jasper

The form Chooser has worked without problems for about a year. It suddenly stopped working in November. It was written for Access2003, but I don't...

thelma@uwm.edu

02-28-2009 09:13 AM
thelma@uwm.edu

Okay, one more for you guys. How could I go about checking a check box based on a value chosen in a combo box on the same form? For example, if the...

merlin

02-28-2009 01:58 AM
Allen Browne