The tabbed windows option in Access 2007 is quite a different concept than the overlapping windows in earlier versions. I'm curious about...

Lars Brownies

05-02-2010 09:45 PM
Arvin Meyer

Dear Sirs , I have a question and I need your help , it is very urgent please . I am using Microsoft access 2007 and I have a table called...

Wisso

04-30-2010 10:08 AM
Salad

I have 2 tables: Member and Bulk Mail I have linked them on Last Name Member has these fields: First Name, Last Name, E-mail Bulk mail has these...

grin

04-30-2010 04:22 AM
zuckermanf@gmail.com

Hi, I'm using Stephen Leban's PDF modules (from http://www.lebans.com/reporttopdf.htm) to generate and save PDF versions of reports. However, I am...

Martin

04-29-2010 10:07 PM
Martin

In the past, when Office was released, MS had an event in several cities on the release day. Anybody know if they will be doing so for...

Salad

04-29-2010 10:01 PM
Tom van Stiphout

Hi All, Has anyone else had this issue............ In AccessXP I use a Docmd.OutputTo a spreadsheet and then I send that created spreadsheet to a...

bobh

04-29-2010 04:02 PM
bobh

Dear Experts, I have an application that I've used for years that runs on Access under the covers. Help shows a reference to: Access 2002 Desktop...

dba_222@yahoo.com

04-29-2010 12:08 AM
dba_222@yahoo.com

Apologies to all you experts for the very simple question. My HP Laserjet has two trays. Plain paper in tray 1. Quality paper in tray 2 (which...

Vincent Oakley

04-28-2010 11:06 PM
Salad

How would I right a case statement like this in Access? SELECT COUNT(CASE WHEN Location = N'Inner Mass Spec.' AND EpaName = N'leak1' THEN MFG_SN...

mcolson

04-28-2010 08:27 PM
David W. Fenton

Since explicit page break controls are ignored in subreports, I had a devil of a time getting things to display properly. My solution is below. The...

pemigh

04-28-2010 04:59 PM
pemigh

All, I have a formless db with a table containing a myLoginID column. I would like to use the currently logged-in user's ID as the default value...

Patrick A

04-28-2010 04:46 PM
Patrick A

I have a multi tabbed form with about 10 tabs, each has a subform with a different record source. I also use the fsubnavigation tool from Access...

Bob Alston

04-28-2010 03:23 PM
Bob Alston

I am collecting a group's information(name, phone number and three paragraphs describing their hobby). I want to send an email to all the group...

a_t

04-28-2010 11:36 AM
a_t

I'm using Access 2007 and am trying to create an SQL string in VBA which loops through each record of a query containing all the names of the tables...

Robin Riviere

04-28-2010 11:22 AM
Robin Riviere

I have a query produces two records for each of my tank I have. The only item in my query that is different in the two records is my Model#. The...

mcolson

04-27-2010 10:18 AM
Salad

Check out this new law that went into effect March...

Roger

04-27-2010 03:46 AM
The Frog

Has anyone deployed an Access 2002 runtime (installed using Wise and Sagekeys) in a Windows 7 environment? I've had no problems (or not many) with...

Bob Darlington

04-26-2010 07:31 PM
Bob Darlington

Hi All, I have a subfrm on a form. When on the subfrm I can go to the Access Menu/View/Subform and switch between form and datasheet view. How do...

Barry Edmund Wright

04-26-2010 12:19 PM
Barry Edmund Wright

How can I fix this? sub SendErrorEmail(err) Dim mailer set mailer = server.CreateObject("CDONTS.NewMail") 'set the properties mailer.From =...

Jim Rojas

04-24-2010 11:42 PM
Jim Rojas

Hello , I am using MS Access 2003. I have two Tables called 'Members' and 'CRM Database', which are related via the same memberhsip...

sharsy

04-24-2010 04:53 AM
Michiel Rapati-Kekkonen

Hi, I'm using the DCount function where the WHERE clause portion is a string variable. The string variable includes the Date function. I get a "You...

whiz

04-22-2010 11:23 AM
Rich P

Hi folks, I need to create a text file with a very specific layout from my access 2003 db. My coding knowledge is very basic and I am stuck on how...

Geospectrum

04-22-2010 10:30 AM
Salad

I've seen this problem before and am currently experiencing it in a database that I am building. Sometimes I'll do design changes to a particular...

Wayne

04-20-2010 10:48 PM
Wayne

Hello All, Access 2007. Unbound main form with 2 subforms. Both subforms are in datasheet view. The 2nd subform is master/child linked to the 1st...

zuckermanf@gmail.com

04-20-2010 10:35 PM
Kathy Whitehead

Hi all--I know there's gotta be a simple answer to this... I need to run a query, and depending on the results of the query, a variable called...

Daniel Habtemariam

04-20-2010 06:40 AM
Daniel Habtemariam

I would like to calculate the number of "work days" between two dates; however, the "regular days off" are may not be Sat and Sun and they may not be...

blah@blah.com

04-19-2010 11:41 PM
Salad

Hi all I'm making a training-db, where I have trainings (courses), which each can have 1 to n sessions. Management can indicate which course a...

Daedalus

04-19-2010 05:17 PM
Daedalus

Hello Group, ... i'm a Dog Groomer & an Access rookie with only a very basic familiarity with designing a database to do what i need ... so i'm...

RVer

04-19-2010 01:55 PM
Salad

I can use some help here. This is a lost password recovery script that connects to a MSAccess MDB. Any Help would be greatly appreciated. Thank...

Jim Rojas

04-19-2010 10:57 AM
Jim Rojas

I have a main form with a combo box of employee ids. I am trying to set it up so the user can select a value from the combo box, click a command...

Coll

04-19-2010 10:06 AM
Coll

Hi, I'm in the process of converting an application from Acc97 to Acc2007, from the mdb format to the accdb format. The app consists of several mdb...

RonG

04-16-2010 10:05 PM
Allen Browne

All, Rich P. gave me a solution to this that works in VB, but I am very curious - can this be done within MS Access in a formless DB? I have a...

Patrick A

04-16-2010 11:51 AM
Patrick A

I have a folder in outlook 2007 that I would like to create a report on. Email sender Email Subject Email date Email body How can I do this

steve1040

04-16-2010 11:14 AM
steve1040

I have a report (RptPaymentRecord) which if I open it in preview and then print it - no problems If I open the report in preview from a...

Phil

04-15-2010 08:33 PM
Salad

I'm using the foll code to display images from a folder on a form. Each time I try to scroll to the "next" record a small window flashes past...

Prakash

04-15-2010 07:19 PM
Phil

Hi Has anyone out there encountered problems with linked tables using mdb files developed in Access 2003 but moved to Access 2007 with MS SQL Server...

Richard Finnigan

04-14-2010 04:30 PM
Richard Finnigan

From a form I'm invoking a report. The report opens in preview mode. However, I'd like the user to be able to click the "close" button on the toolbar...

Prakash

04-14-2010 04:12 AM
Prakash

I have a circumstance where I need to calculate counts based on user set start times, end times, and intervals. It looks like the partition function...

Craig

04-13-2010 05:42 PM
Bob Quintal

Ok guys and gals, I'm at a loss here. At my office we have a SQL server handling most of the databases. Almost everyone uses an MS access 2007 front...

RcCypher

04-13-2010 11:24 AM
Rich P

Strange issue with lock files. Database is split front end with multiple back ends. When users log out of the database, the following situation...

John von Colditz

04-13-2010 12:19 AM
Br@dley

I recently upgraded a 2003 mdb to a 2007 accdb. There is one form in this accdb that causes 2007 to crash after it closes and compacts. (the...

emanning

04-13-2010 12:15 AM
Br@dley

I need to print checks from an Access 2000 database (can be updated if needed). If someone is doing this, can you share information on how you handle...

Karl

04-13-2010 12:07 AM
Br@dley

Hi, I have an Access 97 database that I am in the process of converting to Access 2007 (accdb). When attempting to compile the application, I will...

RonG

04-12-2010 11:58 PM
Br@dley

Hi All, In access xp I have a form that has a listbox, normally I use combboxes but in this case I have to use a listbox. The listbox list lastname,...

bobh

04-12-2010 11:45 PM
Br@dley

I opened my app's starting form on a client's machine from a public folder. I got an error I had never seen before. It read "The expression "On...

Salad

04-12-2010 07:47 PM
Allen Browne

I have some code that works properly in one database that I have pulled into another database, but it does not work in the other database. I am not...

Inquisitive1

04-12-2010 02:06 PM
Inquisitive1

I have made a query called qryKøbSalg in my access 2007 database with the following columns. itemId ref to the table tblItemTransaction descrition...

Poul Erik

04-10-2010 06:41 AM
Marco Pagliero

Hi I have a help desk database that is populated by a user form in ms access 2003. The form has a text box that users can identify if the current...

Doug

04-10-2010 12:39 AM
Tom van Stiphout

I already have a 'date picker'' in my app (mscomct2.ocx) which I have the users select calendar dates for various date input purposes. Has any...

isobadd

04-10-2010 12:27 AM
Tom van Stiphout

I have an append query that works fine unless one of the records includes an apostrophe. INSERT INTO ( ItemAbb, ItemName, AVIDNO ) SELECT DISTINCT...

kyle

04-09-2010 01:44 PM
paii, Ron