Is there a way, either within Access 2002, or with a third party tool, or even some code on the internet, to generate the SQL statements that would...

Marc DVer

08-11-2004 02:46 PM
Marc DVer

Hi, I'm running Access '03, SQL SERVER 2k on Windows XP SP1. I've not got a ton of experience in writing UDF's for t-sql. In SQL Query Analyzer,...

Dave

08-10-2004 11:18 AM
Dave

Hello Using MS Access 2000, when I open the famous Northwind sample database, the data type "Database" is available in Visual Basic...

Mark

08-10-2004 01:23 AM
Carol and Doug Hutcheson

Dear All, How to count the number of records per page per report? (I am using Access 2000). Thank you very much. Arthur Cheung

Arthur Cheung

08-10-2004 01:18 AM
Carol and Doug Hutcheson

I'd like to save the current record only with "enter" and noch with "shift-enter" (default). Has anyone an idea ? Thanks, Klaudia

lemming

08-08-2004 09:26 AM
iuliegriffiths@ihug.co.nz

I have a form having five textbox controls txt_1..txt_5. The data that I want to assign to these controls are located in an excell sheet at A1..A5....

Ramesh Kumar Bhandari

08-07-2004 11:31 AM
Ramesh Kumar Bhandari

Can anyone help me .. Is it possible to connect my JSP page to a MS Access table.. I heard we need a JDBC driver to do this.. So.. how can I set up...

Hussein b. Mohamed

08-06-2004 02:40 AM
Hussein b. Mohamed

im Access wird der aktuelle DS ja durch "Umschalt+Eingabe" gespeichert. Kann man irgendwo definieren, dass dies nur durch "Eingabe" passieren soll...

lemming

08-05-2004 02:25 PM
James Fortune

I am trying to compare some dates in a form, to the current date. Here are some fields in my form: DocOwnerRevDate - Document Owner Review...

Jonathan Pinto

08-05-2004 10:59 AM
Ramesh Kumar Bhandari

Hello everyone, Any help on this matter would be greatly appreciated. I've written a Time clock program for my employer which uses an access 2000...

Frank V.

08-04-2004 09:43 PM
Frank V.

Good morning, I have a client with an Access 2002 database that is giving an Error 3197 upon open (The Microsoft Jet database engine stopped the...

Brian

08-03-2004 07:19 AM
Brian

Hi :) I got this little problem - i put a web browser control (IE 6) in my Access 2003 form and no matter how big that control is - it...

Alexey

08-02-2004 02:45 AM
Alexey

I have an Access 2002 db that uses the NPer function to calculate remaining periods for an amortization function. The NPer function works fine,...

Mr. TwolvesGeek

07-30-2004 03:10 PM
Mr. TwolvesGeek

Pretty simple situation, but what seems like it should work doesn't. I have a subform that is a continuous list, and I need to set one of...

Andrew Backer

07-30-2004 01:54 AM
Andrew Backer

I am using Access 2000. I have a form which when opened does the following: 1. Gets the currently logged on Windows users code 2. Sets that user to...

Trevor Hughes

07-29-2004 05:05 AM
Trevor Hughes

Hello All. I am having issues with the visualbasic gramatic for the following scenario: I am retrieving information from an Access 2000 Database....

JPRW

07-28-2004 11:37 PM
Walt White

Hello. I am a relatively new programmer to Access... appreciate any assistance you can provide on my problem. I have a large database (containing...

TJW

07-28-2004 02:30 PM
TJW

I was hoping someone could provide some guidance as how I can link a Foxpro 2.6 table to MS Access using the Visual Foxpro Driver (only driver...

Bill D.

07-28-2004 08:47 AM
Bill D.

Hallo Group, wie finde/bekomme/erwerbe ich denn eine (gefüllte) aktuelle ISBN Datenbank? Danke im Vorraus Thomas

Thomas

07-25-2004 03:32 PM
Thomas

All, Is there such a function that can strip all non alpha ( not between a-z) characters from a string? I have a function that I currently use that...

Mark C

07-24-2004 08:18 PM
Randy Harris

I am trying to make a database for tracking calls, the caller gets one free call (per 12 months), then is charged a flat fee for every call after...

Trey

07-23-2004 12:34 PM
Trey

tblFoo FooId Name Number 1 One 1 2 Two 2 3 Three 3 The Following query produces the results I want, but it is...

GD

07-21-2004 08:15 PM
Rob Parker

I need to create an IIf function. I have a field called "BREED". There are only two types that can go in this field, either "Siamese" or "OSH". In...

Julie Nicole

07-21-2004 07:58 PM
Ray

My question concerns the use of a shop-management program called, "JobBOSS," in a Novell NetWare environment. First, the background. We are...

Wayne Mathews

07-21-2004 02:38 PM
Wayne Mathews

My question concerns the use of a shop-management program called, "JobBOSS," in a Novell NetWare environment. First, the background. We are...

Wayne Mathews

07-21-2004 02:37 PM
Wayne Mathews

Hi, This is a basic question, but Access' online help is NO help. I want to run an append query like the following: DoCmd.OpenQuery "Append_New",...

darstar

07-20-2004 07:52 PM
darstar

I have 3 tables: tblFaculty | tblDegrees | tblFacultyDegrees FacultyID Auto# Key | Degrees Text Key | ID ...

enjayare

07-20-2004 02:22 PM
King Ron

I have been hitting my head against a wall on this one. I have several reports that I convert to pdf and combine. I am looking for a way to have...

Jamie Templin

07-20-2004 01:55 PM
King Ron

I have a subform based on a query. I use a dropdown list to pull up records on the main form. I would like to have the subform/query requery each...

Fbradley

07-20-2004 01:44 PM
King Ron

Dear Eric. Try the following: (I have not used your field names as you will need to substitute the appropriate fields. You will need to use...

Peter Flick

07-19-2004 08:24 AM
Peter Flick

HI All, I need help trying to accomplish the following: I have three tables: tblClients, tblWork Descriptions, and tblClientWorkDescriptions. I'm...

Michael J. Savage

07-19-2004 07:59 AM
Michael J. Savage

Hi All, I am trying to embed one or more excel spreadsheet into my database. I want to do this be say, clicking a button on a form and selecting...

PJ

07-16-2004 03:18 PM
PJ

Hi I am now sitting for almost ages in front of the screen, and may be someone can help me... Here's the thing I have a table that looks like the...

Stefan

07-13-2004 12:51 PM
Ray

Hi There! I have a distributed Access 2000 app in which I show the user their data on a form and allow them to apply any sorting as they see...

hoytnancy

07-13-2004 10:38 AM
hoytnancy

Are there any utilities that will monitor the resources that Access uses while running? I am exceeding one of my resource limits.

Paul Sieloff

07-12-2004 08:45 PM
Paul Sieloff

Table accountNo PK subType subType domain is (a,b,c,d,e). Customers can have a subscription of any combination of types. I want to find all those...

Simon Long

07-12-2004 08:37 PM
Ray

I have a database application with a front-end containing links to tables in a back-end database. I like this development model because the...

Mike Easter

07-12-2004 05:13 PM
Mike Easter

OK - need some help here, newbie, haven't done this before and reaching a deadline really quickly!! Would like to do the following: In my main...

Renee

07-12-2004 12:04 PM
Renee

I have a continuous form of records (about 4000) that get selected and gets processed. Each record is processed with a call to a local Private...

Paul Sieloff

07-12-2004 10:26 AM
Paul Sieloff

I volunteered to do a small Access project for a friend based on my experience writing an appln. with Access many years ago. It has been a struggle...

Bill Hunt

07-12-2004 06:24 AM
Bill Hunt

All, I have used Excel automation many times in the past without error until now. My machine has both Access 97 and XP installed but this code is...

Mark C

07-11-2004 11:48 PM
Mark C

Hello everyone, I have a database with the following fields: Name Control # Balance Date Posted and more fields

07-11-2004 08:39 PM

Hi All, Sorry, I still need some help with this...I can't for the life of me figure out how to do this: I need to use the field InvoiceNumber (the...

Michael J. Savage

07-11-2004 11:45 AM
Michael J. Savage

OK so I'm making a database where the main entities are Models and Assignments. I've made tables for each and now I am making a form for "new...

trudy

07-10-2004 03:25 AM
Phivos Zomenis

I've used PictureBox controls with Access 2000 and Visual Basic 6.0, but I can't seem to find it in the toolbox that comes with Access 97. Does...

LongDistanceRunner

07-09-2004 04:10 PM
LongDistanceRunner

I'm sure it's simple but.... Have a mainform / subform subform defaults to form view. Want a toggle button on mainform to toggle subform from...

wdgriggs

07-09-2004 11:26 AM
wdgriggs

I have a table with a hyperlink field that I display on a form. I can click on the form field and the hyperlink activates correctly. However, if I...

Tim

07-09-2004 08:24 AM
Tim

I need to create a table by importing from a .csv file. The only problem is I need to create a primary key ID using autonumber, and this cannot be...

CefiroZ

07-08-2004 11:40 AM
Ray

In Access 2000, can anyone enlighten a beginner with how to make a date field in a table auto update evertime another field is updated? In this case...

Mike

07-08-2004 11:33 AM
Ray

Hi, I have a database with 380 records which are numbered from 0 to 380. I would like that record no. 15 should get the number 68! or 391. means...

Michael Schrading

07-07-2004 05:16 PM
Michael Schrading