I have to create a QA report regarding callers calling into a phone hotline. The report consists of many checkboxes such as: Did the IBCCP agency...

zufie

09-18-2008 04:20 PM
paii, Ron

I have used Sum(Abs()) to convert my neg. (-) values to pos. (+) values how can I obtain the correct percentage. For example, here is my expression...

zufie

09-18-2008 03:33 PM
zufie

I have used Sum(Abs()) to convert my neg. (-) values to pos. (+) values how can I obtain the correct percentage. For example, here is my expression...

zufie

09-18-2008 03:02 PM
zufie

Hi, I am using Access 2003. I am having a problem with a pair of combo boxes. I want the second one (cbo_service) to have it's row source limited...

franc sutherland

09-18-2008 02:04 PM
franc sutherland

Hi all! I am new to this and trying to learn as best as i can. This group is defiintely helpful in that regards. Anyways, I was wondering if someone...

Haas C

09-18-2008 01:59 PM
Haas C

I have a list box based on a query. I set the row source in vba with a dynamic string. I have a combo box at the top of the form that selects a unit...

troy_lee@comcast.net

09-18-2008 01:16 PM
Salad

Anyone happen to have the email address of Simon Harder, an Access developer down under in Sydney Australia? He wrote some software that I am...

Bob Alston

09-18-2008 10:09 AM
Salad

How do you find the earliest of a set of dates in a field using a query? I thought using "min" in a totals query would work but it seems to treat...

Keith Wilby

09-18-2008 10:06 AM
Keith Wilby

How could I printout (hardcopy) the scroll bars property of all the forms in a database? Thanks! Steve

Steve

09-18-2008 09:09 AM
Steve

Hi, I just wanted to say thank you to Tina. You have posted the simpliest way of resolving the tax issue at a time when I was about to give up. I...

timbits35 via AccessMonster.com

09-18-2008 07:34 AM
timbits35 via AccessMonster.com

Hi, Ok I know, another question about tax calculations. I have read all the posts, but I still don't get it. I have an sales database and I need to...

timbits35 via AccessMonster.com

09-18-2008 02:07 AM
Carlos Nunes-Ueno

My db allows the user to send email via CDO. The body of the email is determined in code. I have built an email form with To, CC and Subject lines...

evenlater

09-17-2008 02:34 PM
Salad

I need to create a db, my idea is to create a combobox where the user would select an item, ie (style of wine, - there would be about 10 different...

teresaeiben@gmail.com

09-17-2008 01:38 PM
rumkus@hotmail.com

Ian, I've used the same code you mention for years, and have used it many times, successfully, with Access 2003. I got my copy...

Larry Linson

09-17-2008 12:24 PM
Larry Linson

re: Access 2003 I have a field called SentByMethod the displays a 'zero', '1' or '2'. I am trying to set up a text field that shows "Sent by X" if...

RLN

09-17-2008 10:14 AM
RLN

I'm trying to filter a report with a date in VB code. If I type an actual date bracketed with the pound symbol (i.e. #3-Jul-08#) I can get the...

Gord

09-17-2008 12:11 AM
Gord

Hello, I have a Database setup that has two tables that are linked. Table1 contains a list of people with their basic contact details (name & phone...

sharsy

09-16-2008 09:33 PM
Tom van Stiphout

I am working on a very large database that has a main menu, many sub-menus and a few sub-sub-menus. These menus typically have many command...

Steve

09-16-2008 07:34 PM
Steve

Hello, I have a table with marks (from Exams) and when I create a query a calculated field with an expression like: Round(+ )/2 I am confronted...

Arie

09-16-2008 04:48 PM
Marshall Barton

Hello all, I would like to find a piece of software which would allow me to draw out the design of a database, rather than trying to keep it in my...

franc sutherland

09-16-2008 10:52 AM
Larry Linson

We are entering mm/dd/yyyy but some of the date fields only contain years. Can a date be made to only take a year entry if that is all that they...

sparks

09-16-2008 06:39 AM
sparks

Hi, I am using Access 2003. I have set up an invoice in a report. I have set up the name and address as text boxes in the Page Header which I've...

franc sutherland

09-16-2008 06:11 AM
Allen Browne

Hi Just found out that some data is being left out of a report--but I don't know why. The first query below works, but the second one, which I want...

6afraidbecause789@gmail.com

09-16-2008 05:50 AM
bcap

Need Some Help, In Modifing this Bit of VBA Code, This the code i use and it works but i want it to go one step further in on the open event of my...

dan.cawthorne@gmail.com

09-15-2008 08:05 PM
AccessVandal via AccessMonster.com

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote in news:Xns9B1AC55FFCD80f99a49ed1d0c49c5bbb2 (AT) 74 (DOT) 209.136.97: Multiple...

rebecky via AccessMonster.com

09-15-2008 07:56 PM
lyle fairfield

I had a user that converted an application from Access 2003 to Access 2007. The application is split front-end/backj end. When trying to open certain...

Jim Mandala

09-15-2008 07:32 PM
MGFoster

I am creating a table that will show a log sheet for hours worked. Each employee will work part time at their own discretion during the week. This...

Ryker

09-15-2008 03:38 PM
Ryker

Please has anyone any knowledge of extracting data from Sage Accounts into Access. Can link most of the tables, but uncertain of what indexes are...

Phil Stanton

09-15-2008 03:30 PM
paii, Ron

Hi guys, I have create a form type Pivot table in the Access. The base table has a lot of fields and as i assemble my PT is impossible to scroll the...

maffonso

09-15-2008 07:24 AM
maffonso

Hi Access Building Friends, I am building a database for a manufacturer who needs to know the projected End_Date of each job. I know the Start_Date...

Connie via AccessMonster.com

09-13-2008 09:16 AM
Connie via AccessMonster.com

Hello all, When a user starts my app, I run re-attaching code if the links are not valid, etc. In this routine, I then check the version of the...

ARC

09-12-2008 11:25 PM
ARC

Hi: Here's a problem I've had for a long time. The client is really running out of patience, and I have no answers. Access2003, front- and...

Jan

09-12-2008 10:15 PM
Jan

Hello all, I know act databases are easy enough to connect to, but I believe you can change the fields in act, so what do you do if the fields are...

ARC

09-12-2008 03:35 PM
ARC

I have a module that walks down a file of unique claim numbers. Db is Current db. For each claim number I want it to retrieve, to a recordset all...

KC-Mass

09-12-2008 01:32 PM
lyle fairfield

Among other things is Filemaker Pro a relational database. Some of my readings have "hinted" that it is, but descriptions of some of its tables...

Chuck

09-12-2008 09:34 AM
Chuck

Hello, my form is used to filter data displayed in its subform. The origin of the data of the subform is dynamically generated. The filters work in...

Ornitobase

09-12-2008 02:20 AM
Ornitobase

For anyone that has the 'pleasure' of using Office 2007 you will know of one handy feature built in - its the search function housed in the record...

DeZZar

09-12-2008 02:08 AM
Allen Browne

On Sep 11, 5:06*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Your bolKeyExists function does not check for a key in the...

TC

09-11-2008 08:52 PM
rkc

Per Ian: A third choice - suggested to me by somebody who sounds like they know - is to dispense with currency altogether and just format it all...

Allen Browne

09-11-2008 07:09 PM
(PeteCresswell)

Hello all, I developed a tool a year or so ago for adding your own spell-checker to an access application. This is mainly for those using the...

ARC

09-11-2008 06:05 PM
Carlos Nunes-Ueno

I need to purchase 2 copies of MS Access 2003 Full versions. I've checked the usual online resources with no luck. Any help would be greatly...

JustaDawg

09-11-2008 01:30 PM
Bob Alston

I have an A2003 form that's generating a "Reserved Error" when a combo box is requeried in code. This form is bound to a SQL Server 2000 back end. ...

brucedodds@comcast.net

09-11-2008 12:10 PM
brucedodds@comcast.net

Sorry if this double posts... I am trying to set the forecolor on a field of a form to Red if priority is equal to High. The Priority field is...

turtle

09-11-2008 12:02 PM
turtle

If Me.Priority = "high" Then Me.SAP_MM.ForeColor = 255 Else Me.SAP_MM.ForeColor = 0 End If

turtle

09-11-2008 11:24 AM
turtle

Hello, I need to add several new records to Table2 from Table1. Table2 contains a field called that needs to be the previous maximum value of ...

nrtyme@gmail.com

09-11-2008 11:06 AM
Salad

Has anyone ever had some of their menu commands come up missing in Access? Some time ago I made some custom toolbars from the Format menu mostly....

troy_lee@comcast.net

09-11-2008 08:44 AM
troy_lee@comcast.net

Recently I have been helping a nonprofit modify a system built in Access, that they acquired from another nonprofit. I am doing this as...

Bob Alston

09-11-2008 02:24 AM
Tony Toews [MVP]

Hello! My Code destroys Excel's normal work.After running this code I acan' open excel file as normal. Do you know why? Please, answer. Public...

AlenaMezh@gmail.com

09-10-2008 06:31 PM
Rich P

Ciao a tutti sono Stefano neofita di Access. Avrei bisogno di una spiegazione. Ho qualche difficoltà a capire il ciclo for each .... next. Ho trovato...

lanciste@gmail.com

09-10-2008 05:48 PM
lanciste@gmail.com

Path: Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local02.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-...

CLEAVE6@comcast.net

09-10-2008 02:58 PM
CLEAVE6@comcast.net