Hello, Can anyone tell me how to make this alter table command work? alter table tblprospects rename column telephone number to phone I've tried...

mharness

11-30-2003 05:24 PM
Scott McDaniel

Hello, I have just converted a database from A97 to A2K2. I had a procedure for changing start up properties that worked really well. For some...

RWC

11-29-2003 11:24 AM
RWC

I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS,...

Guy

11-28-2003 09:16 AM
Guy

I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS,...

Guy

11-28-2003 09:03 AM
Guy

I have a database file that I have been working on which contains a form. On that form I have several.. = twenty'ish unbound text box's which I...

MTHarris

11-28-2003 05:45 AM
Scott McDaniel

Hi I'm wanting to learn how to create inter-relational (?) forms in Access, but don't know where to begin. Are there any tutorials online?

Wanda

11-28-2003 03:18 AM
Wanda

I have a form I am working on. On that form I have fields which perform calculations. What is the easiest way to define a pass or fail result...

MTHarris

11-27-2003 09:50 PM
MTHarris

Is there any way to determine if a string is a vba reserved word or part of a vba reserved word? Besides creating a table of such words and looking...

G. Stewart

11-27-2003 08:50 PM
G. Stewart

Can you run Access 97 and Access 2002 on the same pc? We have some databases that are converted and some that are in 97. Thanks

Rusty

11-27-2003 08:59 AM
UMFan

Hey, I have to store a history of different entities (pc's, servers, ...) For instance: entity: pc15 date event 1/10/03 software...

Oswald

11-26-2003 05:29 PM
Bradley

I am having data from a union query truncate when displayed in a report. All of my data shows in the table, query, and when the query is exported to...

Sharon Luke

11-26-2003 10:23 AM
Sharon Luke

Hello I am creating a Dbase to handle the borrowing of software (a library booking system essentially). What it has to do is take the details of the...

Jack Smith

11-26-2003 05:38 AM
Jack Smith

I am trying to select data from the left of a delimiter. I have a part number like ABCD123-TOP all of the part numbers are like this. I want to...

ANDY PHILLEY

11-25-2003 08:17 PM
Scott McDaniel

Hi, I need to make a NEW query with help VB code in Access. In the VB is not something like createquery, addquery or newquery. Thanks for...

Paja

11-25-2003 02:30 PM
Bryan Christopher

I have been saddled with a new project at work in where I have to migrate data from acces 97 to a backended SQL server and keep front end either in...

Steven K.

11-25-2003 09:00 AM
John

Hi, I am from the Northern Territory Emergency Services, a volunteer group that assists in man made or natural disarters.( Australia, NT )We give...

Andrew

11-25-2003 08:53 AM
John

Hallo, ich moechte Emails ereignisgesteuert aus A97 über Lotus Notes verschicken, habe aber keinen Schimmer wie. Ein Ansatz, den ich mir mal...

CHRISTIAN THURNBAUER

11-25-2003 03:25 AM
CHRISTIAN THURNBAUER

I´m looking for a tool to searching for a specified data in a file and put this data in a Excel spreadsheet. (freeware). Could you help me ? Thanks...

Shiva MahaDeva

11-22-2003 05:16 AM
Shiva MahaDeva

Download your free software! Audio & Video MP3 Search, Burners, Players, Rippers, Video... Internet Tools, Privacy, Pop-Up Blockers, Chat,...

Downloadline

11-21-2003 06:20 AM
Downloadline

So I added a splash screen using the method of giving the "same filename.bmp" to the graphic as the .mdb filename. The splash screen shows for about...

Shiver

11-20-2003 04:50 PM
John

I need a recommendation for how I might improve my Access development skills (and ultimately, my code) given my personal profile below: Years...

Keith Parish

11-20-2003 01:14 PM
Keith Parish

I have an activex listbox. When a user selects a record it opens a different form. When they make a change to that record i have to refresh the...

OPiewan

11-19-2003 03:28 PM
OPiewan

Hello: I have table "aspects" that contains only fields "ID" (numeric KEY) and "aspect" (char string) such as: 1 rough 2 smooth 3 shiney 4 ...

RJM

11-19-2003 12:52 PM
John

Does anyone know of a setting (within Access, Registry or Group Policy) that will prevent users from upgrading legacy versions of databases? I'm...

Dave Wilkinson

11-19-2003 06:57 AM
Dave Wilkinson

To all, I have a CFO who refuses to go the way of Excel. There is a workbook that he creates and we use it for budget numbers. The problem arises...

Antonio Stroman

11-18-2003 12:22 PM
Antonio Stroman

Ok - I managed to overcome my daftness this morning and get my query to work. I have one last step to conquer and victory will be mine!!!! muah...

Brian

11-18-2003 09:12 AM
Brian

Hope this makes sense - I'm trying to figure out how to store the result of 1 query for use as the criteria for a second query? I'm trying to take...

Brian

11-18-2003 01:23 AM
Brian

Good Morning. I'm trying to open a report with a command button and have it open maximized and set the zoom level to 150%. I accomplished the...

Brian

11-15-2003 06:48 PM
Brian

I have a strange situation with my Access 2000 database. I have code in the database which has worked fine for years, and now all of a sudden...

Neil Ginsberg

11-15-2003 05:05 PM
Hunter

Hello All: I have hopefully a simple question for an experience Access Guru. I have text files that I suck into Access with the wizard. Of...

BlueDolphin

11-15-2003 04:01 PM
TXSG8R

I have a database that I would like to be able to print only customers from a specific zip code. I would like to create a form to do the search...

mmi

11-14-2003 05:07 PM
mmi

I need to open a .mad file ( MS Access shortcut module ) but I'm not skilled in ACCESS . I need to have access at the data contained in this file (...

fred2003

11-13-2003 08:32 AM
fred2003

hi , i am using Access 2000 to make a simple app. i find all i need in the templates "inventory" & "order entry " bundled wih Ms.Office 2k. I...

Lancer

11-13-2003 12:34 AM
Lancer

Hello, I need your help. I am creating a database for work and have run into a problem... I am in the process of creating a form. In one of my...

Tina Marie

11-12-2003 11:43 AM
Tina Marie

Hello to all. I am trying to create a somewhat basic management system for an estimating program. The program exports data in a funky format. I can...

Tony Painter

11-12-2003 10:40 AM
Ira Solomon

I'm using a simple output query to create my initial excel spreadsheet. My problem is that I need to now add more worksheets to the same spreadsheet...

MicahB

11-12-2003 06:31 AM
onedaywhen

Hi all, I am trying to provide an indicator on a form to highlight every 10th occurrence of a Formulation, so this Batch must be sent for testing....

Julie

11-12-2003 06:08 AM
MeadeR

I am getting the following error when I am trying to send a report as an email attachment "Microsoft Access Can't Open the Mail Session" On the...

Stephen

11-12-2003 05:45 AM
Stephen

I am having a problem with my application that uses ODBC. I am doing the following: * prepare a statement * Bind * execute The problem is that my...

Nile

11-10-2003 04:32 PM
Bob Hairgrove

I have a customer that is using Access 2000 and they have some reports that print on Legal paper. Of course on different computers the paper size is...

Ray Valenti

11-10-2003 01:35 PM
Ray Valenti

I have a table: Table(blah, blah, date1, date2, differenceOfDays, blah) I made a query using MS Access, which subtracts the dates to give the number...

iuy@ih.com

11-10-2003 01:22 PM
Ira Solomon

I have a docmd.openquery event assigned to a command button on a form to open a query. (I am doing this to reference information in the query to use...

Seth Delaney

11-10-2003 11:24 AM
Seth Delaney

Hi all, i need to store data of measurments that were measured in a certain date at a ship's main engine bearings. - i have several ships - each ship...

Alex G

11-10-2003 10:00 AM
Alex G

I am creating a web community site where each user can have a list of buddies. I have struck a bit of a problem though. I am designing my db model...

David

11-10-2003 03:47 AM
John

A charitable burn survivors organisation wants a database. Could someone help me setting one up(tables - linking tables -one to one/many etc) on the...

PR

11-10-2003 03:32 AM
PR

I currently have a table that utilises a hyperlink field. The field currently links to a form using the following default value "form frmCand##form...

Jon

11-09-2003 08:35 PM
Jon

I have a hyperlink field in a table. The default value for that field is form frmCand##form frmCand. This command opens up a candidate form from the...

Jon

11-09-2003 05:19 PM
Jon

I'm a teacher using MS Access on an RMConnect 2.4 network. On some workstations both I and my students sometimes get an error message when attempting...

Chris Bolus

11-09-2003 12:15 PM
Chris Bolus

I would like to link a record from a query to the coresponding one in a form. Is there a way to use a field in a query that when clicked, can open up...

Jon

11-09-2003 01:52 AM
John

I have a pair of identical Access 2K dabases. These are used to track information quarterly. The person doing the data entry accidently opened the...

John

11-09-2003 01:38 AM
John