Need Money????
Tue, 16 Dec 2008 00:03:40 -0500
Need Money, visit http://dinero4ever.blogspot.com
Now!!!! ...
|
The ABC's of Application Distribution
Mon, 15 Dec 2008 19:17:02 -0800
Hi â??
Iâ??m nearing the end of development for a small Access application and Iâ??m
starting to think about beta testing and distribution. Iâ??ve developed the
application completely in Access 2003 (I donâ??t own, nor have I used any
â??developerâ??s editions" or tools like Visual Studio). I need advice ...
|
SQL string in VBA
Mon, 15 Dec 2008 17:41:01 -0800
Good day all;
I'm having a problem with an SQL string built in VBA. On my forms I'm using
the value in a Combo Box (e.g., cboSelChkList) as part of the SQL string to
filter the formâ??s recordset. The SQL created in VBA replaces the formâ??s
Record Source. This works fine in that scenario, but does not work ...
|
Routine for listing field names of a table
Mon, 15 Dec 2008 15:09:01 -0800
I am using Access 2002. I need a VBA routine that will give me the names of
all the fields in a table. I would like to simply define the table as a
string and then have it upload the field names in a dimensioned array that I
have already defined. I know this should be easy, but I'm having trouble with
Access ...
|
Opening 2nd Database from Current Database
Mon, 15 Dec 2008 12:49:01 -0800
I have scoured through here for days and all weekened I poured through
newsletters and forums hoping to find something that would work for what I am
trying to accomplish... If I missed it through here, please forgive my
duplicate entry....
I have one Database, Main Database - 1.0.2.mdb, that is current and ...
|
>> class recordsource
Mon, 15 Dec 2008 12:38:01 -0800
Hi, just wondering, is it possible to have a class as the recordsource for a
form or report? If yes, how?
The reason is that I would like to have more control over record navigation,
editing and audit trail.
Many thanks,
Jonathan ...
|
Error #3073 was generated by DAO Database
Mon, 15 Dec 2008 12:32:01 -0800
I have an application programmed in Visual Basic in Microsoft Access 2000
that extracts data using an Oracle 10 ODBC driver. It consists of 70
pass-through queries that are used to append data to 70 tables. The amount
of data generated is very large. Currently, the .mdb that houses all the
data is approxi ...
|
|
|
This is a toughie | auto-calculate depreciation | populate unbound
Mon, 15 Dec 2008 11:45:02 -0800
Using Access 2003, Iâ??m trying to have a db auto calculate an assets
depreciation values over a user specified time period. I have a main form
â??frmAssetsâ? a subform â??frmAssetsSFâ? and then another subform inside the last
subform â??Depreciation Subform.â?
Using the template example for recurring e ...
|
Access 2007 or Vista corrupts mdb?
Mon, 15 Dec 2008 11:15:02 -0800
We have an Access 2002/2003 format mdb shared by a number of users on a local
network. A new user wants to use Access 2007 rather than 2003 to open it,
however every time he does, it corrupts the file badly ("microsoft jet
database engine could not find the object msysdb"). Jetcomp.exe cannot save
it.
...
|
Find the query executed by OpenQuery
Mon, 15 Dec 2008 09:59:03 -0800
I have visual basic code behind a form in an Access database that I did not
create. There are several blocks where different queries are executed, like:
DoCmd.SetWarnings (0)
DoCmd.OpenQuery "DELETE INSTALL DATA"
DoCmd.OpenQuery "DELETE EDITION OVERLAP"
DoCmd.OpenQuery "Make install data"
DoCmd.OpenQuery "Ma ...
|