ÐÒ¸£Éú»î
Fri, 30 Nov 2007 14:24:54 +0800
Ê÷Ò¶
ºÇºÇ£¡
...
|
additems to listbox with two columns
Thu, 29 Nov 2007 16:21:00 -0800
Using an Access Form with two listboxes... List1, having two columns, and
List2, containing nothing. when I click an item in list1 I want the data on
that row to go
into list2 with the columns reversed.
IndexNum = 0
List1.column(1, List1.Listindex) into List2.column(0, IndexNum) &
List1.column(0, List1.Li ...
|
Print multiple mailing labels in Access 2003 or 2007
Wed, 28 Nov 2007 16:07:25 -0700
I have come across the following KB from Microsoft that has helped me to
print a fixed number of copies of the labels that I wish to print. This
works pretty well.
http://support.microsoft.com/kb/299024
However, I would like to include a field in my table for the number of
copies I want of each label. For ...
|
Relinking SQL Tables
Wed, 28 Nov 2007 11:44:45 -0500
Hello all
I have a database that uses quite a few tables from SQL server. The problem
is that when I post a new version of the database, I have to manually relink
the SQL tables via the Linked Table Manager.
Does anyone know of a way to either automatically relink the tables or code
to put behind a butto ...
|
disable security questions on startup when using runtime version
Mon, 26 Nov 2007 13:30:22 -0500
I got the package wizzard running as part of the Access 2003 developer
extensions.
Seem to have some error messages that I do not get in the regular version
which I hopefully can figure out,
but my main "pain" are the VBA security messages (3 in a row) that pop up on
a new Access install.
Usually I get ri ...
|
Change Data from Now() to Date() Format - ** H E L P * *
Mon, 26 Nov 2007 09:58:45 -0500
I've been entering data ( for some time ) in one of my field in a database
with the Now() format - eg: 11/26/2007 9:52:0a AM
I've now discovered that I should have used the standard date() format - eg:
11/26/2007
This would facilitate my record retrieval in the future.
Is there a way to do an update que ...
|
Stored Query vs SQL SELECT statement
Sun, 25 Nov 2007 10:31:00 -0800
I would like to ask for some advice about the performance of stored queries
vs. SELECT statements and when/where to use each.
Which of the following scenarios would be faster/better/more
efficient/preferred by real programmers (unlike myself)
strSQL = "SELECT DISTINCT ANALYTE, AnalyteName, pkAnalyteID,
R ...
|
|
|
Cannot use Kill
Sun, 25 Nov 2007 11:39:29 -0500
Hello Everybody,
In VBA of Access 2003 Pro, I am trying to use Kill to delete Thumbs.db files
form given folders but it is always unsuccessful. Why?
Thanks,
--
Syed Zeeshan Haider
--
http://ca.blog.360.yahoo.com/blog-N3ipF2AiYa4967jn9q0r?p=10
...
|
Desperate
Fri, 23 Nov 2007 06:35:02 -0800
Hope you had a good Thanksgiving!! I am stumped. I am trying to make a query
that looks like the report with different groupings but one that is
exportable to a delimited txt file. In my case a header of several fields a
body of continuous records and a trailer of footer. I then need to export it
to delimted ...
|
Mac software
Thu, 22 Nov 2007 12:47:22 -0800
Is Microsoft continuing to make mac software??? If yes what????
...
|
