Does anyone know how to print out a dump of a query? I want to print out all the various expressions in a query so that I have a log of the formula...

Dave Cuthbert

08-18-2003 06:22 PM
me

When I use =Sum() and the table or query is empty I get #Error. I am using the result in a calculation. Tried NZ, Is Null etc still get...

J Taylor

08-17-2003 08:04 PM
J Taylor

Hello, Why would a query that incorrectly returns about 100 records immediately change to correctly return 20 when sorted on any column? Thanks,...

mharness

08-16-2003 03:46 PM
mharness

I've posted this in the microsoft news group but just noticed the comp newsgroups. What's the difference anyways? This one is a tricky one so I'm...

me

08-16-2003 02:20 PM
me

Hello, I have a table named CUSTOMERS with a field named DOB. It has a mm/dd/yyyy format. It displays dates of birth. I would like to add on a form...

Paolo

08-15-2003 04:02 AM
Paul R

I'm new at access2000, so please excuse if question is stupid. I'm trying to fill addition form with data from table's last record as default. I have...

Martin

08-14-2003 11:56 AM
janthony

I'm working on a database app that tracks software metrics data for our team. In it is a talbe that contains a list of users and another that...

William Lugg

08-13-2003 08:23 AM
Scott McDaniel

Does anyone know of a line of code that I could use to automatically compact and repair a database, either on a click of a button or event/action?

janthony

08-11-2003 01:50 PM
Peter De Baets

How about this one: http://www.fgcu.edu/support/office2000/access/ Hope this helps, -- Peter De Baets Peter's Software - MS Access Tools for...

Peter De Baets

08-11-2003 01:50 PM
Peter De Baets

I am trying to setup access to score a golf tournament. I have the tables setup and forms to enter the data. I have everything in one big table. I...

JohnMc

08-11-2003 09:55 AM
tom

I have a table with many records and many fields in it. Is there an easy way to run a query that will find only the records with empty fields in...

theo

08-10-2003 08:20 PM
theo

Hi folks....please forgive the crossposting. We are an established web design company, that for a variety of reasons, is slowing switching over to a...

Storm

08-09-2003 09:32 PM
Storm

Hello, I have a table with a field which stored account numbers. I import them via a text file and they show up with this format: C 1234567 0 You...

Paolo

08-09-2003 04:25 PM
Ira Solomon

Hello, I've been asked to convert our company from MS Office, MS Access specifically, from version 97 to Access 2000. The real kicker is that most...

Chris Boggs

08-08-2003 09:18 PM
Chris Boggs

Hello, I have a database called PLAYERS which lists players who participate on leagues (Player, League). I also have a database called GAMES...

franky.b@ua.ac.be

08-08-2003 07:07 PM
franky.b@ua.ac.be

Debugging code I didn't write and a novice to VB. The following code is set up as a module within an Access Database: Public Function...

Leah

08-08-2003 03:09 PM
tom

I have a query which outputs the following: IDM Month Account Location...

mdeschen

08-08-2003 12:46 PM
tom

My company is getting a new server which will have Win Server 2000 or 2002. Additionally, I am developing a MS Access database for the first time. ...

judy b

08-08-2003 10:49 AM
judy b

Oren First, if you did an exact copy, you'd expect that "Field_1" of "Table_2" would match "Field_1" of "Table_1" (?perhaps the "Field_2" was a...

Jeff Boyce

08-07-2003 08:59 PM
junkmail1

This thread's been removed from my news server (Giganews) but I wonder if it's exactly what I'm after. I'm wanting to be able to build a SQL...

Rob G

08-07-2003 06:34 PM
Chris

I have 2000 ACCESS db that someone converted from 97 to 2000. Most everything seems to work, but one button. This is a SEARCH button that involces...

bc

08-06-2003 03:10 PM
bc

Friends, I have just upgraded an Access 97 databae to Access 2000 with no problems. I used Win 98 as OS. I am now having problems if running the...

Paolo

08-06-2003 10:54 AM
Ira Solomon

Hello all, I am not an experienced Access user and this is my first time in a newsgroup but I have two difficulties with Access. First let me...

Sander

08-05-2003 05:07 AM
Sander

Guys, When a use Access 97 to link to my Sybase database using ODBC I get this error message when doing a select from. Can't perform join, group,...

Lars Schouw

08-05-2003 04:40 AM
Lars Schouw

I have data in coloumns like so col_1 col_2 col_3 1 3 5 4 3 10 2 5 2 5 5 5 etc... I need a sql query that...

mahnovetsky

08-04-2003 10:12 PM
Ira Solomon

I am looking for assistance. I need to put an Input Mask in a field in a table. The mask needs to look like: 'Denver Airport' or any other group of...

Sydney Landreneau

08-04-2003 07:09 PM
Sydney Landreneau

Hi Again People Don't know if this is possible or not! Maybe one of you wonderful people can help me out. I am still developing this database and...

FishezUk

08-04-2003 12:56 PM
janthony

Hi Everyone Can someone tell me how I can set up a field to calculate the age of someone in months and years. I have a field with the date of birth...

FishezUk

08-04-2003 09:16 AM
Allan Thompson

When I copy a table from Access 2000 to a dbase 5.0 file, either by using the Export menu command or by calling the TransferDatabase method, certain...

Chris Schmidt

08-03-2003 12:03 AM
Chris Schmidt

I've got a program that creates different spreadsheets in Excel, then after I create them, I run some code that is suppose to go through...

janthony

08-02-2003 04:30 PM
Ira Solomon

Do you have a particular question? "Helmar Herman" <BenAndMarsha (AT) mail (DOT) com> wrote

Tom marsh

08-02-2003 12:25 PM
Tom marsh

Hello all, I am a newbie regarding ms access. I have the following problem. I have designed a continuous form which, in design mode, shows the...

Hooked

08-02-2003 05:42 AM
Hooked

hi!!! create a command button name 'Show' in the click event of the command button dim sDate as string ' to store date dim sSQL as string ...

bala

08-02-2003 03:38 AM
Paolo

I am using MS-Access 2k and would like to ask how to disable a user from deleting a record in the table view? Thank you very much. Arthur Cheung

Arthur Cheung

08-01-2003 11:04 PM
Ari Lea

John: this gives the number of months: mnth = DateDiff("m", dob, Date) if you want years and months yrs = mnth / 12 - 0.5 mnths = mnth mod 12 Good...

Ira Solomon

08-01-2003 04:50 PM
Ira Solomon

Given this table, named tblCUST: txtNAME intSCORE ====== ======== CARL 70 ALEX 50 BILL 55 ALEX 55 BILL 50 ALEX 70

POBOXNYC

08-01-2003 04:26 PM
bala

My client wants his database to show a sequential number, for each record. In the past this was done by Access automatically. Recently they changed...

William Bradley

08-01-2003 12:27 PM
William Bradley

Hi all, I've been asked to look at upgrading an Access Database. Unfortunately, all I can see are the forms. Even if hold the shift key down I...

doctor

08-01-2003 09:55 AM
bala

hi!!!! incase it is a continuous form it is going to be bound form. add unbound textboxes in the footer section. assuming there as two columns if...

bala

08-01-2003 09:53 AM
bala

I've got a Form with 2 fields that are usually going to be the same, but not always (hence, the need for a separate field). When a user entering a...

zzz

08-01-2003 01:16 AM
zzz

I don't know if this is any use to you, but could you not create a form based on TeamTable that concatonated ID and TeamName in a list box, and then...

Simonc

07-31-2003 02:14 PM
bala

How do I place controls within a rectangle? In VB, you draw a frame, and then, while the frame is selected, place the control in the frame. This...

Helmar Herman

07-31-2003 10:45 AM
bala

Am trying to format a report such that a value does not show if the total of the values in a field in the detail section is less than 1. The totals...

Ken

07-31-2003 10:34 AM
bala

(dhl) I am using Access 2K. I run a report every week that shows over due purchasing order. Each record in this report has the supplier and their...

David

07-30-2003 04:46 PM
Peter De Baets

Can anyone tell me how I would run a query to give me a set of members that are in one set but not in another? In other words, I have customers in...

Chris Koch

07-30-2003 10:01 AM
Chris Koch

I've designed a project which uses form to populate an ACCESS 2000 database. I'm trying to use the Charting Feature in ACCESS to chart the data in...

Shane Jones

07-29-2003 02:37 PM
Shane Jones

Hello Hello I have an excel spreadsheet that that will be named different each time. What I need to do is be able to open the file in free file...

Bob

07-29-2003 02:01 PM
Bob

I have a feeding a single query and that query linked to a form so I can pull values off of it. The problem I have if any of my first query contain a...

Eric

07-29-2003 11:26 AM
Eric

When placing a text box (or most any other component for that matter) on a form, Access automatically creates an associated label. This has the...

boyle

07-29-2003 10:09 AM
boyle

Anyone have a sample DAO program that prints out metainfo on tables and fields? VB6 will do, I suppose. I need to do it from C# or C++.

Siegfried Heintze

07-28-2003 07:42 PM
Kelly Cromwell