We have a published application (Access front end linked to Access database) made available on a Citrix server farm. All servers are Win 2003. This...

Bill E.

07-29-2009 07:15 PM
David W. Fenton

I have an excel spreadsheet (a dump from another database) which I'm importing into one table; the fields are named: name, scenario (there are 3),...

The T

07-29-2009 05:19 PM
Salad

How can can code be run for each row in a two column report? For example, 1 record = 1 row 2 records = 1 row 3 records = 2 rows 4 records = 2 rows 5...

Steve

07-29-2009 04:21 PM
Larry Linson

How come I get the time in hrs/min/sec while the with the mask input wizard I get 00:00;0;_ as mask. Other similar textboxes give the right input...

AA Arens

07-29-2009 04:11 PM
Larry Linson

If you were asked to survey 1000 people and collect information for your Access database, how would you do that? Let's say its about 10 questions,...

Salad

07-29-2009 01:40 PM
Tim Mills-Groninger

I use these code in the afterupdate event of a combobox to let the cursor jump to another field and also to avoid it default highlight the contents...

AA Arens

07-29-2009 11:54 AM
Marshall Barton

Hi, I am using Access 2000 and am trying to import a TXT file that is Fixed Length. IT appears when reaching the Access database it is cutting out...

bcap

07-29-2009 03:00 AM
Larry Linson

Hi, I have created a Training database. Employees need to enter their training each month. I have created three tables: Employee, Unit,...

Monika

07-29-2009 12:04 AM
MGFoster

We get certain quarterly data in column-width format.. I hate having tor respecify the file layout every time and we would make fewer mistakes if it...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 11:32 PM
MGFoster

Newbie question. In A2003, I select from the menu Help/About and I see the version and the SP that I have; A2003 SP3. Is there a way to see the...

Salad

07-28-2009 06:21 PM
Salad

Hi All, I am using Access as a quickie front-end to our Oracle databases. One of our procedures writes the Oracle RowID to a custom column called...

jonceramic

07-28-2009 05:48 PM
jonceramic

how would I get the most frequent part of a feild (telephone cntrex). I have some idea how to use "ORDER BY COUNT DESC LIMIT 1" but what if I want...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 04:12 PM
Salad

Hi had 2 questions: 1)What is the best way to transfer data that was entered into an MS Access 2003 database by using Access 2007?! (User opened her...

zufie

07-28-2009 03:37 PM
zufie

Hi had 2 questions: 1)What is best way to transfer data entered into a MS Access 2003 data using Access 2007?! (User opened her Access 2003 database...

zufie

07-28-2009 03:30 PM
zufie

I have a selection of SQL queries I'd like to be able to email as a collection so others can import them without my having to copy the entire mdb...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 01:17 PM
vjp2.at@at.BioStrategist.dot.dot.com

I am pretty certain I have used this database from newer versions of access withour problems but I only have PRM and DBF files and no IDX file, which...

vjp2.at@at.BioStrategist.dot.dot.com

07-28-2009 01:14 PM
vjp2.at@at.BioStrategist.dot.dot.com

Hi all, I'm having a problem with a combo box. The combo box shows broker id's and broker name. The bound field is broker id, the limit to...

jovii

07-28-2009 11:49 AM
jovii

Left, Right, Top and Bottom Padding all seem to default to .0208". If any or all are set to 0", they seem to default back to .0208" Is there a way to...

Steve

07-28-2009 10:20 AM
BruceM

I have a text box that needs to be filled / populated with the Sum of all the payments made by the worker selected in the combo box. The following...

RCGUA

07-28-2009 09:12 AM
RCGUA

I have a form. How to add code so that a default find-record button upon activating directly: - set "Look In" to the right column of the table -...

AA Arens

07-28-2009 07:58 AM
AA Arens

Folks - Pardon me if this is an FAQ or something really weird. I have been stumped in this area for one year and I have no where else to...

Dan

07-27-2009 10:23 PM
Tony Toews [MVP]

When I click the Command Button to open a form I receive the error: Object Reuired. This form is a subform connected to a main form. Any...

zufie

07-27-2009 05:27 PM
Salad

I have a bound form that is set to open to a new record. The user picks from a combox, types in an amount in a text box, etc, then saves the record...

RCGUA

07-27-2009 04:38 PM
RCGUA

I'm a novice Access 2007 user trying to modify an existing Form with 3 pages. I've added fields in the table, and then added new fields to p. 1 of...

May PSC PSC

07-27-2009 02:36 PM
Keven Denen

Using a simple example like an order and the order details, how can I save/export to an XML file? One the one-side of an order I might have Order...

Salad

07-27-2009 02:15 PM
Jens Schilling

Hi, I have a main form which has a sub form on the page, the sub form contains two text boxes of totals (total A & total B), when a value is in...

John

07-26-2009 03:44 PM
fredg

Hi Everyone I have 2 memo fields 1. txtBuyerAddressEbay 2. txtBuyerAddress In txtBuyerAddressEbay the address appears thus: Bert Smith 1 Buddy...

bobdydd

07-26-2009 08:24 AM
put_upon

In A2k3, I have a Report system which will include images (linked to a separate folder on the server) in pages after the textual pages. What...

Earl Anderson

07-25-2009 10:01 PM
Earl Anderson

Using acFormatPDF, I'm exporting a report to PDF. Is there any way that this process can embed the font used in the report?

anthony

07-25-2009 04:51 AM
anthony

I would like to have a report print based on the filtered results of a form. How do I set this up?

Rosy

07-24-2009 06:50 PM
Salad

We have a subform that contrains 8 variables. any time on this Continuous Form if someone enters a value in one of the fields I need to put now()...

sparks

07-24-2009 02:47 PM
sparks

I have a main report "ApplicationForm" and a subreport "RptXMonthlyFees" There is a sort of Link Master and Child relationship with a field...

Phil Stanton

07-24-2009 12:20 PM
Phil Stanton

Hi everyone, I can't find how to change a form (in design mode) with a named autoformat by VBA? Is there no VBA command to do that?? Thanks for...

Lorenz Hölscher

07-24-2009 09:06 AM
Lorenz Hölscher

I have a form that I wish to filter by two different fields using unbound combo boxes. I have the following and it works but with only one box at a...

Rosy

07-23-2009 09:21 PM
James A. Fortune

"Mr.Frog.to.you (AT) googlemail (DOT) com" <Mr.Frog.to.you (AT) googlemail (DOT) com> wrote: You do have an excellent point there. And thinking...

mark

07-23-2009 05:45 AM
mark

Interesting Error with WXP & A2K, I have a parentform with a subform control. The subform control is merely a form object with a control source of a...

zuckermanf@gmail.com

07-22-2009 10:07 AM
zuckermanf@gmail.com

Hello, I have a form where I fill out manually or select from a combobox several criteria like Name, Title, Date. These fields are bound to a table...

drgka55

07-22-2009 09:49 AM
drgka55

Hi All, I am attempting to basically display an object and then hide it using an event. I simply need to make it visible, and then make it...

DeZZar

07-22-2009 07:27 AM
paii, Ron

Hi All, I have two problems linking query criteria to forms. Basically, within a query I have the criteria set to read form data. So.... Criteria...

DeZZar

07-21-2009 10:31 PM
MGFoster

Hi all, I have a string where I need to strip out an amount. The string looks something like this: "1.00 cents per gallon premium to July 2009...

jovii

07-21-2009 09:48 PM
jovii

Good Day, Trying to follow a hyperlink using VBA in Access. The address of the hyperlink is to a form (.pdf) that is located in the same directory...

Bull

07-21-2009 06:02 PM
Bull

I'm looking for some upfront guidance. I need to produce a summary report of records for a year with totals split by month. Each column consists of...

cp2599

07-21-2009 02:57 PM
Salad

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