|
äåãòä
ìà ðáçøä
...
|
1 |
1/23/2009 9:19:34 PM |
|
|
Guaranteed Millionaires
http://guaranteedmillionaires.blogspot.com/...
|
1 |
12/31/2008 10:09:44 PM |
|
|
Vista OS - Access 2003 ends abuptly when filtering ODBC linked dat
Only on Vista systems, when I go into any ODBC linked (SQL 2005) table and
try to filter any date (just by clicking on the the Filter By Selection
button) I get the message, "Microsoft Access has stopped working" and it
closes the db down. On Windows XP, I can filter the dates without any
problems. The filter works for all other data types. I have installed all the
latest updates for Vis...
|
4 |
12/31/2008 10:07:46 AM |
|
|
Call Dates from a Table
I am trying to set up a routine that allows me to set dates when a form is
open up...
I have a table called tbl_ROD, which has 2 fileds held in it AGA_ROD and
AWSA_ROD, what I would like to do is set this date on the form when update to
one of these dates...
Can anyone help me......
|
4 |
12/31/2008 7:09:52 AM |
|
|
Listview
I am currently converting code from using DAO to ADO. I am having trouble
with loading a treeview recursively. Microsoft has a good DAO sample code.
Any code examples out there for ADO?
SC
...
|
2 |
12/30/2008 5:57:00 AM |
|
|
SeekNext?
Hi.
I have an index in a table that is not unique.
Is it possible to find all occurences using Seek? Or is Seek just used to
find if a key does exist yes or no. In that case, what is the advantage of
using Seek above FindFirst?
Thanks in advance,
Ronald....
|
8 |
12/21/2008 12:35:34 PM |
|
|
SQL GUID translates into Chinese
Hi,
Can someone help me figure out why I am getting the error "Malformed GUID.
in query expression...", with the expression
containing Chinese-looking characters instead of the GUID value? Here is the
code:
Private Sub Form_Load()
Dim vargd As Variant
vargd = Me.ctlGUID
Dim str As String
str = "SELECT First_Name, [Name] FROM [ContactList] WHERE
((([ContactList].GUID)={guid " & v...
|
1 |
12/19/2008 9:16:29 PM |
|
|
Query incorrectly returning no records in ADO
All
I've got a piece of code to loop through a recordset on a split database.
I'm opening a query, but the code always fails because the recordset
recordcount is always -1. However when I run the query directly in Access it
returns 26 records. The only thing I can think is that the sql syntax for the
query is not good in ADO??
Here's the code:
Dim rs As New ADODB.Recordset
Di...
|
3 |
12/17/2008 6:02:51 AM |
|
|
MSComm controls
Can I put 2 MSComm objects onto 1 form in my access application... The next
obvious question is how would I go about that, but I currently have one
control and I'm able to manipule the communication nicely. I can't seem to
make the second one work and thought I'd ask if it was possible before I lose
too much sleep
--
Many Thanks and occassionally a you''re Welcome
Norm...
|
3 |
12/17/2008 3:20:01 AM |
|
|
Use of an ASCII text file for updating mdb
hi all,
brand new to this forum..! hoping someone can help me - I use an
application developed in MS Access that permits users to use an ASCII file
containing index info (SSNs) for specific records in the database in order
to perform some action on each of those records in the database. Can
someone tell me what this functionity is referred to within MS Access? As a
novice VBA devel...
|
4 |
12/16/2008 1:06:38 PM |
|
|
DELETE with JOIN
I am still using JET SQL and I am pretty comfortable with writing SQL
statements but I cant figure out the syntax for writing a delete sql which
includes a join. Is it even allowed?
DoCmd.RunSQL "DELETE T1.* FROM [DelTable] AS T1 INNER JOIN [JoinTable] " _
& "AS T2 ON T2.[Citation2] = T1.[Citation1] WHERE T1.FirstName = 'Joe'"
looks like a beautiful statement to me but it throws an ...
|
3 |
12/16/2008 12:13:01 PM |
|
|
Updating Attachments in Access 2007
I've recently switched to MS Access 2007. One of the major changes for me was
the switch from OLE Obejct linking to Attachments. Previously I've been
linking jpg's to the DB witch made it possible to change the linked jpg and
then it would instantainiously be reflected in the DB. I'm having problems
with that in Access 2007 using the Attachment Field. I've made changed to
attached jpg's ...
|
1 |
12/15/2008 10:31:01 AM |
|
|
How do I get the Windows User ID
I have an unsecured Access 2000 Database. I need to track the user's that
add new and edit old data. (new requirement) I know there is a dll that can
be used to get the Windows User information and I would like to use that to
save the user info. It's been quite a while since I've done that and I've
forgotten the syntax any help would be appreciated. ...
|
5 |
12/11/2008 2:24:04 PM |
|
|
object dependency
Hallo,
I have an old MS access 2003 database with lots of query,tables,form and
report.
Some of them are no longer in use.
I really would like to do a serious clean up.
Is it possible create a file,report with object dependency for all objects.
Does somebody knows the VBA code to get access to object depency?
thanks
Roland
...
|
2 |
12/10/2008 7:54:42 PM |
|
|
Send a Mime Multipart email from Access 2003
Hi, I've trawled the web for a solution to this:
I need to send a text and HTML multipart email from Access 2003 intefacing
with Outlook 2003 methods. I've tried .textbody and various others. Please
help.
Here's a sample of what I have so far:
Public Sub SendOutlook(NotifyId As Integer, strFrom As String, strTo As
String, Subject As String, HTMLBody As String, SendUsing As String, ...
|
1 |
12/9/2008 1:47:31 PM |
|
|
Returning XML data from SQL Server Stored Procedure
I have a Stored Proccedure in my SQL Server Database that queries the
database and returnsa hierarchical XML string.
How can I call this stored procedure from MS Access so that I can retrieve
this XML string and write it out to a file.
My Code looks like this
Sub test081207_1()
Dim x As String
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Connec...
|
1 |
12/7/2008 3:31:39 AM |
|
|
Can DLL's be malicious?
I'm looking at purchasing a royalty-free license to a DLL and include it in
my commercial application. I'm concerned about including a third-party
component in my app.
Can DLL's be malicious? ...
|
4 |
12/4/2008 5:22:39 PM |
|
|
Left() or Mid() question
I have imported data from an Excel spreadsheet from another department
(They are uncooperative and wont change their data structure...)
Three of their fields contain name data formatted as lastname / lastname
(this is a buddy list):
Example:
Team1 Team2 Team3
Smith/Jones Doe/Johnson Green/Smith
I need to extract the names and separate them so I can put it in ...
|
5 |
12/3/2008 10:00:42 PM |
|
|
Copying an Object to Another DB
I have a process where I copy a number of tables from one database to
another. Following is the VBA for one of those tables -- it works fine:
DoCmd.CopyObject "\\apfs\projs\prodcntl_ops\Entrpris\Data\PRISM\MSAccess
Tools\PCMetrics Tool.mdb", , acTable, "tblPCData"
Now I want to run that table through a select query in order to change some
of the field names, and copy the output of ...
|
3 |
12/3/2008 5:00:01 PM |
|
|
vba not working in Access 2003 Data Project
Hi all,
This is a weird one that I can't really explain except that I'm having
trouble getting some vba code to work in an Access Data Project.
The following sub works fine:
Private Sub btnDistributionAr_Click()
DoCmd.RunSQL "exec spCfxArDistribution"
txtDistLastRun.Value = Now()
End Sub
The following doesn't:
Private Sub lblHome_Click()
Me.varchild.visible = False '
End Sub
...
|
2 |
11/27/2008 12:48:44 AM |
|
|
Edit and Update
Hi All,
I Have the following code, basically the code is to set the ranking number
against a set of records in a table called 'tblRANK'. The table contains
around 50,000 records and the ranking is across each country, in that the
ranking starts agian at 1 each time there is a new country, the table is
already sort by COUNTRY Asc and AMOUNT dec so the table is in the corret
order and t...
|
2 |
11/26/2008 6:51:01 PM |
|
|
Create query using VBA
Can I use ADOX or DAO to create a query? If so, how do I make a column in
the query for each column in a table, yet assign an alias to each column?
Thanks,
Matthew Pfluger...
|
3 |
11/20/2008 10:15:00 PM |
|
|
=trim ...
Suddenly one of our pc fails because it cant find the trim function. Went to
the references for vb & they all were the same. They tried to reload office
xp but that didn't help. Got any ideas? TIA
--
_______________________________
In Christ's matchless name
ted n6trf
...
|
3 |
11/20/2008 6:07:17 PM |
|
|
Outputto question
I have the following in my code. It works as expected. It exports the named
table to an html file.
DoCmd.OutputTo acOutputTable, "tbl_MeetingDates", acFormatHTML,
"F:\html\MeetingDates.html"
What I would like to do is set it up to delete the old file, then export as
HTML and add my own HTML as its created.
How can I have it export basically a bunch of text - my html code - then the
...
|
5 |
11/17/2008 4:35:02 PM |
|
|
Importing huge text files
I have several huge semicolon delimited text files that I import to tables,
one table per file. The files are of size 200 - 300 kB and have more than
1,000,000 lines each. My problem is that it takes too much time to do the
import. I am importing by using DoCmd.TransferText. (I am aware of my
potential problem of max. database size of 2 GB.)
The tables have primary keys, have indexes, a...
|
15 |
11/13/2008 8:13:53 AM |