I was handed a database with the following fields: client name, client birthday, spouse name, and spouse birthday. I was asked to get a report...

cdasteve

01-16-2004 07:42 PM
cdasteve

Can someone tell me a way to give sequential numbers for use in records in queries or in reports? For reports, one could probably build some code in...

Bruce Pick

01-16-2004 11:51 AM
Bruce Pick

Hi I have report which is a reminder leter most of the text is constant but there is one detail line in which lines can be 4 or 5 or anthing. when...

marifusman

01-16-2004 10:10 AM
Amber S.

Does anyone know how to concatenate a string in Excel vb which opens a database with a workgroup switch. Sub...

Rene Montes

01-16-2004 09:24 AM
Rene Montes

I am having a problem with primary keys. I have a main table called Transactions. It's primary key is made up of three fields (date, account,...

delores h.

01-15-2004 10:38 PM
Felovala

Hi, Any help with this would be appreciated. (Access2000) I have a form with command buttons linked to another form which when clicked creates a...

Twysted

01-15-2004 07:29 PM
Twysted

I have a database that will be using 2 forms to collect data (A & B). On form B 4 dates will be entered. I would like those 4 dates...

Mark Lees

01-15-2004 09:53 AM
Amber S.

Is there a way to send one email with multiple reports attached to it? I don't really care what statement I use (does not have to be sendobject) but...

Amber S.

01-15-2004 09:34 AM
Amber S.

Where can I find examples of calendars that I can have in my database, but no ActiveX controls (such as Calendar Control). Thanks. -Mark

Mark S.

01-15-2004 05:30 AM
Paul Welland

You want that user can select various options based on 1.departments, 2.wards, 3.staffgroup 4. etc and then 5.print the report whatever he has...

Paul Welland

01-15-2004 05:23 AM
Paul Welland

I don't know why the detail section of MS Access report has been repeated multiple times if the number of records return by the query is too large. ...

Yi

01-14-2004 11:35 PM
Bruce Pick

I have a bunch of queries that run in a macro, which can take hours, sometimes, to run. Is there any way I can have the name of the currently...

hedrew3

01-14-2004 10:00 PM
Bruce Pick

guppy1490 (AT) yahoo (DOT) com (guppy) wrote in message news:<1cbcb218.0401082104.65852777 (AT) posting (DOT) google.com>... I need a way to...

guppy

01-14-2004 01:51 PM
guppy

I want a field in my form for a client database that will help me keep track of the last time a clients data was updated. The best I can do so far is...

Ibizar

01-13-2004 10:26 PM
Ibizar

Has anyone ever linked a front end Access application to LDAP? I have a client who is interested in doing this with one of his applications. I've...

Terri

01-13-2004 06:37 PM
Terri

Hi! I'm having some trouble controlling how the XP Packaging Wizard installs my applications. In 97, there were options to replace older, never or...

RWC

01-12-2004 08:57 PM
RWC

I need help modifying an existing access 2002 database. I also need to transport data from are current Q&A database email, brian (AT) ahoffmanawning...

TY

01-12-2004 12:28 PM
TY

Hello, first, sorry if I'm not clear because english is not my primary language. I created a WEB file with FrontPage and I find out how to get the...

Jiador

01-12-2004 11:02 AM
Jiador

Looking for help with modifying an existing 2002 database Would like someone local to the Baltimore area Primary concerns are 1) Transporting data...

TY

01-12-2004 10:31 AM
TY

I am having a problem with primary keys. I have a main table called Transactions. It's primary key is made up of three fields (date, account,...

delores h.

01-11-2004 12:12 PM
Ira Solomon

Is it possible to create a macro that will open 7 reports at once and automatically export the results of each report into Excel? Can the results be...

Makuhari1998

01-11-2004 12:01 PM
Ira Solomon

Hello, I'm trying to do some updates on the fly in a remote database. I'd like to do this with code. I'm running basically the following...

RWC

01-10-2004 06:17 PM
RWC

Hi All, I need your suggestions: I have a software that uses MS Access as a front end, and has MS SQL as a back end database. SQL Server is running...

Nauman

01-09-2004 11:32 PM
Bruce Pick

The List Box control in Access 2003 seems to be malfunctioning. When a row source generates a list that that is too long to be displayed in the List...

Primer

01-09-2004 11:03 AM
Primer

Hi, after i use SQL select to select a row of record, how can i capture each value and assign it to variable ? Thanks. Regards, Daniel

Daniel Tan

01-09-2004 03:31 AM
Daniel Tan

Hello everyone, I've been checking archives on this group for hours and haven't found it yet. What I want to do seems simple, I'm sure I'm...

pinballjim

01-08-2004 10:49 AM
pinballjim

Hi, I transfer a access (.mdb) to SQL server (adp). I wrote a procedure but it is not possible to call up it. The system renamed this procedure as:...

Paja

01-08-2004 05:06 AM
Paja

I have a fairly complex Microsoft Access 2000 database that uses lots of VB Code. In the VB code, I had been creating a Database (DB) object and...

VBJonC

01-07-2004 04:06 PM
VBJonC

I am new to SQL and I am hoping this group can help me. While I'm not using MS Access, I am using Jet and the Microsoft Text Driver through ODBC,...

pillbug

01-07-2004 10:36 AM
pillbug

I have SQL delete that generate an error : Microsoft engine cannot find input tabel or query "false". Make sure it exists and name spelled...

Daniel Tan

01-06-2004 10:45 PM
Daniel Tan

I have a form with two fields. In the 1st field the user can select from six options in a lookup table. However each of the six options has between...

JustCurious

01-06-2004 07:25 PM
Andy

I have tried everything I know how to accomplish this. I have a column in my database defined as OLE OBJECT. My form frame control is NOT bound to...

Scott

01-06-2004 01:52 PM
Scott

Greetings. I have a problem with a combo box incorrectly displaying blank items when returning to a form from a modal form. It's fine when the main...

will eichert

01-05-2004 06:01 PM
will eichert

Dear All, I have hospital payroll dept file in excel which has data directorate, departments, wards , grade , budget etc. This file has alot of...

Neha

01-05-2004 03:50 PM
Neha

I have a Table which contains: a field (Date Format) and a field (General Number-ie 1, for hour one) It also has a number field called and a...

Surnom

01-04-2004 09:30 PM
Surnom

I'm using the following code in a validation rule on a form. <(DlookUp("ProductSRP", "tblProducts", "ProductID =" & !!.! & "")) *1.201 This should...

fred

01-02-2004 09:55 PM
Ira Solomon

I am new to Access and have one small problem I can't seem to solve. I have a database with multiple order records for people. Each person has a...

LarryH

01-02-2004 11:41 AM
Ira Solomon

Any help please.I would like for a field to come up in my database in relation to the date i enter but i would like the day field to show the day of...

Grahame

01-01-2004 11:36 AM
Ira Solomon

Hello, I'm trying to add fields to a form, but have exceeded the maximum number of fields allotted for a table (250 fields). So I though I would...

Dan CFC

01-01-2004 11:20 AM
Ira Solomon

I have a rather simple form that's using IME for Japanese conversion. The field in question, is set to disable IME to allow a standard numerical date...

fred

12-30-2003 02:33 PM
fred

Would like to copy the value of a field in the previous record to a different field in the current record during data entry. Also, is it possible to...

Surnom

12-29-2003 05:32 PM
Surnom

I have designed a database in Access 2000 for muliple users within our own intranet enviroment. Most of the users of the database use it...

M

12-29-2003 01:44 PM
M

Hi ! Im developing a contact management software in accesss 2000. I have been trying this for long but no success. I want to extract records from a...

Pragati

12-29-2003 12:50 PM
Scott McDaniel

( I'm running win98 and Access 2000) http://www.mvps.org/access/modules/mdl0004.htm still looks like what I want to use and I've done - "You need...

Michael Slade

12-28-2003 10:41 AM
Michael Slade

Hi Using Dev Ashish's code from a previous email I have been able to successfully export output from a query to an EXCEL spreadsheet however the all...

Laurie

12-28-2003 12:01 AM
Laurie

does anyone know of a freeware or shareware utility that will convert XML files to Access (MDB)? is there any programming involved in conversion?

Northern Light

12-26-2003 02:22 PM
Northern Light

I have a master db and a HR db. While in the HR db, by the click of a button I would like the following to be automated: 1) Create a copy of master,...

Amber S.

12-26-2003 01:42 PM
Amber S.

I have two columns, one is Grant Award, the other is Project Status. The Project Status could be complete, active, or withdrawn. At the bottom of...

Cher

12-25-2003 05:50 PM
Scott McDaniel

Hello All, What's the report counterpart to Forms!..Form.RecordsetClone. I've tried all the obvious stuff and so far nothing works. I'm trying to...

mharness

12-24-2003 03:35 PM
mharness

Could someone please offer me some help on this: I am new to Access and trying to figure out how to automate data import from a science software. ...

Dan

12-24-2003 03:30 PM
mharness