Hello, A very simple select query (no joins) to a linked ODBC SQL Server 2000 table produces incorrect results. The right number of rows seem to...

JM

07-05-2005 03:36 PM
JM

Suppose I'm in an open database (northwind.mdb). Is there a shorter form of doing the following after I've dim'd dbsNorthwind as database... Set...

MLH

07-05-2005 02:53 PM
David W. Fenton

I have a table, tblManinstructions with fields Code & InstructionID, one Code can have many InstructionID. I also have tblinstructions...

Will

07-05-2005 02:35 PM
William

All, If I have a form with multiple fields, If I populate field with a product #, how can I get the manufactures field to auto...

Dub_Man

07-05-2005 12:28 PM
pietlinden@hotmail.com

I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an...

pmhaupt2@cox.net

07-05-2005 12:17 PM
Peter

I have a SQL Server table where one of the fields is the type Decimal 34,2 (Precision 34, Scale 2). I can not get this field to display properly in...

Terri

07-05-2005 12:10 PM
Terri

Hi I need to print "blank" invoices with invoice numbers only at the top. I have a table full of invoice numbers which I am using as the record...

John

07-05-2005 12:03 PM
Bri

Is there a quick way to do it? I'm logged in as the superuser and owner of database and all database objects. I would like to export it to a...

MLH

07-05-2005 11:59 AM
MLH

does anybody know how to use the sendobjects command with an attached text file? Appreciate your help.

sari

07-05-2005 10:57 AM
pietlinden@hotmail.com

With Me!PERSONSLIST.Form.RecordsetClone .FindFirst strID If .NoMatch Then Debug.Print "key " & Key & " nomatch" Exit Sub Else If Me.Dirty Then...

Thelma Lubkin

07-05-2005 10:08 AM
Thelma Lubkin

Happy 4th, all How do you turn off the following type of autofill: Example: I have created a table with four text fields. When entering numeric...

LCalaway

07-05-2005 08:52 AM
LCalaway

Is this possible does anyone know? I mean other than using imaging software. The scenario is this. I have a form with a large image control...

Tim Marshall

07-05-2005 08:34 AM
Tim Marshall

Dear all, please help me in Combo Box Synchronising. I have three levels. Category -> Type -> Subtype Depending on the selected Category, the Type...

Rajesh Sharma

07-05-2005 05:35 AM
Rajesh Sharma

I have installed the Oracle 10g client on my pc, setup net manager connection so I can connect to the database, and created the ODBC entry. When I...

D.Bennett

07-05-2005 05:10 AM
D.Bennett

Hi there everyone, I have a part info form which has a faded image of our company logo as a background. I want to replace the faded image with a...

John Ortt

07-05-2005 03:46 AM
John Ortt

I am trying to solve a connectivity problem. A simplification: tblTemp Section Connected_Section id A B 1 B ...

sd_bradford@hotmail.com

07-05-2005 03:40 AM
sd_bradford@hotmail.com

Does anyone know of a way to search through the SQL code of queries to find table name matches? Bear in mind there are literilly 1000's of queries in...

BillCo

07-05-2005 02:34 AM
BillCo

i need to modify a specific series, line weight and color. however, i need to specify the series number, which can change. how can i translate or...

ironpen45@yahoo.com

07-05-2005 12:30 AM
ironpen45@yahoo.com

I've got quite a large database which is totally form-driven at the moment. I now need to allow multiple users access to various parts of it...

Pecanfan

07-04-2005 11:53 PM
Larry Linson

More to the point... Is it possible for me to install a runtime set of A97 executables onto a CD, give it to some- one, let them pop it into their...

MLH

07-04-2005 10:43 PM
MLH

I'm in the process of moving an Access application onto a different server and need some advice about oplocks... The application is based on Access...

MikeH

07-04-2005 10:22 PM
Larry Linson

Hi, I have 2 forms open at the same time, Form 1 adds information to a field on a record that Form 2 has open. It used to show the new information...

N J

07-04-2005 07:50 PM
Pachydermitis

Did A97, perchance, do away with the need for an AutoExec macro to initiate an autoexec sequence for databases? Or, must we still suffer with that...

MLH

07-04-2005 07:12 PM
SilvrT

Greetings all, I have recently created a database that functions as an inventory analysis tool for the department I work in. Recently, there has...

Andi

07-04-2005 05:50 PM
MacDermott

I am continuing my exploration about upsizing to SQLServer from Access 2000. I have a split database with a front-end and a back-end, each of...

Jim Devenish

07-04-2005 04:28 PM
Steve Jorgensen

A97 At work we have a badly set up network. The boss won't spend any money. Basically there are about 10 computers on a LAN. One computer is used...

MS

07-04-2005 04:17 PM
MS

Running the following code produces NO error, but renders my keyboard incapable of typing. I can use the mouse to open the class module & look at it....

MLH

07-04-2005 03:39 PM
David W. Fenton

I have reports formated and now need to use that format on another table name with the same field names as formated in the report. I belive it is in...

thomas.jacobs@dva.state.wi.us

07-04-2005 12:12 PM
Arno R

I hope someone knows where I can find such databases free., if not, cheap and complete.

nortelsale@yahoo.ca

07-04-2005 12:01 PM
Larry Linson

I want to create a Dcount and an If...Then...Else statement to count the number of records in a table based on the date that is entered to run the...

jstaggs39@gmail.com

07-04-2005 10:04 AM
jstaggs39@gmail.com

Hello everyone, I'm considering upsizing my databases to SQL server. I've tried the upsize wizard on one of them, but the process failed since to...

Demboos

07-04-2005 08:17 AM
Bas Cost Budde

I am using Acc97 and trying to get the following instruction to work in the OnOpen event of a report: DLookup("", "tblTempRevenueByFY",...

Tony Ciconte

07-04-2005 07:31 AM
Douglas J. Steele

I am using Access2000 . In a query window, after selection of a group of records using aggregate function "group by", I want to retrieve only one...

sarak13_2000@yahoo.com

07-04-2005 06:34 AM
BillCo

Hi, I have designed a databasewhich is now able to store all data from my client's Excel sheet.Now I am looking for a good way to move their...

Hi5

07-04-2005 05:59 AM
Hi5

I still have not had an answer to this, anyone with any ideas? I create an MBE in Folder A, it works in folder A, it works when I double click on...

William Grace via AccessMonster.com

07-04-2005 05:57 AM
Deano

Dear all, I have a table with the names and address of all my dealers along with their telephone nos. I want to create a form, wherein I just enter...

Rajesh Sharma

07-04-2005 05:21 AM
Wayne Morgan

Using Ms Access 2003 I am trying to export a query to a delimited txt file containing some CURRENCY fields, which I want to export without the...

GAVO-UK

07-04-2005 03:56 AM
GAVO-UK

Hi, I am working for client, they need to automate data entry to the access DB, by importing it from an excel sheet into 4 diferent tables is...

Hi5

07-04-2005 03:13 AM
Hi5

Despite having at least 2 days VBA programming experience, this one has got me... I'm trying to export multiple tables into one worksheet in Excel....

Regnab

07-04-2005 03:07 AM
Regnab

Mmmm. Doing some work with Access security. Let's say I don't want the users to be able to edit the back end tables directly. Not because it's a...

Mike MacSween

07-04-2005 12:07 AM
Mike MacSween

There doesn't seem to be a way to do this. The Access security model seems to be based around allowing the users to read/alter design of the...

Mike MacSween

07-03-2005 11:09 PM
Bri

Hi, hoping someone can help. Access 2003, WinXP. I have built a database that uses synchro to co-ordinate with the mothership. All is well. The...

Sharktyyfa

07-03-2005 08:30 PM
William Benson

Hi All, I have a table with records and I want to add an image to every record. One of the fields is an OLE Object and another is a text which...

Nicolae Fieraru

07-03-2005 03:44 PM
Nicolae Fieraru

One of my customers is about to create several new positions for internal Access Developers. These are not professional developers who could sell...

Richard Sherratt

07-03-2005 03:22 PM
Lynne D

Have any of you experimented with an Access 97 app running on a web-enabled PC toward the objective of having the remote PC running your application...

MLH

07-03-2005 02:59 PM
MLH

Hi I have this code as below that first runs a report and then an update query to set a flag so these records are not included in the report next...

John

07-03-2005 02:31 PM
David W. Fenton

Hi, hoping someone can help. Access 2003, WinXP. I have built a database that uses synchro to co-ordinate with the mothership. All is well. The...

Sharktyyfa

07-03-2005 02:25 PM
David W. Fenton

I would like to read a MAC address from at least one NIC in a PC on which I have an Access 97 runtime app installed. What's the least hassel method...

MLH

07-03-2005 02:12 PM
David W. Fenton

The report indicated in the send object command below has various colours in it which show nicely when the report is previewed and printed. However,...

Tim Marshall

07-03-2005 02:06 PM
MLH

It has been mentioned that a ghosted machine or a machine linked by cable modem and USB may result in my reading a MAC address other than one burned...

MLH

07-03-2005 09:15 AM
MLH