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 05: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 12:43 PM
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 01: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 10: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 05:26 PM
g

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 11: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 09: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 06: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 03: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 02: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 01: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 04: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 05: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 03:43 PM
g

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

Maple MRS

06-30-2010 02: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 02:25 PM
Barry Edmund Wright

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

Maple MRS

06-30-2010 11: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 08: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 08: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 01: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 04: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 04: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 04: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 03: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 03: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 11: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 08:12 PM
Phil

I am posting this at the suggestion of Tony Toews in response to another of my posts. Access 2007 SP2 with SQL Server 2005 back end. Datasheet form...

AVG

06-27-2010 07:06 PM
Tony Toews

Hi All, With a split db is there code that could be added to the back-end that would make/limit any links from is point forward 'read only' ?? ...

bobh

06-26-2010 07:06 PM
Tony Toews

I received an email and they were asking me what this means and what should be implemented. Data entered by: ________________ (password...

sparks

06-26-2010 05:30 PM
Tony Toews

We have an immediate need to convert an MS Access 2003 app and it's 2003 back end DB to 2007. We do not want or need any of 2007's functionality at...

(PeteCresswell)

06-25-2010 07:57 PM
Banana

Dear Candidate, Title: Business Analyst Location: New York, New York Duration :6 months

Maple MRS

06-25-2010 02:56 PM
Maple MRS

Hi I have a field in a table called tblTransaction in which there is a field called "ListingEbayNumber" I have created a simple query that just has...

bobdydd

06-25-2010 10:45 AM
bobdydd

Hi I have a field in a table called tblTransaction in which there is a field called "ListingEbayNumber" I have created a simple query that just has...

jeff001@stortvalley.com

06-25-2010 07:06 AM
jeff001@stortvalley.com

Dear Access Gurus, I woulld like to customize a login password protection scheme for my database. Based on the login name, a password will be...

LightLY

06-24-2010 11:23 PM
Access Developer

Dear Candidate, Title: Sun IDM resources Duration: 3+ Months Multiple Location

Maple MRS

06-24-2010 05:42 PM
Access Developer

Hi, I am trying to create an update statement that will replace values based on a wild card and only replace the wild card data (not the entire...

bcap

06-24-2010 03:40 PM
bcap

The report is printing some 7 fields from a Table which has 14 fields. The report gets its data(to be displayed) from a single table only. In the...

g

06-23-2010 05:17 PM
g

Dear Access experts, I have been cracking my head for some time over this problem but I am only an Access newbie. Is it possible to make Access send...

LLY

06-22-2010 11:51 PM
LLY

After splitting the database, portions of code that use recordsets (now based on linked tables) don't work. Runtime error 3251 "Operation is not...

Tia Murchie-Beyma

06-22-2010 07:07 PM
David W. Fenton

I have just gone from XP to Win7 and have run into a cookie issue. I wonder if anyone here has managed to successfully set a cookie in IE under Win7...

Richard

06-22-2010 06:39 PM
Richard

I noticed a problem with Allen Browne's Access7 tip using the mouse wheel event to scroll records in form view with Access 2010 beta. Access calls...

paii, Ron

06-22-2010 11:28 AM
paii, Ron

In laying out the relationships between tables in Access 2007, I tried to create two joins between a pair of tables, the AssignmentID and...

M Skabialka

06-22-2010 10:24 AM
M Skabialka

I have a module named 'Module1' which was created in error. If I try to delete it I get the usual 'Do you wish to permanently delete....' message but...

Bob Darlington

06-21-2010 11:57 PM
Bob Darlington

At times I've wished I could have a virtual checkbox to select items for further action. Maybe you have a bunch of records in a form but only want...

Salad

06-21-2010 11:07 PM
Salad

The following has always worked with Access 2000 / Outlook 2000 SendEMail: 'Get Outlook if it's running On Error Resume Next Set oOutlookApp =...

Phil

06-20-2010 04:15 AM
Phil

I do not write code. I use wizards and macros. Until last year none of my clients were using 2007, so I continued to use 2002 to...

Tomahawk Lady

06-19-2010 11:07 AM
Arvin Meyer

MS Access 2002 SP3/SQL Express My client has a form with a BoundObject control on it whose control source is an Image column in a SQL Server...

Edward

06-19-2010 03:12 AM
Arvin Meyer

I am trying to construct a Function which will return a value based on a date. The date is passed in the format DD/MM/YYYY and the output is in the...

BobbyDazzler

06-18-2010 01:28 PM
John Spencer

I have a table with firstname, lastname, and birthdate and about 20 records. I need to visit a website to look up info on each of these people. I'm...

zuckermanf@gmail.com

06-17-2010 08:03 AM
paii, Ron