"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote in message I suspect that you're not interested in a Ford versa Chevy type...

Salad

04-08-2010 06:44 PM
David W. Fenton

If one selects a query one can View the SQL and edit it by hand - or cut & paste from one's favorite editor. I tried putting several lines of SQL in...

Gilgamesh

04-08-2010 04:36 PM
Gilgamesh

I need to have a query that does the opposite of a running sum. I would like to show a totals column that actually decreases with each record. The...

koturtle

04-08-2010 02:23 PM
koturtle

I am a begginner and have created a database where I work and on one of the forms I have a Print button that will print a report. Is there anyway to...

BamaBlast

04-08-2010 01:21 PM
fredg

Is it possible to determine the text and background color for selected items in a listbox, as it is with the unselected items? If you veer away from...

franc sutherland

04-08-2010 11:02 AM
Marshall Barton

I have a small membership program. It consists of 2 main files: 1) A Members Master file 2) A Transaction (payments received) file If a member has...

Prakash

04-08-2010 05:49 AM
Prakash

I have the following VBA code: Dim strMonth As String strMonth = Me.cboOnyxAllocationHistoryMonth.Value strCnxn = set_connection() Set cnxn = New...

hedgracer

04-07-2010 06:52 PM
Rich P

Hi, I'm using Access 2003 on Windows XP. My client wants to classify his customers according to ten classifications. Each customer can fall into...

franc sutherland

04-07-2010 02:59 PM
franc sutherland

Is there an Access SQL function to rename a column? I tried the following: ALTER TABLE tablename RENAME oldcolumn newcolumn; ALTER TABLE tablename...

bubbles

04-07-2010 07:34 AM
Marco Pagliero

I am writing a paper on the use of Microsoft Access, and consequently, I am trying to find good data on who uses the product, what they use it for,...

FraserOrr

04-07-2010 04:54 AM
bubbles

It would be interesting to see if you get any replies. I don't know how many people here actually have applications that they sell and support. -pw

PW

04-06-2010 01:14 PM
PW

Access 2003 novice user. I am attempting to build a report using the wizard. Table "a" has a field "barcode". Table "B" has 4 fields "barcode1",...

DJH

04-06-2010 11:49 AM
paii, Ron

I have an Access DB with a Table containing the fields ID Pilot Flight Date Each Pilot accessing the DB enters the date of his flight each time he...

Mike Glazer

04-06-2010 10:47 AM
Salad

Hi I have a form with combo box that pulls 4 columns from the table A. I want to pass selected row (from pulled values) to another table (table B)...

avi

04-06-2010 10:34 AM
Salad

Ok, this is wierd. We just had a multi-user Access database (2007) crash. Separate front-end/back-ends(multiple). One user had two locks on the back...

John von Colditz

04-05-2010 11:52 PM
Jean-Paul Leppinus

I told somebody that if they wanted to distribute the app via email, go to the AutoFE folder, run StartMDB, and send the email. So the first thing I...

Salad

04-05-2010 09:29 PM
Salad

Depending upon which of several computers is being used to enter cases (having unique case numbers), , I have an application in A2k3 on WinXP which I...

isobadd

04-05-2010 09:06 PM
Salad

Hello. I am using docmd.transfertext to export a pass through (to SQL Server) query to a txt file. When I execute DoCmd.TransferText...

Matthew Wells

04-05-2010 04:25 PM
Albert D. Kallal

Has anyone else noticed this behavior? Double clicking a form's title bar in design to maximize it takes about 3 minutes. Saving takes at least 5...

Matthew Wells

04-05-2010 12:36 AM
Albert D. Kallal

Hi Everyone, I have built a class module that fires some events given specific circumstances. When I step through the code the RaiseEvent...

The Frog

04-04-2010 11:21 PM
rkc

I have used an application developed in Access 2003 very well previously. I bought a new machine with Windows 7 and reloaded Access 2003...

Duncan

04-04-2010 08:31 AM
bsn

Hi, Someone from abroad might be interested in my application. Ha, new perspectives. The user interface's language, now, is Dutch. I want to...

Michiel Rapati-Kekkonen

04-03-2010 02:52 PM
Michiel Rapati-Kekkonen

In MS Access 2007 heb ik een datum veld aangemaakt v.b. datum_u1 in notatie D/M/Y Na koppeling met word 2007 krijg ik de notatie in word M/D/Y In...

wouter

04-03-2010 10:43 AM
Tom van Stiphout

I have come across an odd problem in A2007. I have a small form with a combo in it that I use to display a month from a query that shows all 12...

jbguernsey

04-01-2010 09:23 AM
Tom van Stiphout

Hi, This client brought in this tech guy which copied and pasted our data/backend MDB (front end is an MDE) onto a NAS drive from an XP machine (am...

PW

04-01-2010 07:15 AM
paii, Ron

If your cost base is high relative to your income stream then what about shifting the support 'entirely' to a forum based appraoch. Keep a...

RonG

04-01-2010 03:25 AM
The Frog

Is there a reasonably simple and elegant way of exporting a 3 page report to Powerpoint? I've looked at the Stephen Lebans method of exporting the...

Wayne

04-01-2010 03:00 AM
Wayne

I have a bunch of columns e.g. Day1-A, Day1-B,... Day2-A, Day2-B, etc. and want to write a query to for example, return all Day2 columns only. How...

Parag

03-31-2010 05:55 PM
Rich P

I'm trying to write a macro to update column headers in a table - any ideas on how I can do this? Basically, for a given table I'd like to update...

Parag

03-31-2010 05:34 PM
Parag

Hi Everyone, I am stumped. I have a form with multiple listboxes (cascaded if you will) that 'lead' to a final listbox and under this listbox is...

The Frog

03-31-2010 07:15 AM
Stuart McCall

Hi All, In AccessXP in a sub can I wildcard the CopyFile command or do I have to specify each file example can I write CopyFile "c:\MyData\*.*" ,...

bobh

03-30-2010 11:25 PM
Tom van Stiphout

I'm not sure why but all objects in my A2003 database window are underlined and are basically hyperlinks. Access seems to use the single click...

Salad

03-30-2010 08:17 PM
PW

All, I have a query I need to ORDER BY by either; a) The result of another query (always a single text string, e.g; "TBL_Timers.TimerPos DESC". b) a...

Patrick A

03-30-2010 05:36 PM
Patrick A

Hi All, I have a query that will show my budget for the current year. When I open the query in a form it shows me all the figures but when I try to...

Co

03-30-2010 03:04 PM
Andrew G

Hello Sir, I am having problem in formulating a SQL query . Please help in finding out the solution: I need a SQL query in whichi want to select N...

richa

03-29-2010 05:00 PM
Tom Clavel

If subreports don't show up in 2007 -- Bear in mind that results may vary depending on your choice of Print Preview or the new Report View. -- Make...

pemigh

03-29-2010 04:19 PM
pemigh

I am modifying an existing application for a client. None of the forms has a close or exit button, so users are in the habit of just clicking on the...

John von Colditz

03-29-2010 03:29 AM
The Frog

hi i have a table that contains file paths to documents table fldrecordindex fldpath i have a query that returns the records relating to the open...

kevcar40

03-29-2010 02:41 AM
kevcar40

Hi I have a Text Box of which the Text Format is set to Rich Text. The box is filled with texts containig certain elements that are surrounded by...

Michiel Rapati-Kekkonen

03-27-2010 10:30 AM
Michiel Rapati-Kekkonen

Hallo Is there someone here who could help me? I don’t anything about access, but I need a template which I could use when I buy / sell parts. I...

Poul Erik

03-27-2010 03:35 AM
Poul

Hi, I'm using Access as a Mysql front-end via odbc. I made a form on a connected table and an update query is used to set null some fields and to set...

remigio

03-26-2010 04:05 PM
remigio

Hi Everyone, I was just rummaging around and came across a startling fact (for me anyway). I have no routine to parse a windows or unc path and...

The Frog

03-26-2010 02:35 AM
The Frog

I am getting the message "Microsoft Office Access Has Encountered A Problem And Needs To Close" with the two buttons <Send Error Report> and...

Steve

03-25-2010 04:34 AM
David Poul

I have a large Acces based system that includes a mini report writer. In it, the user selects a "Data source" which is a pre-established query that...

Bob Alston

03-23-2010 11:28 PM
Tom van Stiphout

I've got a list of column headers in a table, e.g. A, B, C 1, 2, 3 4, 5, 6 etc. In another table, I've got a list of field descriptions...

Parag

03-23-2010 04:43 PM
Parag

I'm designing a report based on a totals query, which is in turn based on a pass-through query (SQL Server 2005). For some reason design view in...

brucedodds2

03-23-2010 03:56 PM
brucedodds2

Hi, I've been creating a few forms - my first forays into this. Previously I've used access for querying and writing reports; the data having come...

Gilgamesh

03-23-2010 12:30 PM
Gilgamesh

Hi Everyone, I am wanting to know if it is possible to build a custom object / class 'on the fly'. I am hoping to create a class that has...

The Frog

03-23-2010 05:01 AM
The Frog

I think have been able to do this in the past but am unable to at present time. Have a form bound to a table. Have a combo box on the form bound to a...

doncee

03-22-2010 10:21 AM
doncee

I am trying to colour each line on a listbox differently, depending on one of the fields in the listbox. Because I will be migrating to Access 2010...

Phil

03-19-2010 07:40 PM
Phil