mixed cases words help required!
Fri, 21 Sep 2007 00:55:14 -0700
Hi to everyone in the Newsgroup,
I have a question that I really don't known how to solve.
To handle names with mixed cases, on my form, I'm using the code I
found at this web-link: http://www.mvps.org/access/strings/str0008.htm
Of course, it works great and as I read it should be modular so that
it possible ...
|
Date Function or Command
Thu, 20 Sep 2007 12:51:45 -0700
How to calculate the due date in lotus notes, adding any number of the
day, month or year to any date?
Example:
Calibration date : 21.09.2007
Calibration frequency (interval) : 90 days
Calibration due date : 20.12.2007
or
Calibration date : 21.09.2007
Calibration frequency (interval) : 3 months
Calibration ...
|
How to refresh a treeview on a form?
Tue, 18 Sep 2007 09:32:01 -0700
Hello: I'm new to using a treeview on a form.
I have a main form that contains a treeview. On the main form are two
subforms. One subform (sub A) displays data based on the selected node on the
tree. The second subform (sub B) displays any subordinates that are related
to the initial subform.
If I add a ...
|
Access 2003 - Limit on Value of Primary Key Number
Tue, 18 Sep 2007 09:16:03 -0700
I have an Access 2003 database which I have been using for over 5 years. The
AutoNumber being used as the Primary Key in one of my tables is now 88537 and
is increasing as I add more data. Is there a limit on how high this
AutoNumber can go? Occasionally I delete old information from the database so
I have f ...
|
Import .dbf files to MS ACCESS
Tue, 18 Sep 2007 09:10:00 -0700
I am trying to bulk import .dbf files into access. The numbers change every
time a transaction is input, but the first two positions stay constant. For
instance:
QB00331, QB00451.
Is there a way to check a directory C:\FSMFILES\ for all files that start
with QB and insert them into a table. It can import al ...
|
Paste formatted text from Word to Acces Memo field using vba
Tue, 13 Mar 2007 03:14:00 -0700
I have an access 2007 database with a table. In that table there is a
memofield with formatted text. (bullets, fontcolor etc)
When I enter some text by hand en make text formating, I'm able to copy the
formatted text from one record to another, using a form:
The code looks like this:
iets = Form_Formuli ...
|
Query on controls and subform
Tue, 13 Mar 2007 02:46:18 -0700
I've found out (through experimentation!) how to use a form to put in unbound
controls and then use VBA so that when I hit [OK] button (with the VBA in 'On
click') it opens up a query and form based on the data in the controls. So,
for example, I have a start date and end date. When I put the dates into th ...
|
|
|
Linking Oracle Tables in MS Access using ADO through VB programmin
Mon, 12 Mar 2007 21:50:08 -0700
Anybody is aware of linking oracle tables through ODBC connection in MS
Access database using ADO through VB programming.
I used docmd command but it will prompt for "select unique record
identifier" for each table. I want to be linked without promting.
I can do linking oracle table in MS access databas ...
|
TableDefination of DAO 3.6 is not working in Windows XP (MDAC -2.8
Mon, 12 Mar 2007 20:58:05 -0700
Following code is working in windows 2000 which uses MDAC 2.5 while same is
not working in Windows XP which uses MDAC 2.8. This is regarding Table
defination of DAO 3.6. Anybody has solution to work this code on Windows xp.
=====================================================
Public Sub ProcessDatabase(DSNS ...
|
Deploying VB6 + DAO 3.6 + JET 4.0?
Mon, 12 Mar 2007 03:35:00 -0700
Hi,
We have an Access DB that our customers subscribe to. A new version is
issued every month. Along with the DB we ship a small data selection tool
written in VB 6 that uses DAO 3.6 and Jet 4 to access the DB.
I need to create an MSI installer for this. Where can I find:
1. Merge modules that contain ...
|
