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

I have secured a database in a network ebvironment. The workgroup information file is NOT the default file and the database is opened via a shortcut...

Oisin

07-27-2003 12:50 PM
Oisin

Hi All: I am not quite sure how to refer to different tables within a select statement using ADO recordsets. Can anyone show me how to do this? When...

tmurray0539

07-26-2003 04:50 PM
tmurray0539

I suspect your tables are not well normalized but, without a more explicit example, it's difficult to say what needs to be done. Could you provide...

Gramps

07-25-2003 07:44 PM
Gramps

On 20 Jul 2003 12:58:00 -0700, pleiades_fire (AT) hotmail (DOT) com (Past and Future Ghost) wrote: Click on Joe Brown and then the 'filter by...

martin W

07-25-2003 04:39 PM
martin W

Hi, I made some changes to my Access program and tested everything out. All functionality worked. After converting to Access 97 from 2000. Some...

Dave

07-25-2003 04:23 PM
Dave

Looking for some help. Not really sure if this is VBA or Access. I'm using Access97, and using the TransferText command, and I want the text file to...

Binary Dave

07-25-2003 04:22 PM
khayman_v@yahoo.com

I have an unbound form from which data entered by user is saved to various tables when user clicks on 'save' command buttons. Among the fields...

Chris

07-25-2003 09:11 AM
bala

Hi, I am looking to generate all possible combinations of single words in column "a" and to end up in a result1. I would then like to check to see if...

nb

07-24-2003 09:17 PM
nb

I am initial on ACCESS and I try to put my access project on Cd to install it automatically on other computers. ANd if this computer don't have...

Lino

07-24-2003 06:03 PM
Lino

I have a VB Access database with 65K parts in inventory and 7000 customers and contacts. I need to create an IIF File to export transaction data...

Billy Kyle

07-24-2003 07:41 AM
Michael

I'm trying to produce and filter by form query (without saving it) to excel, the tricky thing is that I want to output also the criteria used (wether...

Choack

07-24-2003 12:09 AM
Choack

Microsoft Access allows me to specify a lot a meta-information about tables and fields (columns). I can specify comments and form element types for...

Siegfried Heintze

07-23-2003 09:23 PM
Siegfried Heintze

I currently have a table as follows: order_date, order_no, total_amt, currency What I would like to do is to generate a query which gives me...

Mike

07-23-2003 07:29 PM
Gramps

Hi all, I've tried for two nights to figure this out and I'm not any closer than I was when I started. I've got a small Access 2000 DB on a WinXP...

Pete L

07-23-2003 04:16 PM
r0adh0g

hi scott first and foremost thanx for replying. well infact i did enclose the time value within pound sign (#). though the backend is ms sql...

bala

07-23-2003 01:59 PM
bala

1. It sounds like you have may want to normalize your data into two different tables a table for patient info and a table for services performed 2....

Billy Kyle

07-23-2003 01:39 PM
Billy Kyle

Hey , you wrote: <snip> well, you could use ifranview for the batch conversion it has a built in tool for that. as far as conversion speeds go the...

Oren Kaplan

07-22-2003 01:33 PM
Oren Kaplan

collega's als ik in een formulier in access 2000 en xp 2 invoervakken met selectie veld heb. en het ene invoervak moet afhankelijk zijn van het...

Pascal Janssen

07-22-2003 09:54 AM
Pascal Janssen

We have a timesheet system running in ASP with an Access back-end on Microsoft Small Business Server 2000. Recently it has come to our notice that...

Jon

07-21-2003 12:16 PM
Jon

Dear all, I've searched through the help files of access 2K help. However, some help are only showing examples of built in functions. How can I...

Arthur Cheung

07-21-2003 11:40 AM
Arthur Cheung

Hello all, Has anyone out there tried running an Access adp file using Remote Desktop/Terminal Services from a pocket PC? I was able to connect...

Al

07-18-2003 07:06 AM
Art Yates

I created a fully functional access database that to be used in a radiology department. Briefly, the database records, patient information, referring...

Hathcock

07-17-2003 08:45 PM
Samuel Hon