We have 3 databases that are just copies of the master. I have no idea why this is but I need to put them all in one. They contain a main table and 2...

sparks

09-10-2008 02:08 PM
Carlos Nunes-Ueno

I have a main form containing a command SEND button that prompts an email form to pop up. The email address(es) that are supposed to appear on the...

zufie

09-10-2008 01:12 PM
Carlos Nunes-Ueno

I have a table with 60 fields so in order to facilitate the data entry, I created a Main form (unbound) that contains a tab control with three tabs...

VinceRuso@gmail.com

09-10-2008 10:41 AM
Rich P

Thanks Fred. That works just fine. Gord "fredg" <fgutkind (AT) example (DOT) invalid> wrote

Gord

09-09-2008 10:50 PM
Gord

A while ago I posted this for help. "I have a table that has a PK field with the following format: Dyymm123. So that, a typical number might look...

troy_lee@comcast.net

09-09-2008 10:00 PM
MGFoster

I have downloaded a Microsoft template .mdb for Access 2003. What I want to do is now save another copy of the template so that I can manipulate...

Hoardling1 via AccessMonster.com

09-09-2008 01:56 PM
MGFoster

I have just been asked to port an Access 97 app from an old Pentium 3 to a new Pentium Core-2-Duo PC. On the new PC, Office 2003 is installed. On...

prakashwadhwani@gmail.com

09-09-2008 06:44 AM
Allen Browne

I have been using a database i designed 15 years ago and suddenly the field next to the key field no longer shows up, it is blank. If i use the...

mikej

09-09-2008 04:54 AM
mikej

Seiko Perpetual Calendar Prices Lower Price Seiko Perpetual Calendar: http://www.fashion163.com/Seiko_Perpetual_Calendar.html Luxury Watches Lower...

blog470@watchesblog.cn

09-09-2008 12:41 AM
blog470@watchesblog.cn

Jacob & Co. 3 Roll Bezel Prices Lower Price Jacob & Co. 3 Roll Bezel: http://www.fashion163.com/Jacob_Co__3_Roll_Bezel.html Luxury Watches Lower...

blog373@watchesblog.cn

09-08-2008 10:25 PM
blog373@watchesblog.cn

High Quality Technomarine Lady Sport High Quality Technomarine Lady Sport: http://www.fashion163.com/Technomarine_Lady_Sport.html High Quality...

blog373@watchesblog.cn

09-08-2008 10:25 PM
blog373@watchesblog.cn

Hello. I have an ms acess database that I use to track my mp3 files. I have included code that lets me select and play files by invoking an...

John O'Flaherty

09-08-2008 07:49 PM
bhicks11 via AccessMonster.com

Hello, I have a form which people use to add customers. One of the fields is "country". Most of the clients are in the UK, but we have the...

franc sutherland

09-08-2008 09:07 AM
franc sutherland

How do you do it? I need to sum a field within a group after the group changes and put it in the group footer. Referral Header Referral...

PW

09-07-2008 09:03 PM
PW

if a message I sent on a political issue makes it to this newsgroup. I canceled the message but the chances of it getting thru to this newsgroup is...

Salad

09-07-2008 06:02 PM
lyle fairfield

Can an Access application running on Terminal Server be accessed by logging in to a remote desktop via a web browser the same as an Access app...

josephlee@live.com.au

09-07-2008 05:56 PM
josephlee@live.com.au

In my combo's list I have for instance these values: AbcdX AbcdY When I press A in the combo, AbcdX gets selected though I need AbcdY to be selected....

John J.

09-07-2008 03:02 PM
John J.

8 years ago the bush camp had a whispering campaign in South Carolina that McCain had adopted a "nigger baby". Many in South Carolina didn't want a...

Salad

09-07-2008 02:17 PM
rkc

Yeah, I did try increasing the DrawWidth and it's still inconsistent. Thanks for your help. On Sep 6, 7:57*pm, fredg <fgutk... (AT) example (DOT)...

evenlater

09-07-2008 01:07 PM
evenlater

Hello, Is it possible to create multiple foreign keys on a field in a table from values in two separate tables where the field value can be from one...

anjee

09-06-2008 08:57 PM
Larry Linson

Hello, I'm hoping someone might be able to offer some guidance to my problem. I have one query in MS Access which consists of 2 tables joined by...

Aaron Hoffman

09-06-2008 07:07 PM
Phil Stanton

I have a continuous form. One of the fields shown is the Primary Key. I want to be able for users to either: Click on the ID number and be taken to...

troy_lee@comcast.net

09-06-2008 03:59 PM
Salad

I have written the following SQL to take data off of a form and insert it into a table. sql = "INSERT INTO Water Values('" & Me.AccountNumber &...

iwasinnihon

09-06-2008 01:28 PM
RoyVidar

I would like the Auto Number field to have 7 digits and the first character "E" eg ; E0000001, E0000002...,E00000120. Can someone help please?

Kissi

09-06-2008 10:36 AM
Rick Brandt

If I have a main form - Form3 - with a subform control named SF4 and they are NOT linked on any common field (no child or master field links) - can I...

MLH

09-06-2008 07:25 AM
Rick Brandt

Access 2003. Will someone please explain how to do this? My applications have all become so absolutely despairingly *&^%ing corrupted - I have no...

Timmy!

09-06-2008 06:40 AM
lyle fairfield

I am trying to make sense of the Sage Line 50 accounts package through Access 2k I have linked the tables and they appear OK The following query...

Phil Stanton

09-06-2008 04:58 AM
Phil Stanton

Hi guys, I have created a VB code through 'Record a new Macro'. This code builds a pivot table.The problem is that the table created has totals but...

maffonso

09-05-2008 11:24 PM
Tom van Stiphout

Is it possible to somehow add the option of "All" at the top of the list of a combo's drop down list? I'm hoping I don't have to go and re-jig...

Gord

09-05-2008 05:22 PM
jonceramic

I recently started a co-op/internship at a company and they are looking to migrate a large legacy supported application from OLEDB to SQL Server. I'm...

Bret Kuhns

09-05-2008 04:35 PM
MGFoster

When clicking an item from a drop down list on a combo box, how does one make another combo box make a selection from it's own list? No matter...

Gord

09-05-2008 12:58 PM
Rick Brandt

I have a form that acts a filter. All of the filtering objects are in the header and the results are displayed in a continuous form in the detail...

troy_lee@comcast.net

09-05-2008 12:21 PM
ARC

I'm using TransferSpreadsheet to import an Excel file in to MS Access 2003. DoCmd.TransferSpreadsheet acImport, 8, strTable, strFileName, True,...

Icarus

09-05-2008 11:52 AM
ARC

Hello all, I'm a fan of Smith's and Sussman's Access 2000 VBA and Barker's Access 2000 Power Programming. I'm now moving into Access 2007 and...

Monica

09-05-2008 11:20 AM
Allen Browne

Is there a way I can open Windows Explorer at a specific folder, size the window, and position it in relation to the (already opened) Access window?...

terrybell105@gmail.com

09-05-2008 10:43 AM
Steve

Hi, I couldn't find a reference to this with a simple google search. I'm on Access 2003, and every once in a while. (Like now! Grrrr!) I get my...

jonceramic

09-05-2008 10:20 AM
jonceramic

I've been trying to find out where to get the royalty-free runtime for Access 2003 but it seems to get more confusing the more I dig. (I noticed...

Don

09-05-2008 08:04 AM
Element

We have a database with NO security on a network drive. Seems that some IT person went in and created a security.mdw Now no one can log into the...

sparks

09-04-2008 11:36 PM
Larry Linson

Currently I have a button that allows the user to "Close Company" - at the moment it doesn't do anything :D I would like the button to "disconnect"...

Kelii

09-04-2008 10:19 PM
Kelii

Hello all, My app has an e-mailing feature where you can e-mail reports, as well as a bulk e-mail feature for e-mailing all customers (as separate...

ARC

09-04-2008 10:06 PM
Tony Toews [MVP]

I don't know if this is the correct place for this. I am new to discussion groups, so bear with me. I am designing a farm records database in Access...

RiceFarmer via AccessMonster.com

09-04-2008 08:36 PM
bhicks11 via AccessMonster.com

Hi all, I need to regularly backup my database as an Excel file and have been using the File > Export option. Problem is I need anyone using the...

DeZZar

09-04-2008 07:25 PM
DeZZar

Now that everything seems to be fixed in the 1st service pack of the 2007 runtime, I'm wondering if anyone else has seen the annoying focus...

ARC

09-04-2008 04:49 PM
ARC

I inherited a table. One field in this table is Date_Observed, and users entered data directly into this (I'm not sure there was an input mask;...

BonnieW via AccessMonster.com

09-04-2008 04:42 PM
Bob Quintal

I've continued to use Access 97 all these years because (1) it does everything I need quickly and (2) most of what I've read online indicates that...

Don

09-04-2008 03:20 PM
Sky

ZoomControl is a hidden property of reports. Setting it to zero, makes the report fit the window. The default view of a report created in Access...

lyle fairfield

09-04-2008 03:06 PM
Sky

In article <Xns9B09B058399A6f99a49ed1d0c49c5bbb2 (AT) 64 (DOT) 209.0.89>, David W. Fenton <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Am I...

O

09-04-2008 01:45 PM
O

Hi all, I have a table that contains employee IDs, dates and point values (-1, 0 or 1). I want to query the table and exclude the oldest record...

murch.alexander@gmail.com

09-04-2008 10:22 AM
Allen Browne

Hello, I have a client who uses Access 97, but does not have the Linked Table Manager. The system is split into front and back end. Is it possible...

franc sutherland

09-04-2008 08:05 AM
Stuart McCall

Hi, My application contains 2 databases: appl.mdb and data.mdb. From appl.mdb I link to data.mdb. How can I (in appl.mdb using a commandclick)...

susan

09-04-2008 06:39 AM
lyle fairfield