i had a button on a form. when clicked, the button runs code that retrieve the values of unbound textboxes on the form and saved the values in a...

fredloh@gmail.com

12-14-2007 08:50 PM
Allen Browne

Michael Lalonde got a letter bomb from Mr Harnwell on a pirate ship and got banished from the country because he felt like it and chased a bunnywhich...

Michael Lalonde

12-14-2007 06:55 PM
Michael Lalonde

If a report has a some text fields, let's say in the detail band, and you set one (or all) of the fields to CanGrow, and all the fields have borders...

Salad

12-14-2007 05:04 PM
christianlott1@yahoo.com

On Dec 14, 12:06 pm, mirandacasc... (AT) yahoo (DOT) com wrote: See below for two solutions for iterating through a controls collection Dim ctrl As...

Tim Ricard

12-14-2007 03:57 PM
Salad

Hi, I am looking to write a query with multiple factors and do not know the best way to do it. I want use Event Type, Status, and Region as my...

bcap

12-14-2007 02:08 PM
James Beswick

I have two main forms that I am preparing. These have been passed back and forth between a consultant and me. For some reason I cannot copy...

kathrynwoning

12-14-2007 12:54 PM
kathrynwoning via AccessMonster.com

I am trying to create a from with a series of combo boxes that each query a different field (called Specific01, Specific02 etc., except the first...

omar.norton@gmail.com

12-14-2007 07:35 AM
tricard@gmail.com

I want to be able to click a button, open a form, and run an SQL statement via VBA. In the example below, I want to open frmBoM and display...

Bob Sanderson

12-14-2007 07:31 AM
lyle fairfield

Hi Group, I'm creating a maintenance switchboard and am trying to create forms to update tables and wanted these to appear as datasheets. Although...

dwasbig9@gmail.com

12-14-2007 06:00 AM
dwasbig9@gmail.com

I have an access application with a backend Sql Server. All data is passed from the back-end (remote Sql Server) to unbound forms via...

Frank Kolbe

12-13-2007 11:32 PM
Frank Kolbe

My environment: A parameterized query that MUST be run as a pass-thru (MS Access cannot handle the SQL) and so cannot accept a parameter from MS...

Oko

12-13-2007 10:23 PM
Tom van Stiphout

I created a report containing a subreport on an XP Pro machine running Access 2003 (using 2000 format for the database) . It is a student report...

youngac@thejnet.com

12-13-2007 07:37 PM
youngac@thejnet.com

I'm trying to export a table to an ODBC database using a VBA subroutine. I have tested the ODBC setup manually and it works fine but when I try to...

Bob Sanderson

12-13-2007 07:36 PM
Chuck Grimsby

Hi All, In AccessXP I have a report, in print preview the report looks good, when I choose Office Links - Analyze It With Excel the...

bobh

12-13-2007 07:19 PM
CDMAPoster@fortunejames.com

I have some code in which I use Transactions. If there is a problem and the Rollback method is called, only the statements which use db.execute...

ionic-fire via AccessMonster.com

12-13-2007 06:36 PM
Allen Browne

Background: I have a table of fields each field representing a month (Jan, Feb, Mar...). These are not a date field but more of a bucket to...

turtle

12-13-2007 05:13 PM
Arch

In Relation to preserving form values: Setting one variable equal to another can be done two ways: "By Reference" or "By Value". "By Reference"...

Oko

12-13-2007 05:08 PM
Oko

Hello..... RE: Access 2003 / VBA Editor Given the sample code: Public Sub TestPayment() Line 1: lngCalculated Amount = ('my large decimal...

rlntemp-gng@yahoo.com

12-13-2007 04:45 PM
rlntemp-gng@yahoo.com

Dear Group Excuse my ignorance but I have never come across this problem and need some advice. I have two copies of the same MS Access 2000...

theintrepidfox

12-13-2007 04:20 PM
theintrepidfox

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: Whereas I have no problem with the A2000/2003 VBE. but to each thier...

Salad

12-13-2007 01:37 PM
Tony Toews [MVP]

I have a report in Access. I want to calculate with the DateDiff function. Two questions. 1. How do I set up the Date Diff to subtract a date in the...

Troy Lee

12-13-2007 01:16 PM
Ron2006

I just talked to some big shot analysis people. They want the data....ok do you want the database, you already have access don't you. NO we want the...

sparks

12-13-2007 12:24 PM
sparks

Is there a way I can direct the cursor to a specific field (variable) in a form by typing the field name while in form view? I have a form with many...

mckbill

12-13-2007 12:17 PM
mckbill

I needed this for address labels that wouldn't wrap. Couldn't find the function so I made one. Splits at space. Function cvtWordWrap(Apl As String,...

christianlott1@yahoo.com

12-13-2007 10:56 AM
christianlott1@yahoo.com

Using A2000 When I click the save icon in form design, Access closes immediately. No warning messges, nothing. This happens on only one form. I...

Karl

12-13-2007 09:45 AM
Karl

Does anyone know how to convert an access table to a csv file with either a macro or a module in an access database??? I can use either access 2003...

f18jetpilot@gmail.com

12-13-2007 09:03 AM
Ron2006

I have a form with 2 fields on it, one for directorate and the other for quarter's i.e. 1,2,3,4 if a certain directorate and quarter is selected go...

Elainie

12-13-2007 08:13 AM
oldeast

I have a list and it's rowsourcetype is set to the function get_databases_DIR. Function works without any problem in MDB, but not in MDE (nothing is...

Chris

12-13-2007 03:24 AM
Chris

Hi, My company's backend is located at a location with a long address, something like...

bg_ie@yahoo.com

12-13-2007 12:39 AM
Salad

i'm new to VBA and i need to Build a Dailog form that will enble me to import .csv or .xls files to access. anybody directs me where can i find...

xtopia

12-13-2007 12:19 AM
Allen Browne

I have a form with several comboboxes whose contents I'm trying to initialize from a table. The table, ComboSelections, has 3 fields, an autonumber...

Thelma Roslyn Lubkin

12-12-2007 10:03 PM
Salad

we have 2 Access Applications. One is in Access 97, the other in 2000. With Access 97 I was able to replace a module that contains an old...

alanmcarter@gmail.com

12-12-2007 09:49 PM
Salad

We have a tool built for determing which Access version an mdb is that works nicely. Problem is, hundreds of PC's here are getting reimaged without...

don.fleming@pse.com

12-12-2007 09:27 PM
Tom van Stiphout

Hello, I am relatively new to Microsoft Access and databases in general, and have a problem - one which I think may necessitate some VBA code...

p.smachylo@gmail.com

12-12-2007 08:59 PM
Bob Quintal

I am trying to create a form that shows quote info, but also has a subform that lists all keywords and allows you to select multiple keywords to...

Craig

12-12-2007 07:52 PM
Craig

I have this query that when run on Access 2007 works, when run in 2002 it fails with the following error: Incorrect Syntax near '.'. INSERT INTO...

pmacdiddie@gmail.com

12-12-2007 07:48 PM
Chuck Grimsby

I can see why this doen't work in a simple query, but I don't know how to fix it... I have a table of client transactions, (ACCOUNT_NUMBER, DATE,...

gcattley@dawsonmedia.com.au

12-12-2007 05:44 PM
Bob Quintal

I work for a company where I do quality assurance. We get a spreadsheet every week of the curent employees where I work. What I need to do is import...

majortool

12-12-2007 02:45 PM
majortool

I received an installation program to load an application on my home computer (WinXP w/ OfficeProXP). The app was originally built in AccessXP,...

Earl Anderson

12-12-2007 01:43 PM
DawnTreader

Afternoon Is it possible to display test alongside the Navigation Buttons in an MS Access form? I have a complex form containing a number of...

Gary

12-12-2007 08:47 AM
Allen Browne

Hi, we encounter a strange error with our Access Database. It's randomly raised and looks like this : ***** Debug Assertion Failed ! Program :...

Franck

12-12-2007 04:37 AM
Franck

Ian wrote: The only way to display an image per picture in a continous form is to use a bound picture control and store the images in your database...

Rick Brandt

12-12-2007 01:09 AM
John Mishefske

Where and how do I declare a variable that I want to use throughout the entire Access database? Thanks

bgreer5050@yahoo.com

12-12-2007 12:54 AM
Larry Linson

10 years ago, the below was written (see very end, after my signature RL). What, if anything, has changed? I have Access 2003 and soon Access 2007...

raylopez99

12-11-2007 07:31 PM
raylopez99

Hi, Using Access97 and WinXP I'm trying to control the drop-down list shown in a subform combobox from the selection made in a combobox on the...

brian_snelling@telus.net

12-11-2007 07:23 PM
brian_snelling@telus.net

Dear reader, In case a report is a sub report the Report Header of the sub report is printed in the report but the Page Header of the sub report...

Simon

12-11-2007 06:24 PM
Wayne Gillespie

download now http://freenewsoftware.blogspot.com/2007/12/free-xml-schema-editor-liquid-xml.html

Tony Andreas

12-11-2007 06:22 PM
Tony Andreas

Hi all, I've looked through many forums and still indecisive of what to choose for my database. Can anyone give me a full account (advantages...

angeletan@gmail.com

12-11-2007 08:22 AM
Ron2006

Hi, i'm using Access2003. I have created db1 that is password protected and db2 which is a copy of db1 that is read-only and available to all. I...

timothy.burt@gmail.com

12-11-2007 05:05 AM
timothy.burt@gmail.com

Hello, I had posted a few days ago regarding the lpad and rpad and thanks to help i got I was able to format my data.On the same lines I need help in...

Roy

12-10-2007 07:30 PM
lyle