I think the formatting has to be done on the Word end. Here's a link on the subject:
http://office.microsoft.com/en-us/wo...in=EC001022717
About two-thirds of the way down the page they actually use currency as an example of formatting text.
Linq ;0)>...
missinglinq
Last Activity: Dec 25 '10, 03:34 AM
Joined: Nov 6 '06
Location: Richmond, Virginia USA
-
I seldom say "No," but I don't think so. Things like that are controlled from within Windows and carry thru all Windows-compliant apps. The whole point is for the user to set colors for things like this to his or her preferences.
Welcome to Bytes!
Linq ;0)>Leave a comment:
-
Did you also move the file, perchance? In Access 2007/2010 macros, like code, won't run unless the folder holding the file has been declared as "trusted." If you move a file from a trusted folder to one that hasn't been declared as trusted you'll get this error.
Of course, if all you're doing is having the main form open when the database does, you can go to
Tools-Startup
and set it in the Display...Leave a comment:
-
Our exalted leader, NeoPa, has an excellent tutorial on that very subject in the Insights section:
http://bytes.com/topic/access/insigh...-when-use-them
Linq ;0)>...Leave a comment:
-
I don't think there's any formatting that can be done to a table using VBA, for a very simple reason. Tables should never be made directly available to end users! The data should only be accessed by users by way of forms or queries. You can use the Form Wizard to create a form from your table, in Datasheet View, in less than a minute.
Linq ;0)>Leave a comment:
-
It think it should be TableDef, as in the example that works, not TableDefs, which doesn't. Try dropping the s from the end.
Linq ;0)>Leave a comment:
-
To have the items show, have the combobox drop down when the user enters it, using code like this:
And in the future, please don't send followup questions by PMs to members who have responded to your thread. It violates the rules of the forum and it precludes other members helping you. Simply add another post to your thread.Code:Private Sub ComboBoxName_GotFocus() ComboBoxName.Dropdown End Sub
Linq...Leave a comment:
-
This is standard behavior for a Combobox when the AutoExpand Property is set to Yes, which is the default for this property.
Welcome to Bytes!
Linw ;0)>Leave a comment:
-
Substituting your actual names:
Welcome to Bytes!Code:DCount("*", "CompanyTable", "[CountryFieldName] <>'" & "Portugal" & "'")
Linq ;0)>Leave a comment:
-
Are you aware that setting Data Entry to Yes is not necessary in order to enter new records?
Data Entry = No
AllowAdditions = Yes
AllowEdits = Yes
will allow the adding of new records and the viewing/editing of existing records.
Linq ;0)>Leave a comment:
-
Note that for ADezii's code to work the RowSourceType has to be set to "Value List." Also, this method is only available in post Access2000 versions. In v2000 and earlier versions AddItem was used to add items to Menus, I believe.
Linq ;0)>Leave a comment:
-
Forcing users to scroll a form is considered by most experienced developers to be the absolute epitome of user-unfriendliness!
If a form is too big to view without scrolling the usual solution is to utilize a Tabbed Control. This approach also has the advantage of allowing the logical grouping of controls.
For example, in an employee database, you could organize data like:
Page1
FirstName
...Leave a comment:
-
A couple of things.
First, as illogical as it seems, C & R is considered to be a common cause of data corruption! Because of this, the native Access "Compact on Close" option is possibly one of the worst features they've ever come up with! You should always back up an Access file before doing a C & R, which is the reverse of what you're speaking of doing.
Secondly, one has to ask why you feel the...Leave a comment:
-
Setting a form to Popup or Popup/Modal does not, in and of itself, prevent records from being deleted! The poster in the linked post has to have something else going on other than the form being set to Popup to cause the problem.
Linq ;0)>...Leave a comment:
-
Setting a form to Popup or Popup/Modal does not, in and of itself, prevent records from being deleted! You have to have something else going on here that is doing this.
Linq ;0)>Leave a comment:
-
Per Access Help, Refresh only shows changes made to current records in a multi-user environment. It will not show/exclude records that have been added/deleted. For this you have to actually Requery the RecordSet using Me.Requery.
Linq ;0)>Leave a comment:
-
This is a calculated field, so you want it to be Unbound. Anytime you need it simply re-calculate it.
In Form Design View, place the textbox for ClientName on the form, then goto Properties and in the Control Source use
=[FirstName] & " " & [LastName]
Welcome to Bytes!
Linq ;0)>Leave a comment:
-
Glad we could help!
Linq ;0)>Leave a comment:
-
My guess is that the new record on the first form hasn't been saved when you move to the second form. Immediately before the line of code you posted place this line:
If Me.Dirty Then Me.Dirty = False
and see if that doesn't do the trick!
Linq ;0)>Leave a comment:
-
missinglinq replied to How can I change 'Data entry' property and 'Allow additions' without using VBAin AccessYour interpretation of what you've read is incorrect!
Setting Data Entry to Yes is causing the problem. Forms set like this only allow the entry of new records! They do not allow for the viewing/editing/deleting of existing records!
The Data Entry Property name was a poor choice by Microsoft, as it would seem to indicate that it is necessary in order to enter records, which is incorrect.
Welcome to By...Leave a comment:
No activity results to display
Leave a comment: