I have a table with an address field. The data in this field for example is 1234 Main St.; 1234 Main Street. I want the data to be consistent,...

Kissi Asiedu

07-11-2010 06:25 AM
Bob Barrows

I have problem with one of my A2003 databases. I'm getting strange behaviour when I type in a module. For example if I type 'dim x as string' this...

Dave G @ K2

07-10-2010 07:41 PM
Stuart McCall

We have an Access 2003 database that handles Contacts and Events for the organization. This is used by everyone in the organization - across all...

Vet Tech

07-10-2010 11:05 AM
Vet Tech

Thanks for replying again, Salad. I accept what you are saying. Using your suggestion, what would I do if the customer had 3 outstanding invoices...

BobbyDazzler

07-09-2010 09:21 PM
Salad

Again we have an access 2007 database and they want me to convert it to 2003. Like before the person put in everything neet and cool she could...

sparks

07-09-2010 07:03 PM
sparks

How do I get past this problem, where I want to place a variable where it's expecting the exact name: strTable = "Query1" Set rs =...

christianlott1@yahoo.com

07-09-2010 06:18 PM
David W. Fenton

I've got an Access 2007 table with a field called Zip which is a text field. Some zips were entered like "67203" and others like "67203-2752". Is...

emanning

07-09-2010 06:12 PM
David W. Fenton

Karl <karl3200 (AT) gmail (DOT) com> wrote in news:47b29e08-0dae-4900-8936-f3c7c84cade7 (AT) w12g2000yqj (DOT) googlegroups.co m: With a website?...

JeffP

07-09-2010 06:08 PM
David W. Fenton

Here's the story: I had an mdb (2003) with permissions setup (security1.mdw). I needed to make changes and since the original was bloated, I created...

christianlott1@yahoo.com

07-09-2010 01:20 PM
christianlott1@yahoo.com

So simple, yet so puzzling. Searches have turned up nothing useful, so I hope someone here can provide some insights. This SQL statement: cJEnq =...

Neil Gould

07-09-2010 12:33 PM
Neil Gould

Hi, I'm working w/ data like this: parent: 1061001 child: 810 parent: 1061002 parent: 1067303 child: 809 parent: 1068201

christianlott1@yahoo.com

07-09-2010 11:07 AM
christianlott1@yahoo.com

Hi all I have a client for whom I've created an Access database over a period of some years. It's now getting to the point where we're going to...

Andrew

07-08-2010 04:30 PM
Tony Toews

I've just taken over a klunky but functional application for a new client. They are running Access 2000. It's a BE-FE system, no security features,...

freddy007

07-08-2010 04:02 PM
freddy007

I’m trying to make a conditional macro that will check a table to make sure there isn’t already a record with the same ID and Entry #. If there is a...

Craig

07-08-2010 01:46 PM
Salad

I would like to do a search feature similar to what Google has done. When the user types in the initial letters of a keyword, Google...

klar

07-08-2010 05:06 AM
klar

Hi All I'm running into a problem I've not encountered before and was wondering if anyone else has. In a split Database after running a standard...

Jon Lewis

07-08-2010 04:04 AM
Jon Lewis

I’m creating a query that is going to go through and look for various impossible data entries. What I would like to do is use an IIF statement and...

Craig

07-07-2010 09:21 AM
Salad

Hi all I have, over the past few years, been developing a datase for a client in MS Access. The time is now approaching, however, when we will...

Andrew

07-07-2010 09:12 AM
Andrew

Hi, I have a form with a text box and a subform. Main form is unbound. SubForm is displaying records from a query. I would like to the user to be...

Dragon

07-07-2010 09:03 AM
Salad

I have a mde database file developed for a client. This was originally set up and run in Access 2003. Everything worked fine. Recently this client...

clk

07-07-2010 06:59 AM
Douglas J. Steele

I created a form, added a combobox to it and want the combobox to be populated by values from two different tables. For the rowsource property of...

g

07-06-2010 04:49 PM
David W. Fenton

For source code browsing of software written in C, java, C++, there are convenient and free source code browsing tools like source navigator. This...

Lay

07-06-2010 02:48 PM
Tony Toews

I have an unbound combo box linked to a query that sorts on LastName and FirstName. It works when the form is loaded but when I reset the rowsource...

Access

07-05-2010 04:29 PM
Marshall Barton

Hi All, I have MS Access 2003 (11.8308.8324) SP3 with hot fix 945674 & 970623 applied. There appears to be a Tab Ctl bug as explained below:...

Barry Edmund Wright

07-05-2010 11:43 AM
Barry Edmund Wright

I have a 2003 MS Access database using 2000 file format. The database was originally written with Access 2 (1995) and upgraded to where it...

PAR

07-05-2010 12:42 AM
PAR

I have created a form which has 5 fields of a Table as textboxes. The table has 10 fields. I have added buttons for adding a new record, saving it...

g

07-03-2010 09:17 PM
g

I moved data from a MS-Word Table into a MS-Access table using VBA code. Almost all of the word documents had five rows for first table in the...

g

07-03-2010 04:26 PM
g

I have 2 computers, both windows 7 & both Access2010. On the slower machine the code below works and creates an AccDe correctly, but it doesn't work...

Phil

07-02-2010 05:28 PM
David W. Fenton

Hi, I'm using Access 2003, Windows XP. I have a table of company turnover data. I want to query out the most recent entry, by date, for each...

franc sutherland

07-02-2010 10:16 AM
franc sutherland

Dear Access experts, I am using Access 2003 mdb now. I plan to convert it to mde file for security reasons. May I know if the creation of new...

Lay

07-01-2010 08:53 PM
Lay

Just thought I'd share this in case anyone else encounters this problem some day. I have a database that's been in use for 6 years, the last 2 in...

Rick A.B.

07-01-2010 05:50 PM
Tony Toews

While I have been able to getAccess 97 running under XP, I still can not get any SR 2 to install. SR2CHK.EXE gives the same error that any SR 2...

Gene Wirchenko

07-01-2010 02:25 PM
David W. Fenton

Has any one ever used Sharepoint as a backend for Access? Are there any benefits to Sharepoint over SQL server? Very general question I know, but I...

Paul H

07-01-2010 01:07 PM
Arvin Meyer

Hi all, Sorry... I don't know if 'color scheme' is the right option that I want since I am using a Dutch version of Access... I would like to...

Arno R

07-01-2010 12:19 PM
Banana

Hi all, I need to print to (or publish) an Access report to pdf with code. This is a standard option with Access 2007 (SP2) BUT....I don't want to...

Arno R

07-01-2010 03:37 AM
Arno R

I searched a few days to come up with all these answers, so I'd like to share my knowledge. I wanted to export to excel using multiple criteria...

christianlott1@yahoo.com

06-30-2010 04:45 PM
christianlott1@yahoo.com

When a button is clicked on a Access Form, I want to run a query and display its result. I am able to do that, but my form has 12 buttons and I am...

g

06-30-2010 02:43 PM
g

Dear Candidate, Title: Tester Duration: 4 months Location: Bellevue, Washington LOCAL or Commutable candidates only

Maple MRS

06-30-2010 01:42 PM
Maple MRS

Hi All, I have the following code under a button click. The dialog opens to display the "My Documents" folder. My question is how can I change it to...

Barry Edmund Wright

06-30-2010 01:25 PM
Barry Edmund Wright

Dear Candidate, Title: INVISION Project Manager Duration: 12 month Location: Hospital in Philadelphia. Description:

Maple MRS

06-30-2010 10:54 AM
Maple MRS

I have two tables child and responses. Child stores child information such as name/id while the responses table stores the responses for...

Craig

06-30-2010 07:59 AM
John Spencer

If I make a report one field displays limited amount of characters (252) while another field has no limitation. Both fields has format "Memo" and...

AA Arens

06-30-2010 07:35 AM
Bart van Dongen

Hi, I am trying to have a 'time out' field auto populate when the user comes into the record the second time. The first time when the user creates...

David

06-29-2010 12:17 AM
Marshall Barton

Driving and Car Maintenance: Transportation accounts for 66% of U.S. oil use -mainly in the form of gasoline. Luckily, there are plenty of ways to...

..

06-28-2010 03:42 PM
..

Title: Business Analyst Defined Contribution Plans Right to Hire: No Professional Day Length: 0.0 Contract Duration: Environment: Business...

Maple MRS

06-28-2010 03:26 PM
Maple MRS

Title : Sr Technical Project Manager Location : Reston, Virginia Description : Minimum Requirements: Typically possesses 10 to 15 years of...

Maple MRS

06-28-2010 03:15 PM
Maple MRS

Hello: I have just picked up a bit of work on an Access 97 system. In British Columbia, we have a change in the way that the taxes will be computed...

Gene Wirchenko

06-28-2010 02:58 PM
David W. Fenton

Hi all, When I try to open the previous version database in Ms-Access 2010 is not working. Please help me and solve my problem. Naushad

Naushad

06-28-2010 02:40 PM
Tony Toews

Hi All, In AccessXP I have a need to select a random sampling from a large set of records giving the process some guidelines as in, from a 1000...

bobh

06-28-2010 10:33 AM
Rich P

This code worked in AK2 for seeing whether a database was an MDb or MDe Function IsItMDE() As Boolean On Error Resume Next Dim strMDE As...

Phil

06-27-2010 07:12 PM
Phil