hey
Sun, 6 Jun 2010 14:03:03 -0400
hey kiss my but ...
|
Final Reminder - Microsoft Responds to the Evolution of Community
Fri, 28 May 2010 09:35:37 -0700
Microsoft Office Evolves Community as Part of Office 2010 Launch:
As you know, this is a big year for Microsoft as we are launching the latest
version of Office. Office 2010 is all about making it easy for you to get
and use Office on your terms. Office 2010 lets you work from the office,
from home, or a ...
|
Import nonconsecutive rows from excel to access
Thu, 27 May 2010 14:02:53 -0700
Hello I'm new to this forum and to VBA so pardon me if I did not post this in
the right place.
I need help importing an excel sheet into 3 access tables which are already
created.
I've got the first part going into the first table figured out, but i'm
stuck on the second part which is importing nonconsec ...
|
Left and Right Functions - Vista
Tue, 25 May 2010 12:14:01 -0700
I have an MS-Access app being used by 15 people on laptops in the field.
Most are on 2007 and Windows XP and are experiencing no problems. Two users
are using Vista and are getting error messages (Function is not available in
query expressions) whenever the code hits a simple Right("str",int) or
Left("str" ...
|
Need help ! insert query in pgm that works sometimes
Tue, 25 May 2010 07:13:01 -0700
I have a VB6 program, and I'm using ADO to pull data from a DB2 DB(linked
tables) and inserting the data into an existing table.
I run this same query but for two different dates. If I run the query in
Access it brigns back less than 200 rows(correct #) for each of the two
dates. However, when I run it fr ...
|
Compile Error when Recordset Declared Correctly
Fri, 21 May 2010 11:09:01 -0700
I am receiving an error when I click the button that runs the code below.
"Compile error: Method or data member not found"
Here's some background. I had originally planned on using two different
recordsets within this procedure, which I declared them as rsBOL and rsPS. I
wrote the code for the first reco ...
|
Reminder - Microsoft Responds to the Evolution of Community
Thu, 20 May 2010 08:13:22 -0700
Microsoft Office Evolves Community as Part of Office 2010 Launch:
As you know, this is a big year for Microsoft as we are launching the latest
version of Office. Office 2010 is all about making it easy for you to get
and use Office on your terms. Office 2010 lets you work from the office,
from home, or a ...
|
|
|
switching to another Outlook mailbox
Thu, 20 May 2010 03:38:01 -0700
I'm sending some emails using the DoCmd.SendObject, but I'd really prefer the
emails not to go from my Outlook mailbox, but from another mailbox as they
have responsibility for the work the emails may generate.
Is it possible to programatically swith to this other mailbox in Access
2003/Outlook 2003 within ...
|
Problem with: DBEngine.SetOption dbMaxLocksPerFile, 500000
Tue, 18 May 2010 12:56:01 -0700
I need to use the DBEngine.SetOption to modify MaxLocksPerFile registry
entry. It just isn't working for me. If I manually change the registry, it
works. But, when I issue the command through VBA, it doesn't work (doesn't
err, either)
My SQL is inside a BeginTrans and CommitTrans block, such as:
Dim ...
|
equivalent DAO connect in ADO
Tue, 18 May 2010 00:51:01 -0700
I am updating an application from 2003 to 2007 and it currently uses
ODBCDirect. Since ODBCDirect is no longer supported in 2007, I am converting
the DSN connection to ADO.
Currently, the module uses the DAO CreateWorkspace and it get the connection
details from the "connect" property. e.g strDSNdetails= ...
|