I'm currently running queries in Access, saving the results to a CSV file and loading this into a separate vendor SMTP mass email program (Max Bulk...

mjbuhr@umich.edu

10-24-2008 11:11 AM
PW

Hi All In AccessXP I have a tab control with 5 tabs and I went to requery a combobox if and only if the user is moving from one perticular tab....

bobh

10-24-2008 08:49 AM
bobh

On Oct 24, 5:47*am, BobbyDazzler <david.a.mitch... (AT) inbox (DOT) com> wrote: Probably there is some code which responds to <f6>? Sometimes I...

BobbyDazzler

10-24-2008 06:57 AM
lyle fairfield

I've built a moderately complex table relationship using Access 2007 and back-saving to 2003; my partner on the project has made edits in Access...

Jeff

10-24-2008 06:53 AM
lyle fairfield

I am using DAO360 and Seek command on table with MEMO field (indexed, but not primary key). It seems that Seek command searches only for 255...

chrisdev3@gmail.com

10-24-2008 12:25 AM
chrisdev3@gmail.com

This is a new problem for me: I have some queries that open very slowly in design view. My benchmark query takes about 20 minutes to open in design...

existential.philosophy@gmail.com

10-23-2008 10:25 PM
existential.philosophy@gmail.com

All ~ I'm looking for an access programmer to work for England Logistics in, SLC ~ Utah. The position is base plus monthly bonus. Get paid to...

utahfun@gmail.com

10-23-2008 08:15 PM
Larry Linson

Hi everyone, I am using Access 2003. I have a database with a table in it which is linked to an excel spreadsheet. When I install the database...

franc sutherland

10-23-2008 03:44 PM
jonceramic

Hi, I'd like to add a picture in a report where the path to the picture is from a table, depending on the dogid that is on the report (in the detail...

PW

10-23-2008 03:26 PM
paii, Ron

Hi everyone. Sorry for posting my question about linking to spreadsheets twice. I got an error on the first one, so thought I needed to post...

franc sutherland

10-23-2008 12:32 PM
franc sutherland

Is there a way to copy a import specification from one access database to another? Thanks.

whizdogbob76@gmail.com

10-23-2008 08:48 AM
Tom van Stiphout

I have some data that I need to run date diffs on. The catch is that for some of this data, there is a date value in one of the fields, with no...

nospam@thankyou.com

10-23-2008 07:47 AM
nospam@thankyou.com

Hi all! I need help with a small project using Access and since I am a newbie, I would like to have someone look at the database and help me...

Haas C

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

This may be a dumb questions please forgive I have a form that shows a list box that links to a table with 7 employee names The form does not show...

Steve

10-22-2008 02:08 PM
Roger

Hi All, I have a database which uses a lot of linked tables from the front-end to both Access and Oracle backend tables. I was just doing fine for...

jonceramic

10-22-2008 11:59 AM
jonceramic

I am wanting to set the Find window to not have the 'Search Fields As Formatted' check box checked. I un-check it but when I close and go back in it...

Dennis

10-22-2008 09:39 AM
Dennis

Hello everyone, I am using Access 2003. In my database there is a table which is linked to an excel spreadsheet. When I move the mdb file to...

franc sutherland

10-22-2008 06:14 AM
franc sutherland

So why not use DLookup on a stored query on all required tables? Keith.

Jim Devenish

10-22-2008 03:22 AM
Keith Wilby

I have a situation where some, not all, users get the message "Couldn't find file "F:\AccessApps\AppName.mdw". This file is required for...

Salad

10-21-2008 06:32 PM
Salad

I have a form that had been setup with a combo box. You'd select a value from the combo box and a query would open and display matching records. I...

Coll

10-21-2008 02:59 PM
jonceramic

Hello I am developing a database to calculate commissions on a sale for each rep involved in the same and their uplines. Below is the database...

spima05

10-21-2008 10:39 AM
spima05

I am trying to send a Word document as the body (not attachment) of an email. I can create the Word document using VBA in Access. In Word, it is...

Jim Devenish

10-21-2008 09:26 AM
Jim Devenish

Trying to add The Microsoft Rich Text Control to a '97 database & keep getting the message "You don't have the license required to use...

doncee

10-21-2008 07:40 AM
doncee

hello to all, i am using .net web application. in my web page i am opening word document. also i am having a VBA code in that so after opeining...

kavita chawoor

10-21-2008 04:57 AM
kavita chawoor

Hello' I have a field in which I require validation in a before update event. The validation code I have works fine, no problem there. However I...

ryan.paquette@gmail.com

10-20-2008 07:51 PM
Tony Toews [MVP]

Our application has used this PrintersClass module for some time without a problem but some new Toughbooks have caused problems. We use laser...

Tim

10-20-2008 03:49 PM
Tim

Hi all, I am a newbie who goes through tasks in apainfully slow and in an inefficient way in Access. I've been experimenting here and there and have...

Haas C

10-20-2008 09:27 AM
Keith Wilby

The system I support exists to generate invoices to send to European clients. Currency values in these reports must be represented as Euros with...

brucedodds@comcast.net

10-20-2008 03:31 AM
Phil Stanton

I wrote a very simple demo program in A97 for concatenating email lists. The undo and redo buttons only undo or redo a set of single clicks, not a...

CDMAPoster@fortunejames.com

10-18-2008 10:52 PM
CDMAPoster@fortunejames.com

I made a simple public function to set and return a date value (see below). I have a number of queries that call up the function to get the "As Of...

murch.alexander@gmail.com

10-18-2008 06:18 PM
lyle fairfield

I want to loop through the queries collection and then use these names to define a value list for a combo box. What is the best way to...

troy_lee@comcast.net

10-18-2008 11:48 AM
Chuck Grimsby

The following unexpected error occurred in AppSpecific Module's Sub Check4PastSaleDates(), line #350 when called from Cron Form: 2046: "The command...

MLH

10-17-2008 06:24 PM
ARC

Currently running an Access97 app split fe/be on one pc running Windows XP. Upgrading to Access 2003 and adding a new pc running Windows Vista via a...

BobbyDazzler

10-17-2008 04:59 PM
Tony Toews [MVP]

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 04: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 11:08 AM
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 11:05 AM
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 07: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 06: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 02: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 10: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 09: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 04: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 01: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 10: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 10: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 10: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 08: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 07: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 02: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 12:23 PM
troy_lee@comcast.net