|
Create Field in table and define it's position
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!...
|
2 |
11/11/2008 1:20:15 PM |
|
|
ADO Transaction with linked MDB file?
I get 'Operation Not available for this object'
when I try these lines:
Public cnMain As New ADODB.Connection
' fails here ----> Set cnMain = CurrentDb.Connection
'my intent is to do transactions that I normally would with this line
Set cnMain = CurrentProject.connection (in an ADP)
..
..
..
cnMain.BeginTrans
Can I do ADO Transactions with MDB's? (linked or otherwise?)
I k...
|
7 |
11/6/2008 10:04:04 PM |
|
|
vba runtime error
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,
tblDSRDMTasks.TaskCode, ztblDDT.DSRTask1, ztblDDT.DSRTask2, ztblDDT.DSRTask3,
ztblDD...
|
4 |
11/6/2008 9:57:01 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...
|
4 |
11/6/2008 9:14:19 PM |
|
|
Make a new table in Access using fields from LDAP? Or read it fast
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?
Set cnn = CreateObject("ADODB.Connection")
cnn.ConnectionString = "Provider=ADsDSOOb...
|
4 |
11/6/2008 8:34:33 PM |
|
|
Stored Procedure Based Recordset
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
.ConnectionString = CurrentProject.BaseConnectionString
.CursorLocation = adUs...
|
3 |
11/6/2008 10:14:21 AM |
|
|
Runtime Error 1004 : opening Excel file via VBA
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 = xlWbk.Worksheets("QA")
xlsht.Select
I use this code on the click event of a for...
|
1 |
11/4/2008 12:58:55 PM |
|
|
LDAP Is it possible to read the Active Directory within an Access
Is it possible to read the LDAP Active Directory within an Access Form?...
|
12 |
11/4/2008 8:59:45 AM |
|
|
Error when trying to use ADO
I am new to Access and maybe I missed something. When I use the ADO syntax I
get a message that I am trying to use an undefined user type. So I have been
using the DAO syntax instead. Is there a pre-step where I set up Access 2007
to see the ADO library? Thanks....
|
2 |
11/4/2008 12:06:01 AM |
|
|
2 questions on table updating
Two questions on Access 2007:
First question:
I have a single table containing unique ID and name of performing artists
(ArtistID, ArtistName). A Recordset - artistRS - that is populated with a
simple "SELECT a.artistID, a.artistName FROM Artist as a ORDER BY
a.artistID". artistID is an auto-number
I need to add a new record then get the the new artistID for further
processing. Fo...
|
2 |
11/4/2008 12:03:01 AM |
|
|
Duplicating columns in Excel from Access
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 'strColCopy=P:P
.columns.copy 'I had .Selection.Copy it didn't ...
|
3 |
11/2/2008 3:11:44 AM |
|
|
sorting text field function
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 fSortSpecial(strIn, _
Optional strDelimit As String = ".", _
Optional LnumSize As Long =...
|
8 |
10/31/2008 4:27:40 PM |
|
|
Validation message not showing when database is opened from extern
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 move from the
control until the Escape Key is pressed. The user is unaware why the...
|
1 |
10/29/2008 11:36:00 PM |
|
|
Access 2003 database in 2007, Rename not working
DoCmd.Rename on a linked table does not rename the table. It does not raise
any errors either. This happens with Access 2007 runtime only. It works as
expected with Access Retail.
Is there a workaround for this issue?
Thanks...
|
3 |
10/28/2008 2:32:12 PM |
|
|
AddFromOutlook command in Access 2007
Dear Expert,
I'm building an access database which has a contact information table.
Most of those contacts will be taken from the Outlook Contacts Folder.
Access 2007 has a command "AddFromOutlook" which brings up the address book,
and allows you to select the Contacts that you wish to write into the table,
but so far, this command has not worked for me. Any ideas?
Thanks,
-a...
|
2 |
10/28/2008 12:48:12 PM |
|
|
SEEK characters limitation
I am using DAO360 and Seek command on table with MEMO field. It seems that
Seek command searches only for 255 characters, not more. Am I right ?
Is it a bug ? Because in documentation of Seek I did not find limitation in
characters to be searched...
Thanks a lot in advance!...
|
7 |
10/23/2008 8:02:51 AM |
|
|
LastUpdated value needed
does anyone know where to find the date of a module? I tried this but I get a
way to old value:
db.Containers!Modules(strModuleName).LastUpdated
and this didnt fix it either:
Set ctr = dbs.Containers("Modules")
Set doc = ctr.Documents(strModuleName)
doc.Properties.Refresh
doc.LastUpdated
I know it mu...
|
3 |
10/17/2008 12:42:23 PM |
|
|
"Restore" Query Results via VBA?
A button on a form runs a select query that produces a list of names.
Because the form is maximized, the query results are maximized too. How can
I display the query results "restored" to not fill the entire screen?
Haven't been able to find any arguments in DoCmd.OpenQuery that would give me
what I want. I could show the results in a popup form/datasheet view, I
suppose, but would r...
|
2 |
10/17/2008 4:32:50 AM |
|
|
ODBC Relink via File DSN
Hi Everybody,
I've an Access application which links to an ODBC data source.
Currently, I'm using File DSN for ODBC access.
I've opened the DSN file and changed the server IP address, from
'SERVER=192.168.0.2' to 'SERVER=192.168.0.1' . Unfortunately, the Access
application is still refering to the old server IP address.
Does anyone know I've done wrong?
...
|
5 |
10/15/2008 2:33:22 AM |
|
|
Table size and network response time
I need a table with 4 fields, one date, three texts and one autonumber that
is also a unique number for a barcode ID.
The problem is that the table will have over 1 million records. I am
wondering how MS Access will cope and whether the users will be affected on
the LAN.
Does anyone use that sort of size and know what the response time is like?
Should I break up the table into 10...
|
3 |
10/14/2008 5:49:00 AM |
|
|
Show User Roster in Split Database
I'd like to show a roster of users in a multiuser database. I used to use
the ShowUserRosterMultipleUsers code which I found in a knowledge base
article. This worked fine for the unsplit database which resided on a
network server. Now, however, I've split the database and so only the
back-end is on the server.
The OpenSchema line in the following code no longer works:
Dim cn As Ne...
|
3 |
10/13/2008 5:03:01 PM |
|
|
Why won't this work!?
Gday, I'm getting an error " operation is not allowed when object is open"
I'm not sure which object the error is referring to. Can you have more than 1
recordset open at a time?
Dim rsAllClients As New ADODB.Recordset
Dim strSql As String
'returns all account info for a specific client
Dim rsClientAccount As New ADODB.Recordset
'retrurns the latest balance for a speci...
|
2 |
10/12/2008 6:26:53 PM |
|
|
SendObject/LotusNotes/NoUserInput
Trying to use SendObject to EMail an object (query for testing purposes); it
all works except Lotus Notes pops open and requires me to hit Send despite
the False argument for EditMessage. I've searched by all they keywords I
could think of but found no help in the discussion groups. Can anybody help?
Is this fixable at the VBA end, or is it a problem within Lotus Notes?
...
|
2 |
10/12/2008 3:46:50 AM |
|
|
Add a list of records to an Email
I'm trying to add a list of records to an mail. My records are training
requirements for a person. The record set pulls expired training requirement
for a specific person. I would like to add a line of text in the body of an
email for each expired training requirement. I can't seem to figure it out.
This is as far I have gotten:
Dim dbs As Database
Dim TrainingDuePersRS As R...
|
7 |
10/11/2008 4:14:20 AM |
|
|
Access 97 database size increases rapidly
We are using access 97 database with JET database engine 4.0 with dot net
application. Database size increases rapidly and with every transaction.
While if we use the same database with VB6 and DAO. It does not show this
abnormal behavior. If any one any idea please help us ASAP.
Thanks in advance...
Jatin
...
|
3 |
10/9/2008 11:22:42 PM |