?????
Wed, 12 Nov 2008 09:16:54 -0700
zugeerspam@yahoo.com
...
|
??????
Wed, 12 Nov 2008 02:06:05 -0700
info@emarketer.mn
...
|
Create Field in table and define it's position
Tue, 11 Nov 2008 04:27:01 -0800
Can I create Field in a table and define it's position, for not being the
last field ?
ex. Table fields (Field1,Field2,Field3,Field4)
add Field5 and table fields to be (Field1,Field2,FIELD5,Field3,Field4)
Thanks a lot in advance! ...
|
vba runtime error
Wed, 5 Nov 2008 13:54:03 -0800
Help!
I keep getting runtime error (-2147217904 80040e10)
No value given for one or more required parameters. It then highlights my
Open statement. Please tell me what's wrong with it.
Dim rst As ADODB.Recordset
Dim strSQL As String
strSQL = "SELECT tblDSRDMTasks.DeptID, tblDSRDMTasks.DSRPartNo,
tbl ...
|
Stored Procedure Based Recordset
Tue, 4 Nov 2008 16:49:40 -0000
I need to get a recordset from a stored procedure, however I think my coding
is wrong and get an empty recordset as an error 3021 is returned from the
recordcount line.
Regards
Set cnn = New ADODB.Connection
strdb = "Q:\ManagementInformation.adp"
' Open connection
With cnn
.Con ...
|
Make a new table in Access using fields from LDAP? Or read it fast
Tue, 4 Nov 2008 06:10:06 -0800
Is it possible to just run a program, as needed, to create a local table in
Access from the Active Directory? It would only contain the information that
I need for use in my form? I am currently doing the following to read the
info, but it takes at least 30 seconds for each read. If not, any other ideas?
Se ...
|
Runtime Error 1004 : opening Excel file via VBA
Tue, 04 Nov 2008 12:58:55 GMT
Good morning,
I am using the following code to open an excel file from an access database
(2003).
Set xlapp = New Excel.Application
xlapp.Visible = False
Address = "X:\QualityAssurance\Documents\QADocs.xls"
Set xlWbk = xlapp.Workbooks.Open(Address) -------------> Debug stops
here
Set xlsht = xlW ...
|
|
|
Duplicating columns in Excel from Access
Sat, 1 Nov 2008 00:25:00 -0700
I am trying to copy a column and make a copy of the column next to it using
InsertCopiedCells
This macro in Excel works:
Columns("P:P").Select
Selection.Copy
Columns("Q:Q").Select
Selection.Insert Shift:=xlToRight
In Access I have
with wks2 'Worksheet 2
.columns(strColCopy).Select 'strColCo ...
|
sorting text field function
Thu, 30 Oct 2008 14:40:15 -0700
i found the following function for MS Access to sort text fields with
numbers. this code is excately what i need, however i need the function to
use two "strDelimit" variables, spitting the string based on two different
characters, a "-" and a ".", can anyone help me? thank you.
Public Function fSortSp ...
|
Validation message not showing when database is opened from extern
Wed, 29 Oct 2008 16:36:00 -0700
I have an application that is comprised of 4 databases (.mde s) The Main mde
has the more commonly used forms and the others, the "Called" mde(s), are
called when needed.
I have found that when there are error messages from the "called" mde(s)
that the dialogue box does not appear and the cursor does not m ...
|
