Description:
MS Windows' relational database system, Access.
|
|
|
Error 3045 Could not use <db file path> File already in use
|
| |
I'm getting the above error message at the line 'Set db = ...' in the following code (which is called from the autoexec macro before anything else happens).
Dim ws as Workspace, db as DAO.Database
set ws = Workspaces(0)
set db = Currentdb
If I remove the 'set ws = ...' line, then the message doesn't appear.... more »
|
|
|
Database Modeling help???
|
| |
Sorry for being a newb, for whatever reason I just can't wrap my head
around this. I need some help in figuring out the entities and their
relationships here, I already sent in a couple of submissions, and I
get the impression my professor is getting a bit ticked off.
Film Showings
The Cinema Guild Theatre Group wants the following collection of 21... more »
|
|
|
Change splash screen on forward date
|
| |
I'm a relative newbie but have developed several Databases at our
organisation. Because of a forthcoming reorganization, there is a need
to change the first screen ( what I call splash screen) on a pre-
determined date. The splash screen is displays the DB name, version
and contact details for support etc.... more »
|
|
|
CFP - DEIS2012 - Czech Republic - SDIWC
|
| |
Dear Colleagues,
We are inviting you to join and participate in the upcoming conference
that will be held in Czech Republic. This will able to build
connections among researchers in the field of digital applications.
Please spend some time to overview the research topics.
Below are the conference information. If you have any questions, you... more »
|
|
|
Table Macro to log edit date/time
|
| |
I'm having trouble getting Table Macros to work. Might be
some general thing, but I'll give 2 examples:
1) Whenever any field is edited, I want the [EditRecDate] field to update to Now()
(of course, exclude updates to [EditRecDate] field in this trigger)
2) Whenever any field is edited, I want an [EditRecDate] in a DIFFERENT table to update to Now()... more »
|
|
|
vba to upload to sharepoint
|
| |
Hi All,
Using Access2003 I extract some data from some tables and populate
some spreadsheet templates and save them on a server/folder. Now I'd
like to copy those spreadsheets to SharePoint. There are already prior
month copies of the spreadsheets on SharePoint so the folder structure
already is there.... more »
|
|
|
Scrolling subforms
|
| |
I have a subfom sized to show up to 16 records i.e. about 4" high and each
record is about 1/4" high The subform itself can contain anything from no
records to many hundreds. I want to go to a new record, bur see as many of
the preeceeding records as possible, so the new record needs to be near the... more »
|
|
|
Designing tables to be compatible with Sharepoint
|
| |
Hi,
I have a new project and I am thinking I might as well at least try
and make the Access 2010 backend tables compatible with Sharepoint
(not sure if I want to deal with macros for the front end). But, what
the heck. Might as well see what I have to do for the backend.
The books I have describe Sharepoint tables but don't really go much... more »
|
|
|
Error 5 "Invalid Code or Procedure" when using string functions
|
| |
I'm getting Error 5 "Invalid Code or Procedure" when I execute the
following line of code:
If (Left((strCutAddress), InStr(1, (strCutAddress), " ") - 1))
= "West " Then
I am looping through my data table and populating strCutAddress with
the value from a field in the table
Everything works fine for the first 3 fields, and when I reach the 4th... more »
|
|
|
Inserting OLE Object field into Oracle Blob with stored procedure
|
| |
Hi,
I'm trying to import Ms Access 2003 data into Oracle database.
One of the field is an OLE Object field with word doc into it.
I'm trying to import it into a BLOB field but it doesn't work.
I'm connecting to the db with the MSADORA.1 provider and adding the parameter to my adodb command like this... more »
|
|
|
