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 ...
|
Click on a detail record field, reference the record?
Thu, 26 Jun 2008 10:38:04 -0700 (PDT)
I click on a detail record field in a form, and want to reference
other fields in that same record. In the OnClick handler, I can easily
see the field text value, and the Me.CurrentRecord number, like so:
Private Sub Tset_Click()
' I can see the text of the cell I clicked on (tset) fine.
' I can refer ...
|
Possible to import csv file with different field name??
Tue, 24 Jun 2008 00:20:00 -0700
Hello,
Is it possible to import csv file with different field names?? I want to
have different field names in my table but want to import fields from csv in
fields from table (I know which field to import in which field)
thx
juvi ...
|
How do I access a field in a previous record? (Access 2997)
Mon, 23 Jun 2008 18:20:01 -0700
--
Sister Patricia Stanley CSJ ...
|
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 ...
|
