So, I'm using my favorite search code from here: http://allenbrowne.com/ser-62code.html Once I have everything filtered on the form, the users want...

musicloverlch

01-13-2012 10:16 AM
Patrick Finucane

Hi: A subquery has me stumped. Suggestions appreciated... Simplified sql is Select Field1, Field2, (Select Max(FieldA) from tblEvent...

Tom

01-12-2012 07:33 AM
Tom

This is a follow up to previous unresolved thread which was getting a bit messy. I have a multi select (extended) unbound list box which has a...

Bob Darlington

01-12-2012 02:51 AM
Bob Darlington

Dear Access gurus, I am retrieving data from Access into Excel through ADO. It is quite slow. The data are retrieved from an Access queries. Will it...

Lane

01-12-2012 02:32 AM
Albert D. Kallal

Global Business Intelligence (BI) software vendor, Yellowfin, has released a new white paper that explores the need for, drivers and potential...

janette.pelletier@yahoo.com.au

01-11-2012 07:41 AM
janette.pelletier@yahoo.com.au

I am trying to interface Access 2010 with google calendars. I have a nice calendar program, ans want to be able to upload and download events to...

Phil

01-11-2012 04:53 AM
Phil

Hi Access experts, Does anyone know the ADO connection string used for connecting to a password-protected Access 2010 database? So far, I can...

Lane

01-10-2012 08:02 PM
Lane

At work I have an Access 2002 mdb all set up and working, and security is working fine, except: I have created a special admin group for this db,...

croy

01-10-2012 10:20 AM
croy

Background - I have app for managing cattle (UK) If a calf is an Embryo transfer then and will be different. If the calf is natural then the 2...

David B

01-10-2012 04:00 AM
David B

I have files that are too big for excel to manipulate and need help breaking down the data in access. Below is a sample of 3 lines of data for...

Andrew Swartz

01-10-2012 03:43 AM
Phil

The following is a follow up to a previous post. I'm using Access 2010 with a form containing a multi select list box. The code I'm using for the...

Bob Darlington

01-09-2012 04:59 PM
Bob Darlington

Using Access 2010 I want to open a report in Print Preview, and at some point, have the option of saving it as either an RTF or PDF Have tried the...

Phil

01-08-2012 05:34 PM
(PeteCresswell)

Hi, My buttons are appearing on top of each other by default, like a grid I suppose. Is it possible to make them appear next to each other...

PW

01-07-2012 12:05 AM
PW

I'm using Access 2010 with a Multi Select - Extended list box. Can anyone explain why the Click event should get called when the KeyPress or KeyDown...

Bob Darlington

01-06-2012 06:32 PM
Bob Darlington

I am trying to create a query (if possible) that will add certain numbers over a specified number of rows. The situation is a greenhouse in which...

Keith

01-06-2012 03:05 PM
Keith

Dear Access gurus, I am not sure if using DLookup inside a user-defined function and then using that function inside a query is forbidden. When I...

Lane

01-05-2012 09:33 PM
JHB

I have a form with a subform that Supervisors use to paste in phone stats. When the Supervisor tries to paste in phone stats for an agent and date...

faraa

01-05-2012 10:41 AM
faraa

Hi Access experts, I would like to retrieve data from Access using Excel VBA through ADO. This was successfully done in the past until a...

Lane

01-05-2012 09:38 AM
Bob Barrows

I am working with an accdb Microsoft Access database that is going to posted to a SharePoint server via Access Services. Everything I have is web...

Ryan Cunard

01-05-2012 05:01 AM
Albert D. Kallal

I have been working with one particular database - my Repair Database - which is an order entry / shipping program for selling repair parts for our...

BrianDP

01-04-2012 10:59 AM
BrianDP

Greetings. Long time no post. I need to play with documents stored in a SharePoint system. Can anybody point me at a suitable book or Web site that...

boatbloke

01-04-2012 06:29 AM
boatbloke

Dear Access gurus, I am not sure if I should address this question to Excel or Access experts. Sorry if I posted on the wrong group. I would like...

Lane

01-03-2012 10:50 AM
Bob Barrows

Hi, More and more clients are talking about using the 'cloud' and going online. I use Access 2003 and 2010. What are my options for going online? Do...

franc sutherland

01-03-2012 08:30 AM
franc sutherland

I'm using Access 2010 with a form containing a list box. The code I'm using for the KeyPress event in the list box, calls the after update event for...

Bob Darlington

12-30-2011 06:41 PM
Bob Darlington

I'm looking to create a scheduling program for appointments. I was looking at the ActiveX components in Access 2007 and couldn't find anything that...

Ecovindaloo

12-30-2011 08:54 AM
Ron Paii

Access 2003. Hi I need to construct a query that selects multiple criteria to return but do not want to hard wire the criteria into the query. Can...

donh

12-29-2011 07:03 PM
Albert D. Kallal

The latest newsletter from FMS, Inc., maker of software developer tools and utilities, carried an article informing us of the death of Mike Groh. ...

Access Developer

12-28-2011 11:06 PM
Albert D. Kallal

I found some code for generating a list of the number of occurrences of a word in a Word...

Christopher M.

12-28-2011 04:12 PM
Christopher M.

For Access10 I need an expression to search for currency numbers that will add up to a certain figure. For example, if the books are out by...

Peter Jason

12-28-2011 01:13 AM
Peter Jason

How do I get a form to return to the same record after I requery. At the moment every time I requery the form returns to the first record in the...

FireyColin

12-27-2011 02:23 PM
Phil

I've got a line of code that opens a form - passing a sizable string in .OpenArgs. One of the references has started throwing a "Method or...

(PeteCresswell)

12-25-2011 07:00 PM
Tony Toews

I have a program I'm running in Access 2007 that automates Excel. It needs to create a large number of columns in one worksheet (somewhere in the...

septimus

12-24-2011 02:04 PM
septimus

Hi NG I have two dropdowns, that sorts on IDnumber and IDtext...both ASC... I made two queryes for the dropdown... 1 - with IDnumber in first colown...

bsn

12-24-2011 12:25 PM
Access Developer

I have a formula, but it is not calculating correctly. AvgCostPerGal:...

misscrf

12-22-2011 09:37 PM
misscrf

Does anybody have the code to link to an Outlook Global Contacts list using the Docmd.TransferDatebase method?

Patrick Finucane

12-22-2011 08:48 PM
Patrick Finucane

Have any of you used InfoPath with Access at all? What's your success with it? It looks like a pretty cool product.

Patrick Finucane

12-22-2011 08:37 PM
Patrick Finucane

MS Access 2002 on Windows XP... I've been assigned to a database where data-entry is done twice, and then it is to be "cross-checked" for data...

croy

12-22-2011 08:27 PM
Patrick Finucane

I have a number that may contain a decimal portion: 1.00, 1.33, 40.25. I need to separate this number to two different fields: 1 and 0, 1 and 33 and...

Annette

12-22-2011 05:44 PM
Access Developer

I have a subform with various columns. At the top of each column there is a button that the user can click to sort the form using the column...

buckskin

12-18-2011 12:52 PM
buckskin

Hi I am trying to find a way to change a text field from UpperCase To ProperCase and back again with another doubleclick but it is not working. Can...

bobdydd

12-17-2011 07:42 AM
Douglas J Steele

Why when I boot up one version after running another does this install process still have to be run? What is "MS Office Single Image"? Is this what...

PW

12-16-2011 03:21 PM
PW

Dear Access gurus, May I know if it is possible to have a software update feature for Access application? The Access app will update its front-end...

klar

12-16-2011 05:35 AM
Stuart McCall

I Have a main database with 120 forms and a referenced database with 36 forms - Yes I know its big. The following code is in a form in the...

Phil

12-15-2011 09:49 AM
Phil

frmGlobals!GetVisible = False gobjRibbon.InvalidateControl ("grp3") frmGlobals!GetVisible = True gobjRibbon.InvalidateControl ("cmd22") In the...

Norman

12-14-2011 04:12 AM
Albert D. Kallal

Hi I'm trying to produce a procedure that will create a new instance of a form whose name is passed as a string to the proc. I know I can do it this...

Wilhemina

12-12-2011 10:45 AM
Jon Lewis

"David W. Fenton, age 49, of Weehawken, New Jersey, formerly of Chesterfield, IL passed away Tuesday, Nov. 1, 2011 at his...

Albert D. Kallal

12-12-2011 12:08 AM
Tony Toews

I'm using Access 2010. I have a tab form with a list box (exposed to all tab pages). If I reset the recordsource for the main form, and then set the...

Bob Darlington

12-11-2011 10:51 PM
buckskin

I've got (among other things) an Excel and a Word button on a ribbon bar. They each call the following code which works as intended, but Excel...

Bob Darlington

12-11-2011 05:46 PM
Bob Darlington

"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote I used a Tab Control with Subforms to experiment with a similar form...

Patrick Finucane

12-11-2011 10:47 AM
Patrick Finucane

Many of us have encountered the problems with continually having to decompile Dbs after applying SP1. Has the problem been fixed, and if so, what is...

Phil

12-10-2011 02:45 PM
Patrick Finucane