|
table of contents - corrupted
The table of contents in a 170+ pages Hebrew document typed on Word 2000
appears with a group of pages numbers in letters rather than numbers in the
middled of the table. How can I fix this?...
|
3 |
06.02.2006 09:00:27 |
|
|
macro for currency Ranges
Does anyone have a macro for getting a value based on currency ranges
Example: if currecncy range is between $29000 to $100,000 = 100%
--
Ron D...
|
4 |
06.02.2006 17:49:40 |
|
|
IsEmpty - macro problems...
I have a database, which you can make ONE label and then you can print the
label in 19 languages BUT if the field "Productname" is empty, it should
stop... but I can't seen to get it working right..
F.x.: Productname in UK are "Product 1" and Productname in Austria is empty
(no sale)
---
Private Sub Button_Print_Austria_Click()
On Error GoTo Err_Button_Print_Austria_Click
Dim...
|
4 |
12.02.2006 00:33:58 |
|
|
filter property in macro
I would like to apply a filter upon opening a form. I have created a macro
to open the form and see that I can apply a filter. I have already created a
query that acts as the filter. Under filter name can I just enter the name
of the query I have created?...
|
2 |
10.02.2006 18:33:47 |
|
|
Does anyone know good resources for building macros and ActiveX?
I'm looking for a book or website that explains all the items in the pick
lists for building macros and so forth. It is not in the help option or the
books I currently have (Access 2000 Bible and How to do Everything with Acess
2002). I don't do programming yet so it needs to be relatively simple.
Thanks...
|
2 |
10.02.2006 18:30:41 |
|
|
setvalue help
I am building a Employee Training Tracker . I want to use setvalve to
automatically populate the Hours for each class based on which Course is
selected in the Combo Box. The sngHours Field in the
tblAOGAnnualTrainingCourse table has the hours predetermined. I have the
following table
tblAOGAnnualTrainingCourses
with fields
IDAnnualTraining
AogAnnualTraining
sngHours
I built a f...
|
2 |
10.02.2006 15:08:52 |
|
|
Put INSERT OLE Embedded Object into a button
I have an Access database, which has an image embedded in a form.
This process has to be repeated a number of times for each record (as they
will have different images).
The process of adding a new image involes finding the option on the toolbar,
which then loads the 'find image' screen. Is it possible to create a macro
which can then be integrated into a push button, which, when clicked,...
|
1 |
10.02.2006 09:30:26 |
|
|
How to input date by Calendar ActiveX in Access?
How to input date by Calendar ActiveX in Access?...
|
1 |
10.02.2006 06:52:26 |
|
|
Macros affected by Table Links
I have a situation where a desk top has Access2002 but which does not have
the Linked Table Manager add-in.
To complete the install of a new FrontEnd Access Program, without the Linked
Table Manager, I deleted all the existing Tables in the F.E. (they were all
link references to the Back End) and went to 'File' 'Get External Data' and
brought in all those tables.
Everything seems t...
|
1 |
09.02.2006 20:19:28 |
|
|
Access Module Help Needed
I have Access 2000, and have used an old Access 97 module as my source for
the syntax of statements for a new module I'm writing. Basically, I want to
have a macro execute the code, which will read a table from the open database
one record at a time, perform some logic, and write the results to a new
table. I think I'm ok with all the logic and the reading and writing of the
records.
...
|
6 |
09.02.2006 13:35:44 |
|
|
Data from one form to another
I am trying to copy a customer ID number from one form (customer ID is key
from this table) and use this ID in another form/table (can have many ID
entries). I have been able to find an expression to pull current entries,
but can not seem to create a new entry in another table....
|
2 |
09.02.2006 08:38:37 |
|
|
Importing Updated Data
I have a data bases that we import student names into. They now want me to
update it every month. Will Access over write duplicate data when importing? ...
|
2 |
09.02.2006 08:32:01 |
|
|
Automate a macro
I need to run a report every night and it is easiest to have as a html file,
and I need this emailing to a number of people every night, Is this possible.
I am presently using xp -home edition with Office 2003.
I have set up a macro to produce the report.
Can it be set to run every 24 hours?
can it be set to create email?
If so how.
I am not a numpty, but need step by step instruct...
|
5 |
08.02.2006 20:15:28 |
|
|
Execute Macro from batch file
I created a batch file:
REM - delete the file on disk
del c:\payor.rtf
START "C:\Program Files\Microsoft Office\Office11\msaccess.exe" "S:\
Access_DB\CMSI_batch_Reporting.mdb" /x "PAYOR - Assignment - Generate report
/ Email"
EXIT
(Note: the Start line is all on one line)
The problem is that it opens Access and navigates to the macro but does not
execute it.
Thanks......
|
1 |
08.02.2006 16:13:10 |
|
|
Macros
I have tried to transfer my old database onto my new pc using access 2003 as
well and i have the following error message
Security warning..
trying to open file......blah blah....
This file may not be safe if it contains codes that was intended to harm
your computer
Do you want to open this file or cancel?
When i open it as its my database so from a trusted source i am unable to
...
|
2 |
08.02.2006 16:10:30 |
|
|
Macro to automate a text entry into a comment text field
Hello,
I am trying to figure out a way (maybe not a macro) to automate text entry
into a text comment field.
Here is what I am trying to do. Either by pressing a macro key or by a
assigning a macro to a control button, I would like to "automatically" enter
the text into the selected comment box. The information I am trying to
display as text is something like (like a text-based time...
|
1 |
07.02.2006 22:19:30 |
|
|
Now to make process converting xls files to existing mdb automati.
Now to make process converting xls files to existing mdb automatically?...
|
2 |
07.02.2006 18:32:54 |
|
|
Access Macro Select Query Dialog Box needs to be resizable
I can never see my entire query name in the little tiny box that the Macro
gives you for selecting your query when you add an openquery statement to the
macro. The box which shows up at the bottom of the screen needs to be
resizable. I thought it might get fixed in Office XP and then maybe in Office
2003 but nope, still is that way. I guess I'm the only Access user who makes
long query ...
|
2 |
07.02.2006 18:26:34 |
|
|
I need help
every time I send and receive this error message comes up. It says incorrect
password or account nameCheck the username/password or security settings.
And it doesn't let me get my mail. can somebody help? my address is
eli.barr@providenceday.org
...
|
1 |
07.02.2006 02:06:14 |
|
|
Get Repeat Count from unbound control in Form
Hello, and this is my first post :)
How can I grab a numerical value from an unbound control on a Form, to use
as the repeat count for a Macro?
many Thanks.
...
|
4 |
06.02.2006 08:16:27 |
|
|
How2 move 1 field from 97 recrds to create 1 table with 97 fields
I have table with 97 records containing data that I wish to use to populate
another table with the first record containing all 97 fields from the other
table across in 97 fields. There must be some sort of loop reading the first
table (all 97 records) and then populating one record in the second table
with 97 fields. How do I do that?
...
|
6 |
06.02.2006 01:58:56 |
|
|
GoToControl
I would like to move to another combo box (text4) after update and in case no
changes are made would like to go to same combobox on exit. Used the
following code, but receive error message that focus can not be moved to
control text4 (Run-time error 2110)
Please help
Option Compare Database
Private Sub Text_AfterUpdate()
DoCmd.GoToControl "Text4"
End Sub
Private Sub Text_Exit(C...
|
1 |
05.02.2006 20:30:28 |
|
|
control 'TabCtl8'
(the control 'TabCtl8' the macro is attempting to search can't be searched).
I am getting this message on some machines which are using a database i have
developed in Access, the message appears when trying to use a find button on
a form. can anyone help please
...
|
3 |
04.02.2006 16:47:51 |
|
|
Animals in China
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
sales@lpi-hk.com
...
|
1 |
04.02.2006 10:03:53 |
|
|
Animals in China
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
sales@lpi-hk.com
...
|
1 |
04.02.2006 10:03:47 |