I have recently been provided with a new laptop. The old one ran Win 2000 with Access 2000 and the new one runs Win XP with Access 2000. When I try...

Scott Dillard

10-21-2003 04:59 PM
Scott Dillard

I have a form with the following code on Click that calls a procedure passing a date data type value. The field in the table is a date/time data...

mark

10-21-2003 06:36 AM
Scott McDaniel

Friends, I was thinking of creating a form in Access and add a list box that displays all my Word files I have saved in my C:\My Documents\...

Paolo

10-20-2003 07:13 PM
Bradley

Hello; Stats: MSAccess 2000 How do I do the Following: Replace all of the occurrance of a string with a <CarriageReturn/LineFeed> in a memo field...

Allan

10-20-2003 10:29 AM
Allan

Thanks. I opened a new database and imported the table. I found the font was script so I changed it to Ariel. Then I simply changed the font on my...

arbowen@macomb.com

10-20-2003 09:41 AM
arbowen@macomb.com

I have a database with payment details for members. Each member can have multiiple payment records. What I would like to query for is the most...

jording@pacbell.net

10-20-2003 09:38 AM
Philippa

I am new at acces and have a problem. I have a file that open where the tables, forms, queries etc would be list as just a blank grey screen...

Ron Thetford

10-20-2003 09:11 AM
Philippa

I thought I posted this yesterday but I can't find it now so here it is again: Hi to all. We have a Microsoft Access 2002 database that is...

George W. Jackson

10-17-2003 11:25 AM
George W. Jackson

I Need Update one table of a company This system is all in Excel with table of clients and prices of products. I like to develop a site with database...

OramaF1Net

10-17-2003 08:05 AM
OramaF1Net

Hi, I've got a query that was working fine previously. Now I'm having problems with the output. The query is below. The problem is that the...

D Andersen

10-16-2003 03:09 PM
D Andersen

I'm trying to make a field 'value' that is equal to 'cost' * 'quantity'. I'm new to databases, and this seems like it should be fairly simple. So...

Ryan

10-16-2003 03:53 AM
Ray

Hello, Does anyone know how to disable the mouse on a specific form? So users are only allowed to use keyboard controls. Thanks already for...

H.Bierhuizen

10-15-2003 10:14 AM
janthony

I print reports that get a different blurb for certain states I done this in a querie but have created a different one for each instance Blurb0:...

Swilson513

10-15-2003 04:06 AM
Ray

I am new to Access. Rather than figure this all out myself, this must have been done thousands of times. Are there are standards for how long (in...

Michael M.

10-15-2003 03:58 AM
Ray

I need to know how to make a particular textbox in a form have the Focus when I click the > button to start entering a new record. As it stands now,...

Jonathan Upright

10-13-2003 07:56 PM
Bradley

Hell all, I have created a form and a report with the same record source, "FailureAnalysis" (which is a query). The report I have created is...

Special Ed

10-10-2003 09:41 AM
Special Ed

Is there a way to only print the first page for a report? Also, if the report is grouped by person (with each person's data starting on a new page),...

Neil Ginsberg

10-10-2003 04:42 AM
Neil Ginsberg

I'm trying to select from an Access database in VB. There are 5 records in the table but this select will only return 1. I have no idea why. If I...

Kevin

10-09-2003 10:11 AM
Kevin

I am using Acess 2000, and I would like to be able to put 2-line captions on my tab controls. I have several subforms on tabbed panels with longish...

Tim Blanchard

10-09-2003 01:31 AM
Tim Blanchard

I am linking my Outlook Contacts in MS Access. Not all fields from Outlook appear ... specifically I want the Email field. Any ideas? Thanks

Snoopy Dawg

10-08-2003 09:11 PM
Bradley

Is there such a thing as Access runtime for (2000) ??? If there is where can i get it or how do i set it up???? Any help would be greatly...

Colin Graham

10-08-2003 09:08 PM
Bradley

I have a data table containing a list of orders for parts to be manufactured. There can be several orders for the same part logged into this table,...

What-a-Tool

10-08-2003 07:19 PM
What-a-Tool

Just would like to get some recommendations from the group for a POS cash register for a retail pharmacy. There are many POS solutions out there...

mike

10-08-2003 10:04 AM
mike

I have an Access database that links to a set of tables in a SQL7 database and performs updates. This works fine as long as there is an "Identity"...

Zack Sessions

10-07-2003 02:36 PM
Zack Sessions

Hi I was wondering if someone could tell me how to connect forms, reports, macros, ect... from access(97) to sql server7. I have the tables connected...

Leon

10-07-2003 02:20 PM
Leon

HI, Im new and got a few tables for a dance studio db. I wish to have on a student reg form, a drop down box that lists (vertically) ~ 13...

jal

10-07-2003 01:30 PM
laj

Dear all I have created a simple database (access 2000) with the addition of VB code to make it more usable. This morning I have double-clicked...

Davina

10-07-2003 07:31 AM
Davina

Please advise me if a convention exists for how to set up the fields for the street address part of a mailing labels database: Should the street...

Dana

10-06-2003 12:02 PM
Ray

ACCESS 97 When I want to add a property to a newly created table I get the error: "Object or With variable not set" Any suggestions on what is...

jansb000

10-06-2003 11:59 AM
Ray

Sorry to be s bore, but I recently rebuilt my wife's puter to p4 with 768 mb ram, ya-da-ya. I finally found her Office 97 cd, and loaded it Now,...

Dick Kerrigan

10-06-2003 01:23 AM
Bradley

Hello, everyone. I have a challenge that I just can't figure out. I engrave personalized ID bracelets. The form is submitted to MSaccess via my...

JerryScary

10-05-2003 03:52 PM
jansb000

I have MDE file. When I open it with MS Access - it closes. How can I extract tables from MDE file?

Andrey Kuzik

10-05-2003 10:05 AM
Bruce Rusk

Is your complete source for professional administrative assistance. We are your very own personal virtual assistants. With just the touch of a...

Typing4Less Services

10-04-2003 08:59 PM
Typing4Less Services

Greetings: Is it possible to write a query which allows the user to specify multiple criteria for the records to be returned? What I mean is, say I...

Matthew Braumiller

10-04-2003 12:07 PM
Ira Solomon

I Have 2 tables. tblOrders contains all open and closed orders: Product - Part - Part Variant - Quantity of Order tblPartialCompletions contains a...

What-a-Tool

10-03-2003 07:06 PM
What-a-Tool

Hello All, I have a listbox in a form which I want the ability to have the user double click an item in the listbox and then open another form. The...

Nick

10-03-2003 08:01 AM
Nick

I have a low-tech client with Access 97. I have a series of update SQL statements I would like to send to them. In other RDBMS I can run a series of...

Andy B

10-02-2003 04:23 PM
Andy B

I need to create a database that will do a check for data entry. Data are entered 2x, by two different research assistants and I want to compare...

Marc

10-02-2003 11:16 AM
Marc

Greetings again: The databade we are using at the office here has an Access 2002 front end (client) on each user's work station. The data tables are...

Matthew Braumiller

10-02-2003 11:13 AM
Gary Floam

Is there a way to either create a website act like an access application or can you redirect someone with something like a hyperlink to an...

mike

10-01-2003 07:48 PM
Andy B

Is there any way to generate relationship diagrams with the primary key in bold using Microsoft Access 2000?

Paul S

10-01-2003 06:28 PM
Paul S

I hope someone can help me get this graph outputing in proper order. After help from Tom, I got a graph to display output from the previous 12 months...

Jeff Blee

10-01-2003 06:20 PM
Bob Quintal

Hi I have an access table containing a number of fields the primary key of which is an autonumber field. i also have another table of exactly the...

paul

10-01-2003 11:55 AM
paul

Hi, I have an Access database and I want to populate a memo/text field with a string of values retrieved from the database based upon a particular...

Emmett Power

10-01-2003 05:14 AM
Sidney Linkers

I have been recently re-acquaint myself with ACCESS, I used access from 1995 to 1998. I had developed a large database I was really young and lacked...

rockstar

10-01-2003 01:27 AM
rockstar

Does anyone know whether the ADT is still sold and/or supported by Microsoft for versions 8.0 and above, ie, Access 97, 2002, XP? I'd like to...

Michael Rosadino

09-30-2003 12:38 PM
Rack&Stack

Help, I was using the secure database wizard. It installed a WIG on my database, then I lost the file and password. I have a large database that I...

BigRedinHawaii

09-30-2003 12:35 PM
Rack&Stack

I'm going to buy a database tool in order to make a database of my clients. The database should contain about 50 informations about 7000 clients and...

susanne

09-29-2003 10:36 AM
tom

I've got a database and there are tables for every year starting with 2000. In a form, I have set a combo box to read from the mysysobjects table,...

Brian Ashley

09-29-2003 10:09 AM
Brian Ashley

Hi, i am trying to select get data to go into a field when the user selects data from a dropdown. for example Table 1: Name Address Joe...

Badger

09-29-2003 09:57 AM
Brian Ashley