|
|
|
How can I make an Interface that implements Code like IDisposable
Thu, 30 Oct 2008 12:36:10 -0700
I want to mak an Interface than, when I implement it on a class writes full
sub and function code and comment . How must I write my Interface ??
Thanks ...
|
Find string in a string
Thu, 30 Oct 2008 09:01:01 -0700
I am building an email and am dealing witht he TO: line.
strToWhom = strToWhom & .... (I bring in 3 people from different fields)
What I would like to do is to search strToWhom to see if I have already added
this person but I can not figure out how to code the find or search on this
field. Any ideas? I k ...
|
What events fire when returning from a modal pop-up form?
Thu, 30 Oct 2008 13:32:51 GMT
I have an unbound form with a list box, and a command button that opens a
modal pop-up form that adds records directly related to the list box. I want
the list box to be requeried onced the pop-up form is closed. Where is the
best place to put the requery code?
Thank you,
Anthony
--
Message posted via ...
|
what the difference between recordset and recordsetclone
Thu, 30 Oct 2008 04:09:01 -0700
...
|
VBA no longer works when linked to SQL server tables
Thu, 30 Oct 2008 04:07:01 -0700
I have linked our existing Access database to SQLand am running the tables
purely in SQL server 2008 having deleted the Acess tables and renamed the
linked tables to what the Access tables used to be called. However when i
try to run some code now it doesnt work. Clicking on the 'submit' button
normally in ...
|
Turn off auto spell check for selected txt boxs with in a form
Wed, 29 Oct 2008 14:00:00 -0700
We have auto spell check turned on for the database, however when users are
entering new constituents into the database, auto spell checking starts
â??correctingâ? names when it shouldnâ??t, this is slowing down our data
processers. Am I able to turn off the auto spell check for just the name
fields (first ...
|
Do you use On Error, Err_, Exit_ ??
Wed, 29 Oct 2008 12:11:00 -0700
I ran across an access db that had all code references to On Error, Err_,
and Exit_ stripped out... it looked so clean and i was wondering how many
people actually do this? I can understand how some of my code does have some
necessary error handling routines, but for a simple form opening or
run-of-the-mil ...
|
|
|
Insert a HyperLink in to Word using VBA
Wed, 29 Oct 2008 10:56:00 -0700
Using MS Access 2003.
I'm able to insert text in to the 2nd column of the 11th row of a table in a
word doc.
I'd like to insert a hyperlink in to that 2nd column of the 11th row of a
table in a word doc.
Below is a quick sample of the code I'm currently using:
Dim objWord As Word.Application
Dim objWo ...
|
SQL Query Duplicate Rows
Wed, 29 Oct 2008 10:12:07 -0700
Hello,
I have a query that returns duplicate rows because of a one to many
relationship. Basically here is a simplified version of the data.
person,date,problem
1, 10/29/08, sick
2, 10/29/08, pain
I want to return it as
person, date, problem
1,10/29/08, sick and pain
BUT I can't get it to return a l ...
|
Adding other email address to the DoCmd.SendOject
Wed, 29 Oct 2008 10:08:08 -0700
Hi,
The DoCmd.SendObject below works fine. Would you please show me how I can
add another email address to it. Ex: Ctran@parkland.edu.
Private Sub EmailRequest_Click()
DoCmd.SendObject _
, _
, _
, _
"sue.tran@parkland.edu", _
, _
, _
" ...
|
|
|
