Using VBA how do I access table properties in Access 2007?
Thu, 19 Jun 2008 10:04:11 -0700
In the Navigation Pane I set a table to hidden using the right click button
and opening "Table Properties" and then I clicked the "Hidden" checkbox in
the "Attributes" section to hide it. I can reverse it in "Navigation Options"
in Access but I can't find anything in the object model in VBA to
programmatical ...
|
Run-time error '3112' Record(s) cannot be read; no read permission
Wed, 18 Jun 2008 10:51:08 -0700
I have an Access 2003 FE & BE database running on a PC. The source for a
Combo box is a simple query that selects all 6 fields from a Sales Source
linked table. I have an After Update Event which checks the OldValue from the
Combo Box to see if it is a particular type of sales source, as it uses the
informat ...
|
ADO and Large Varchar truncated to 255 chars
Mon, 16 Jun 2008 17:58:01 -0700
Hi there,
I am trying to retrieve data from an SQL Server 2000 db. The data is
Varchar(4000). Using the following VBA the data gets truncated to 255 chars.
How do I get data from large Varchar fields using ADO?
Many thanks
Tim
Do Until rs.EOF
i = 0
For Each f In rs.Fields
...
|
Error 'Too few parameters. Expected 1.'
Thu, 12 Jun 2008 00:58:01 -0700
Hi, excuse the cross posting. I did post this in Forms Coding, but didn't get
a response so I think I may have posted in the wrong place (seeing as my
error occurs when using ADO). My apologies, I wouldn't normally post twice!
Anyway I've got a strange problem.
I've got a form 'EditPartNumbers' where a user ...
|
Module corrupted in access format (2002-2003)
Wed, 11 Jun 2008 01:31:00 -0700
When I open my ACCESS file and execute the program I wrote ,I recieved an
error that the VBA project is corrupted .aslkme if I want to delete the VBA
project To continue.
Last week every thing was OK.
I open the program with access 2007 , I try with Access 2003 , but I have
the same error.
Please Can anyb ...
|
code used to analyze database objects - Documentor not enough
Tue, 10 Jun 2008 08:35:06 -0700
I've inherited a large Access database with a lot of connected tables, tons
of queries, and loads of macros. I would like to be able to do the following:
1. Run code to count the number of database objects -- What is the syntax
to return the number of Macros, Reports, and Forms in the database?
a. db.Tabl ...
|
Find 'e', 'ë', 'é'
Tue, 10 Jun 2008 04:10:01 -0700
Hi.
I can't find how to (programmatically) make a setting that treats 'ë', 'é',
etc. the same as an 'e' for use in a recordset.FindFirst
Thanks,
Ronald. ...
|
|
|
AutoNumber emulation
Mon, 9 Jun 2008 06:55:00 -0700
I would like to stay in control and determin myself what Number to add as
index value. Is there way to add unique values just without using the
AutoNumber feature in my index field? AutoNumber is a problem when you need
to restore data... ...
|
Deactivate AutoNumber in vba
Mon, 9 Jun 2008 06:29:01 -0700
does anyone know how to deactivate a fields AutoNumber property in vba? ...
|
Powerpoint presentation
Thu, 5 Jun 2008 04:49:01 -0700
hi,
When I open a PowerPoint presentation from an access 2003 it disappears
into the background. Is it possible to bring this presentation iimmediately
in the foreground?
tx
greetings
Michaël ...
|
