I'm currently developing an MS Access Data Project (.adp) in MS Access 2002. One of the reports within the DB uses data that is Dynamic and...

Oko

11-28-2007 02:52 PM
lyle

Hi, I just upgraded to 2007. It is quite a change in interface, but, on one of my computers double-clicking a table or a form or any other object in...

Michiel Rapati-Kekkonen

11-28-2007 11:25 AM
Michiel Rapati-Kekkonen

Greetings, I'm still using MS Access 2K3 and DAO 3.6 objects (I know, I know, I'm a dinosaur)... I'm traversing through the fields of a table to...

Fester Bestertester

11-28-2007 11:03 AM
Fester Bestertester

I need to do a query and limit it to returning 10 rows at a time. I can't rely on dynamic cursors or anything like that because I can't keep a...

eselk@surfbest.net

11-28-2007 10:13 AM
eselk@surfbest.net

HI, I'm not that experienced in Access so am turning to the experts for some basic help. I have the following fields in a table : Name ...

Mintyman

11-28-2007 10:03 AM
Neil

I recall reading somewhere about a function or property that returns the height of a window's title bar, but can't recall. Anyone know off the top...

Neil

11-28-2007 08:08 AM
Neil

pl see win the prize http://earnmac.blogspot.com

pooja

11-28-2007 05:37 AM
pooja

I have a form based on a complex query (Lots of tables) If I delete a record, everything appears to be OK. Get the message "Youa are about to delete...

Phil Stanton

11-28-2007 04:49 AM
Phil Stanton

I tried to retrieve the digit grouping symbol in MSAccess but unfortunately 3;0 is retrieved instead of comma which is my symbol. Function retrieves...

Chris

11-28-2007 04:22 AM
Chris

Does anyone know how to read a NSF file using VBA? It seems I need NotesSQL (http://www-306.ibm.com/software/lotus/products/domino/notessql.html)...

NoEd

11-28-2007 03:46 AM
The Frog

Help!!! This is driving me nuts! We have created a DB for a company. We split the DB. Everything seems to work well except for this one...

abprules

11-28-2007 03:23 AM
Keith Wilby

Is there a way to add comments to a Access SQL string. For example between UNION to comment on what data each UNION is adding.

paii, Ron

11-28-2007 02:49 AM
John Mishefske

using Access 2003 and sql server version 8.0 Hey everyone. Created a text box where the user types in an Inventory number and it takes them to that...

eighthman11

11-27-2007 06:58 PM
Neil

Can someone help me with this???? I have a linked table, which is an excel spreadsheet. In one of the columns there is a date and time. When I...

dst393 via AccessMonster.com

11-27-2007 06:01 PM
dst393 via AccessMonster.com

Very beautiful girls and complete stock information,please check it out http://groups.google.com/group/all-good-things/web/beautiful-girls-and-ladies

my glass

11-27-2007 05:52 PM
my glass

last month I started on changing the format in a LOT of tables. changing Long Integer and Singles to double. I got that working but I have one more...

sparks

11-27-2007 04:50 PM
sparks

We have one database that they are constantly reformatting their inputs. I asked about the changes and they can never get the same types of numbers...

sparks

11-27-2007 04:19 PM
Chuck

I have a system where many subforms are used. Often the size of the subform had to be larger than could be displayed without scrolling. I set the...

Bob Alston

11-27-2007 03:31 PM
Salad

Instead of having to open a table, selecting a OLE Object field then going Insert, Object, etc how can I enter the information into this field using...

TD

11-27-2007 11:37 AM
Stephen Lebans

I'm redesigning a report in my frontend. When I move a text object, sometimes Access gives a message that Access has to be closed. After opening or...

11-27-2007 10:33 AM

I have a tblProduction w/ which is an autonumber associated specifically with the combination of , , and . I also have another table,...

tbrogdon@gmail.com

11-27-2007 10:23 AM
tbrogdon@gmail.com

I have 3 Access 2003 tables: TableMain MID PO TE INFO 1 2 3 ABC 2 2 1 EREER 3 1 3 OIUOI 4 3 3 PERE 5 2 ...

teser3@hotmail.com

11-27-2007 03:38 AM
purpleflash

Hi, I have this code in Access 2003 for checking if an Internet connection is present: (In the code below, "somedomain" represents the web site that...

biganthony

11-26-2007 06:53 PM
biganthony via AccessMonster.com

Work at home opportunities,most complete work at home site. Featured on present work at home jobs..............http://www.workfrmhome.org/ joomla

ta5e8yl7

11-26-2007 06:39 PM
ta5e8yl7

Access 2003 I have a Continuous Form. On Open I force it to go to the Last Record. When the form opens only the last record is shown at the top. ...

Clint Stowers

11-26-2007 05:48 PM
Stephen Lebans

This is driving me crazy - my unmatched query wizard will not display field names for any tables I choose. All my other query wizards work properly....

Sharon V

11-26-2007 03:09 PM
Sharon V

On Nov 19, 4:35 pm, fredg <fgutk... (AT) example (DOT) invalid> wrote: Thanks for suggestions above, but I'm actually referring to importing the...

veaux@aol.com

11-26-2007 02:55 PM
veaux@aol.com

I have a form to add new employees to tblEmployee with the following fields: Department (text - linked to tblDept - 3 values in a single...

tbrogdon@gmail.com

11-26-2007 01:49 PM
tbrogdon@gmail.com

Hi all I tried to seperate my query update im order to define what is the limitation for the field becaouse i know that it is limiting for 1024...

thread

11-26-2007 12:53 PM
thread

Hi, could anybody help me with this please I want to add a date stamp in a table, it should automaticlly updated when another field in the same table...

Tang

11-26-2007 12:46 PM
Neil

I have a form where on current, it evaluates some fields to determine which page on a tab control should be displayed and which should be hidden. If...

rdpacer@yahoo.com

11-26-2007 11:48 AM
Pachydermitis

I have had this before in the past and just ignored it, but now I need a solution. Basically, using ACC2003 if I have one particular printer as the...

AP

11-26-2007 11:31 AM
AP

Hi All Using AccessXP front-end on PC linked to AccessXP database on server. System works well for about 25 concurrent users. Have been forced...

Bigpond News

11-26-2007 10:34 AM
Bigpond News

On Nov 22, 12:42 pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Thanks again to the both of you! Jana

Jana

11-26-2007 10:18 AM
Jana

Is is possible to track or stop someone from importing your tables from a unprotected db? Is it possible to track of stop someone from linking to...

gumby

11-26-2007 09:04 AM
Tom van Stiphout

Hi On a form listbox Access version 2003 has a limited number or characters that can be stored in a listbox when the Row source Type is set to "Value...

m-sjoblom@telia.com

11-26-2007 07:01 AM
Stuart McCall

"lyle" <lyle.fairfield (AT) gmail (DOT) com> wrote Question for you. I'm doing something similar, only, instead of opening the forms all at once,...

Neil

11-26-2007 04:26 AM
Neil

Hi, How do I get a Calender Control popup to appear near the button which activated it, rather than on the other side of the screen? (MS Access...

Doug@NoEmail.com

11-25-2007 08:59 PM
Tony Toews [MVP]

Anyone use the AHRESIZE utility to resize a form dynamically who is also using background images? I have an app that creates electronic versions of...

Bob Alston

11-25-2007 04:28 PM
Phil Stanton

David W. Fenton wrote: I would say Me is a way to reference an instance of an object from within the class module that defines the object. It's...

Doug@NoEmail.com

11-25-2007 03:17 PM
Neil

Is this guy for real? I cam on this forum expecting to find database related topics.....What has this guys' rants got to do with Microsoft Access?...

Mintyman

11-25-2007 03:05 PM
Arch

These Hidden tools will help you get maximum performance Inside Vista, The Best of Vista's New Tools,Tweak Security Settings in XP and Vista, Using...

Russel Pitt

11-25-2007 02:10 AM
Allen Browne

Hello all, I have created a class to track the session details on a database we use at work. The class stores information about the current...

ApothecarySW@gmail.com

11-24-2007 06:33 PM
Tom van Stiphout

I have the onOpen event of my report as docmd.maximize but when I open the report rather than truly maximizing the window, it enlarges it so that...

Kevin

11-24-2007 10:41 AM
Deano

I new new to Acces and tryig to do something that should be fairly straight forward. I am trying to have an address book table and link it multiple...

tyler.horning@gmail.com

11-24-2007 09:27 AM
Neil

Hi, I created a short date field. The format is dd/mm/yyyy when displayed. The input mask is set to 99/99/00;0 (default, I didn't type anything). If...

Doug@NoEmail.com

11-24-2007 03:54 AM
Allen Browne

Hi, Is there a way to get a popup window to position itself near the control button than launched it. My date selector popup appears all the way to...

Doug@NoEmail.com

11-24-2007 02:22 AM
Doug@NoEmail.com

Here's a problem I haven't seen discussed. I have a continuous form with a conditional format for the background color of a text box. It had been...

vircalendar via AccessMonster.com

11-23-2007 09:13 PM
Larry Linson

Dear reader, I have two forms, FormMain and FormX. FormX will be open as a popup in front of FormMain. By selection a field in FormMain, FormX...

Simon

11-23-2007 08:46 PM
Neil

I'm using SendObject to generate an email to a list that I have built up in a string variable from email addresses held in a text field within a...

Roy Tong

11-23-2007 11:01 AM
Roy Tong