Using Access 2010. I've designed (with much help from this ng) a set of custom ribbons for my app. I now want to hide the QAT items (which I've...

Bob Darlington

12-21-2010 06:01 PM
Bob Darlington

I have two tables of the same structure, ID and Location. I would like to run a SQL query and end up with two identical tables. Adding Locations...

ck

12-21-2010 10:39 AM
Marshall Barton

Can the Backstage items 'visible' property be reset through a custom ribbon XML, or only for the entire database by selecting an application ribbon...

Bob Darlington

12-21-2010 02:24 AM
Albert D. Kallal

I'm using Access 2010 and the default print preview ribbon. When I open a report and select the Excel button, the 'Export Excel Spreadsheet' dialog...

Bob Darlington

12-21-2010 02:06 AM
Bob Darlington

We have the French version of Office 2010 Pro. I connect to a ODBC link and it includes a field named 'RATE' (which is the currency exchange rate). ...

saintor1@hotmail.com

12-20-2010 02:00 PM
imb

Repost: Using Access 2010. When I set the Control Bar Align property to 'Left' for a List Box using the Property Sheet, nothing happens. The scroll...

Bob Darlington

12-19-2010 09:38 PM
Bob Darlington

Hello I know I can undo a certain number of design changes I make, but how do I return to the last saved state of my app? I have almost...

Joost

12-18-2010 03:16 PM
Marshall Barton

I've created a crosstab query and I need to get the totals by quarter. It works but I can't seem to get the quarters in order. For example right...

Ecovindaloo

12-18-2010 02:10 PM
John Spencer

In Access 2007, my cursor sometimes behaves badly. Ex: Instead of automatically changing to the correct type of sizing handle as the mouse moves...

pemigh

12-18-2010 01:42 PM
pemigh

I've come across a curious problem in Access 2003: If I set the OrderBy Property to: Me.OrderBy = "dbo_Task.sim_date, dbo_task.name" it works...

Jacob

12-17-2010 03:01 PM
James A. Fortune

I am using Legan's RTF2 control. I am trying to send the RTF text via an Outlook email. No problem sending normal, plain text. Anyone know how to...

Bob Alston

12-17-2010 02:03 PM
Bob Alston

Hi Group I have a table with data stored like below: Date MCName PBNo 01/01/2009 CM1 1 01/01/2009 RS2 ...

The Pipe

12-17-2010 09:06 AM
The Pipe

Dear All My report open event has the following code Private Sub Report_Open(Cancel As Integer) Dim strDocName As String strDocName =...

Shakeel

12-15-2010 02:00 PM
Access Developer

I need some help here. It might be something diffferent in ACC2007/2010. Unless I am mistaken, before I used a form's filter to open a report. ...

saintor1@hotmail.com

12-14-2010 12:38 PM
saintor1@hotmail.com

I'd like to use application.setOption to change the document window options from 'overlapping windows' to 'tabbed documents' but online help only...

Roger

12-13-2010 06:32 PM
Roger

When I set the Control Bar Align property to 'Left' for a List Box using the Property Sheet, nothing happens. The scroll bar continues to display to...

Bob Darlington

12-13-2010 05:10 PM
Bob Darlington

Here is a bit of code from the middle of a long module for creating a Mail merge data file If Left(strSQL, 10) = "PARAMETERS" Then Stop '...

Phil

12-13-2010 03:50 AM
Phil

I've just started out with XML and customised ribbons for one of my distributed applications. I have 3 ribbons (one each for switchboard forms, other...

Bob Darlington

12-12-2010 11:59 PM
Bob Darlington

Hi all, Using A2007. I'm using an append query to load data into a temporary table. The query works fine when I run it from the query view. But...

franc sutherland

12-12-2010 07:39 PM
Tony Toews

Here is a bit of code from the middle of a long module for creating a Mail merge data file If Left(strSQL, 10) = "PARAMETERS" Then Stop '...

Phil

12-12-2010 05:48 PM
Phil

I have been connecting to mysql tables from ms-access vba through odbc connection string and everything is ok. when I try to create a permanent...

tele

12-10-2010 10:46 AM
The Frog

if I have an error handler like this on error goto fErr .... .... fExit: exit sub fErr:

Roger

12-10-2010 09:38 AM
Bob Barrows

Confusing behavior toggling the footer visible. Before I split the database this worked very quickly, now it disappears fast but when I make it...

christianlott1@yahoo.com

12-09-2010 11:53 AM
christianlott1@yahoo.com

Hi I have a Maintenance database with a form with a tabbed page that has a feedback subform on one of the tabs. I have a report form with a query...

don

12-09-2010 08:43 AM
don

International Business Intelligence (BI) vendor, Yellowfin, has released the new version of its BI solution – Yellowfin 5.1 Socialize, Visualize &...

JTP PR

12-09-2010 06:24 AM
JTP PR

I am having trouble getting the properties of a table. I have an Access.mdb front-end with the data tables linked from a back-end access.mdb file. ...

Bob

12-08-2010 05:45 PM
Bob

"Object doesn't support this property or method" for: ctl.Form.InsideWidth Forms!frmmain!frmFormView!(ctl.Name).ScrollBars = 3 Private Sub...

christianlott1@yahoo.com

12-08-2010 03:19 PM
Marshall Barton

Sorry but I have got stuck on the simple things. Don't want to use auto number. I have a REF Field starting at 101. I want to increment this by 1...

Paul

12-08-2010 08:43 AM
John Spencer

Hi All, I have an AccessXP database that I use to produce a month end report. I've used this db for the past 3 years without any issue until...

bobh

12-08-2010 08:37 AM
John Spencer

It seems like this ought to be easy, and I'm sure it is, I just haven't figure out how to make it easy. I have data in a secondary table that I have...

Tim Olson

12-07-2010 08:51 AM
Tim Olson

Finding the best beer by geography We kicked-off the selection process by perusing an awesome web site www.beerme.com , which has a great beer list...

JTP PR

12-06-2010 06:35 AM
JTP PR

Have written a system in Access 2003 that uses automation to open Word and display a document. No prob - works fine. But for some users I want to...

Dave G @ K2

12-06-2010 05:42 AM
Jon Lewis

I have a rather complicated procedure which includes a SQL statement in which I need to add a further criterion which is the field P.Cancelled (a...

FireyColin

12-05-2010 06:15 PM
Ken Snell

Hi, When I use DoCmd.FindRecord "#", acStart in a form, the form shows a record that starts with a number. But I want to go to a record that...

imb

12-05-2010 05:39 PM
Marshall Barton

I need to do a report with graphs for the data below. Specifically, I need to create a graph per store ID with all the quantities for that store in a...

Joe Smith

12-05-2010 07:27 AM
Arvin Meyer

Hi all, I wish I could get my head around access.Probably need to take a formal course. Anyway, I have an A-2007 database of plant information for...

TimK

12-04-2010 01:51 PM
TimK

I have installed a program called PdfCreator to use alongside an Access2K program. I include a Reference to it (the program resides in C:\Program...

Jim Devenish

12-03-2010 07:09 PM
Clif McIrvin

Hello NG Somebody with experience in Access on PDA... Bjarne

ngs

12-03-2010 02:46 AM
bsn

There is no ROI in Business Intelligence; unless you make a decision. Yellowfin has launched its 5.1 release to an expectant international audience...

JTP PR

12-02-2010 06:41 AM
JTP PR

Hi all, For those who are interested..: Last week I posted a question: 'Slow multi-user application, 1 user is fine...' Problem (slowness) occurred...

Arno R

12-01-2010 07:15 PM
Allen Browne

In a medical application, the client needs to lock the patient's daily record after a supervisor has reviewed and "signed" that day's input. Can I do...

Nance

12-01-2010 09:53 AM
Nance

If I create a report and drag the chart onto it I get a MSGraph.Chart.8. This is the same version of the graph I have on all the reports updated...

Phil

12-01-2010 08:24 AM
Phil

I had data set up as MailTo hyperlinks. I broke up a large table into three tables but discovered all the MailTo hyperlinks are now just web address...

Duncan

12-01-2010 08:04 AM
Duncan

Hi Everyone, I am working with an FE / BE that uses the JStreet Access Relinker to reconect tables when the BE is moved or replaced. This seems to...

The Frog

12-01-2010 05:33 AM
The Frog

I have the following function that usually works but occassionally, the "DoCmd.RunCommand acCmdZoom100" statement fails with a The command or action...

Roger

11-30-2010 08:44 PM
David-W-Fenton

Hi Everyone, Is there a way that the page setup properties for a report, such as page size, orientation, margins can be obtained without needing...

The Frog

11-30-2010 06:55 PM
Tony Toews

Hi Is it possible to embed the query design mode screen into a form? I would like to be able to allow users of my solution to edit and create new...

KatieK

11-30-2010 03:19 AM
The Frog

I am trying to get a simple archive process working on a simple database ( archiving data from a basic customer table) and I keep getting this error...

Sue

11-29-2010 04:51 PM
James A. Fortune

This query runs OK SELECT Hosts.* FROM Hosts; but SELECT DISTINCT Hosts.* FROM Hosts; gives an error (No number) "The field is too small to accept...

Phil

11-28-2010 05:03 PM
Phil

The Frog <mr.frog.to.you (AT) googlemail (DOT) com> wrote in news:a657974b-bdde-416c-85fd-e1dfb3ae7017 (AT) u10g2000yqk (DOT) googlegroups.co m: I...

Marlène Gagnaire

11-27-2010 07:13 PM
Tony Toews