Is there a way to shade a row in a report based on the value in a field? I have a "Job Title" field in a tabular report, and if the person's job...

Jim

02-11-2009 04:08 PM
Larry Linson

Are there any free activeX components I can use to call the TWAIN driver from within Access. Do I need an activeX control, or can I call the Twain...

grant@technologyworks.co.nz

02-11-2009 02:42 PM
grant@technologyworks.co.nz

I have a table I'll call "WORKING" In it, there is a column called "username" After a bunch of vb code is run, I end up with 5,400 user names in...

Jim

02-11-2009 02:42 PM
Jim

I hope this does not get me in trouble for posting first in the wrong group the first time.....this is the same now in the right group. Has anyone...

mochatrpl@gmail.com

02-11-2009 02:38 PM
mochatrpl@gmail.com

Does anyone know why Microsoft set the kill bits for the flex grid and hierarchical flex grid controls? I imagine these controls are utilized by...

Vincent

02-11-2009 12:01 PM
Vincent

Dear All, Using Access 2003/2007 I am looking to build a right to left menu on a pop-up form. Using the activeX toolbar ( provided by windows V 6.0...

karramli@gmail.com

02-11-2009 10:51 AM
karramli@gmail.com

All, I thought I had this working, but...I spoke too soon. I have a variable (DTDateField) being set on a form, via this: Public DTDateField As...

GM7

02-11-2009 10:33 AM
GM7

Using A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8 I’m New to Access 2007 I develop apps in Access 2000 and both FE.mdb and BE.mdb are in Access 2000...

JGravesNBS

02-11-2009 10:25 AM
paii, Ron

I know this is easy, but I just can't quite seem to get it. I have a query that is getting a parameter from a form for a date field. When I use...

troy_lee@comcast.net

02-11-2009 08:55 AM
troy_lee@comcast.net

Anyone have any experience running 64 bit SQL Server as a back end, and any issues with it over the 32 bit version? I'm running SQL 2005 against...

Neil

02-10-2009 09:44 PM
aaron.kempf@gmail.com

I have a continuous form, with a button that shows on each row. When the button is pressed, a popup form displays details about that particular row....

Greg (codepug@gmail.com)

02-10-2009 08:32 PM
Greg (codepug@gmail.com)

currently using access97 and dsn connections to link tables / views to sql2005 thinking of upgrading to access2003, same sql server is there any...

Roger

02-10-2009 05:14 PM
Roger

I've got 2 controls on a form employeeid employeeName employeeId contains 100 employeeName's controls source is =IIf( Is...

Roger

02-10-2009 05:02 PM
Bob Quintal

When I click the ADD control on my form all but essential controls are made non-visible. There is a SAVE button and a CANCEL button visible. If,...

blemmon@ndtg.net

02-10-2009 11:08 AM
Salad

I'm linking to an excell spreadsheet which is full of dirty data ... carriage returns in numeric fields, text in date fields etc. This is causing...

Astley Le Jasper

02-09-2009 11:01 PM
Lauren Quantrell

On Feb 7, 7:10*am, CDMAPos... (AT) FortuneJames (DOT) com wrote: .. *Right now I think of Vista as the beta The general consensus is that Win7 is...

Wayne

02-09-2009 10:00 PM
Wayne

I've got 7 citrix servers supporting 150 users running access97 through softgrid with some users running 3-4 access applications, my server CPUs...

Roger

02-09-2009 06:45 PM
Albert D. Kallal

I downloaded the sample one from the business section of the templates. I have changed one of the fields to read "Reference Number". What I am...

SQL

02-09-2009 05:41 PM
SQL

ALl, Thanks to information I've found here, I was able to build a function and use it in the Criteria row of a query. This works fine now for...

GM7

02-09-2009 03:46 PM
GM7

Outlook has a nifty feature for parsing an address into individual elements: street number, street name, city, state, zip. I wanted to add this...

Lauren Quantrell

02-09-2009 03:14 PM
Lauren Quantrell

Global Const AppOpenTime = Now Above statement won't compile. Access compile error says "Constant expression required" Why is that? Is there some...

MLH

02-09-2009 01:50 PM
MLH

On Sun, 8 Feb 2009 09:30:30 -0800, fredg <fgutkind (AT) example (DOT) invalid> wrote: Yes, that was it. Thanks so much for your help! So now we...

PW

02-09-2009 12:28 PM
PW

Hello, I prepared a database with MS Access. There are reports in this database. I want to print reports of in this database with my Visual...

asude

02-09-2009 11:57 AM
Rich P

I have an external database, i.e. separate from the one in which I am working, named: C:\holiday\AvailabilityForWeb.mdb Within this is a table...

Jim Devenish

02-09-2009 06:53 AM
Jim Devenish

Business Warehouse – Direkt Import / Retail Goods Wholesale Wholesale Trading Supply Hong Kong (Asia), United Kingdom, & U.S.A. Trade Confederation...

Industrial Engineering

02-09-2009 06:49 AM
Industrial Engineering

I just noticed the following.... In my form load event, I have the following code: Private Sub Form_Load() Me.Filter =...

zuckermanf@gmail.com

02-09-2009 04:53 AM
zuckermanf@gmail.com

I'm using the following to open a PDF document lngRet = apiShellExecute(hWndAccessApp, vbNullString, strFile, vbNullString,...

Roger

02-09-2009 04:43 AM
Roger

Hi, I have a bound form and a bound subform. I have set both to Data Entry = Yes. When I input entries on the form, no records get created until I...

audrey.nsh@gmail.com

02-09-2009 04:41 AM
Mike P

I am using a RecordSet to assign each persons name from the RecordSet as the ControlSource of a TextBox. There are about 50 names and about 84...

Phil Stanton

02-09-2009 04:34 AM
Neil

Perhaps it's been too long since I worked with MS Access workgroup security but something doesn't make sense to me. Can someone please refresh my...

Bill E.

02-09-2009 02:37 AM
Keith Wilby

I have a form containing student details that has a linked continuous subform that contains the details of courses attended by each student. ...

Wayne

02-08-2009 08:41 PM
Wayne

Other than with Access 97 RunCode macro command, can a macro be used to set value of a global variable?

MLH

02-08-2009 03:46 PM
Neil

Hi all, I ran to a very strange problem last week: One of my clients is running an acc2k app for years. So now he wants to share the backend...

Arno R

02-07-2009 05:45 PM
Arno R

We have a database that has one to many to many relationships. one to many autoid ID1 in the main table and number ID1 in the first multi...

sparks

02-07-2009 01:49 PM
tina

Hi Im running a query from excel that takes a few values from the spreadsheet and inserts it into an access db. When i try to run the query i get...

paul

02-07-2009 01:24 PM
tina

My database is corrupting around 10 times an hour at the moment while designing forms. The database is using a SQLServer 2008 Express backend and I'm...

Astley Le Jasper

02-07-2009 10:41 AM
Astley Le Jasper

Hi all, What's the best way to "remember" the position of a form when it's closed down and re-opened? If you have code to share, that would be...

Andy

02-07-2009 02:59 AM
John Mishefske

I am trying to fix my report. I receive the following error when I attempt to run my report: The specified field qryHSFTageEdu. could refer to more...

zufie

02-06-2009 08:39 PM
tina

On Feb 6, 3:09*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Yeah, I have to get used to that whole "it's not a reference,...

robert.waters

02-06-2009 08:36 PM
robert.waters

Yep. Thanks David. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to...

Paul

02-06-2009 07:56 PM
Allen Browne

Give the difference between ado and rdo

Agile Consulting

02-06-2009 12:50 PM
robert.waters

All, I have inherited a DB with a single table showing: MemberName |Group |EmailDate|Status,...

GM7

02-06-2009 12:47 AM
CDMAPoster@FortuneJames.com

Gentlement, Ladies, I've been reading the threads about slow performance in Access 2007. I'm going through the same. And i don't seem to be able to...

monicaroman@yahoo.com

02-05-2009 07:25 PM
Allen Browne

I'm trying to build a little tracking system for a non-profit. They are all paper-based and have lost client requests a few times - can...

sara

02-05-2009 03:06 PM
sara

I try to insert many records from an Exceltabel and using this code: rst3.Open "tblSprofil", cn1, adOpenKeyset, adLockOptimistic, adCmdTable With...

Helge's

02-05-2009 06:51 AM
The Frog

I recently upgraded my pc to Windows Service Pack 3. I am working on a new client software delivery. I keep the latest code in one central location...

PW

02-04-2009 01:22 PM
Salad

On Jan 30, 9:22*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Thank you for the reply, your gues has led me to think the...

Heather

02-04-2009 10:55 AM
Heather

All, I have a Crosstab Query that deals with dates and incidents on dates for individuals within Groups. For example, it shows me the days Fred,...

GM7

02-04-2009 08:36 AM
GM7

My first question is: I have an 'opportunities' table/form that my users need to complete. I want them to select from a 'customer contacts' table...

Astley Le Jasper

02-04-2009 08:28 AM
Astley Le Jasper

Hi I am playing around with an Access 2007 project with a SQL 2005 back end. I have created a very simple form, which works perfectly, until I...

Andrew

02-04-2009 06:55 AM
Andrew