Hi - I am trying to get a report that will show 12 months of data for a Department (or less if fewer than 12 months are on file), BUT the user is...

sara

10-27-2009 06:03 PM
sara

I'm trying to update a table using as criteria selections made on a form with a combo box and a multi select listbox (lstproducts). The combo box...

Gordon

10-27-2009 09:08 AM
Gordon

A new user loaded my program onto her computer and began entering data. A number of macros had already run successfully before she got to one that...

Tomahawk Lady

10-27-2009 06:24 AM
Tomahawk Lady

I've set the record source of a subform to be a SELECT TOP N query. The problem is that Access appears to perform the TOP N before the implied WHERE...

Randy Yates

10-26-2009 11:28 AM
Krzysztof Naworyta

I am wondering what methodology you use, if you use FindFirst, to find exact matches in a string. If one uses linked tables, one can't use...

Salad

10-26-2009 07:26 AM
hbinc

Dear reader, In a datasheet form you have the possibility to set the field property Enabled to No. With this property you lock the field to...

Simon

10-26-2009 04:02 AM
Phil Stanton

Hi, This must be a problem which lots of people get on a daily basis, but so far I haven't been able to find a solution. I am using Access 2003 as a...

Bobby

10-24-2009 06:15 PM
Chuck Grimsby

I have a continuous form and I'd like to put a separator line after every 5 records. I've searched and can't find an easy way to do this. Any...

Jill McCarthy

10-24-2009 06:03 PM
Jill McCarthy

I have HTML color codes stored in fields - how do I convert these to accurate Access color codes that can be used to set background colors to Access...

Malcolm Hind

10-24-2009 06:02 PM
Chuck Grimsby

I need some advice on the design for a sales lead database. I have 4 tables (salespersons/products/postcode area covered/sales leads). Each...

Gordon

10-23-2009 06:15 PM
Gordon

Perhaps some will find the following useful. With more and more date fields showing up on forms lately, I decided to try to come up with a better...

James A. Fortune

10-23-2009 02:26 PM
James A. Fortune

I have a Report that contains a column of percentages (one at the end of each of the six rows). I have the Percentages Total textbox at the bottom...

zufie

10-23-2009 11:33 AM
paii, Ron

I have an A2000 mdb that works OK on one computer. I have transferred the mdb to a second computer and all is good except that when I click the...

Karl

10-23-2009 10:28 AM
Karl

HI All, My company is switching from Groupwise to Outlook 2007 and so I need to change/test all my applications that have email functionality...

bobh

10-22-2009 08:51 PM
Lou O

Hi I am interfacing an Access database to an SMS gateway and wanted to display the length of the SMS body as the user inputs it. I have tried to...

John Paterson

10-22-2009 08:36 PM
Lou O

Hi, I have been trawling round the net trying to find an answer to this, but all the solutions I have found so far have given me errors. I have a...

Kroaky

10-22-2009 08:01 PM
Allen Browne

Hello, I have a continuous subform within a form. Behind a button on the form, I included validation checks to ensure that various fields (on both...

Odd

10-22-2009 04:34 PM
Odd

I am working with an ocx control, that refuses to be instantiated directly through code. So, I thought I would employ a little "workaround." I...

Vincent

10-22-2009 10:26 AM
Vincent

We have an MDB that will need to impersonate a system user rather than the user using it. IT will assign the security groups surrounding...

Bob

10-22-2009 09:44 AM
Bob

Hi everyone, I'm trying to write a past append qry and as this is the first time I've had a go at it, I think I am way off the mark. I've got two...

Stinky Pete

10-21-2009 07:17 PM
Stinky Pete

Hi, I am using the dynaPDF solution for printing reports to PDF documents. On my own machine using the full Access 2003 it works fine. However, on a...

franc sutherland

10-20-2009 03:38 AM
franc sutherland

Access 2003 Listbox.AddItem w / 5 Columns Is Incredibly Slow As one can see from the function / code below I create a recordset with 5 returned...

JustBoo

10-19-2009 06:46 PM
rquintal@sympatico.ca

Hi - I haven't done anything in Access in a few years now and I'm blocked! I hope someone can help. I have data in a table: Key AccountNumber...

sara

10-19-2009 06:33 PM
sara

I have a CrossTab query that needs to use some values from a Form in its Where clause: TRANSFORM Sum(ContractProfitsTaken.ProfitTaken) AS...

Jim Devenish

10-19-2009 11:26 AM
fredg

After upgrading to 2007 i get a Query is too complex error on one of my queries. Here is the SQL statement. SELECT ProjectSnapshot.WBSID,...

koturtle

10-19-2009 10:01 AM
Milhouse Van Houten

I am designing a simple A4 portrait report. The report has two columns. If I set the column layout to "Across, then down": The report looks fine,...

Paul H

10-19-2009 03:04 AM
Paul H

I have a problem with an Access 2002 db deployed in an Access 2003 environment. I can change the permissions for tables for individual users, but not...

Bob Darlington

10-18-2009 09:01 PM
Bob Darlington

I am using an external linked GIF file as the picture on an image control Does anyone know the code to print this image (probably to the...

Phil Stanton

10-16-2009 04:48 PM
Phil Stanton

I have and A2000 database with a Pop Up form. It works fine on a desktop but on a new laptop it won't open until I set the Pop Up property to No. The...

Karl

10-16-2009 03:49 PM
Karl

Converted an Access 2003 app to an Access 2007 application with a main form and several subforms. Office SP2 Installed. On a combobox on one of...

akg

10-16-2009 02:13 PM
akg

I'm trying to export a query to excel file using VBA. I can export the data only once, successfully. The code runs fine every 1st time after reopen...

shanq

10-16-2009 01:14 PM
MGFoster

Hi, I have a purchase order table that has a yes/no tick which triggers an add as asset form. At this point other detail such as serial number of...

don

10-16-2009 01:10 PM
Salad

Access 2007 running on Windows XP. Report is a multipage letter format and Access is not handling paging correctly when a text field, which can span...

bontemps

10-16-2009 11:59 AM
bontemps

I have a table containing profits taken (transferred) from contracts. There is either zero or one entry per month for a contract. The day of the...

Jim Devenish

10-16-2009 11:11 AM
Jim Devenish

Access 2003 SP3, Windows XP Pro, FE/BE’s on a LAN. The Macro Security Level is set to low in our applications. An interesting find that may prove...

Bob

10-16-2009 08:46 AM
Bob

Hi, Instead of hard coding the actual name of the menu, how would I scan through a table or query replacing the references in the following code...

PW

10-15-2009 05:47 PM
PW

Hello All I have the following code which I am using to dynamically change sub- reports on a master report. Do Until rs.EOF ReportToPrint =...

Trevor

10-15-2009 03:28 PM
Trevor

Hello Importing data from txt file by ISAM (schema.ini configured) accours Error 3349 as in the topic For some reason on Eng Win2000 with installed...

Maciej Franciszkowski

10-15-2009 11:27 AM
Maciej Franciszkowski

I self taught myself enough to create a database for keeping track of stock transactions some time ago. It's worked fine for probably more than year...

Gord

10-15-2009 11:07 AM
timmg

In AccessXP I use the following vba code to email a message thru GroupWise, the company I work for is changing to Outlook and I need to re-write this...

bobh

10-15-2009 10:09 AM
bobh

Hello, I'd like to put security type tables in a small separate database instead of where the rest of the data is located (in case either...

PW

10-14-2009 11:42 PM
Tom van Stiphout

Hi Everybody Access 2007 I have a form based on a query that does NOT include the primary key autonumber And I am trying to use the "Duplicate"...

bobdydd

10-14-2009 05:55 PM
Marshall Barton

I'm running an Access 2003 mde in Access 2007 runtime. Although I can replace the default menu bar with one of my own when I run the mde in Access...

terry

10-14-2009 05:44 PM
terry

Using A2003. I've got a 2-page report with several totals in the report footer. The totals preview and print just fine when printing both pages but...

emanning

10-14-2009 03:48 PM
emanning

In previous version os Access, there was a Duplicate command on the Edit menu. It could also be called by hitting Ctrl-D. If you were in form or...

BB

10-14-2009 03:34 PM
Marshall Barton

Hi, I have an Access 2000 database that we have many Groups created in it which we are now trying to use in Access 2007. Each year we add a new...

bcap

10-14-2009 01:51 PM
bcap

For the moment, Google Search is finding old posts. Thanks Google. Does anyone sell a searchable archive of this NG? If not, it's ironic that no...

James A. Fortune

10-14-2009 12:50 PM
bobh

I keep getting this error Run time error 2501 This SendObject action was canceled. This is my code: Private Sub cmdMailTicket_Click() On Error...

shanq

10-14-2009 12:19 PM
shanq

Hi I have been using Access 2003 to Export Values to produce time sheets for Invoices as raw data. Some time sheets are produced OK as Reports but...

CobaltHayabusa@aol.com

10-14-2009 04:23 AM
CobaltHayabusa@aol.com

I'm working on a legacy app that uses separate date and time fields. Yet, they should probably be combined -- especially now that I need to do a...

Jeff

10-13-2009 08:04 PM
Jeff Norville