DCount error 3163
Tue, 16 Mar 2010 08:18:53 -0700 (PDT)
Hi everyone.
I have been assigned the task of checking wether all of our Access
2003 applications currently running under WinXP 32-bit will behave
well if we moved to Access 2010, Win7 64-bit.
So I went to the Direct-Box of the code window and entered
?Application.DCount("*", "TB_xxx")
where "TB_xxx" i ...
|
ahtFillPrinterList in Windows 7?
Fri, 12 Mar 2010 13:30:50 -0800
Has anyone tried using the basGetPrinters ("ahtFillPrinterList") code from
Getz/Litwin to build a combo box of installed printers under Windows 7?
I've tried, but the resulting combo box is empty. The code doesn't throw
any errors ... it just doesn't seem to do anything.
bob
...
|
MAPI error=2 first time, works everything after that
Thu, 11 Mar 2010 21:51:46 -0500
I'm not sure if this is the right group. Please help me with the correct
group if this needs to be moved
Environment:
Windows Live Mail (most current version)
Windows XP sp3, Vista, or 7
Access 2003 or 2007 .mdb or .mde (does not seem to matter)
The send message will fail with a MAPIError of 2 (the somethi ...
|
SQl help with assigning data to new column in query results
Thu, 11 Mar 2010 06:17:01 -0800
Hi
I am trying to assign a value to a temp column for something based on 2
other columns.
Select ID, Imm, Ell
From table_1
where Imm='Y' OR Ell='Y'
I want the column to report an E if or an I. Where and How do I declare? ...
|
Form / ListBox Poor performance 2007
Wed, 10 Mar 2010 05:15:01 -0800
Hi,
I have a form with a listbox that has SQL as the rowsource. The query is
somewhat complex but is running against a main table and a couple of lookups
(all indexed) that have less thatn 6000 records each. I am populating about
13 fields in the list box.
The query correctly retrieves about 40 records ...
|
How to create a scheduled task in MS Access
Sun, 7 Mar 2010 05:25:01 -0800
Hi everyone:
I have done some research into finding ways to perform a scheduled task for
MS Access.
Basically all I have found is to use MS Scheduled Task can open ms access to
run a macro.
I would like to do something a little more in house.
So I would like to have a form in access that the user wil ...
|
2007 - 2003 Databases
Tue, 2 Mar 2010 10:33:01 -0800
2007/2003
Are there any hints or fixes?
I have clients using 2003 exclusively and some other clients using 2007
database exclusively. I love 2007 and develop exclusively in 2007.
I have installed both 2003 and 2007 installed on my laptop (and I have a
couple of other machines with dual installs and ...
|
|
|
Re: ANTIVIRUS FREE DOWNLOAD 8933
Sat, 27 Feb 2010 05:12:23 -0700
On Thu, 25 Feb 2010 16:10:06 -0800, antivirus gratis
<antivirusgratis@discussions.microsoft.com> wrote:
Hi, you're back! Did you really think that this time we would fall for
trusting our machines to unknown software from a spammer? We didn't
get THAT stupid in one week.
-Tom.
Microsoft Access MVP
<cl ...
|
Editing Link Specifications and system tables
Wed, 24 Feb 2010 17:24:30 -0000
I want to create lots of Link Specifications, preferably on the fly.
These are stored in the tables MSysIMEXColumns and MSysIMEXSpecs, but a user
is preventing from appending or editing them.
Is there a way around this, is it sensible or is there a better way?
thanks in advance
Rod
...
|
Button to open specific excel document
Tue, 23 Feb 2010 01:00:01 -0800
Hi
Sorry I am not experienced with VB.
Could someone please provide a code I can assign to a command button that
will open a specific excel spreadsheet that is password protected and input
the password on our behalf?
Adapting the following would be great
Private Sub Command0_Click()
On Error GoTo Err_Co ...
|
