|
iteration through Caption property of all labels
Hello.
I want to internationalize my. mde application forms and reports.
Is it possible to iterate through all labels in all forms an reports, get
their Caption property values, put them in some local JET table and then use
it for other language translations?
I thought to add translations as columns to that local table, so that during
start-up, my application cheks which language is cur...
|
5 |
24.09.2006 08:12:02 |
|
How do I set up a Database so users cannot change tables,forms,rep
I have created a Constituents Database. I have it in various offices without
any restrictions on users. I would like to set up the database so that users
cannot access tables, forms or reports other than what I have set up without
my permission. What is the easiest and best way to accomplish this?...
|
3 |
24.09.2006 06:38:35 |
|
report build on cross-tab parameter query
Hi folks,
I build report based on cross table query and everything was good until
I put parametrs in my query. The parameter is
Forms![FormName]!FieldName]. The query is working well but that
addition disabled my report. Now I am getting message - The microsoft
Jet database does not recognize " as a valid name or expresion. As soon
as I remove parameter report starts to work well. Any idea...
|
4 |
24.09.2006 04:56:02 |
|
Text Wrap & Access 2003
I am creating a database for the local United Way office in our county. The
one report is on 11x17 paper but I need to do a text wrap for the column
headings and cannot for the life of me figure out where to do this.
I would appreciate any suggestions. Thanks in advance for your time!...
|
6 |
24.09.2006 03:16:30 |
|
Side by side installs of Access XP and Access 2003
Hello all,
I know there are a lot of threads in the newsgroups and references in
the MS knowledge base about running different Access versions
simultaneously. Some of the solutions posted even appear to work so
long as one doesn't apply any service packs. At any rate, I am trying
to figure out how to run Access XP and Access 2003 on the same machine
without being bedeviled by the Windows...
|
2 |
24.09.2006 02:00:23 |
|
how can i debug windows explorer?
dear sir/madam
good time .how are you?
i have a problem , when my notebook is in standby and i turn it on, it show
a messege that windows explorer has a problem and must close it.
i push debug several time but it could not solve my problem.
thanks a lot
amir ...
|
2 |
24.09.2006 01:10:43 |
|
create access database for bar exam preparation
does anyone know how i can create an access database table for bar exam
preparation?
thanks,
john bevan...
|
2 |
24.09.2006 01:10:18 |
|
Multi-line field does not merge in MS Word
When I add a multiline field to a query that has fields Word only shows
M__ and M__1 fiels.
Is there a workaround for that?
Greetings from Paraguay.
Claudio Bogado Pompa.
...
|
4 |
24.09.2006 00:51:13 |
|
Maximize a form
How can I keep a form maximized? I would like to keep a form maximized
always, when opening reports and other forms....
|
2 |
24.09.2006 00:45:48 |
|
Where do I find a silent auction database template?
We are having a silent auction (70-100) items for 300-500 people. I was
hoping to find a silent auction template for use in either Access or Excel to
use to gather names, address, bid number, then a table for item number and
price paid.
first time I've posted, sorry if this is not the place to ask. ...
|
4 |
24.09.2006 00:38:08 |
|
Access 2007 Front End for SQL 2005
How can Access 2007 be used as a Front End for an SQL 2005 Database. Access
2003 and older has the options of create new project which created an .adp
file. This Access .adp file could create a new database, change existing
data, change the design of an existing sql 2000 database. Access 2003 could
not change the design of SQL 2005 DB.
Is there a comparable feature in Access 2007 whe...
|
23 |
23.09.2006 23:43:27 |
|
Etat automatique sur requête variable en critères et affichages
Bonjour,
J'utilise une requête avec différents critères sur différents champs, avec
un affichage de certains champs selon la demande ponctuelle.
Je peux alors faire un état sur le résultat.
est il possible d'automatiser la création de cet état selon les critères et
champs affichés par l'utilisateur de la requête ?
Sans relancer l'assistant chaque fois, choisir la requête, etc...
Un plus, ...
|
2 |
23.09.2006 23:37:06 |
|
Textbox Backcolor
Hi,
I have a textbox on a form and I set the BackColor property to gray.
The form is set to display in DataSheet mode, when it displays, the
backcolor appears as the default white, which is not what I want. There
are other textboxes on the form, that I want to stay at the default setting
of white.
Can someone tell me how to set the Backcolor property so that it
st...
|
6 |
23.09.2006 23:28:30 |
|
What is the meaning of A$100?
I have to study an excel-sheet, and I do'nt understand the mening of this
sign: $
Whow would this sign have to been used?
thank you...
|
3 |
23.09.2006 23:25:10 |
|
how can i download a spanish translator
i need to translate messages into spanish. does anybody know how i can get a
spanish translation downloaded into my computer...
|
2 |
23.09.2006 21:53:36 |
|
Move down one line in a textbox
I have a combobox that populates a textBox. That is working fine. What
I can't figure out is that when I want to add another record to the
same textBox, coming from the same comboBox, I'm not able to do so. I
want to know if there is a way to tell VBA to put that new record under
the previous one. Here is the code I have so far.
Private Sub Command130_Click()
Dim aov100 As String
aov1...
|
9 |
23.09.2006 21:32:18 |
|
Question about ActiveX
i have a Access 2003 database that i deploy to my customers. I have today
found some ActiveX components that i can use with my database from
http://www.namtuk.com/mycommandbutton.aspx
Ive never had anything to do with activex control before. can someone point
me in the right direction of some good articles of what they are and how they
work.
Also i have the option to purchase the act...
|
6 |
23.09.2006 19:33:29 |
|
How do I make a weekly attendance roll for my database?
I need to make an attendance roll for the people in my database each week, so
that the list of people can be ticked off if they are present, and the
information can then be stored in the database so reports can be printed, etc
without the data being accessable to manipulate....
|
2 |
23.09.2006 18:49:38 |
|
Date format using pre-defined specification in Access?
When attempting to import a text file using a pre-defined Import
Specification file that contains a Date field, the resulting table does not
have the corresponding field is not of the type Date/Time and the data is
brought in as text.
Example: 02051998 should be brought in as 02/05/1948 but comes in exactly
the same as in the text file.
Thanks....
|
3 |
23.09.2006 18:23:02 |
|
Requery, Refresh is there better way to do it then I have been
I have a form with a listbox. I have an event on double click on the listbox
that opens a form that coresponds to the value in the listbox to edit. After
I edit the record I have a command button to close the popup form. however
to Requerry the list box I have to re-open the form (keep in mind the form is
already opened in the background) then use the statement to requery the
listbox....
|
8 |
23.09.2006 18:03:38 |
|
Make Access available over the Web
Is it possible to create an Access database and then make it available over
an intranet or the internet? If yes, is there a good source on how to do this?...
|
2 |
23.09.2006 18:01:22 |
|
split up adres no.
I have a database with a field with an adress number in it. Some of these
numbers also have an "non number" in it. f.e. 45a or 45-a.
I like to spilt this up into 2 fields so 45a must be split up in one field
the "45" and in an other field the "a"
Is their some function to do so?
regards
Kees
...
|
3 |
23.09.2006 17:18:29 |
|
Month/Year Format
I created an invoices database with one field being "Month Paid" but I can't
seem to get the formatted date the way I want. I want MON-YY. So, Jan-05,
Feb-05, Mar-05 but there doesn't seem to be a date format with that
selection. So, I made the fields text fields and just typed in the Month &
Year but now when I want to create a report and group by the Month & Year
field, it sorts the...
|
4 |
23.09.2006 16:20:42 |
|
Duplicate numbers
I am trying to set a warning when a duplicate project number is entered into
a field on my form. The index is set to Yes(No Duplicates), but it only
gives me the error when I have filledout the rest of the form. i need it to
prompt me when I enter the duplicate number. My table name is 2006 FB Quote
Data. The Field name is Project Number and the Form name is 2006 FB Quote
Approval F...
|
5 |
23.09.2006 14:26:43 |
|
no "dao360.dll"!
Hi. I am getting an error msg "Active X cannot create object" in Access 2003,
when I am trying to use wizards.
I have tried to register "dao360.dll" through regsvr32, but hav actually
found that through a search I have no "dao360.dll" on my hard disk at all. I
have also tried to reinstall files "acwzmain.mde", "acwztools.mde" and
"acwzlib.mde" but that did nothing. Then I uninstalled Offi...
|
3 |
23.09.2006 13:59:04 |