... Er, because there is. See the StrConv function and use vbProperCase as the flag....
240
Chris Kelly
chris@xxxxxxxxxx.xxxx
Aug 1, 1999 11:10 pm
I guess I've never had much use for it :) Mea culpa. ... +-------------------------------+-----------------------------------------+ ... ...
241
Bhuvah
Bhuvah@...
Aug 2, 1999 11:22 am
Hello I have to write online help for a database. I have written one once for an Access 2.0 database - I wrote it in Word 6 using a template called what6 that...
242
Paul Walker
pwalker@xxxxxxxxxx.xx...
Aug 2, 1999 11:30 am
The easiest way is to get the developer edition of office which comes with the help workshop allowing you to create help files from rtf files. ... From: Bhuvah...
243
mfox
mfox@xxxxxxx.xxx.xxx
Aug 2, 1999 12:02 pm
Am after any advice. I am preparing a PowerPoint presentation which I would like to personalise. I have an access database which I would like to link to one or...
244
TOM CURRIER
THC@xxxxxxx.xxxx
Aug 2, 1999 2:44 pm
Here Goes: Public Function Proper(strToChange As String) As String ' Converts string to Proper case On Error Resume Next Proper = StrConv(strToChange,...
245
patricia johnston
patricia_johnston@xx....
Aug 2, 1999 5:57 pm
Hi, How do you increase the amount of data you can type into a row? for example I have a field named Remarks, and I cannot type in as much as I need to. It ...
246
Stephen Pickering
SJPickering@xxxxxx.xxxx
Aug 2, 1999 7:41 pm
As far as the text goes, you can change the field size property in the Design view of the table. Text defaults at a size of 50 characters, but you can change...
247
Bhuvah
Bhuvah@...
Aug 3, 1999 7:38 am
I have found that when I open a datasheet form with code I can't seem to have the form not display recordselectors and the minimize and maximize buttons even...
248
Pat Wills
TheWills@xxxxxxxxx.xxxx
Aug 3, 1999 4:53 pm
I tried to publish a report in Word... and got the message... "You tried to use a form, report or database that contains an OLE object, but the OLE server may...
249
Chris Kelly
chris@xxxxxxxxxx.xxxx
Aug 3, 1999 6:53 pm
In the scenario described by you below, _Word_ is the OLE server, Access is the OLE client. Maybe if you re-install Word ... ? If that doesn't do it, perhaps...
250
r a
sbs1@xxxxxxxx.xxxx
Aug 3, 1999 7:09 pm
-- Pat I think you can fix this by making a reference to the word object library in Access.You do this by going to references in the Menu from the module ...
251
r a
sbs1@xxxxxxxx.xxxx
Aug 3, 1999 7:29 pm
Hi I just taken over a database application that was developed by another person. When I look at the code the developer has used standard naming conventions eg...
252
Stephen Pickering
SJPickering@xxxxxx.xxxx
Aug 3, 1999 7:28 pm
We use "z" prefixes for system or development objects. It sorts 'em to the end of the list in the Database Container, and helps us track what's what. ... ...
253
TOM CURRIER
THC@xxxxxxx.xxxx
Aug 3, 1999 10:46 pm
Sometimes, it's used to further identify either forms used as menus or sub-forms. It is a method of grouping like items together at the bottom of the list. ...
254
Chris Kelly
chris@xxxxxxxxxx.xxxx
Aug 4, 1999 12:24 am
... System tables (which are hidden by default, but can be un-hidden) all begining with "MSys". One would imagine that even MS would manage to be consistent...
255
Andreas Kodyat
andreas_kodyat@xxxxxx...
Jul 24, 1999 1:58 pm
Hi Christy, I'm quite new too. :) I think all you need to do is to refresh that form after you updated the other table. Regards, Andreas. ... I do have a...
256
Gavin McEwan
gavinmce@xxxxxxx.xxxx
Aug 4, 1999 11:05 am
Perhaps someone has had a similar problem to this. A multi-user database on a server has full-access users and read-only users. The full-access users can all...
257
Jon Higgins
jhiggins@xxxxxxxxxx.x...
Aug 5, 1999 3:44 pm
Hi, I'm trying to create an interface that allows a user to set the filter property of a subform from one of several controls in the main form. When I refer...
258
Jon Higgins
jhiggins@xxxxxxxxxx.x...
Aug 5, 1999 7:13 pm
Hi, After reading this it occured to me that it wasn't entirely clear what I was asking. The stumbling block for me is basically being able to set the filter ...
259
Chad Gould
Chad_Gould@xxxxx.xxxx
Aug 5, 1999 8:16 pm
... users. ... Unfortunately, Microsoft Access requires read/write/delete privileges to be given to all users for the directory which the database is in. This...
260
Chad Gould
Chad_Gould@xxxxx.xxxx
Aug 5, 1999 8:25 pm
... a ... You can try: Forms![frmMainForm]![frmSubForm].[Filter] = "Filter value" However, I don't see this as a property on the subform page, so I'm not sure ...
261
TOM CURRIER
THC@xxxxxxx.xxxx
Aug 5, 1999 9:17 pm
We have a database as follows: Parent Table Parent Key Desc...etc. Child Table Joining Key Role Value We would like to create a table which contains: Parent...
262
Sue Johnson
suej@xx.xxxxxx.xxxx
Aug 5, 1999 11:54 pm
Thanks, Chad, I figured it out, just asked the wrong way I suppose. Sue ... From: <accessaskme@onelist.com> To: <accessaskme@onelist.com> Sent: Monday, August...
263
Chris Kelly
chris@xxxxxxxxxx.xxxx
Aug 6, 1999 1:12 am
... form. When ... You need to understand the relationship between the ParentForm, the SubFormCONTROL & the SubForm. The SubForm is contained _within_ the...
264
Chris Kelly
chris@xxxxxxxxxx.xxxx
Aug 6, 1999 1:31 am
I think you'll have a bugger of a time trying to create Access tables with variable numbers of fields, but it's fairly easy in code: Function OutputSomeStuff()...
265
Mark
marka@xxxxxx.xx.xxx
Aug 6, 1999 5:44 am
After doing that you might have to set .FilterOn = True ... From: Chad Gould [mailto:Chad_Gould@...] Sent: 05 August 1999 22:26 To:...
266
Gavin McEwan
gavinmce@xxxxxxx.xxxx
Aug 6, 1999 9:03 am
... Thanks; in the end we just decided to keep a copy of the db in a separate, read-only directory, backing up the data from time to time (hopefully!) from the...
267
Chad Gould
Chad_Gould@xxxxx.xxxx
Aug 6, 1999 1:31 pm
... Microsoft does have a database security function (the "user level security" stuff) where people are required to log in, and various forms and reports can...
268
Chris Kelly
chris@xxxxxxxxxx.xxxx
Aug 6, 1999 2:16 pm
... help me out a ... OpenArgs parameter of OpenForm to set, OpenArgs property of the Form to use. ... were ... Access ... Improve? In what way? If they...
