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

Given the business requirements bellow for the current-term enrollment at a large university: · An instructor may teach none, one, or more...

tlwillia

07-17-2003 04:03 PM
tlwillia

Hi, I would like to know if anyone can provide me with instructions on how to convert ddl files which are the files that store audio and video to a...

tlwillia

07-17-2003 03:20 PM
tlwillia

I had a form designed in which all of the text box controls were working and fully functional, then I split one of the tables in the database. When...

judy b

07-17-2003 11:29 AM
judy b

Hello, I have 2 tables in a database - Comic Books - Comic Writers I made a 'form' on the table 'Comic Books'. This table is linked to the table...

BiLlAbOnG

07-16-2003 02:08 PM
BiLlAbOnG

Just a thought... make sure that the 'control wizards' button on the form toolbar is 'on' (that's the one with the wand & stars...) its a...

Chris

07-16-2003 01:00 PM
Chris

Hi, I am trying to append a small table to a master table. The small table contains patient demographic data (name, address, birthday, etc.)...

trash

07-15-2003 12:53 PM
trash

I would like to know how to print one label and one label only from a mishap database. When I try to get my results I get a page full of the same...

Mike S.

07-15-2003 09:48 AM
Ira Solomon

Hello, We're finding that Visual Sourcesafe isn't always capturing all the property changes we're making to our forms when we "get latest version"...

Al

07-14-2003 02:46 PM
Al

Does anyone have a old copy of MS Access 5.0? I want to buy a copy. I volunteer at a local parochial school and their library wants to buy a...

Jim

07-13-2003 11:14 PM
Jim

How do I use the controls in vb 6 in Microsoft Access 2002? John

RBCC

07-13-2003 05:09 PM
RBCC

Is there an OCX control that mimics the shape control in Microsoft Access 2002? John

RBCC

07-13-2003 05:08 PM
RBCC

I', a relative newbie to access and have just converted a Dbase app to MS-Access. My problem is I am sorting a database on a date field and then...

David Kellerman

07-12-2003 11:00 AM
David Kellerman

Hi there, I am setting up a Purchase Order database, and need to have my PO#'s set up as "MTR-00001" and increment from there. How can I use...

Heidi

07-11-2003 11:02 AM
Heidi

Hi All, Have you ever seen this problem with Access 97 running on Win2K? From my Access application, a user enters information into two fields and...

Rich G

07-09-2003 06:51 PM
Ira Solomon

I have an Access 2000 database that uses checkboxes to record received monthly reports. I want to generate a querry that will return values for the...

John Chiurato

07-09-2003 06:45 PM
Ira Solomon

Is there an easy way, in a simple Access table with a lot of records, to populate the same field of every record with the same peice of data? ...

Sean Ryan

07-08-2003 12:57 PM
John

Sorry, just read my previous post, and realized I didn't word it very clearly. I couldn't figure out how to attach this to my previous post. I am...

Sean Ryan

07-08-2003 11:15 AM
Chris

I have 6 different dates on a Home Inventory form that I would like to link to 1 ActiveX Calendar Control, as I have seen in Oracle. Is...

Mark Gatanas

07-08-2003 08:59 AM
Ray

This newsgroup has much less activity and was likely setup in error. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups...

Tony Toews

07-08-2003 12:59 AM
Tony Toews

Ok here is my setup. first off im i kinda newbie so be kind. i am runing just a basic access 2000 database. there are three tables,...

Chuck

07-07-2003 03:35 PM
Chuck

Hi, I am a new Access user and need some help.(I use Offise2000) I designed update query that updatesrecord in one table. When Access asks me if I...

AllaGul

07-06-2003 05:56 PM
Ira Solomon

Hi John, Ok, I worked on this for ages with a version that I was doing. And after much deliberation it turned out to be quite simple. All you have...

Carl

07-06-2003 09:59 AM
Carl

Hi All. I know it is a beginner's question but how can I change the fields properties of many fields in my table at once. I know you can change them...

Fida

07-05-2003 12:43 AM
Billy Kyle

Here it is again. I've run into this problem before, but my usual solutions aren't working. When the code closes Excel, it remains in the processes...

Jason

07-03-2003 05:57 PM
Jason

Hi NG Every month end, I need to import data (*.txt and *.csv files) into some tables. These files are on the same server, in the same folder. BUT...

Chris

07-03-2003 12:11 PM
Chris

I have had Office 2000 Pro installed on my machine and running fine for a year or so. Recently had a chance to install Visual Studio 6/Visual Basic...

Bill W.

07-03-2003 11:14 AM
Bill W.

Does anyone know how to code a WAIT command using VB in Forms? For example, I want to move an object (e.g. a command button) using the LEFT property...

Stu

07-02-2003 12:28 PM
Stu

I don't know if this helps, but when I merge from access I do the mail merge in Word and from the Tools Menu choose "Envelopes and Labels" > "Labels"...

Stan Glenn

07-01-2003 08:45 PM
Stan Glenn