I have been trying for nearly 2 weeks to find the answer, I hope someone can help me. Sorry it is so long, but want to give you as much info as...

Ed

09-05-2003 01:21 AM
tom

I have a strange issue, I have a number of tables linked to an informix database. The queries have been working just fine for quite a while,...

Mark Roach

09-05-2003 01:05 AM
tom

Good day, I have: 1) A table with numbered fields (1, 2, 3, etc.) 2) A form text box, whose ControlSource property contains an expression. This...

Shelli Carol

09-05-2003 12:56 AM
tom

Open up the front end of your database app. When you get the error saying that the path for the database is not valid just click OK. Next, go up to...

Kelly Cromwell

09-04-2003 05:31 PM
John

I have an Access 97 db linked through ODBC to an Oracle 7.3 db. The users seelect data found in a list box and perform various functions on the...

April

09-04-2003 05:17 PM
April

Hi eddiec Have you tried to get the database main window, pressing F11? Maybe it works and you can finally see the...

Marcos

09-04-2003 07:17 AM
Marcos

I am looking for some help with data access pages. I am using them for the first time and I cannot get the dropdown list to work properly. I...

JE Madison

09-03-2003 11:20 PM
JE Madison

Hi, Bradley That sounds like a great solution, but....when I look at my Outlook Inbox, I see no option to attach an Access table to it. How is this...

janthony

09-03-2003 06:19 PM
Bradley

Your dialect of SQL is recognized by Access, but is not standard for access. i'm not sure how you do an Outer Join this way, but the Access standard...

tom

09-03-2003 03:58 PM
tom

Hi, I wanted to use a Text Area in my VBA form.I just want the MS form objects to appera in my toolbar so i can use them. If i take the references...

mickykt

09-03-2003 03:21 PM
tom

The second paragraph of the code below is from the Help of Access 2002. I don't know how to declare the variable MyObj. Please help. Dim MyObj As...

Nigel Root

09-03-2003 01:56 PM
MikeB

Hello, Apparently the problem was with my default form. I changed it to "normal" and could immediately create a new form. Mike "mharness"...

mharness

09-02-2003 08:30 AM
mharness

Hello All, does anybody have a nice idea how to drag a selected date from Calendar10 control to a textbox. I think drag drop is a genral problem in...

KemperR

09-02-2003 05:52 AM
KemperR

Hello Experts, I have the following situation: ACCESS 2002 Client DB with linked tables to BE_DB holding all tables and a lot of code. In the BE_DB...

KemperR

09-02-2003 05:48 AM
KemperR

I am currently attempting to send a report using the wizard to create an e-mail button. My report looks fine and prints fine, however, when I e-mail...

Hathcock

09-02-2003 12:29 AM
Bradley

Anybody had this problem? When I compile my code (Access 2002), the compiler stops with the error message "User-defined type not defined"' but there...

Jay

09-02-2003 12:18 AM
Bradley

"mahnovetsky" <mahnovetsky (AT) yahoo (DOT) com.au> wrote I found little help on it but have taught myself a lot so I may be able to help.. let me...

Bradley

09-02-2003 12:09 AM
Bradley

Hi I have a combobox on a form (This form fills a table called Contacts) which gets its info (a list of suburbs) from a table called PostCodes. This...

The Roys

09-01-2003 11:52 PM
Bradley

I am initial on ACCESS and I try to put my access project on Cd to install it automatically on other computers. ANd if this computer don't have...

Lino

09-01-2003 11:38 PM
Bradley

Got an easy one for you. On the table design view, how do you make one of the fields a link that holds an email address so when you click on it,...

Curt

09-01-2003 11:36 PM
Bradley

I am trying to create ledger report with an account name and then detail amounts listed underneath. If there are only a few details the next account...

Laura Wilson

09-01-2003 12:43 PM
Laura Wilson

First, thank you for replies to last post, i havent gotten back sooner, i apologize..but they have helped me tremendously. Next question and i will...

Susan

08-29-2003 08:04 PM
Domster

HI, I have a Access 2002 database with embedded graphics made in Corel 6. I now have Corel 11, and when I double click on the graphics to edit it, I...

DRW

08-29-2003 04:16 PM
DRW

John, here are a couple of things that you can try: 1. Compact your program if you have not done so already. 2. Decompile your program. You may...

Terri

08-28-2003 08:00 AM
Terri

I've upgraded my OS from Windows 2000 to Windows XP. Since the upgrade, my progress bar works for about 80% of the program and then stops updating....

Terri

08-27-2003 09:36 PM
Terri

I am using ACCESS 2002 on Win XP. I want to automate exporting a query to EXCEL. When I run the query and then File -> EXPORT, I want the EXPORT...

bc

08-27-2003 05:19 PM
bc

It seem I have to close a Query/Form and then reopen it to get it to reflect changes in underlying tables. Is there a less combersome way?

me

08-27-2003 08:26 AM
Ray

Such a simple and elegant solution. Also, I learned a new command in Access. Thank you very much! Terri

Terri

08-26-2003 08:17 PM
Terri

Hi I would like to add a listbox to my form in ACCESS. I want to use the listbox.Additem property,But i realise that i can only use this if i am...

mickykt

08-25-2003 11:21 PM
mickykt

Hi I am running a crosstab query using a range of dates as the column heading, product name as row headings and a summation of purchase earnings as...

jbachich

08-24-2003 05:14 AM
Marc

I have set up my switchboard form to access another form that I have set in properties to 'datasheet' view only. If I open the form normally, it...

jbmic

08-24-2003 04:09 AM
Marc

RE/ Seems to me like there's a setting somewhere that tells what macro to execute on startup. Just checked Tools/Startup and didn't see it...

(Pete Cresswell)

08-24-2003 12:16 AM
Pieter Linden

I'm starting off Access with the classic 'Name and address' exercise. The first field is 'Family name or organisation' because a person...

Nigel Root

08-24-2003 12:14 AM
Pieter Linden

Ira Solomon <isolomon (AT) solomonltd (DOT) com> wrote Ira, I think ADO is a red herring here. If you're playing with properties, an object may or...

Pieter Linden

08-24-2003 12:12 AM
Pieter Linden

d_schultz64 (AT) hotmail (DOT) com (Dan) wrote in message news:<326716af.0308181720.40634f88 (AT) posting (DOT) google.com>... Dan, help everyone...

Pieter Linden

08-24-2003 12:05 AM
Pieter Linden

Hi, everyone I'm wondering if anyone knows a relatively simple way to set up a button or buttons to toggle allowing form editing on or off. I want...

LWD

08-23-2003 09:31 PM
Marc

Hi All I have a problem with merging with access (or excel) that's doing my head in, and I'm sure that it should be able to be done. I have a list...

Moggle

08-23-2003 07:02 PM
Pieter Linden

Hi, I've been having problems trying to write vba code that will add records to tables in my database. I only want the tables to be added to no...

caroline

08-23-2003 06:57 PM
Pieter Linden

Hello everyone, Does anyone know how to get rid of the "Visual SourceSafe is not installed" message when I open a code module? I don't want to use...

Tom marsh

08-23-2003 10:44 AM
Tom marsh

I'm starting to switch all of my code over to ADO but read something the other day that has gotten me thinking so I wanted other opinions. I read...

Terri

08-22-2003 02:42 PM
r0adh0g

This is very basic, but here goes, from a form, I want to pass parameters to a query to open another form (form by query?). Using a combo box to...

Don Trieschman

08-22-2003 01:14 PM
Don Trieschman

got an email on the first question and its fixed... still need 2nd one though, please "simsghost" <simsghost (AT) hotmail (DOT) com> wrote

simsghost

08-22-2003 10:44 AM
bala

hi scott u can do it why using group by clause. thanx and take care regards bala

bala

08-22-2003 10:39 AM
bala

I'm having difficulty transferring data entered in forms into the relevant tables of my database. For reasons I'm not going into here I am trying to...

caroline

08-22-2003 09:54 AM
caroline

Hi, Could anybody send me or post in the newsgroup the whole list of keywords used in MS Access.? thank you, Den.

Den

08-22-2003 08:35 AM
Den

How can I combine two records and all its fields in Access? For example if I have a part number that got replaced with a new part number. I need to...

JCA

08-22-2003 01:09 AM
LWD

With a many to many, you can handle the data entry for your junction table like this: Create a form that updates the junction table. The field that...

me

08-20-2003 06:12 PM
me

use an embedded SQL statement and the IN keyword, i.e., SELECT * FROM Table WHERE sal IN (SELECT . FROM ). this will get everything from the first...

tom

08-20-2003 12:35 AM
tom

Hi, Our company uses an application called "Prolaw" which has a SyBase backend database. Since its reporting system is quite weak, I've...

Oren

08-20-2003 12:27 AM
Matthew Reeves

I am using the "product orders" template off page 3 of the Microsoft site. This template works great except one thing. I am in Canada, and...

simsghost

08-19-2003 05:23 AM
Paolo