Timed Inputbox
Wed, 12 Dec 2007 03:27:01 -0800
Is it possible to put a Timer on an Inputbox?
I have a DB that imports a series of files from a folder and the user is
required to Input a Received date for each file.
Sometimes the user leaves the App running overnight if a large amount of
files have been received.
Is there anyway of closing the Inputb ...
|
Changing the field type
Mon, 10 Dec 2007 03:16:01 -0800
Hi.
I have a system where a file is imported to a new table and is given an
AutoNumber field so each record has a sequential reference number.
At the end of the import process, I need to 'juggle' the reference number
between records so they are sorted differently on a report.
I am trying to change the f ...
|
Viewing a .doc document directly from the binary file.
Thu, 6 Dec 2007 13:54:01 -0800
- The binary file is in a SQL Server table image field.
- I am using Microsoft acces for the frontend, VBA code.
How can I view a Word document saved in a blob (Binary file) without having
to recreate the file. I would like to view(push) the binary file directly in
the Word application without having to recr ...
|
Problem with error 3709
Wed, 5 Dec 2007 19:49:00 -0800
Hi All,
I have a table with a single record that contains the dates and
information for the jobs processed during a quarters processing, I want to
create a form so that users can update the table.
The table "tblQuarterDates" contains the following fields.
fldPreQuarterStart
fldPreQuarterEnd
fldCurQ ...
|
Pass Recordset object between subs/functions
Wed, 5 Dec 2007 15:35:03 -0800 (PST)
Hi there,
I'm trying to code up a function in ACCESS 2000 VBA to return a
recordset object to a sub. However, I couldn't make the recordset
returned as the recordset object I got inside the function disappered
as the ADODB connection was closed at the end of the function. I tried
to assign the recordset to a ...
|
opening a word file.
Wed, 5 Dec 2007 10:33:00 -0800
I want to open a word document saved in a SQL Server table in Microsoft Word .
My ducoment is saved in an image field in a SQL Server database table and I
know how to rewrite the image field (Blob) as a file in a directory.
My problem is that I would like to open the document in microsoft Word
without havi ...
|
Recordset 'Record Locking'
Tue, 27 Nov 2007 02:33:00 -0800
If I open a recordset in code, do the records get 'Locked' and in-accessable
to other users?
If not, is it possible to apply locking to these records? I am trying to
create a 'batching' facility where 100 records are assigned to each user.
Cheers,
Steve. ...
|
|
|
Phantom break point in VBA module
Mon, 26 Nov 2007 14:21:01 -0800
Access 2003, stand-alone single-file .MDB (while developing). If I open the
application and select a button on a form that causes some code in a module
to run, the application opens up the VBA window with a line of code
highlighted in yellow as if I had planted a breakpoint. But I didn't. There
is no diag ...
|
Runtime Access / OLE Automation
Mon, 26 Nov 2007 03:11:01 -0800
Hi.
I have created a DB in Access that is used by a person who only has Runtime
access to the Application.
The App uses OLE automation to complete a standard letter template by using
a Find/Replace function. Sometimes this works fine and other days it does
not!
The code used for the automation is hel ...
|
hide Start Toolbar
Sun, 25 Nov 2007 00:31:00 -0800
I have a form that I dont't want users to be able to go anywhere but on the
form, with the help of a mouse. The keyboard is hidden from the users.
There is a specific Close Command button that requires a password, so only
the person with a keyboard can close it.
I can do all that, my Maximising the form, ...
|
