Hi Group (fairly limited knowledge of Access and almost none of Access VBA. Using Access 2003). My company give leaflets out when undertaking home...

dwasbig9@gmail.com

11-08-2007 10:49 AM
don

I have a BMP file of the name of my application. I use a mdw so that the user needs to enter a login id/pw. When I click on the desktop icon for...

Salad

11-08-2007 10:38 AM
Salad

I have a field that has Yes/No in it, I would like if it is a "Yes" to send an auto email to a certain member of staff with a form attachment on...

Elainie

11-08-2007 10:26 AM
Larry Linson

Hi I have the following query: SELECT qryBlackbook.* FROM qryBlackbook inner JOIN qryLatestMeetingDate ON (qryBlackbook.Site_Ref =...

paulquinlan100@hotmail.com

11-08-2007 10:12 AM
OldPro

I have a table with pdf files stored in an attachment data type field in a 2007 Access File. I would like to run a query that would select a group...

nduerr@morrisseyinc.com

11-08-2007 09:42 AM
Tom van Stiphout

In my Access table I keep characters other than English (Bulgarian, Russian etc) If I export my query with TransferText I am able to see the...

Chris

11-08-2007 06:37 AM
Chris

This is driving me nuts. Can anyone help? I have a program which searches for and analyses Access databases across a corporate network. At one point...

Michael Scott

11-08-2007 04:57 AM
Michael Scott

This is driving me nuts. Can anyone help? I have a program which searches for and analyses Access databases across a corporate network. At one point...

Michael Scott

11-08-2007 04:57 AM
Michael Scott

A pc that was created in MS office xp's Access 2002 has been working fine on a windows vista Ultimate pc that has MS OFfice Vista Edition. But all...

mindspring

11-07-2007 11:59 PM
FMS Development Team

I am trying to return several value in and IF in a query statement. The generic is as follows... =IIf(!!=10,Between 1 and 10,"") Can anyone help...

Chesne

11-07-2007 09:07 PM
Tom van Stiphout

I am using Ostrosofts OSMTP email macro and it works extremely well. What I have is an email that is sent to our clients. I want them to be able...

bhipwell via AccessMonster.com

11-07-2007 09:06 PM
Tom van Stiphout

Hi all, I am trying to do a simple insert into query that inserts data from one table to itself. Here is the design of my table: Batch_Desc -...

Tangz

11-07-2007 04:23 PM
Salad

I need to create a supervisory log for my clients. The log table has the following fields date, checkbox and notes. now for the tricky part......

bml337 via AccessMonster.com

11-07-2007 03:57 PM
bml337 via AccessMonster.com

How do I use VB to create some code behind a button in one database that will add a field to a table in another database that is not open at the...

Jim

11-07-2007 03:54 PM
Jana

Hello, I have a subform that has a command button to move to the next record. If there are more records i would just like to move to the...

gavm360@yahoo.com

11-07-2007 02:48 PM
Jana

I preview a report and click the button to publish the report to Word or Excel document. It works correctly until today. It produced below error...

Sam

11-07-2007 02:16 PM
Salad

Hi I'm using the following code to retrieve some data from a seperate DB: Dim con As New ADODB.Connection con.Open...

paulquinlan100@hotmail.com

11-07-2007 09:11 AM
paulquinlan100@hotmail.com

Is there a way of adding more than the 8 items to a switchboard on Access 97? If so how? Colm

colmkav

11-07-2007 08:18 AM
colmkav

Hello, I have a database with one table (tblTest) which has two columns (id (int) and ts (date/time)). In this table I want to select all...

k.renaud@gmail.com

11-07-2007 06:31 AM
lyle fairfield

One of my clients is having a problem where users will be kicked out of an Access program. Six out of the seven users have an Access runtime. The...

jodi@softwareplanning.com

11-06-2007 10:38 PM
lyle

I currently have a button once clicked, invokes the following: If Address_Select = -1 Then Forms!ProspectForm!Address = End If However, there are...

magmike

11-06-2007 06:43 PM
Jana

I have a column in a table named "Hospice". I have a make table query that pulls in this column but renames the column in the result to "Hospice...

Captain Jack Sparrow

11-06-2007 05:24 PM
Salad

I have a application that links to several sql tables. To improve performance I want to have a seperate database with an autoexec macro that when...

Bob

11-06-2007 05:14 PM
Jana

Any straightforward way to open a form with multiple subforms, where the main form and all subforms are opened in readonly status? If I...

Bob Alston

11-06-2007 01:33 PM
DavidB

Hello everyone, Using Access 2003 SQL Server 8.0 I have a link to a View on a Sql Server. The View does a sum of inventory quantity -- ...

eighthman11

11-06-2007 01:26 PM
Rich P

Hi, I have a very simple way of highlighting the current row in a continuous subform, and using up/down buttons on the form I'm able to move the...

ANDRESUK

11-06-2007 12:22 PM
ANDRESUK

What is the correct way to code this? I'd like to change the value of a field on the main form with the value of a field on the subform using the...

magmike

11-06-2007 10:59 AM
magmike

Hi! I have 2 tables: Table Users: ID Name Password Birth

Vicente

11-06-2007 10:29 AM
Michel Walsh

I would like to put a button on a form that will load up a website the website...

Simon

11-06-2007 10:00 AM
Fred Zuckerman

I have an Access app with ULS applied. It has a main form and a subform with a 1:M relationship. My client wants some of his users to be able...

Keith Wilby

11-06-2007 06:23 AM
rkc

Hi, i have found out as i have developed the database i've ended up with a number of tables that have the same attributes. For instance, my...

Chris Morley

11-06-2007 04:16 AM
Allen Browne

Hello, I have database, which contains the list of laptop companies and some information about them. Some laptop models, have series, sub series,...

dkultasev@gmail.com

11-06-2007 03:14 AM
dkultasev@gmail.com

I need some help getting unique records from our database! I work for a small non-profit homeless shelter. We keep track of guest information as well...

srusskinyon@gmail.com

11-06-2007 02:34 AM
Carlos Nunes-Ueno

OK, one more time (with feeling...). I thought the person was saying that in a well-designed system, all data, including temp data, would go in...

Neil

11-05-2007 08:23 PM
Neil

Although I've been fortunate enough to start with companies at a point fairly early on in the database design process, I've had to work...

CDMAPoster@FortuneJames.com

11-05-2007 08:13 PM
CDMAPoster@FortuneJames.com

In: http://groups.google.com/group/comp.databases.ms-access/msg/f06bd4c45037ef29 Lyle wrote: :Terry Kreft wrote: : :>Suck it and See? :

CDMAPoster@FortuneJames.com

11-05-2007 05:04 PM
CDMAPoster@FortuneJames.com

Hey everyone, Using Access 2003 and SQL Server 8.0 I have a stored procdure on SQL Server that is launched from my access database where I send the...

eighthman11

11-05-2007 01:59 PM
Rich P

Say I've got a graphic on a report's detail section. Say it's a bound object frame linked to an image spec in a bound table field named . How might...

MLH

11-05-2007 01:21 PM
Bruce

Hi All, I have this query which updates a field based on the result of an IIF statement. The table is on SQLServer and I'm linked to it and it...

bobh

11-05-2007 10:48 AM
bobh

Hello, I'm trying to find a good program to use for editing memo fields in Access 2003. I'd love to use Notepad or Wordpad, but the only option I'm...

Charles

11-05-2007 08:15 AM
Neil

I was having problems connecting to an ODBC data source in A2003. I would click on File/GetExternalData/Link and select "ODBC Databases()" from the...

Salad

11-05-2007 03:28 AM
Keith Wilby

Well, remember I wrote: So, instead of judging whether I'm doing things right or wrong, why don't you just get that information? I didn't give it...

Tom van Stiphout

11-04-2007 11:12 PM
Neil

Cut this little FN out-a-Access 97 HELP. It makes mention of the new record being made the current record. Is it the Update method responsible for...

MLH

11-04-2007 04:39 PM
MLH

Hello All, I have been asked to build a simple database that will operate and track a liquid dispensing device. The machine is run in a...

flymo

11-04-2007 12:30 PM
flymo

Hello, Any help would be appreciated!!! I need to sum AMOUNTTEND on a receipts subform that meet a certain criteria. It has to be something...

David Grist

11-04-2007 11:39 AM
tina

I have 2 tables and the only unique and common identifier is part...

JackpipE

11-04-2007 06:31 AM
Bob Quintal

Hi I have a report and I am doing the following calculation in the load report event: Me.TbxClass1_1.Value = Sales1Count \ Me.TbxSales1.Value where...

Hansen

11-04-2007 01:02 AM
CDMAPoster@FortuneJames.com

I am converting an application from A97 to A2003. I have 2 tables created by another application as a Foxpro.dbf. The table has no index. The...

Salad

11-03-2007 09:06 PM
Larry Linson

With the database window open I click on Help, then click on "About Microsoft Office Access". A dialog window is presented and there are 4 buttons...

Salad

11-03-2007 07:50 PM
Salad

If I click on the Macros button in the database window there is 1 macro that exists...AutoExec. If I click on the Modules button and enter the VB...

Salad

11-03-2007 07:46 PM
Salad