Search results for query: *

My Access module is supposed to start automatically but running a batch file. This could be achieved easily by specifying a /x switch with the name of the macro and to put this command line inside a batch file. For example, "c:\program files....\MSACESS.exe" c:\myProgram\aaa.mdb /x startMacro...

In the office we purchased a number of well-known brand PC. They arrived with WindowsXP pro pre-installed, each bearing a sticker for COA. I set them up a few months so I know them. Recently (few weeks ago) I was given a task to upgrade some WinNt/Win9x PC for WindowsXP. We don't have a...

Well, in the company I work for we're still having quite a number of Win9x stations. The operators of these workstations run no PC applications other than entering data onto a web-based application. Sort of ASP hosted internally (in other words, purely intranet application). People say...

To access Oracle data via ODBC and writting application using VBA codes (Windows Environment), what client software do I need to install? Thanks.

I need to create a command file (batch file) and run it from the command prompt. I am familiar how to create this. However between two particular command lines, I want to insert a time gap between them so that the second command is only run, say one minute after the first one. Insert of...

My stored procedure, say sp_aa is a sysobject of Database a. Can I code in sp_aa to invoke another stored procedure sp_bb that is a sysobject of database b? If yes, what is the syntax?

Examining the properties of the table sales in the pubs sample database (MS SQL 2000), I notice the salesID column has the data type tid. What is that? I read the chapter "data type" in BOL but get nowhere.

I've used to process multiple rows data return by sql select statement, using vb or Java codes. As usual, it is just looping through the result set and process the data one record at a time. Can people employ Stored Procedure alone to do row-level processing? I did some research from the web...

Assume both PC (running Windows 2000) PC-A and PC-B are part of the same domain on Day 1. A user logon on PC-A as domainX/userX and it setup a mapped drive (say M:) to access resource from PC-B. Assume the resource is \\10.20.1.20\sharename Then recently PC-B un-join the domain, as far as I...

I know how to create an "import/export" specification file in Access and use it to import a text delimited file (.csv usually) if the file is delimited by a comma, for example. But what if the delimiter is a special character, say ascii code 241, how could I import it without writing vba codes...

A desktop PC running Windows 2000 pro is configured as part of a domain called say, DomainX. I used to logon using the Domain account xxx. I am a bit confused here as when do I need to add another user to the PC, in order for it to logon. If yyy is a valid Domain account but has never logon to...

Before I try to work out how I should implement locking in a multiuser environment. I want to clarify how my openrecordset statement works. In an MS Access application I create a recordset and process some data with: Sub myProcess() Dim rcdSet as DAO.recordset set...

I used to access our sql2k server data using the ADO or DAO object in a MDB project (ACCESS MDB file). What is the advantage of employing a ADP over MDB?

This is a VBA module created in an MS Access environment. This MS Access Db has a linked table called "lkTable" setup to access data in a MS SQL table (via odbc.) The current codes read: dim RS as DAO.recordset set RS = currentdb.openrecordset("Select * from lkTable where xxx='xxxx'") do rem...

I want to write VBA codes in MS Access 2000 environment to access data in SQL server. How do we find a complete method reference to use with DAO or ADO? For example, though VB6 is able is provide a hint that a DAO.openrecordset method requires parameters in the order: name as string, [type],[...

I am developing an application that accesses SQL server data via ODBC. I set up linked tables and run codes and the codes are supposed to run unattended. I am confused as to what determine whether a password is required to be entered when the codes are run. If there a place where we specify it...

We run client application (in VBA), accessing a SQL 2k Database via odbc. SQL server security accepts authentication in mix modes (both sql authen. and Windows authentication.) Our odbc DSN configuration is setup to use Windows authentication. Our applications run fine most 98% of the time...

I am new to SQL server 2000. After installing SQL 2000 (eval copy), my console tree shows only one SQL server under the SQL Server Group. I build some database using the Enterprise manager. Now I want to create a copy of the database I created before proceeding. I read an article here (an...

I set up Outlook myself to retreive all my mails from the Exchange server onto a pst file locally. I have been working happily in that way. Now there is a new policy that everyone has to leave his/her email in the mail box (in the server). I read the documentation, it seems I could configure an...

This Citrix application is a text-based (non-GUI) one. Can we change the display settings (such as background color, font color and size?