Macro to wait until an excel spreadsheet macro has finished runnin
Tue, 5 Aug 2008 10:38:01 -0700
Hi, i hope you can help.
Basically, from within a database i have a command (runapp macro) that opens
a specific excel workbook. This excel workbook has an autoexec macro in it so
that it runs when it opens and it takes about 40 seconds fro it to run
fully....My problem is that i want the runapp macro to do ...
|
Can't find macro error message
Mon, 4 Aug 2008 13:06:01 -0700
I am a macro newbie.
I copied a query and report from one database to another. In the new
database when I open the report I get an error message "cannot find macro
Macro1Page".
How do I locate the macro in the original database and copy it to the new one?
Thanks. ...
|
Macro to change data type
Mon, 4 Aug 2008 10:16:07 -0700
I am importing a .CSV into an access 2007 database. All the fields in the
.CSV are text and some need to be number, date, text etc when being imported
into access. How can I change multiple fields from text to a useful data type
without going into table design after each import? Macro? Thanks in advance. ...
|
How to change data type
Mon, 4 Aug 2008 10:00:05 -0700
I am importing a csv file into an Access database< but need to change the
data types of several fields. Is there a way this can be done with a macro
and without having to go into design mode? ...
|
Using the SetProperty Macro action in a subform
Mon, 4 Aug 2008 03:27:01 -0700
When setting the font colour of a control in a subform Upon Change, i get an
error message about an incorrect control name. The name is correct, the macro
is embedded, and when i add SelectObject for the subform it says it is not
open, probably bc it is within another form.
Is there any way to get around thi ...
|
Inventory DAtabase
Mon, 4 Aug 2008 01:50:01 -0700
Hi,
I have an Inventory DB.
SupplierTbl â?? SupplierID, SupplierName
CustomerTBL â?? CustomerID, CustomerName
PartsTbl â?? PartID, PartModel, PartSN, SupplierID
I should create 2 forms:
Incoming form (to my stock) that should contain: IncomingID, part model,
part serial number etc. for every part I'm re ...
|
MsgBox - autoexec macro
Fri, 1 Aug 2008 12:17:02 -0700
upon opening my database I have a message box that asks "are you ready to run
the bank and register macros?" with a yes or no choice. this is in the
condition column. In the action column I have RunMacro - name AutoExec, then
in the next row RunMacro - bank load, and the next row RunMacro - Register
load, ...
|
|
|
code for expression
Fri, 1 Aug 2008 08:45:00 -0700
I have a RumMacro that send multiple emails to all my customers about their
invoices. I need help coming up with an expression that I can build so that
it will only email the customers who are not credit released. If a customer
is credit released we enter a date into the credit released field if not we
leav ...
|
Conversion error on importing Excel spreadsheet
Fri, 1 Aug 2008 08:12:11 -0700 (PDT)
I am imported an Excel Spreadsheet and I am getting a conversion error
on one field. It was initially supposed to be a number for Employee
ID, but we found out that some old ID's had letter in them. Someone in
London sent me a new file to import and some of the records start
with"TX". I went into Excel and thoug ...
|
Anuncios Gratis www.AnunciosGratis.de
Fri, 1 Aug 2008 12:13:30 +0200
Vendo coche seat ibiza, 1999 . en buen estado, color plata, Precio ,4900 euros. Precio 4566 Euros.
Tfno: 91452123334
Puedes ver mi anuncio gratis en:
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
ww ...
|
