Close Button on Custom tool bar no longer works in Access 2007
Fri, 18 Jul 2008 10:44:01 -0700
I created a custom toolbar (for all my reports) that works fine in Access
2003. But when someone opens the same database in Access 2007, all the
buttons on the custom toolbar work except the close button. It does nothing
when this button is clicked. Any ideas? ...
|
Trouble Closing My Application
Thu, 17 Jul 2008 11:33:18 -0700
I'm having trouble closing database app. It occurs only after I click a node
in a treeview control then try closing the app. I get "Microsoft Office
Access has encountered a problem and needs to close. We are sorry for the
inconvenience.". Here is the code: (only started do this when we upgraded
to 2007 ...
|
Macro to create new field in access db
Tue, 15 Jul 2008 08:09:01 -0700
I have a simple database in which users need to be able to add new fields to
later down the road. I want to make a macro that will allow them to enter a
new field name and the macro will copy the last field on the table, paste it
underneath of that one as a new one, and then change the name to the one
entere ...
|
VBA Syntax - Get Filepath of the Current MDB/MDE
Fri, 11 Jul 2008 17:46:00 -0700
Hi. In VBA, is it possible to determine the filepath of where the current
MDB/MDE is running? For example, If I have the file c:\dev\app.mdb, I would
like to write code which returns "c:\dev\app.mdb".
Thanks! ...
|
Need to convert multiple columns into 1 colum in MS Access table
Thu, 10 Jul 2008 10:53:41 -0700 (PDT)
Hi,
I have a table which has dates & quantity going across as columns. I
need to get the dates in only 1 column & the dates in another
column.
How do I do this in vba?
Here is a sample:
ID Fname Lname ProductID Order Date 1 Order Qty 1
100 William Smith 4/9 8
102 N West 4/9 8
Order Date 2 Order Qty 2 ...
|
FileSearch for MS Access 2007
Wed, 9 Jul 2008 12:49:05 -0700
Why was FileSearch dropped? ...
|
DBEngine Error
Wed, 9 Jul 2008 11:39:01 -0700
We moved an Access 2002 database to Access 2007 and are now receiving an
error stating the system can't findthe name "DBEngine" entered in the
expression. No code changes were made. Any ideas? ...
|
|
|
JET + kana sensitive
Tue, 8 Jul 2008 09:18:06 -0700 (PDT)
Hello,
I'm probably wrong here, but I couldn't find a suitable group:(
does anybody know how to make a JET database kana sensitive?
Thank you in advance
Konrad ...
|
autonumbering logic
Sat, 28 Jun 2008 05:09:01 -0700
The nice thing about autonumbers is that it allocates a unique number.
does anyone know where Access stores the info of the last allocated index
number?
...
|
Programmatically renaming reports
Thu, 26 Jun 2008 11:58:01 -0700
I have a number of reports that I want to rename programmatically.
They are all named "[reportnumber] HP Detail". I want to change that to "HP
Detail [reportnumber]"
The following code filters for reports with the proper name structure,
determines the [reportnumber] portion, then uses the docmd.rename method ...
|
