Hello, I am in need of some help concerning hyperlinks. I have this small database where the "front end" is part of a bigger database and the...

safarinut via AccessMonster.com

01-25-2008 12:28 PM
safarinut via AccessMonster.com

When I output a table's values to XLS, one value in a very small table, and only one value, is changed. Here are the values in the table,...

John Bartley K7AAY

01-25-2008 08:32 AM
Chuck

Hi, I would like to generate a versionnumber (and save it in a internal table) on the moment I make a mde. Then there would also be such version...

Michiel Rapati-Kekkonen

01-25-2008 05:45 AM
Michiel Rapati-Kekkonen

David Wrote: Because it was the first example of code that creates relations that I found, most of the other example I found used the same libraries...

Richard@Home

01-25-2008 05:05 AM
Richard@Home

I have a report that contains an image in it's header (an embedded bmp file). When I choose "Publish it with MS Word" the report opens fine in Word...

Keith Wilby

01-25-2008 04:43 AM
Keith Wilby

Are you planning for vacation, holiday? We would like you to spare your valuable time! Visit our website www.magical-nepal.com for information on...

magicalnepal@gmail.com

01-25-2008 02:16 AM
Larry Linson

Access 2003 I have an access database used for scoring a high school sporting event. Data is entered as scores are turned in from the...

Dale

01-24-2008 11:28 PM
Dale

I have a db w/3 required fields, I'm using the follow code to validate on the forms before update, which works fine. Problem is user are selecting...

T

01-24-2008 09:34 PM
Allen Browne

My Access 2000 app doesn't work correctly under Vista for lord knows what reason. Any code for detected Vista when I start the database? Nothing...

Deano

01-24-2008 05:25 PM
Stuart McCall

Hi I've got a mdb that is recreated monthly/weekly. I've written a bas module with lots of functions in it so that they can be used in...

Yitzak

01-24-2008 02:07 PM
Yitzak

Hi I am using Access 2003 mdb as a front end to an application which uses SQL Server 2000 as the backend. The two are connected using ODBC. On one...

Bobby

01-24-2008 02:04 PM
Rick Brandt

Hi, I'm using Office 2004 Professional and have a question about Word mailmerge using data from Access. I knpw how to export data from an...

susan

01-24-2008 11:35 AM
Rick A.B.

you like a new photos without cloth : see and enjoy more information and get my...

fathima

01-24-2008 11:24 AM
fathima

I've been experimenting with SQL Server Express and have successfully upsized a couple of databases i.e. the tables are now on the local installation...

josephlee@live.com.au

01-24-2008 06:29 AM
josephlee@live.com.au

Hi Can anyone pointme in the right direction? I run Access2000 and have a passthrough query to a Sybase db I am trying to make a table out of the...

KayC

01-24-2008 05:30 AM
KayC

We are all in quest of true happiness. In this world, the idea of true/perfect happiness is not feasible because this world is inevitably doomed to...

abdo911

01-24-2008 04:04 AM
abdo911

We are all in quest of true happiness. In this world, the idea of true/perfect happiness is not feasible because this world is inevitably doomed to...

abdo911

01-24-2008 03:59 AM
abdo911

Hello. I am saving an Excel file as a text file then importing it into Access using a specification. One of the fields in the file is a...

angelasg

01-24-2008 01:05 AM
Larry Linson

I would appreciate any comment. I want MS Access to act as a reporting tool accessing Oracle tables. The Oracle database is populated by another...

lukethegooner

01-23-2008 11:45 PM
Tony Toews [MVP]

What is wrong with the following code? I am trying to filter a form based on the selection of a combobox named cblPRD Dim...

dkohel@gmail.com

01-23-2008 10:36 PM
dkohel@gmail.com

This is a way out there question, but hoping this is possible. I have an Access form with the Web Control. The web control navigates to a web page...

Lauren Quantrell

01-23-2008 10:24 PM
Lauren Quantrell

Please Help We have 4 Inspectors carrying inspections and a lack of Trust, which means we need to validate the Inspections so that they are only...

kevinjouco@hotmail.com

01-23-2008 06:36 PM
lyle

I have built the table that has a field with records 1, 3, 5.. How can I show them differently in the report? like 1= customer, 3 =distributor, 5 =...

shichen1979@yahoo.com

01-23-2008 06:21 PM
Salad

The SQL string returns 4 records if pasted into a QBE grid and run manually. But in this DAO setting, I can't seem to get it to retrun any records....

MLH

01-23-2008 05:55 PM
Bob Quintal

I have created various reports for my database. When I open the report in display mode all of the reports display on half of the screen without any...

Tyler

01-23-2008 05:45 PM
Bob Quintal

Hi, A customer has requested that if a integer field shows a 0 or is null that it appears as 'ND" (or no data). Not too sure whether this can be...

mcgrathml@gmail.com

01-23-2008 02:38 PM
mcgrathml@gmail.com

I have developed an appointments system database and I use the attached code in the main form's current event to detect appointment clashes in...

Keith Wilby

01-23-2008 11:21 AM
Keith Wilby

Hello, I have a database in MS Access containing 2 tables: the first one called "weeks" has 4 columns: id, week number (ex: 2007/01), start...

foutuguy@gmail.com

01-23-2008 10:00 AM
Salad

I'm not sure what I'm doing wrong here, but I am not able to get value based on the following query: select TYPE_ID from MY_TABLE where...

pzimmermann@gmail.com

01-23-2008 02:15 AM
Dominic Vella

How do I default a Check Box to have the tick already in it

Paul

01-23-2008 02:12 AM
Dominic Vella

HELLO GUYS, anyone could help me on how to connect my MS access program to sql server for storage of data. i'll be using sql database instead of...

mroks via AccessMonster.com

01-22-2008 10:04 PM
mroks via AccessMonster.com

tblproduct (simplified) productid(pk) productcode productcost productprice warrantycode any warranty claim is invoiced out as the original...

BobbyDazzler

01-22-2008 04:25 PM
CDMAPoster@fortunejames.com

New at macros, trying to send a report to file so it will work on any machine. I can't figure out how to send to the TMP directory, or to...

John Bartley K7AAY

01-22-2008 03:10 PM
John Bartley K7AAY

I have a window with a subform that has a subform. The main (outter) window is a single form that enables navigation through the recordset via...

Susan Bricker

01-22-2008 02:29 PM
Salad

I have a simple database using Access 2000 which currently has three fields. I keep track of my lighthouse collection. The fields are all text, and...

rfdjr1@optonline.net

01-22-2008 01:09 PM
Phil Stanton

When making changes to an object in Access 2007 I have the Navigation Pane on the left-hand side of the screen and the object under change displayed...

Tony

01-22-2008 12:49 PM
Tony

Hi all, So I bought a new laptop 10 days ago to test my apps with Vista. (home premium) Apparently Office 2007 is pre-installed. (a time limited but...

Arno R

01-22-2008 09:49 AM
Arno R

I have a string variable that is presently being sent to a MessageBox. I want to add a command button to the Form so I can send the string...

RICHARD BROMBERG

01-22-2008 08:40 AM
Stuart McCall

Hi Guys Good news is 23 Electronic and Computer Science video courses are free, No login, No fee. All you need to have is real player installed on...

AK444

01-22-2008 07:23 AM
AK444

Here's something I thought I'd know how to do ... I have an Appointments table and want to add a duration (integer representing hours) to a start...

Keith Wilby

01-22-2008 06:48 AM
Keith Wilby

Is there any way, from within Access, to concatenate several PDF reports? Thanks in advance. Angel.

amn

01-22-2008 04:47 AM
amn

Hi. I would like to create an array and use the data to populate some new records when the user clicks on a button (that's the...

Susan Bricker

01-22-2008 03:13 AM
Dominic Vella

I have hyperlinks from within Access forms that link to Adobe PDF documents; these are the new PDF Package documents created with Acrobat 8 - and...

Carl Gabel

01-22-2008 12:57 AM
Carl Gabel

Hi All i'm trying to build a parallel function in vba access that appear in excel: FileDialog(msoFileDialogFolderPicker) does anyone know how to...

thread

01-21-2008 11:50 AM
thread

are there any workarounds for using a specific printer for a report in access 2007? something i can write in code? i have 12 different label...

scousineau@oaeusa.com

01-21-2008 11:29 AM
scousineau@oaeusa.com

I have created an access database that is used to record machine failures. Typically a failure will happen anything from twice per day to a couple...

}{

01-21-2008 11:29 AM
Tony

Hello, I have 10 optional numerical fields on a form. When I try to sum them in the control source of another input box, or even using VB, I only...

Cron

01-21-2008 11:28 AM
Cron

Earrings come in many forms, and the complexity of the style reflects the sophistication of the wearer's taste. One of the most elegant and complex...

apollo66942@yahoo.com.tw

01-21-2008 10:49 AM
apollo66942@yahoo.com.tw

I am running Access 2007 SP1 under Windows XP home. I have configured the Default Database Folder for Access using Office / Access Options / Popular...

Tony

01-21-2008 09:27 AM
Tony

Dear all, My form contains a button to save a report to PDF. However, the future user can not choose the place the pdf is placed, nor the name of...

Sietske

01-21-2008 07:09 AM
Allen Browne