Hi Everyone, Just a quick check if this is possible (I havent seen it done but I am still hopeful...). I am looking for a way to take an ADO stream...

The Frog

07-21-2009 06:12 AM
Mr.Frog.to.you@googlemail.com

I am trying to show a concise list of membership fees for new members joining different months. Tables are (simplified) and ignoring add the...

Phil Stanton

07-21-2009 05:56 AM
Phil Stanton

I have a form with a subform that has a subform. When you tab on the last field of the main form it goes to the first field of the subform. ...

Rosy

07-21-2009 12:46 AM
MGFoster

I have a form which pulls in records on vessel names. (VesselName) On this form I have a subform (VesselInfo) which displays in datasheet and...

Rosy

07-20-2009 06:19 PM
Rich P

I am using a boolean field in tblOrgs (Organisations) called 'Active' to indicate whether an organisation is active and should be displayed in combo...

Paul H

07-20-2009 05:45 PM
Larry Linson

I am redoing the user interface for a client application. On the main screen it displays the time in all of the time zones in the Continential US....

John von Colditz

07-20-2009 05:00 PM
John von Colditz

I have a form that I would like to query a table and display the last record entered. I've tried macros and basic query but am having no luck. It...

Rosy

07-20-2009 01:52 PM
Salad

Anyone know a way to show the pivot table field list by default when opening a query in pivot table view? Bob

Bob Alston

07-20-2009 01:39 PM
Bob Alston

All, I developed a little Access app that outputs a query to Excel; rather than complicate things for the client with adding Tools > References, the...

Jeff

07-20-2009 11:24 AM
Jeff Norville

To make it simple, say the main report is Make and the subreport is model. The subreport is set as a two column report, across then down. This works...

Steve

07-20-2009 10:03 AM
Keith Wilby

Hi. I want to create a simple invoice in access? Is there any example or tutorial of how to make an invoice? Thank you in advance.

Bono Vox

07-20-2009 07:52 AM
Bono Vox

lyle fairfield <lyle.fairfield (AT) gmail (DOT) com> wrote in news:acb8d6b0-6de6-474b-a08d-a03ea3202fe0 (AT) w9g2000pro (DOT)...

James A. Fortune

07-19-2009 06:41 PM
James A. Fortune

Allen, thanks for the advice regarding the Trans Type Table. I can see the merit of using this for a large inventory of like items ,i.e., 200 widgets...

Rolan

07-19-2009 07:47 AM
Allen Browne

Let's say there are 2 sets of records; set 1 for today, set 2 for tomorrow. Can 1 PDF file be created (I'm using Stephen Leban's Report to PDF...

Salad

07-18-2009 08:37 PM
mark

Is there a way to have a form display the number of records return by a query? I realize that this info is in the navigation bar at the bottom of...

Rosy

07-18-2009 10:45 AM
Krzysztof Naworyta

In Access, Is an API the same as a module? If so, how can you call a module in the VB code? Thank you! Ray

bcap

07-17-2009 03:52 PM
MGFoster

Hi, I am looking to create a command. When clicking on a button I would like to: 1) Run a update query 2) Create a new file that is query...

bcap

07-17-2009 03:38 PM
MGFoster

thanks for the replies guys! MGFoster I tried your suggestion but I get the error "Subscript out of range" and the line " dblValues(i+1) =...

DeZZar

07-16-2009 08:25 PM
DeZZar

Hi All, Is there a way to make an inputbox activate the forms modal properity? Normally I would use inputboxes like this strAns=Inputbox("Ask the...

bobh

07-16-2009 07:37 PM
Lou O

I'm converting an Access 97 mdb to Access 2007. There is a subform in 97 that is based on a query which has a field called Attendee that is either 1...

emanning

07-16-2009 01:09 PM
emanning

Hi, Where i work i'm the only person who has Access2007, everyone else is on 2000. I have a bunch of queries that i export on a weekly basis and...

d3cyph3r@gmail.com

07-16-2009 12:21 PM
Salad

I have a database that was originally created in Access 2003. I now use 2007, but have users who still use 2003 so I can't convert it to newer...

Rosy

07-16-2009 09:44 AM
Rosy

I can't figure out why when I open my database the "Enter Parameter Value" dialogue boxes for the Date From and Date To textboxes appear on the...

zufie

07-16-2009 09:22 AM
zufie

When I add the "duplicate record" button, which is a standard feature of Access, I get the alert "CopyPaste isn't available now". I have browsed...

AA Arens

07-16-2009 09:05 AM
Marshall Barton

hi i have a folder containing varioous documents, which are in any number of formats using a combobox i select a fault and print the relevent...

kevcar40

07-16-2009 07:55 AM
kevcar40

Hello: I am a self-taught Access user (thanks to Google) and trying to finish a correspondence tracking database for my office. The table contains...

ellie.smith

07-15-2009 11:22 PM
DeZZar

I have a continuous subform with a text box and 5 check boxes. I know how to use condiitonal formatting to make the text bold when the value in the...

Opal

07-15-2009 06:44 PM
Opal

Is it possible to call a function within a form? I think I've done it before, using some syntax like: Forms!!Me.MyFunction W. Pooh (AKA Winnie P.)

Christopher M.

07-15-2009 02:42 PM
Christopher M.

I have been tasked with the following: See if you can figure out approximately how much space it takes to store 1 individual (record)? This would...

zufie

07-15-2009 02:28 PM
MGFoster

This code: Set qdfCP = DB.QueryDefs("lqrptPhotoActivity") For Each prmCP In qdfCP.Parameters prmCP.Value = Eval(prmCP.Name) Next prmCP Set rstCP =...

anthony

07-15-2009 11:31 AM
anthony

Hello all, I want to refer a value from subreport on a main report. If the Name on the main report matched the name on the subreport, the field...

Orchid

07-14-2009 06:22 PM
Larry Linson

Dear all, Code below should open an excelfile in maximized window, it always did, until we moved from Windows XP to vista ( windowserver2008) What...

Filips Benoit

07-14-2009 10:25 AM
Filips Benoit

I am using Access 2003 and Office Developer Packaging Wizard to create a .exe setup/install file of my Access database. The package is made but when...

RCGUA

07-12-2009 10:28 PM
RCGUA

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote in message Actually, as a minor point, I never anywhere in those posts...

Salad

07-11-2009 04:04 PM
Wayne

Hello all, I have a parts screen with mainly a left-handed tree view control with part categories, and the right hand side is a datasheet subform...

Andy

07-10-2009 11:03 AM
Andy

Hi Lyle, I have had a look at Zoho but have not had the chance yet to really 'put it through its paces'. I might have a look at it this weekend...

Mr.Frog.to.you@googlemail.com

07-10-2009 02:20 AM
Mr.Frog.to.you@googlemail.com

I have a form that is bound to a table and some of the text boxes on the form are bound to fields in that table. I also have many labels on the form...

RCGUA

07-10-2009 01:18 AM
Larry Linson

I do have a form. With buttons, textboxes and combo's on it. All output from this form to be stored in one record in one table. I am looking for a...

AA Arens

07-10-2009 01:02 AM
AA Arens

I am using Access 2007 and I have been tasked with creating a query to produce information, and for the life of me, I cant figure it out...maybe you...

OverMyHead

07-09-2009 04:08 PM
paii, Ron

Dear all, Since we moved from Windows XP to vista ( windowserver2008) we have this resting problem: Officeversion 2003 unchanged. Remote desktop...

Filips Benoit

07-09-2009 01:14 PM
Filips Benoit

I need to display the last time a table was modified (design changes) on a form. I don't care about data changes but only the modified date that...

koturtle

07-09-2009 11:44 AM
koturtle

I have recently replaced several of my backend tables with ODBC links to a MySQL database residing in the local network. A consequence of this is now...

robert.waters

07-09-2009 11:20 AM
Tony Toews [MVP]

How to get red button text if I click on it (where the value in the table will be -1) and remains red when pushed down, and remains black text in not...

AA Arens

07-08-2009 11:07 PM
AA Arens

MS access XP (which sucks compared to 97) SP3 Just building a new app using my usual style with utilises a main form with a tab control on it in...

NZDeveloper

07-08-2009 09:09 PM
NZDeveloper

Hi, I have a user who gets the OpenReport Action was Canceled error when clicking on any report preview button in any Access 2003 database that she...

ellenricca@gmail.com

07-08-2009 03:54 PM
ellenricca@gmail.com

The following data needs to be placed in a preprinted report: AssemblyID Assembly ComponentID Component 1 A ...

Steve

07-08-2009 02:01 AM
StopThisAdvertising

Under Tools -> Startup I can choose to have most features in the menu bar (or even the menubar himself) dismissed. This is including the item...

AA Arens

07-07-2009 11:17 PM
AA Arens

I am re-posting this because I wasn't sure if the previous posting was considered as "solved" and I wasn't sure if I should add to the previous post...

RCGUA

07-07-2009 07:16 PM
RCGUA

I am re-posting this because I wasn't sure if the previous posting was considered as "solved" and I wasn't sure if I should add to the previous post...

RCGUA

07-07-2009 06:56 PM
RCGUA

Dear reader, I have an application developed under Access 2003. Now it is working on Access 2007. It looks like everything is working on the local...

Simon

07-07-2009 06:33 PM
Tony Toews [MVP]