My client insists that the printed copy of text entered into a memo field have EXACTLY the same layout as it appears on the screen. I found I had to...

Bob Alston

02-29-2008 04:35 PM
Salad

Thanks Fred! Actually, yes, the query is tied to other reports and queries. I want to build the form so someone can change the various criteria on...

Menelomie

02-29-2008 04:12 PM
Menelomie

Why can't I write to a field name 2ndItemNumber with rs!2ndItemNumber = st2nd. When I type that in I get a message expected end of statement and...

Cyberwolf

02-29-2008 03:17 PM
Arch

I have a new client who has an Access 2000 database that used to run under Windows 2000 Pro. They have just "upgraded" to Access 2007 under Vista,...

teddysnips@hotmail.com

02-29-2008 01:33 PM
ARC

A97 crosstab queries are limited to 255-fields. Does any later version(s) of Access support a greater number?

MLH

02-29-2008 01:16 PM
MLH

This is a repost from a couple of days ago. I didn't get any responses, and am really hitting my head on the wall with this. Even knowing that it...

eidosabi

02-29-2008 11:04 AM
lyle

Hi guys, i have a table with 12 checkboxes for different type of products, so basically user has to tick if this product applies to the...

Mike

02-29-2008 09:27 AM
Mike

Hi everyone, I am having some trouble with an SQL statement that I just cant seem to get to work. I have imported some data into MS Access from...

The Frog

02-29-2008 04:58 AM
The Frog

Hi Apologies if this is not in the right area but first time for posting here. I know how to add up amounts on a form to create a total for a...

tony.stevens5@gmail.com

02-29-2008 02:22 AM
Allen Browne

I've searched this forum and trawled the wider web and can't find any information on how to hide or disable the A2007 Quick Access Toolbar. The...

Wayne

02-29-2008 01:19 AM
Wayne

I have created a database with approximately 60 tables. One table "tblClients" needs to be linked with about 40 tables. Some are simply look up...

dgardner@twcny.rr.com

02-28-2008 10:51 PM
Tom van Stiphout

I have a table named "Services" which has a "ServicesID" field as a key, GuestID, ServicesType and another field called "Bed". When a guest stays in...

RussCRM

02-28-2008 09:24 PM
Allen Browne

Is there a way to get rid of that horrid 'ribbon' and go back to a 'normal' menu structure in '07? I'd like to continue to develop and distribute...

frogsteaks@yahoo.com

02-28-2008 08:35 PM
Larry Linson

Hello Everyone, I am new in MS Access and I was tasked to create a porject. I have done some initial things already but need help and guidance: - I...

lrheeza@gmail.com

02-28-2008 07:39 PM
Larry Linson

I added all the tables, forms, reports and cmd buttons concerning an addition to a database. I entered data for Q1 in order to produce a report but...

zufie

02-28-2008 03:09 PM
zufie

Hello I develop my applications in Access 2002. My development system is running Windows XP SP2 and I have Microsoft Office XP Developer. Microsoft...

Sebastian

02-28-2008 02:19 PM
Sebastian

Hello, I have one simple query joining two tables with left outer join on 3 fields and using MIN on two fields. These two tables have lot of...

dsdevonsomer@gmail.com

02-28-2008 02:14 PM
dsdevonsomer@gmail.com

I have created a file DSN on my PC, and am using it to provide one of the two connections required for an Access query. (The other connection uses...

Patrick A

02-28-2008 01:57 PM
Patrick A

So I have a form showing my data items with a selection tick box to indicate when an item is active. I want to save the record automatically when...

dkintheuk

02-28-2008 01:52 PM
Albert D. Kallal

TRYING TO USE SHORT NAMES might make more since. I have a main form and its tied to tblmain subform1 and it is tied to tbl1 subsubformA on subform1...

sparks

02-28-2008 12:42 PM
Salad

Typically, Microsoft Access reports have default 'Page Setup' settings, and every time you restart Access, the reports always return to the...

Dominic Vella

02-28-2008 12:25 PM
Salad

Hello everyone, My problem is updating Subform filter by onchange event in one of main form field I've got following: Me!.Form.Filter = " = "" N...

maciejfr@poczta.onet.pl

02-28-2008 12:07 PM
Salad

Dear All well i want to say that this forum is from the best access forums in the internet really ,many problems & bugs solved by this forum expert...

MrCC via AccessMonster.com

02-28-2008 10:40 AM
MrCC via AccessMonster.com

Hello, I have many applications (DOTNET. Connected using OleDB) that all write data to the same table in a Access database file. But sometimes I...

palm.kevin@gmail.com

02-28-2008 08:30 AM
Dominic Vella

Hi - I have been asked to change a combo box display to sort in alphabetical order. This is in an app I did not write, but it should be simple...

sara

02-28-2008 07:30 AM
sara

I use an MsAccess frontend app that uses a 2 table view defined in Sql(2005). When i link the view manually I can say (and cache in Access) what...

addepad

02-28-2008 04:37 AM
addepad

I would like to verify the data entered in one table and calling for the verification then after gothru the each controls making corrections I...

lrnathantrc

02-28-2008 01:11 AM
lrnathantrc

I wish to create a temporary table that on closing will tranfer data to a main table. My problem is that on a network if more than one person opens...

anthonyspeirs via AccessMonster.com

02-28-2008 12:10 AM
anthonyspeirs via AccessMonster.com

Neighbour has got a new `puter which came with Office 2007 (without Access ) He needs Access to run an app for his business. He still has a copy of...

David B

02-27-2008 07:48 PM
Allen Browne

I have an opinion question relating to deleting important records in a human resources database. Any "best practices" papers or "white papers" anyone...

brockuswade@yahoo.com

02-27-2008 07:42 PM
Allen Browne

Hello, Quick and easy question, I hope..... Without using a text fieldtype, how can I get Access to store and display the number 12.1.2 or 1.3.9 ?

Chris

02-27-2008 07:04 PM
Bob Quintal

I've used Dbase/Clipper for years & Access for a little while now but Access doesn't seem to have any elegant solution to limiting the size of a text...

prakashwadhwani@gmail.com

02-27-2008 05:43 PM
Albert D. Kallal

I've just been informed that an Access 2003 based system in use at one of my customers now needs to send data in the form of an XML file to...

Dave G @ K2

02-27-2008 05:25 PM
Albert D. Kallal

Hello, I have read posts on license managers that are used with runtime access applications developed in 2k3 but ... What about MS Access...

vanleurth

02-27-2008 07:55 AM
vanleurth

I can't see my posts once i've posted them

Luvin lunch

02-27-2008 07:51 AM
Dominic Vella

Hello all, I'm looking for the pro's and con's for an MS Access Application which has an Oracle backend (Oracle Express). Especially how it is about...

SePp

02-27-2008 03:43 AM
SePp

I've got an Access db that has many different relationships between tables, for example, books <-> book_author <-> authors <-> author_institution <->...

eidosabi

02-27-2008 03:36 AM
eidosabi

I'm having a little problem with this Update statement and have been toiling away to no good. Could anyone please correct my syntax. Here's the...

prakashwadhwani@gmail.com

02-27-2008 02:28 AM
Salad

Hello Folks, This may be a really simple thing, but I haven't found the answer. Perhaps you'll tell me my approach is all wrong. Either way, I...

Dave

02-26-2008 05:52 PM
Dave

I'm having a problem with MS Access 2003 and its conditional formatting. I have textboxes on a continuous form whose left and right margins are set...

robertng90025@gmail.com

02-26-2008 03:48 PM
robertng90025@gmail.com

Hi, I have to build a database for Hotel on line availability. Is there someone that know some good example of database tables design in Access I...

LaSalamandra

02-26-2008 02:34 PM
Salad

I have a database in Access 2003 that was originally developed using XP. When the database is opened on a Vista computer, the font size in a report...

FreeLunch

02-26-2008 08:37 AM
Salad

I inherited an Access 2003 database with this setup: TableOne TableOneId pocOne pocTwo 1 2 3 2 2...

teser3@hotmail.com

02-26-2008 08:28 AM
Salad

ms-access97 & sql server2005 two tables tblItem tblItemFeature form frmItem contains subform frmItemFeature each form is based on their respective...

Roger

02-26-2008 07:08 AM
Rick Brandt

I don't have a great deal of experience with Access so please excuse my ignorance. I have two tables: Asset details and Department details More...

mainlandenvironment@yahoo.com.au

02-26-2008 06:00 AM
Allen Browne

Hello, I've got this supposedly easy problem of redirecting all of the linked tables and pass-through queries from reading from...

steph

02-26-2008 04:27 AM
steph

how to access the notes view programmatically

syam

02-26-2008 02:41 AM
Larry Linson

Hey Guys, I hope I didn't miss a post on this subject already. I am using Access 2003 through ADO. I have query 1 (MergeThisLastSeason): SELECT...

Gina_Marano

02-26-2008 01:47 AM
Gina_Marano

I am working on a user interface for a lab database in Access 2007. The 9 tables with the actual data are in a back-end database and the forms are...

Shevaun

02-26-2008 12:58 AM
lyle

Is there a way to merge data to an eMail? I have 10,000 students in our current class registration system that we are going to shut down in a few...

Jim

02-25-2008 11:51 PM
Tony Toews [MVP]