I’m having difficulty in building a qry to remove optout emails. I have three tables which are below that include an ID and email...

CD

10-10-2012 01:10 PM
CD

Hi All, I am looking for some code that will display the "Region and Language" format setting when the database starts. I need all the users to have...

Barry Wright

10-10-2012 09:48 AM
Barry

When I use the following code: Dim db As DAO.Database, rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Select Sum(RentPA) as...

Bob Darlington

10-08-2012 08:06 PM
Gene Wirchenko

I have a rather complex MS Access Application (6.8 MB)we use at work. I would really like to gather all of its objects together as a reference in the...

isobadd

10-08-2012 04:31 PM
Access Developer

Hi,I have two tables which are 1) orchestra and 2) musician The condition is "An orchestra consists of different musicians; each musician services...

anjanitec4020@gmail.com

10-08-2012 10:49 AM
Douglas J Steele

Some of the people here would like to do fancy reports in access. They are trying to do multiple groupings of a report like single record has 3 types...

sparks

10-08-2012 08:34 AM
sparks

I am messing around trying to get font colours that contrast with background colours. My first problem is what appears to be inconsistencies with...

Phil

10-05-2012 09:16 AM
Phil

Data cleansing is the process of uncovering and correcting inconsistent records from a table, a set, or database. This is used mainly in databases to...

kalpanaganeshm@gmail.com

10-05-2012 12:25 AM
kalpanaganeshm@gmail.com

I know I'm being thick I have a function Function RgbToHls(ByVal R As Double, ByVal G As Double, _ ByVal B As Double, ByRef H As Double, ByRef L As...

Phil

10-04-2012 08:04 PM
The Frog

A market research report writing has to convey information that would assist decision-making in business. The report is the means by which one...

kalpanaganeshm@gmail.com

10-04-2012 12:29 AM
kalpanaganeshm@gmail.com

A2010 Hi ... I need to build a form(weekday planning tool)... It should show days for one week at the time... The data shown in the planning tool,...

Bjarne S. Nielsen

10-03-2012 03:24 PM
kduc

I have a packaged program I want to sell from my website. If I zip the package and upload it, when it is downloaded again it won't open "stating it...

Jim Baird

10-03-2012 03:18 PM
bsn

I am having a problem with major slowness of a .accdb database running on Windows 64 bit. I have done everything discussed in this string and...

musicloverlch

10-02-2012 09:57 PM
PW

Hi, I have a combobox on a form that lists names of people. I want the People form to open when the user selects an entry (and have it open up with...

PW

10-01-2012 08:30 PM
Albert Kallal (Access MVP)

I have schedule a vba MsAccess code that execute a Mysql odb connection! every time i find the "mysql connector/odb data source configuration" form...

massimiliano.brambilla@gmail.com

10-01-2012 02:22 PM
The Frog

Has anyone had experience demonstating their Access applications to remote prospective clients using third party software? I understand that Net...

Bob Darlington

10-01-2012 11:51 AM
Access Developer

I try to make it a rule to set my form and report's control source property to a query rather than a table. I am wondering if there is an...

KW

09-30-2012 06:22 AM
Patrick Finucane

Please help me solve this. I have a table city with city and citydata like below san francisco - a,b,f,z seattle - j,a,w,z new york - a, f, j I...

gold.herman@gmail.com

09-30-2012 06:15 AM
Patrick Finucane

I've distributed an Access 2010 application using SageKeys deployment wizard. For a particular client, with Windows XP and Office XP installed,...

Bob Darlington

09-29-2012 07:55 PM
Bob Darlington

Database Database Database Database Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable...

scott93727@gmail.com

09-29-2012 07:33 PM
scott93727@gmail.com

I wrote a report in Access 2003 with a group footer and the property "Force New Page" set to "After Section" When I import it into Access 2010 it...

KW

09-27-2012 02:01 PM
KW

Hi All, In Access2003 I'm using the upsizing wizard to upsize some access tables to SQLServer. On SQLServer I already have the database setup and it...

bobh

09-26-2012 09:04 AM
bobh

DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate:...

scott93727@gmail.com

09-26-2012 04:44 AM
scott93727@gmail.com

I want to select all records that fall between certain dates (12/1-2/29-winter),(3/1-5/15-spring),(5/16-8/31-summer)and(9/1-11/30-fall) regardless of...

Desiree

09-25-2012 04:14 PM
Bob Quintal

Anyone ever implement a Back button in an Access 2010 Web Browser control? It's simple enough to keep track of where the app sends the browser to....

Neil

09-25-2012 03:03 PM
Neil

Hi, I have an Access query that I want to make a pass thru query of and after doing so and trying to run it, it errors with; incorrect syntax near...

bobh

09-25-2012 12:03 PM
bobh

Further to my post of 17 Sept (Expression on click you entered...), I've decided that I need to amend my application by moving function calls in...

Bob Darlington

09-22-2012 07:34 PM
Bob Darlington

Further to my post of 17 Sept (Expression on click you entered...), I've decided that I need to amend my application by moving function calls in...

Bob Darlington

09-19-2012 08:12 PM
Bob Darlington

What is wrong with the statement? Nz(DCount("", "", " = '" & !! & "' and = '" & !! & "'")) I've tried both with and without the Nz and neither...

FireyColin

09-17-2012 04:05 PM
Douglas J Steele

Bob Quintal wrote: I didn't interpret it that way but if you're right, then Frog already had the correct design.

Bob Barrows

09-17-2012 06:14 AM
The Frog

Sorry to post this here, but I can't find any active Mappoint groups! I need to use MapPoint with an Access db that I am developing. Specifically, I...

Paul H

09-15-2012 09:16 AM
Patrick Finucane

Hi all, I am trying to accomplish what seems to be a simple task but I am having trouble getting the logic down. Basically to explain, consider a...

James

09-14-2012 06:18 PM
David Hare-Scott

Hi, I hoping some can re-write this Access query for me, please. I don't know t-sql at all and I'm at a complete loss. UPDATE tblStBMthlyWorking...

bobh

09-12-2012 12:49 PM
Albert D. Kallal

Hi We're in the process of changing from office 2003 to office 2010 and having a few problems with several MSAccess databases. The following piece...

Carl Barrett

09-12-2012 01:35 AM
Carl Barrett

Hi All, Is there a third party product or access add-in or a sqlserver software product/add-in that would have a query like grid and works like an...

bobh

09-11-2012 09:54 PM
Albert D. Kallal

I have a form based on a query that if the query returns a value opens another form to perform a function then returns to the original form to test...

Jim Baird

09-11-2012 03:11 PM
Jim Baird

I have an application that derives data from an Excel spreadsheet. All of the data is imported as text and the columns are converted into other...

Jim Baird

09-10-2012 06:01 PM
Jim Baird

Where I work at our workstations use a standard graphics setting. Recently, after I developed an app my team decided to demo it to the managers. ...

Patrick Finucane

09-09-2012 01:07 PM
Jürgen Meyer

A client got a warning message: The Microsoft Access Database Engine could not find the object 'MSysDb'. Make sure the object exists and that you...

Nance

09-08-2012 01:32 PM
Patrick Finucane

We have a 2007 database on a server that each user has linked tables to and from their personal reporting database to the server database. The user...

sparks

09-08-2012 08:56 AM
Douglas J Steele

Hi, I can not figure out why I am getting this error. I have declared gobjRibbon as Public gobjRibbon As iRibbonUI in a module. The line that...

PW

09-06-2012 02:54 PM
PW

Hello all- I have a series of queries dependant on network source tables that normallyupdate between 4 and 5 AM. Occasionally, there will be an...

RobBrouil

09-06-2012 12:20 PM
RobBrouil

Hi, In the BeforeUpdate event, I am requiring a field to be completed and issuing a message "Activity is Required" if activity is null. I get the...

KW

09-06-2012 11:58 AM
Douglas J Steele

Hi, I want to place a button on my form to take the information in specific cells and add them to another table in the data base, but I’m not sure...

Dromas@msn.com

09-05-2012 01:22 PM
bsn

On Thursday, December 11, 1997 1:30:00 PM UTC+5:30, Alan Hodesblatt wrote: I think you need to get help from best general contractor who have good...

jackhhampton@gmail.com

09-05-2012 07:25 AM
jackhhampton@gmail.com

Haven't tried this but I'm about to hit the same problem. Can the rich text be moved into the memo field via the clipboard? Using API's perhaps? How...

The Frog

09-04-2012 10:32 PM
Gene Wirchenko

More from me, sorry! This is really two issues; the first is that everytime I click on an http hyperlink on a form Access 2010 prompts me - please...

fearless55

09-04-2012 02:50 PM
fearless55

Hi All, I am working on a database that stores servicing information for industrialequipment - it enables users to log the actions and work...

oli.paris@gmail.com

09-04-2012 12:36 PM
oli.paris@gmail.com

I'm tryng to replicate the box in object that can filter the visualized data while I digitize searching in every field of the table. I have realized...

ancucchi@gmail.com

09-03-2012 07:50 AM
Patrick Finucane

I am going mad with 3 graphs on a form! I can't stop them updating. When I change it to Manual Access resets it back to Automatic (Update Options)....

fearless55

09-03-2012 06:28 AM
Patrick Finucane