Whenever I open the VBA Code window, 23 separate windows open together with the Project window. I can close all unwanted windows and maximize the one...

dpcman01

03-30-2009 07:21 PM
dpcman01

Hi, I've updated my database from ac2003 professional SR2 to sr3. now when if click on a general form to go to another form there is a delay to open...

Georg

03-30-2009 06:00 PM
Salad

I'm building a new database in 2007. Fields include monthly values for Social Security, Wages, Pension, Other -- all set up as currency fields. In...

Tomahawk Lady

03-30-2009 05:13 PM
Bob Quintal

Hi I have a report which displays various bits of data, i want to add a webbrowser control to the report so that i can show a google map of the...

paul

03-30-2009 12:18 PM
Jens Schilling

I'm tyring to get a Text Boxes name by double clicking on it (don't ask why) The following always gives me Null Debug.Print Me.Form.ActiveControl

Karl

03-30-2009 10:30 AM
Marshall Barton

I have spent the past two years creating an herbal database with photos of the herb in a container field. When I try to export the file to access,...

tjay2988@gmail.com

03-30-2009 09:54 AM
Phil Stanton

I made up a VERY simple app that automates this process, and have just added the option to "/decompile /recompile" before sending the last...

Don L

03-30-2009 09:38 AM
Phil Stanton

My problem is creating a "Salary Change" report that shows all employees during a specific time period who have had a pay change. The query below...

david.moore@charter.net

03-30-2009 07:31 AM
david.moore@charter.net

When I open a Db (created in a different computer) or trying to create a new empty database,Access does nothing but goes only into the "Introduction...

Torrione73

03-30-2009 05:52 AM
Torrione73

Is there a way to convert an RTF memo field to plain text easily? By this I mean using a simple query or possibly some VBA code. This is a Access...

pa_nk1@hotmail.com

03-28-2009 01:03 PM
pa_nk1@hotmail.com

Hi folks, I'm using Access 2007 as the front end and SQL server as the backend of an application I have written. I am also using Windows XP. I have...

Bobby

03-28-2009 09:53 AM
hans.updyke@gmail.com

Is there any way to control the format of the column labels on a pivot table, other than reducing the fontsize? When I view the pivot table in Print...

D.Stone@ed.ac.uk

03-28-2009 08:34 AM
Phil Stanton

I've got access97 and sql2005, and I've got a DSN to a sql2005 db and I've linked a sql2005 table (tblCust) and I've created an access query...

Roger

03-27-2009 10:21 AM
Roger

I am using Access 2003 and would like to be able to retrieve the Date and Time of the PC where the backend MDB is stored, from the front ends (MDE)...

john@kosmosbusiness.com

03-27-2009 08:21 AM
Salad

Hi all. I have an odd problem. I have 4 pc's on a small network, all Win XP SP2. I'm using Access XP (2002 I think). Program works fine on 3...

jbguernsey

03-27-2009 07:09 AM
jbguernsey

Apologies for posting a question that has been asked and answered many times but its been causing me a lot of grief! I'm using the following code to...

paul

03-27-2009 02:11 AM
hbinc

On Mar 26, 10:54*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Thanks David, for bravely leading us forward to the...

evenlater

03-27-2009 01:41 AM
lyle fairfield

Suddenly today, when I open an Access 2000 MDE database in Access 2007, I get a Error #2950 on the AutoExec macro. When I look this up on the...

Icarus

03-26-2009 08:31 PM
Allen Browne

Hi All, I am making a report showing average % of different ages groups over several years. I really need to use the data table as part of my chart,...

musicloverlch

03-26-2009 05:08 PM
MGFoster

Good Evening, I am not a programmer or developer, but I've muddled my way through creating a large Access Database to manage the students at the...

principalfuller@gmail.com

03-26-2009 09:04 AM
Curt

I am working on the design of a recruitment database. I am stuck at the tricky subject of candidate availability. All contracts in this db are...

Paul H

03-26-2009 08:05 AM
Paul H

I've got an Access application which is behaving rather strange. It has trouble handling strings correctly in VBA at random places. For...

stefan.krul@gmail.com

03-26-2009 06:55 AM
Builder

Hi, I have a form which has multiple checkboxes as many as two or three checkboxes (choices) per question. I want to ensure the user can only select...

zufie

03-26-2009 02:15 AM
Terry Kreft

Has anybody used Quick License Manager - (Interactive Studios) for protecting softwares from being copied ? Do you have any comments ? Thanks a lot...

chrisdev3@gmail.com

03-26-2009 01:53 AM
Tony Toews [MVP]

Aaron, You seem really confused here; I have never said that SQL Server is never the right solution, I certainly have never shouted that, you though...

chickenfriedsteak

03-25-2009 02:14 PM
Larry Linson

Accessed

03-25-2009 01:59 PM
Larry Linson

Hi Everyone, I am faced with a situation that I have not come across before. In my department are a number of people that are all heavy data...

The Frog

03-25-2009 01:16 PM
Albert D. Kallal

Hello Everyone: Can anyone help me with this problem? I need to open a form to a specific record, and I am using the following code: Private Sub...

tonynahon@gmail.com

03-25-2009 10:29 AM
tonynahon@gmail.com

http://mail.avatel.us/1.jpg http://mail.avatel.us/2.jpg http://mail.avatel.us/3.jpg I have provided links to 3 pictures which will hopefully help...

joecosmides@gmail.com

03-25-2009 07:17 AM
tina

Is it possible to update a DB table from a visual basic script ran out side of Access? I have a database that is used at multiple sites (each has...

mcolson

03-25-2009 02:33 AM
Robert Schott

Hi, I have a form whose record source is set to a specific table. Next and Previous navigation buttons were added using the wizard. I added a...

Vmusic

03-24-2009 07:50 PM
Salad

Does anyone know of any VBA code I can incorporate into a Microsoft Access database which would allow me to display bitrates and playing time of mp3...

Elwood Herring

03-24-2009 07:18 PM
Elwood Herring

I have a list of codes in a Continuous Forms where I want certain codes to light up in a different colour shade. The expression I came up with in...

John

03-24-2009 04:33 PM
Steve

Hi, I have a combo box tied to a table on a form. (I used the wizard to set the source of the combo box as the table). I put one row in the table to...

Vmusic

03-24-2009 04:09 PM
alex_that_would_be_me@yahoo.com

I am trying to create an append query using an Excel file as source. Can I show the Excel file on the "show table screen"? Using Excess 2007. This is...

shub

03-24-2009 03:32 PM
shub

Hello -- I have a quick question! What is the command to run a named macro off a selected Excel file? Thanks. Cindy

Cindy

03-24-2009 03:29 PM
CDMAPoster@FortuneJames.com

I have some generalized table edit logic that works fine in Access 2003 but has a quirk in 2007. IN the form heading, the user selects the table...

Bob Alston

03-24-2009 01:05 PM
Bob Alston

Hi I'm just trying to use access for the first time. I have used mysql befor so I know i little about datebases. I have imported some tables into...

kalle

03-24-2009 11:49 AM
Salad

Hello all, I am using what appear to be identical INSERT INTO statements to populate a table, but some of them give me the 3078 error, whilst others...

franc sutherland

03-24-2009 10:53 AM
franc sutherland

This is driving me nuts! Access 2003 FE/SQL Server 2000 BE My client has asked me to provide a simple form to allow a run of address labels to be...

teddysnips@hotmail.com

03-24-2009 03:01 AM
teddysnips@hotmail.com

In previous versions of Access, while in datasheet view, I was able to right click and type multiple criteria items in the 'Filter For' textbox using...

Grumpy

03-24-2009 12:34 AM
Grumpy

I have a form in a secured db (Access 2003) that allows users to change their password. Simple form, accepts old password and new password, and uses...

jan@dontspamme.com

03-23-2009 07:30 PM
jan@dontspamme.com

Hi Folks, STILL banging away with Access97 here... (more below) LOL I'm "nearing completion" (yeah, right!) of my latest app ... and I've screwed...

Don L

03-22-2009 09:55 PM
Don L

Hello, I have a simple report running from a query that displays employee names multiple times next to the name of courses they have completed. I...

DeZZar

03-22-2009 05:37 PM
DeZZar

Hi I have a table and a form. I want to use the form to enter my data, but why is that when you open the form the first record is shown? How can...

Mike

03-22-2009 06:53 AM
Roger

Public Const IDC_HAND = 32649& Public Const IDC_ARROW = 32512& Public Declare Function LoadCursor Lib "user32" Alias "LoadCursorA" (ByVal hInstance...

Phil Stanton

03-21-2009 01:06 PM
Phil Stanton

I repeat below my previous post on this problem. I have still not solved it, but I have at last found time to try again... <<<<<<<<<<<< The form...

thelma@uwm.edu

03-21-2009 11:54 AM
Tom van Stiphout

Hello everybody, I am writing an application using Access 2007 and I'd like to open a specific page in a .chm file by clicking on a control button...

nuts

03-20-2009 03:58 PM
nuts

In the group header I print 2 line objects; one at the top and one at bottom of the group. In the detail section I print several records each...

Lou O

03-20-2009 03:50 PM
Lou O

Suppose I have MyString, a string-Type var in a VBA module. If MyString = "Hello. This is my string." Can I print that DIRECTLY to a local...

MLH

03-20-2009 02:26 PM
Tony Toews [MVP]