I am trying to access data in a Lotus Notes database, from Access. The Notes database is release R5. I installed NotesSQL 8.x and have it working. ...

Bob Alston

10-17-2008 05:16 PM
Rich P

I have successfully added shortcut menus to Forms but I am now having difficulty when I attach a shortcut menu to a text control. I have a shortcut...

Jim Devenish

10-17-2008 12:08 PM
Jim Devenish

This is my original equation: =(/)*100 When the denomimator is zero I am unable to calculate the percentage. I tried changing my equation to this...

zufie

10-17-2008 12:05 PM
Salad

Sorry for a simple question: What is the trick to have the Column Headings on Queries to wrap-around versus remain on single line? I often use...

Jacque Asse

10-17-2008 08:29 AM
Salad

More experienced programmers may laugh that I had to struggle with this, but I post it so that others in my position might benefit. My application...

Composer

10-17-2008 07:35 AM
Composer

Hi, I'm working on a database where I need to calculate some data that fits certain sets of parameters, but I'd like it to give me more...

Jen P.

10-17-2008 03:39 AM
Jen P.

A crude, unlikely scenario just so I can get my head around this: Split DB; front end back end. Each user has the FE locally the BE is stored on a...

paul@servicequoter.co.uk

10-16-2008 11:58 PM
CDMAPoster@fortunejames.com

Hello I am working on a database to track sales reps involved on a sale. I would like to flag the sales rep that initiated the sale but read...

spima05

10-16-2008 10:41 PM
spima05

In Access 2007, I have successfully imported a text file with fixed width fields. However the import did not correctly interpret a date. In the...

Mimi

10-16-2008 05:07 PM
Mimi

Help! How do I divide by zero on my form (in a text box). That is, how do I carry out a division problem when the denominator...

zufie

10-16-2008 02:18 PM
ARC

Hi all, I have a form with a sub1 and a sub2. Most everything is working right. Except this. I have a "beforeupdate" and an "afterupdate" event...

jonceramic

10-16-2008 11:33 AM
Salad

Right now I had to build a report that allowed the people to check for gross outliers in their data input. short I am looking at 2.5* std dev +...

sparks

10-16-2008 11:22 AM
Salad

All, I'm not a big Access user - I'm developing a department database. It's based on the Resource template. I've created a form with a control for...

Steve

10-16-2008 11:17 AM
jonceramic

If a person has a MDB secured with user-level security that uses an MDW, what steps does one take to fully remove the user-level security.

Salad

10-16-2008 09:21 AM
Salad

David W. Fenton wrote: My fading memory ... Not only does it open the form, it's opened in a data view and it's invisible so it's not obvious...

Steve

10-15-2008 08:19 PM
Marshall Barton

Hi, I am using Office 2007. I need to be able to open a Word document from Access and insert a customer name and address depending on the record...

Bobby

10-15-2008 03:53 PM
Tony Toews [MVP]

Here is my code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "C: \Databases\RMA Database Redesign\ParetoTemplate2.xls" Access says...

troy_lee@comcast.net

10-15-2008 01:23 PM
troy_lee@comcast.net

Hi, I have a 2 subform form, which uses the selection of a row in subform 1 to show a set of rows in subform 2. I have my queries pointing directly...

jonceramic

10-15-2008 12:30 PM
rquintal@sympatico.ca

Gina asks: I have a form in Access 2003 with a textbox to accept a date. The format is shortdate and I have set the default to Date(). Is it...

Gina G

10-15-2008 08:38 AM
Salad

Hello, I am a junior level programmer and working from home. When I was surfing the net, I found a new tool which is used to compare two access...

cuteshree08@gmail.com

10-15-2008 06:03 AM
cuteshree08@gmail.com

In a table the "TestID" is PK is AutoNumber and format is set "000" so to display leading zeros for numbers less than 100. I have the next field is...

Rob

10-14-2008 04:52 PM
Rob

Hello I am trying to create a database to calculate commissions on a sale based on a tiered commission schedule and am having trouble with how to...

spima05

10-14-2008 04:37 PM
spima05

I am trying to build an Access 2002/2003 database application that I would like to offer to other writers so they can track submissions. Just trying...

rik

10-14-2008 11:58 AM
rik

Hi guys, I'm losing hair over this, so i decided to cry for help here :) Right, i have a query that, when fired off from the saved queries works...

Thuman

10-14-2008 07:02 AM
Allen Browne

Part of my Access 2003 DB tracks Vehicle Events and records a date and an odometer reading along with the Vehicle registration Vehicle Table...

Rob

10-14-2008 05:15 AM
Allen Browne

If I have a form open with a subform control on it in datasheet view that has its record source set to a query or a table, is it possible to...

Gord

10-13-2008 11:58 PM
Tony Toews [MVP]

Hello, I have a user that is running an MS-ACCESS 97 application. However, she needs to have some extra development work done on this database but...

audrey.nsh@gmail.com

10-13-2008 08:34 PM
Larry Linson

Given a week Number, how do I calculate the date that for the Monday of that week?

Vince

10-13-2008 12:23 PM
Salad

I'm getting this message when starting application A (Access 2003), while Application B (Access 2.0) is running. ABC.mdb is a back-end Access...

Mourad

10-13-2008 09:30 AM
Mourad

Trying to add the formatting toolbar to a memo field in '97. I am able to add the toolbar from the view\toolbar\custom menu but as soon as I open the...

doncee

10-13-2008 09:24 AM
ARC

"Steve" <nonsense (AT) nomsense (DOT) com> wrote Yes.

Keith Wilby

10-13-2008 03:32 AM
Keith Wilby

We used software from a now defunct company for many years and all of our data is stored in an access database. Two years ago our software was...

kbrci

10-12-2008 11:24 PM
Larry Linson

Hi NG I try to export a report, by using the following code - it fails with errorcode: 2282 DoCmd.OutputTo acOutputReport, "Faktura", acFormatSNP,...

Carl Hansen

10-12-2008 06:05 PM
Rick Brandt

I have five subforms each living in a page on a tab control. Each form is in datasheet view. The time has come to resize both the forms and the...

Deano

10-12-2008 03:43 PM
Deano

I have an image list with Icons stored in it. How do I display those Icons? Do I use an Image control or a bound or unbound Object Frame.? What...

Phil Stanton

10-12-2008 12:16 PM
Phil Stanton

I've been having problems with Access and Excel talking to one another. In the process of trying to add features (programs) to Access 97 I have...

Chuck

10-12-2008 12:30 AM
CDMAPoster@fortunejames.com

Is there a way to programatically determine if a closed form has one or more subforms and if it does output the source object of the subform...

Steve

10-11-2008 10:46 PM
Arvin Meyer [MVP]

Is it possible to get a table type grid to appear on a custom dialog form? Basically, get the same thing as when you open a table in Datasheet view...

Gord

10-11-2008 05:03 PM
Gord

I need to send an email containing 2 reports. I have tried sending a 2 page snapshot report, but while it prints just fine before sending, email is...

dee

10-11-2008 10:08 AM
Salad

When trying to email a report I get the following error message "an error occurred while attempting to open the windows address book MAPI 1.0 Can...

Phil Stanton

10-11-2008 05:31 AM
Phil Stanton

Hi I've completed work on an access2007 database which is to be run on a network server by many users at the same time. Every time the database is...

Cron

10-10-2008 10:35 PM
Tony Toews [MVP]

On Oct 8, 12:03 pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: I've been trying on and off to adopt the Execute method into...

sara

10-10-2008 10:08 PM
Tony Toews [MVP]

Hello all, In Access 2007, is there a way to determine if a user has their ribbons minimized? If they do, I'd like to put up a warning. Many...

ARC

10-10-2008 09:44 PM
ARC

Hi I have 2 tables with a 1 to many relationship a Pipeline table which can have several impacts (impacts table). What i want to achieve is a form...

paulquinlan100@hotmail.com

10-10-2008 09:51 AM
paulquinlan100@hotmail.com

I have a database table called "tbl_personal" and struggling to VBA program a bit of code to create multiple tables in a database from the main...

bbcdancer@hotmail.com

10-09-2008 04:58 PM
Phil Stanton

Made a data entry form which is a subform. I made a continuous form that displays everything entered through the data entry form. The data entry...

Tyler

10-09-2008 04:31 PM
Steve

Using A2003 w/ tables linked to SQL Server. All users have their own copy of the mdb. I have a combobox whose rowsource is a query. This query is...

emanning@kumc.edu

10-09-2008 12:06 PM
emanning@kumc.edu

I am using a Treeview type menu sustem and need to load various icons I have a form called Icons with a MSComctlLib.ImageListCtrl.2 control on...

Phil Stanton

10-09-2008 06:30 AM
Phil Stanton

Hello, I am using Access 2003. I have a query which shows a list of club meetings sorted by date. This query is displayed in continuous forms, in...

franc sutherland

10-09-2008 04:53 AM
franc sutherland

In VB6, a custom dialog can be easily created by adding a new form, adding whatever controls you like, sizing it as you like, adding code and then...

Gord

10-09-2008 12:38 AM
Lou O