Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
group : microsoft.public.access.modulesdaovba      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



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. ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us