I have created a report with a few concatenated fields, I want to be able to hide some defaults I have created in the concatenated field. For...

Dave

11-01-2011 05:43 PM
Patrick Finucane

I have created a report with a few concatenated fields, I want to be able to hide some defaults I have created in the concatenated field itself. For...

Dave

11-01-2011 04:43 PM
Dave

On 31/10/2011 16:07:49, "christianlott1 (AT) yahoo (DOT) com" wrote: Thanks Christian Don't thin that helps, but I will look into it forther. I am...

Phil

11-01-2011 04:23 PM
christianlott1@yahoo.com

Thanks for the link. Looks like I can customize this to my need. ;-) On Fri, 21 Oct 2011 10:29:37 -0700 (PDT), "christianlott1 (AT) yahoo (DOT)...

JackonLI

11-01-2011 03:19 PM
Access Developer

I have a provider report that has a group footing at the provider name. I would like to run this report and save the output of the report as a .pdf...

Annette

11-01-2011 12:05 PM
Patrick Finucane

We had a guy here make determinations on a table(s) and replaced missing values with numbers. something like if missing -9, unsure -3, etc so now...

sparks

11-01-2011 07:51 AM
Bob Barrows

Access 2010. I am finding it difficult to find records using FindFirst. In the code below I open the same file in two recordsets. The...

Patrick Finucane

10-31-2011 05:42 PM
Douglas J Steele

When sorting and grouping in Access 97 reports (I know, I know, it was inherited). Is there any way to separate the group from the sort in the...

John

10-30-2011 11:11 AM
Joan Wild

Like the subject says - is there a way (some button or dialog I can't seem to find) to use the DISTINCT parameter (as in SELECT DISTINCT) in the...

exapplerep@gmail.com

10-27-2011 03:01 PM
Access Developer

I have downloaded Stephen Leban’s SubClassFormatByCriteriaVer45.mdb database which creates coloured rectangles over fields in a continuous form. I...

Phil

10-27-2011 05:29 AM
Phil

Has anyone noticed this and if so, is there a fix? The problem appears when running a database that has been been converted from A2003 to an A2007...

Wayne

10-27-2011 04:17 AM
Wayne

I would like to use a tab control but I need to know which page/tab has been selected. Which one is the active tab. I don't see a property for...

PW

10-26-2011 01:02 PM
PW

I need to format a currency field to export to an excel file. The field must be numeric, zero fill and in the format of 00000010.00 (10 dollars), for...

Annette

10-25-2011 09:08 AM
Bob Barrows

Ich habe A 2010 auf dem Rechner. Versucht habe ich es so: Set db = ws.CreateDatabase("D:\Test.mdb", dbLangGeneral, dbVersion30) Klicke ich auf die...

Jürgen Meyer

10-25-2011 05:16 AM
Jürgen Meyer

I have a continuous report to print placr name that has a picture and a name. The picture is the same ineach case. The report is 2 columns with 7...

Phil

10-24-2011 06:27 PM
Phil

I have Access10. How can the horizontal lines be put back into the design window? Peter

Peter Jason

10-24-2011 05:48 PM
Peter Jason

I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource...

Roger

10-24-2011 05:35 PM
Bob Barrows

Hi there, I am looking for the way to represent data with the similar column value to one row. A query retrieves 3 records AS IS, but I need one...

Alex aalkor

10-24-2011 05:30 PM
Bob Barrows

I want to be able to double click on the embedded image file in a image control and have that image open in windows picture viewer. Anyone know how...

christianlott1@yahoo.com

10-24-2011 07:45 AM
Jon Lewis

I have a 7 page standardized gov't document I will need to print out as hardcopy in the future. I am wondering what method you used in the past that...

Patrick Finucane

10-23-2011 03:19 PM
BobAlston

Yellowfin, the leader in easy-to-use Business Intelligence (BI), has been recognized in Gartner’s annual Who’s Who in Mobile BI report. The 2011...

Jan

10-20-2011 10:02 PM
Access Developer

I have a form that is in datasheet view and each record contains about 10 fields. I would like to give the user an option to select records they wish...

Annette

10-20-2011 04:12 PM
Patrick Finucane

Anyone have any experience using the MUST upsizer which converts Access data to SQL combined with the +Web which converts Access forms to...

BobAlston

10-20-2011 01:45 PM
andy@ascassociates.biz

SendKeys causes a debugger interruption in Windows 7. I posted the message below to Windows 7 group, and got sympathy, but no solutions to the...

Paul Brady

10-19-2011 09:00 PM
Paul Brady

I've been experiencing a really annoying problem for quite some time that I assume is being caused by some type of software conflict because the...

Wayne

10-19-2011 11:06 AM
Patrick Finucane

I have a form with a button on it that basically previews an invoice (Report) based on the form. If I try to print the report I get an error message...

Phil

10-19-2011 04:43 AM
Phil

Interesting. I'm using A2007 with a custom QAT (quick access toolbar) created via the USYSRIBBON table. If a user has the standard QAT in their...

zuckermanf@gmail.com

10-18-2011 08:19 PM
zuckermanf@gmail.com

A2007/A2010. I have a form I call from the another form's command button. Docmd.OpenForm "SummaryData" The form SummaryData summarizes data that...

Patrick Finucane

10-18-2011 11:06 AM
Patrick Finucane

"Ed J." <ed (AT) smbpartners (DOT) com> wrote Because initially I thought it *had* to be done through manipulating to form but it might be...

buckskin

10-18-2011 07:59 AM
Bob Barrows

I have a single front end database, and a number of alternative BE databases that can be linked in; call them BE1.AccDb and BE2.AccDb. I then open a...

Phil

10-17-2011 12:32 PM
Phil

Hi, Up until two weeks ago, I was quite happily using the sendobject function to send a message (I am using Office 2010 professional). However, all...

Peter Morris

10-16-2011 02:42 AM
Peter Morris

In Excel 2007/2010 I miight save the file as Junk and I end up with Junk.Xlsx. Then I can do a SaveAs and save it in another earlier version and I...

Patrick Finucane

10-15-2011 10:53 PM
ML

Hi, I have an Access 2003 DB where the Mailto function was working fine when users were on Lotus Notes email system. The organisation recently moved...

Yvonne

10-15-2011 11:16 AM
Yvonne

I was using A2007 yesterday and today moved to 2010. And the same feature, one I don't particularly care for, exists in both versions. I have set...

Patrick Finucane

10-14-2011 05:25 PM
Patrick Finucane

I have a database originally created in A97, since migrated to A2000 that uses the SetMDIBackGroundImage function by Stephen...

kyle

10-14-2011 04:24 PM
kyle

Hi, I would like to be able to take records from an Access database (most likely 2010) and update them to whatever database is being used on a web...

PW

10-14-2011 02:14 AM
PW

Hi All With the exception of one combobox: Is there a way of disabling all other controlfields on a form without listing all of them...

Vacuum Sealed

10-12-2011 07:48 PM
Vacuum Sealed

Has anyone got any experience of identifying slow moving stock via queries?

BobbyDazzler

10-12-2011 05:31 AM
The Frog

The problem code: ------------------------------------------------------------------ targetRS.FindFirst "DocumentName_App='" & !DocumentName_App &...

(PeteCresswell)

10-11-2011 04:18 PM
Duncan

Hi All, In AccessXP I'm trying to add a link to the message body of an email using cdo and it would appear to work except when the link has...

bobh

10-11-2011 04:15 PM
bobh

baanitem is a combobox with an existing value when the rowsource is changed, that value is no longer valid, so I want to clear it the...

Roger

10-11-2011 12:24 PM
Roger

I have a database written in Access 2002. It runs just fine on 2003 and 2007. Now a new user with 2010 is getting a message, "cannot verify the...

Nance

10-10-2011 04:40 PM
Nance

I am looking up the first record in a list that is sorted by date, but it doesn't always return the next record in the list. Here is the code: Dim...

JKRoyal

10-10-2011 01:16 PM
ron paii

Hi all Can anyone help point me in the right syntax direction for the following please... Using a cmdbtn on frmmDirectory, I would like it to open...

Vacuum Sealed

10-09-2011 09:56 AM
Vacuum Sealed

Hi everyone It's been at least 2 years since I have done any Access work as I am doing more in Excel than anything nowadays, that said..!! I have...

Vacuum Sealed

10-08-2011 11:50 AM
Vacuum Sealed

Hi everyone, A few weeks ago, I posted a note about Outlook application coding to which I have had some minor success. It's not there yet, but...

Peter Morris

10-08-2011 07:15 AM
Vacuum Sealed

Hi, Has any taken a table from an Access database and uploaded it to a Google calendar? Is this possible? I would like to take a person's schedule...

PW

10-08-2011 01:13 AM
PW

access2007, sql2005 form bound to a linked table combobox bound to a field (baanItem) with an afterUpdate event the event has a 'stop' statement so I...

Roger

10-07-2011 08:13 AM
ron paii

How to connect to an external access db codeproject for cataloging it's forms queries and reports? There is a CurrentProject and a CodeProject which...

christianlott1@yahoo.com

10-06-2011 05:08 PM
Access Developer

Article Link http://www.yellowfinbi.com/YFCommunityNews-Benefits-of-Mobile-Business-Intelligence-Part-Two-108062 Brief Aberdeen Group on Mobile...

Jan

10-06-2011 01:55 PM
Access Developer