I want to create a MsgBox that when (checked) will not open again and annoy the User Can i have help with this please. I am trying to write code for...

DD

11-09-2003 01:30 AM
John

I have a table and a form with about 100 zip codes and their corresponding cities. I have another table and form that will contain each person's...

djm

11-08-2003 10:56 PM
DD

I'm trying to make a macro to print the current record. Can anyone help me with this. I need to know how to setup the filter. Thanks

Brian

11-08-2003 01:05 PM
DGCahill

Friends, I am using VB 6.0 and MS Access 2000 for a small program. I found that some data which has been inserted latest can be found in...

AR John

11-08-2003 02:30 AM
AR John

I am trying to specify a range of dates in a query. I have tried using Between "12/01/1938" and 05/31/1939", but I don't get any response. ...

jca1492

11-07-2003 11:25 AM
jca1492

I would like to create a music database using the information in the MP3 ID3 tags (v1 and v2). Is it possible to capture those tags and spread them...

gilles

11-07-2003 10:31 AM
gilles

I would like to open an Access2000 database file in Visual Basic 6. When I try it tells me that the database is in the wrong format. If I convert...

Dan Shelby

11-07-2003 08:32 AM
John

I am looking to include an Access database with my application and I have one question (for now). How can I include an Access database into my VB6...

Daniel S. Bravo

11-07-2003 07:43 AM
MeadeR

Hi, I have designed a simple database using Microsoft Access 97 on a Windows XP machine. The database is basically a stock label generator. I have...

Access97

11-06-2003 11:29 PM
News

Hi all! I am somewhat new to MS Access. I created a database with customer info in it. I created a search form with a text box for typing in a...

mmi

11-06-2003 10:36 PM
mmi

I have a small local reservation database made in MS Access which I update with new reservations 3-4 times every day. I also have a webpage where...

Mattias

11-06-2003 02:29 PM
Mattias

I need to protect my database by password and I did it from tool menu of Access. But next step, I need to access this database from VB6 using ADO...

ALEX KLEIN

11-06-2003 11:03 AM
ALEX KLEIN

I do not quite understand this property. Everything is clear to me, when I read the corresponding help text. But in practice I have a question: Why...

Beat Scheidiger

11-06-2003 09:08 AM
Beat Scheidiger

How do you create a report in design view in Microsoft Access? I find it highly confusing. Does any one know of any good tutorials online?

Becca

11-06-2003 04:51 AM
Becca

In Access 2000 and 2002, I have created an import specification to import the fixed-width recordset below into an existing table. I am having...

mark

11-05-2003 11:07 PM
John

Hello all. I'm not very familiar with Access; my DB experience is primarily in FileMaker Pro. I'm doing a learning by doing experiment before I...

Ben

11-05-2003 10:36 PM
John

I defined a table with a primary key as AutoNumber. Now I insert a row - is there a way to know the primary key value that will be created without...

Zalek Bloom

11-05-2003 10:31 PM
John

Can anyone tell me how to set up printing a report which will print 2 pages per sheet in landscape. I have grouped section which forces a page...

mickel

11-05-2003 10:26 PM
John

Need to sort months like jan, feb and march. My results shows feb,jan, and march using a query. please advise. What expression or how should I...

neo

11-05-2003 10:23 PM
John

1.How could I sort months like Jan, Feb, and March, etc.In the query it shows Feb, Jan, and March. 2. From another query I need to sum total hours...

neo

11-05-2003 10:22 PM
John

Download the free super software searcher ebook absolutely free. It will link you to thousands of downloads including software,...

Richard Whittingham

11-05-2003 05:13 PM
Richard Whittingham

Hello All: I have spent too many hours trying to resolve this prob. I have a table that has 15 Y/N fields. I want to form-drive a query that will...

RJM

11-05-2003 09:20 AM
Allan Thompson

Hi All, I get the following error on a application which was running well for 4 years. The error happens few times a...

Ash

11-04-2003 04:15 PM
Ash

Hi, I have an application written in Access 97. The front-end and back-end are separated into two .mde files. I still have the original .mdb...

pieter

11-04-2003 12:44 PM
Bruce M. Thompson

I have brand new ML 570 700 xeon server for sale. comes with 6 72.8 hard drives, 2 g memory, and auto 8 tape backup. I have more add-ons if...

Brian

11-03-2003 07:54 PM
Brian

I have imported records with email info into a table with a hyperlink field. I then ran an update query to add the "mailto:" text to every e-mail...

McLean

11-02-2003 04:48 PM
Bradley

I hope I'm not trying to do something untoward. I am developing a small DB that has an entity, say Universities, each of which has a many to many...

Michael M.

11-01-2003 10:43 AM
Ira Solomon

I have a date field in a form that I'm using that I want to automatically update to the current date anytime I change any information in that...

sjboyd81

10-31-2003 03:23 PM
janthony

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

10-31-2003 10:58 AM
BlueDolphin

I am just wondering if there is any way that Microsoft Access in any version can be used by a Mac user. I work at a publishing/printing company. ...

M

10-31-2003 08:03 AM
Scott McDaniel

Access 2000: I creating a report that has a record source built by the user who selects the WHERE values. An example is: SELECT * FROM CHARGELOG...

mark

10-30-2003 09:13 AM
MeadeR

Hi I'm wanting to connect to an Access MDB file using ActiveX from an OpenRoad program. Can someone tell me what files I need to use/register in...

Darren Harvey

10-29-2003 06:45 PM
Darren Harvey

Here's the scene; I call up a data input form from a switchboard form. I'll be working on the form and receive an e-mail notification so I click on...

Rick Kowalski

10-29-2003 04:09 PM
Rick Kowalski

Hello, I have to Update all fields from a table with the values of a related table, i've tried some querys i found on the internet, but nothing...

Fons Roelandt

10-29-2003 01:27 PM
MeadeR

Hi Everyone, in access XP, is there any possibilities to create subform on a form's subform or make parent-child relation between two subform?

Hivessy Ákos

10-29-2003 07:46 AM
Hivessy Ákos

Hello, I have created a database that is used by many users in over 30 offices in the world. Suddently I have been informed of a problem that I...

Paolo

10-28-2003 03:18 PM
John

hi , somebody help me with this little bit of calculation in access , am not able to work out . i have 4 fields on a form , its like this , TOTAL...

Lancer

10-28-2003 02:20 PM
Lancer

I'm a bit of an Access newbie, so bear with me. I have a database I've created with a query that calculates the date of next service based on a...

TechJosh

10-28-2003 04:33 AM
John

I have a report, that can have any number of records that will print in the detail section, and a total in the detail footer. Is there any way, to...

janthony

10-28-2003 04:30 AM
John

Hello, How do I determine the modified date on an input file? Thanks, Mike

mharness

10-28-2003 04:28 AM
John

Hi all, I have taken over a progam from an ex collegue. When I convert a access'97 database to access 2000 or 2002 then I get on a update of a query...

Karel Koll

10-28-2003 01:45 AM
John

DoCmd.DeleteObject acTable, "tblName" will delete the table. if you want to save the structure but delete the records use SQL: DELETE * FROM...

John

10-28-2003 01:42 AM
John

ok im kind of new to this program so forgive me if i sound stupid, hehe i am making a medical record database that has pull down fields....

RICHARD MALLIA

10-28-2003 01:37 AM
John

I have the zip codes from the USPS in an Access 2000 database available for immediate download for $2.50 via PayPal. ...

Tarheel

10-25-2003 01:43 PM
Tarheel

Have a query which shows all fields from two tables. One table is much shorter than the other, so several field values are Null values. I would like...

What-a-Tool

10-25-2003 09:58 AM
What-a-Tool

hope you can help. I need to get my access db backend to sql2000. I have tried the upsizing wizard but the get message "overflow" and cannot get any...

Mark Worrell

10-24-2003 12:06 AM
MeadeR

Help, please. I've got a bound form but the OnDirty event won't fire whenever I change a text field. I can't get it fire at all. TIA, Jerry

Jerry Merz

10-23-2003 04:22 PM
Jerry Merz

I have a checkbox field called Active, with a yes/no check for whether a customer is active. Is there a way that I can keep using a checkbox, but...

Andrew

10-22-2003 06:17 PM
Jack Stockton

How do I combine data from two fields into one field? Specifically, I have two fields for LastName and FirstName and a field for FullName. When new...

Andrew

10-22-2003 05:59 PM
Jack Stockton

All my number data in Access 2003 automatically rounds to the nearest interger, even when I request a 2 decimal place format. Is this a known bug and...

Avery

10-22-2003 05:03 PM
MikeB