<foziabeshre (AT) yahoo (DOT) com> wrote And this relates to Microsoft Access database software, the subject of the comp.databases.ms-access...

Larry Linson

05-06-2007 11:28 PM
Larry Linson

Hi, David. Sorry. I didn't make that very clear. The front end needs to be compacted after splitting the database with the wizard (to reclaim the...

Stan

05-06-2007 08:08 PM
'69 Camaro

On Sun, 06 May 2007 12:26:14 GMT, "Rick Brandt" <rickbrandt2 (AT) hotmail (DOT) com> wrote: RTF is essentially standard text with some html-like...

Tom van Stiphout

05-06-2007 01:52 PM
Neil

I am working on a database in ACCESS 2003. This is a simple DB with only one table. I have successfully split the database into database.mdb and...

Stan

05-06-2007 01:08 PM
Stan

On Sat, 05 May 2007 15:42:39 GMT, "Neil" <nospam (AT) nospam (DOT) net> wrote: This is not generally the case. I'm running several A2000 and...

Tom van Stiphout

05-06-2007 03:08 AM
Neil

I have a form which contains two subforms: and . The two subforms each have a SQL query to display their results in datasheet view and allow the...

jgrob3@hotmail.com

05-06-2007 02:18 AM
jgrob3@hotmail.com

Hi, could someone tell me how I can check whether a database is open by name eg something like db("mydbname")

colmkav

05-06-2007 12:09 AM
John Mishefske

Not exactly sure how to explain this. I have 4 fields (in access 2000). Category, Catid, Subcat, subcatid. There are 40 categories, and about 1500...

JA

05-05-2007 04:51 PM
JA

The design view of my form is this.. I hav command buttons namely cmdRecord, cmdEdit and cmdUpdate.. Ol of these command buttons are set into Enabled...

hugz via AccessMonster.com

05-05-2007 08:10 AM
Arno R

Is there a way (code, plugin, etc.) to output a single Access report as multiple reports? Preferrably, I want to control the output target by data...

joel@

05-05-2007 07:56 AM
robert.waters

It takes five minutes when using object linking and embedding to save a PDF file using a normal from. The data type is image in an SQL...

tomlebold@msn.com

05-05-2007 07:51 AM
robert.waters

My Access 2003 applicaton is attempting to store the path and file name of a PDF file in a hyperlink column. After clicking on the hyperlink a form...

tomlebold@msn.com

05-05-2007 07:45 AM
robert.waters

Hey.. I made a starting set-up for my form dat sets my controls RECORD, EDIT, UPDATE into enabled NO.. then when i close the whole database and try...

hugz via AccessMonster.com

05-04-2007 10:28 PM
hugz via AccessMonster.com

I am wondering if I can create an application that when you click on it (say a shortcut), it opens a report parameter box to query a set...

Debbiedo

05-04-2007 10:26 PM
Chuck

Using Access 2003 front-end, with SQL Server 2005 backend. I need to make the front-end application automatically refresh the linked SQL Server...

bubbles

05-04-2007 07:26 PM
(PeteCresswell)

Just a quick note to let you all know that I am handing out free NFR licenses for SqlSpec to Microsoft MVPs and other important contributors to the...

Jesse

05-04-2007 06:38 PM
Jesse

My Access 2003 application is attempting to store the path and file name of a PDF file in a hyperlink column. After clicking on the hyperlink a form...

tomlebold@msn.com

05-04-2007 05:44 PM
tomlebold@msn.com

I searched the groups and tried several approaches but still cannot find a solution. I have a table that has several hundred fields that may or may...

Debbiedo

05-04-2007 12:18 PM
Debbiedo

Thank you! "fredg" <fgutkind (AT) example (DOT) invalid> wrote

Robert

05-04-2007 11:59 AM
Robert

Hello, My main question is... What and where do I write to allow a button in a form to open my main database window? We all know the keyboard...

kennyrogersjr

05-04-2007 10:40 AM
ManningFan

I have a form with a field who's Visible property by default is set to false. If another field meets a certain criteria, then the visible property is...

paquer@gmail.com

05-04-2007 09:33 AM
paquer@gmail.com

I'd like to provide an Export Function from my forms, where the User can choose the File name & save location Although I cannot get the "Save As"...

paquer@gmail.com

05-04-2007 09:29 AM
paquer@gmail.com

All: This isn't strictly an Access issue, but it relates to productively working in Access, so... I recently added a second monitor (yes I know,...

Tom

05-04-2007 09:03 AM
Tom

Is it possible to build a chart where you supply the X & Y Co-ordinates and have the data displayed at that point. To clarify:- Suppose we have a...

Phil Stanton

05-04-2007 08:23 AM
Phil Stanton

I'm reasonably sure that this issue isn't related to the database as such. I have an Access 2003 report with a couple of coloured logos on it that...

Wayne

05-04-2007 06:26 AM
Stephen Lebans

We have a system of Data collection terminal (Capdrive from captorgroup) with keypad and with Microcap terminal. We had a MRP software that...

AL

05-04-2007 05:55 AM
The Frog

I am using an MS Access 2002 database to track user login information. I have copied Allen Browne's audit log and removed the references to the...

melissamuse@gmail.com

05-04-2007 12:26 AM
Allen Browne

Hi, what function do I call to create a copy of a (linked) table to a new temp table in my current db? after that I want to copy the data back to...

colmkav

05-03-2007 09:47 PM
Tom van Stiphout

I need help converting dates. Currently, I have several tables and databases that use the format 1/20/2007. I have a table right now that uses the...

zshenk@riteaid.com

05-03-2007 09:23 PM
Last Boy Scout

I have been trying and looking for a few days to a solution into a query I am looking up one stock code from a table containing multiple outstanding...

walt750@gmail.com

05-03-2007 03:35 PM
Jason Lepack

What is the best way to publish ms access reports to the web? Is there a way to web-enable the form I use to select report criteria and run the...

Marty

05-03-2007 02:23 PM
Marty

In a nested subform in datasheet view, an interviewer of homeless people picks a descriptive CATEGORY from 20 descriptive categories. The 20...

Strasser

05-03-2007 12:01 PM
salad

when i creat query from Query Wizard and select the fields from table and click next it doesnt show me the option of Detail / Summary why is it...

access baby

05-03-2007 11:58 AM
salad

Hi, I am using a linked table to identify which records to update another linked table from the same database. I need to compact this database during...

colmkav

05-03-2007 11:26 AM
colmkav

I'm not sure why this doesn't work... EACRank: IIf(>20,"1",IIf(<14.99,"3",IIf((>14.99) And (<19.99),"2"))) The first condition returns a 1 as...

Bob

05-03-2007 10:36 AM
Bob

I am having one HELL of a time with sending pdfs that I generate. Outlook is not my preferred mail client but I have the wrethced thing installed so...

Tim Marshall

05-03-2007 10:17 AM
Tim Marshall

One of my clients has asked me to make a change to one of their Access applications. The application is a Front End/Back End standard app. I...

teddysnips@hotmail.com

05-03-2007 08:09 AM
paii, Ron

Dear reader, With the DoCmd.OutputTo ...... you have the possibility to write a report to an external location. In case the external location...

Simon

05-03-2007 06:37 AM
UrbanSpaceman

I have a database that I regularly import data into from a text file. The text file is produced by payroll software, and it is always the...

Capn Stoobie

05-03-2007 12:57 AM
Capn Stoobie

Hi, I don't think my message posted correctly so here it is. Is there any way to access the individual values of a form text box? I want to iterate...

greg

05-03-2007 12:32 AM
greg

I created a field called cash in a MS Access form, I want the totals for these fields 100 50 20 10 5 to be placed in that cash field. In the control...

oliver_optic

05-02-2007 11:08 PM
Tom van Stiphout

On Thu, 3 May 2007 01:39:24 +0100, "John" <John (AT) nospam (DOT) infovis.co.uk> wrote: Ship it with the lowest supported version. Buy Office2000 if...

Tom van Stiphout

05-02-2007 09:49 PM
Tom van Stiphout

On Tue, 1 May 2007 02:25:38 +0100, "John" <John (AT) nospam (DOT) infovis.co.uk> wrote: The list control should be unbound. In its AfterUpdate...

Tom van Stiphout

05-02-2007 09:33 PM
Tom van Stiphout

Hello, I have a field of Name and its data are different insurance company names, but there is a "N/A" standing for those folks without...

Steven

05-02-2007 08:48 PM
Allen Browne

Can someone tell me how to check the size of an access database in VB code? I want to write code to check the size and then compact it if it...

colmkav

05-02-2007 05:49 PM
'69 Camaro

Hi - I have 2 new questions in a new database I'm trying to develop. The first has 6 fields on a table and allows the user to enter them on a form. ...

sara

05-02-2007 04:56 PM
sara

Hi everyone I will be having a split database, running on 2 computers via mapped drive. computer "A" will have one front end and the back end...

najimou

05-02-2007 04:20 PM
bob

I have a data view of several records, several columns. Yesterday, I hid a few columns. Today, I want to see the columns when I run the view. I...

Mitchell_Collen via AccessMonster.com

05-02-2007 04:02 PM
Jason Lepack

I have a popup form that consist of a single field called EnteredBy and a Subform that has three fields. The popup form also has a button in the Form...

Del

05-02-2007 02:24 PM
villarreal68@yahoo.com

How do I create and ODBC connection enbedded inside a link???? The upsizing wizard worked great however when it created the ODBC connection somehow...

Michael Kintner

05-02-2007 02:16 PM
Aaron Kempf