| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Using ImportXML to import xml data into Access tables. I typically,
delete all records in the target table (e.g. the table with the same
name as the...
BobAlston
|
07-07-2011 03:49 PM
BobAlston  | 1 | 2 |
| | | I updated from A2K to A2010 recently and found that in order to use
existing right button clicks (for popup menus) I needed to change the
SandBoxMode...
Jim Devenish
|
07-05-2011 01:45 PM
Tony Toews | 1 | 2 |
| | | Hi NG
WinXPPro
Office 2007
I try to make an installation pack with runtime 2007...
I make a packet with an accdb file, and runtime included...
It...
bsn
|
07-04-2011 03:35 AM
bsn | 5 | 6 |
| | | When using an Access FE with an Access BE, I often use filtering,
docme.openform with a where parameter specifying the specific record to
be opened....
BobAlston
|
07-01-2011 04:50 PM
David-W-Fenton | 1 | 2 |
| | | I've got an Access 2010 subform with 3 combo boxes, 3 textboxes with
input masks (for a date formatted mm/dd/yyyy), and 2 check boxes. If
I click on...
emanning
|
07-01-2011 04:28 AM
Jon Lewis | 3 | 4 |
| | | I am using Access 2002 - I have a Form where I allow a user to enter some
details then press a button to merge these with an 'Email Template' I
have...
Isis
|
06-30-2011 04:36 PM
James A. Fortune | 3 | 4 |
| | | Being an optimist, I've just loaded Office 2010 SP1 in the hope that it
would fix the Nav Pane scroll bar problem (which I've posted here before).
It...
Bob Darlington
|
06-30-2011 12:40 PM
Arvin Meyer | 1 | 2 |
| | | Anyone know if the DFW area Metroplex Access Developers group is still
in existence?
I am aware of the NTPCUG Access...
BobAlston
|
06-29-2011 06:51 PM
Access Developer | 1 | 2 |
 | | "Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote in
news:ZVtNp.28547$8G4.25505 (AT) newsfe17 (DOT) iad:
I don't think this is a...
cubangeek
|
06-28-2011 02:12 PM
PW | 17 | 18 |
| | | I have an Access 2010 subform with 3 comboboxes, 3 textboxes, and 2 checkboxes. The first control I click on, whether it's a combo or text, causes...
emanning
|
06-28-2011 11:24 AM
Clif McIrvin | 1 | 2 |
| | | Hi All
I need some help to rewrite Access SQL tol SQL Express
TRANSFORM Count(tbl_ORDH_STAT.RECID) AS AntalOfRECID
SELECT tbl_ORDH_STAT.O_UGE
FROM...
olesen
|
06-28-2011 09:35 AM
Bob Barrows | 3 | 4 |
| | | I have Access2010 and I use this for a Movie Titles database.
I have already configured the a query to remove the "A" and "The" from
the titles to...
Peter Jason
|
06-28-2011 06:54 AM
Bob Barrows | 14 | 15 |
| | | Data visualizations: When only the most appropriate, not the ‘best’,
will do
In a recent blog post – Business Intelligence: Intuitive vs cool...
Jan
|
06-27-2011 07:57 AM
Jan | 0 | 1 |
| | | I have an Access app that I provide for free to nonprofit food pantries.
so far I have a few hundred installs. Generally they operate in a
single...
BobAlston
|
06-25-2011 01:52 PM
Tony Toews | 9 | 10 |
| | | On Jun 24, 8:57*am, Roger <lesperan... (AT) natpro (DOT) com> wrote:
I'm using a ADODB.Connection to wrap a complex update into a
transaction
where...
Roger
|
06-24-2011 11:19 AM
Roger | 0 | 1 |
| | | Hello All
I tried this multiple ways and nothing is helping.
I have a report based on a crosstab query to allow me to show 2 rows
on one line - query...
flymo
|
06-23-2011 10:28 AM
Access Developer | 12 | 13 |
| | | Hi
I have a Main Form with Subform
I have a Report that opens on a query that restricts it to a single
record
On the report there are Labels whose...
bobdydd
|
06-22-2011 09:12 AM
John Spencer | 3 | 4 |
| | | Using Access 2010. I am using a custom ribbon with startfromscratch=true. My
custom tabs/buttons appear and work. However when a form is open...
agiamb
|
06-21-2011 12:15 PM
Sky | 8 | 9 |
| | | I'm using a multi select list box after update event to call a separate
function to build a filter for a form using:
strList = ""
With Me!lstLAN
For...
Bob Darlington
|
06-21-2011 03:45 AM
Bob Darlington | 2 | 3 |
| | | Hi all,
I have an application running on a virtual server, Windows 2008
Server. Clients log in via remote desktop and run an Access 2007
runtime...
Owen
|
06-21-2011 12:38 AM
Owen | 1 | 2 |
| | | Hi,
I have created an mde which sends email using simple SMTP (let's call
it Email.mde). I want to reference it in another mde, called Main.mde.
I...
Owen
|
06-20-2011 08:26 PM
Owen | 2 | 3 |
| | | Subject : - Concatenate Column Values from Multiple Rows into a
Single Column with Access
I would like to combine a field's values from multiple...
Vikas Chauhan
|
06-20-2011 08:59 AM
Bob Barrows | 3 | 4 |
| | | Hello All
I have utilized the excellent examples from Duane Hookom recurring
calendar mdb and have a question about modding for...
flymo
|
06-20-2011 08:37 AM
flymo | 7 | 8 |
| | | Hi,
Why is this returning records that exist in the first table
(tblRoomAssignmentTemp) that are not in the second table
(tblMoneyReceived)? From a...
PW
|
06-16-2011 01:13 PM
PW | 10 | 11 |
| | | It might be worth having a look at SysFilterByForm from a firm called
www.AccessToGo.org.UK. It costs, and is a bit fussy requiring saved queries
as...
PW
|
06-15-2011 12:08 PM
PW | 5 | 6 |
| | | In A2010 I can place subforms in a stacked layout and get them to
resize with a bit of code. I try the same thing with A2007 and the
subforms jump to...
christianlott1@yahoo.com
|
06-14-2011 02:01 PM
christianlott1@yahoo.com | 2 | 3 |
| | | I have the following VBA code (behind an Access button) that moves all
emails from one Outlook folder to another. The code works fine for
users of...
Boyd
|
06-14-2011 12:12 PM
Phil | 3 | 4 |
| | | I have an Access 2000 FE/BE that was converted to Access 2007 and has been
working fine. Client now wants to use with 2010. Most everything works ok...
agiamb
|
06-13-2011 01:47 PM
agiamb | 0 | 1 |
| | | I have a procedure that is intended to publish an Access report as a
PDF repeatedly, each time with the recordsource data changed.
When I use the...
septimus
|
06-13-2011 08:48 AM
grovelli | 7 | 8 |
| | | Can anyone advise on the best way to network an access database.
Currently have two computers connected by LAN cables to a broadband
router. Main...
BobbyDazzler
|
06-12-2011 05:07 PM
Tony Toews | 6 | 7 |
| | | Hi All!
I have a field called txtAcctNum that may change occassionally. I have
a LOT of tables to deal with and am tired of setting up an...
musicloverlch
|
06-10-2011 02:46 PM
John Spencer | 3 | 4 |
| | | I was recently upgraded to Access 2007. I am trying to export a table
to text. My table has 2 date fields and several other fields. The
fields look...
Coll
|
06-10-2011 01:52 PM
Phil | 1 | 2 |
| | | Hello Master,
Is it Possible to put Networkdays with Holidays formula in Ms Access
Please Help me it's Very urgent for me.
Advance Thnx,
Vikas Chauhan
|
06-10-2011 08:06 AM
ron paii | 10 | 11 |
| | | I've got a command button that on rare occasions
fails with "Object invalid or no longer set"
I've got such a case now and
in the debug window, if I...
Roger
|
06-09-2011 07:07 PM
agiamb | 5 | 6 |
| | | qryPartsQuote is a linked table to a sql server 2005 view
running the select statement in the management studio takes less than
a second
the...
Roger
|
06-09-2011 12:07 PM
Roger | 0 | 1 |
| | | Anyone know how to reference a DLL which does not have a separate .tib
file? I have generated the DLL using WSDL.exe and VBC.exe. It
generates a...
BobAlston
|
06-09-2011 05:02 AM
The Frog | 19 | 20 |
| | | Does anybody have experience with MS Access deployments in a
Citrix environment?
On one of my apps, a mystery problem has arisen.
A certain form,...
(PeteCresswell)
|
06-08-2011 06:53 PM
David-W-Fenton | 24 | 25 |
| | | The Frog <mr.frog.to.you (AT) googlemail (DOT) com> wrote in
news:f6e5e79f-36bf-4049-9983-71ecd314b1bb (AT) hl1g2000vbb (DOT)...
aceware
|
06-08-2011 06:51 PM
David-W-Fenton | 11 | 12 |
| | | per Microsoft kb articles
you cannot use the outlook object model as part of a process
(scheduled task)
CDO is not supported with outlook 2010,...
Roger
|
06-08-2011 06:25 AM
Roger | 2 | 3 |
| | | I know this is a well trodden path but I am confused. I need to
connect an Access 2010 database to a SQL Server. I make two...
Jim Devenish
|
06-07-2011 04:15 PM
Bob Barrows | 1 | 2 |
| | | In my split dabase, which is used by 15 persons, the backend's main table
suddenly misses 4000 records in comparison to last night's backup. I... |
06-06-2011 04:40 PM | 4 | 5 |
| | | I use the following to send an email to various people.
When there is a single MailTo name (e.g. Fred Smith) it works fine
If I want to send it to...
Phil
|
06-06-2011 09:14 AM
Phil | 13 | 14 |
| | | Dear All,
I want to copy multiple records from one table to another with
specific field. I have written code. It is copying only first record.
I use...
Naushad
|
06-06-2011 06:31 AM
Bob Barrows | 1 | 2 |
| | | Hello All
I have been googling, trying to find a sample of a form where list
boxes are used based for a fairly complex schedule and multiple
resource...
flymo
|
06-05-2011 05:23 PM
flymo | 6 | 7 |
| | | Hi
I have created a simple database to record daily events (events on a
subform on the header record for the day). I have included an unbound
combo...
Chris
|
06-05-2011 12:15 PM
Marshall Barton | 2 | 3 |
| | | I have a combo box that based on what is selected populates a list
box. When the user creates a report, I create a variant that stores
the combo box...
Icarus
|
06-05-2011 12:00 PM
Marshall Barton | 3 | 4 |
| | | Can I programmatically control the Y axis major and minor units on
charts? The ones that Access is deciding for itself are wrong.
Thanks,
Laura
musicloverlch
|
06-03-2011 09:49 PM
Rob Parker | 4 | 5 |
| | | Since access 97 we have used this and it worked perfectly well to
reset something on an option group
double click =
Public Function...
sparks
|
06-03-2011 10:59 AM
sparks | 2 | 3 |
| | | BobAlston <bobalston9 (AT) yahoo (DOT) com> wrote in
news:irrcek$3as$1 (AT) dont-email (DOT) me:
I'll answer these in the opposite order you...
David-W-Fenton
|
06-01-2011 08:54 PM
Tony Toews | 2 | 3 |
| | | --
Notes on 25 May 2011
The "New Google Groups" UI does not thread correctly, but the old UI
still does.
From the old Google Groups UI there is a...
Clif McIrvin
|
06-01-2011 06:24 PM
Tony Toews | 3 | 4 |
