move a randomly selected file from one folder to another folder
Wed, 26 Nov 2008 00:31:01 -0800
This is a Windows file - directory question using VB in Access 97.
How can I move a randomly selected file from one folder to another folder
in Windows.
thanks for any ideas
...
|
Identify PC by ldb
Tue, 25 Nov 2008 20:58:00 -0800
I would like to identify who has my DB opened. I know that when the DB is
opened an ldb file opens with it. I can right click on the ldb and open it
with notepad to reveil the PC name(s) of who has it opened. I would like to
have a database that can evaluate an ldb to find the PC name(s) and store
this info ...
|
Importing from Excel using INSERT INTO
Tue, 25 Nov 2008 18:20:05 -0800
These questions pertain to the code below. Thanks in advance.
John
1) Does not work with Sheet1! But works without putting Sheet1 in clause.
With actual spreadsheets I use, there are several sheets, so need to specify
which sheet
2) Requires first row in range to have field names corresponding to fiel ...
|
Control Notepad with VBA
Tue, 25 Nov 2008 17:34:39 -0800 (PST)
I need to automate the following tasks from within Access. I need to
open a txt file (easy part), then change the page setup setting from
within Notepad, and print the document. Anybody know if this
possible. I tried opening the file and using sendkeys but the
sendkeys were executed within Access.
If that i ...
|
Average of string function??
Wed, 26 Nov 2008 00:46:22 GMT
Hey guys,
I hope someone can help me... I need to find a way in Access VBA to average a
string of numbers. I tried to use string.average but this doesn't appear to
work in VBA only VB?? I need to do this as a function in the VBA code itself.. ...
|
return function value from another DB?
Tue, 25 Nov 2008 15:52:05 -0800
Can you return a function value from another database? I know how to call a
subroutine form another DB, as well as how to pass parameters, but am not
sure if there's any way of returning a value from a function. Any help is
appreciated. ...
|
Debugging stopped Access 2007 mdb not accdb
Tue, 25 Nov 2008 13:48:02 -0800
I just stumbled on a nasty problem:
When debugging after setting breakpoints in VBA, execution does not longer
halt in Access 2007 mdb databases (but it does in Access 2007 accdb
databases.)
I do not know what causes this problem -- not much has changed since the
time that it did work.
I hope someone can he ...
|
|
|
Ac 2007 vs .NET
Tue, 25 Nov 2008 11:55:02 -0800
Does anyone know if a client application developed in .NET that connects to
an Access 2007 back-end database is faster than an application developed with
Ac 07 for both the front-end interface and back-end component. In other words
an .accde as the front-end and an .accdb as the back-end. Your insights on
t ...
|
Import last Excel ws to Access table
Tue, 25 Nov 2008 11:29:06 -0800
Hi,
I am using the DoCmd.TransferSpreadsheet method to import an Excel worksheet
to an Access table. However, the worksheet I want to import is the last
sheet in the file. Using the DoCmd.TransferSpreadsheet method imports the
first worksheet. How do I get around this so that I import the last
workshee ...
|
MsgBox Question
Tue, 25 Nov 2008 10:23:09 -0800
Can someone tell me why the following code does not generate a message box
when Agency_ID is 999 or 888 and the EventDescription field is empty?
Agency_ID is a number field and EventDescription is a memo field.
Private Sub cmdNewRecord_Click()
On Error GoTo Err_cmdNewRecord_Click
If ([Agency_ID] ...
|
