I have a SQL Server function which returns the data type VARCHAR(max). When I use the function in a view and link to the view through ODBC, it...

existential.philosophy@gmail.com

04-03-2009 12:09 PM
MGFoster

I am trying to programmatically (vba) set set the "Language for non- Unicode programs", which can be found in Control Panel> Regional and Language...

john@kosmosbusiness.com

04-02-2009 02:56 PM
john@kosmosbusiness.com

Hi, I don't understand. The MAIN form header information is populated in the header of the MAIN form via a separate data entry form. However,...

zufie

04-02-2009 01:28 PM
banem2@gmail.com

I'm trying to "hide" a report while printing. I need to open the report in preview mode as so to count the pages (if multiple so I can set the...

brian.flannery@ci.verona.wi.us

04-02-2009 01:28 AM
Terry Kreft

I am using Access 2007 and I just can't figure out how to create a one record table. Could someone help me out? Thank you.

JackonLI

04-01-2009 10:51 PM
JackonLI

Yesterday I became so frustrated with Access 2007 that I converted the database I'm designing into 2002 -03 and began to work. I was modifying one...

Tomahawk Lady

04-01-2009 03:33 PM
banem2@gmail.com

I see #Num! displayed in a control ( in a textbox of a subform). What can I do to avoid this error? Do I need to add =IIf(=0,0, to the beginning of...

zufie

04-01-2009 03:22 PM
banem2@gmail.com

Hi all I hav designed a databas in Access 2003. My Company is upgraded it by Access 2007. In the database there is a report, containing a graph that...

Naushad

04-01-2009 03:13 PM
banem2@gmail.com

I have recently started downloading Access 2007 templates and modifying for my own use. Almost every change results in a request for backup. Access...

Barry

04-01-2009 03:07 PM
banem2@gmail.com

I am trying to create a form with about 100 text boxes or labels on it. I can programmatically set the ControlSource or Caption, set the Top and...

Phil Stanton

04-01-2009 01:00 PM
Phil Stanton

Can anyone tell me what Me.hDC is. I presume this is a property only available in Access versions after AK2. Is there an equivalent for...

Phil Stanton

04-01-2009 12:59 PM
Phil Stanton

hi all ! i need a user to select a year from a list eg . 2007,2008,2009 when searching in a form that will run a query . however the date format in...

brino

04-01-2009 03:17 AM
Larry Linson

I just received a mess. They admit it and are willing to do whatever it takes to fix. they have 4 tables and they entered the data in the tables,...

sparks

04-01-2009 01:24 AM
Builder

I am well aware that you cannot simply type a tab character into a text field because of the focus event. This post has nothing to do with that. I...

occorled@gmail.com

03-31-2009 12:58 PM
occorled@gmail.com

sparks wrote: Change the autoid columns in tables 1-4 to type Long Integer, and populate them with the autoid values from your new tblDemographics....

Builder

03-31-2009 12:26 PM
sparks

Hi, I'm using Access 2003. On startup of my application I show a form. This form however is displayed on the layout of Access (menubars,...

susan

03-31-2009 07:58 AM
Allen Browne

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote Golly...is it that long ago....wow...just wow........ I mean, load up access...

Don L

03-31-2009 02:19 AM
Don L

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 08: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 07: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 06: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 01: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 11: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 10: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 10: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 08: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 06: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 02: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 10: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 09: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 11: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 09: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 08: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 03: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 02: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 09: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 06: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 10: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 09: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 07: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 03: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 02: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 03:14 PM
Larry Linson

Accessed

03-25-2009 02: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 02: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 11: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 08: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 03: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 08: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 08: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 05:33 PM
Steve