Database Expanding out of Norm
Fri, 19 Mar 2010 15:02:01 -0700
I am working with a relatively small DB (about 9MB when compacted). It is
shared amongst 40 users but not all at once. I have noticed that the
database grows in size at the rate of about 30kb every 15 seconds or so. I
have never seen this before. I know it will grow, but this expands to about
250MB per d ...
|
Import Historical Stock Data from Yahoo-Finance
Fri, 19 Mar 2010 14:36:06 -0700
For a long time I thought this was not possible, but I just read a post
recently that makes me think that this probably IS possible. Is there a way
to import data from finance.yahoo.com, into a table, if you store all stock
symbols in a table, and put beginning and ending date in a form (in a couple
of Te ...
|
Filling drop list
Fri, 19 Mar 2010 14:22:03 -0700
how can i fill a single field in a drop list with data from 2 fields in
seperate tables. my db has 2 tables, one for data that is less than a month
old and one for older data. i need to provide my users the option to select,
from a single drop list, serial numbers both tables. hopefully there is a
way to ...
|
Use of DSum, DCount, DLookup, etc in form after splitting
Fri, 19 Mar 2010 12:54:01 -0700
I was reviewing Tony's Performance FAQ and am trying to address point 'Use of
DSum, DCount, DLookup, etc in form after splitting' That said the link he
provides is broken. Before I reinvent the wheel, I thought I ask if/where
others had found good replacement functions?
I know and use Allen Browne's Elook ...
|
cut and paste from a combo box into a memo field
Fri, 19 Mar 2010 12:25:56 -0700
I have a combo box "cboReferences" and a memo field "message" (in a text
box) on a form. I would like to be able to do the following:
1. Make a selection from combo box
2. Place cursor at the appropriate point in memo field
3. Click an "Insert" button and have it copy the selection in the combo
box and paste it ...
|
Determine if an object variable is set
Fri, 19 Mar 2010 11:10:15 -0700
How can I determine if an object variable is Nothing.
Dim appMapPoint as Object
Set appMapPoint = CreateObject("MapPoint.Application")Set appMapPoint =
CreateObject("MapPoint.Application")
Later.... Set appMapPoint = Nothing
Here is why:
I am automating MapPoint via Access/VBA. I always set the map ap ...
|
Mutliple Databases Open for Some Users
Fri, 19 Mar 2010 11:06:01 -0700
I found the code and explanation listed below but I'm not a programmer so I'm
not really sure where to put this. Can anyone help me out? Thanks.
This solution uses the titlebar of the database window. It checks each
other instance of Access currently running and if the titlebar of the ODb
class window ma ...
|
|
|
Table to Array
Fri, 19 Mar 2010 10:51:02 -0700
Hello,
I am hoping to work out a method to transform a data table into a running
list.
The table has identifiers in column A, and product weights in a dynamic
number of columns to the right. i.e. Cols B-M. I would like to manipulate
the table into a running list of three columns
Col A = Value of ID @ r ...
|
Run Time Error 3027
Fri, 19 Mar 2010 08:33:01 -0700
Running Access 2007 with an Pervasive SQL database and everytime I try to add
a record I get this error and tell me the record is read-only.
I use the same procedure in other updates and works fine.
Needing Help. ...
|
UTF-8 Encoding
Fri, 19 Mar 2010 08:04:01 -0700
Hello.
I'm using VBA to create a XML string. Now i need to encode it to UTF-8.
How can i do this?
Thanks.
Luis. ...
|
