Macro Validation?
Tue, 16 Sep 2008 14:52:29 -0700
I have a macro running with a condition to check a date field "AfterUpdate".
the point is to see if a date entered is invalid. In this case an invalid
date is anything before last sunday, or sometime in the future or "within
this week"
I have
[Forms]![frmNewClockIssue]![Date]>Date()
checking to see if t ...
|
Export Access Table into multiple Excel Workbooks
Tue, 16 Sep 2008 14:25:01 -0700
I have an access table that has information sorted by group, i would like a
macro or VB code that would export data from one access table into different
Excel workbooks depending on their group. Example:
Region Group First Name last Name
A Delta John Doe
A ...
|
Send email if an error message popup when running macro
Tue, 16 Sep 2008 08:41:01 -0700
I have a database which runs a macro from the Task Scheduler each night. The
macro builds tables and creates export files that are uploaded to our web
site each night. It is very important that I am immediately notified if an
error message pops up (visual basic or macro error) during the running of the
mac ...
|
How to setup a macro to change current record yes/no field to Yes?
Mon, 15 Sep 2008 21:16:01 -0700
How to setup a macro to change current record yes/no field to Yes? ...
|
macro to auto copy and fill down data in column
Mon, 15 Sep 2008 08:00:06 -0700
I want to highlight a column that has data in various cells and automatically
fill the blank cells down until new data is found at which point the new data
is automatically copied and filled down etc. I am using Excel 2003. How do I
do this?
--
kks ...
|
Can I use 'AND' in the macro statement?
Mon, 15 Sep 2008 07:46:14 -0700
I need the subsequent form to open taking into account the value of 2 fields
on the 'calling form' that the button the code is attached to is on. I've
written a 'WHERE' statement that looks like:
-"[Firstfield] ="& [Firstfield] $" AND [Secondfield] =" $[Secondfield]
(the Wizard gave me the first part but I h ...
|
Why macro runs on the same excel sheet?
Sat, 13 Sep 2008 00:00:00 -0700
I have recorded a macro, when i run it on other sheet, it runs on the same
sheet where it was created.
...
|
|
|
variable in a chart macro
Fri, 12 Sep 2008 20:51:00 -0700
Really new to this. Trying to get a do...loop to create a chart that shows
increasing data points with each pass. (Excel 2000)
How do I get the variable row to make sense in the charting
statement
ActiveChart.SeriesCollection(1).XValues = "=result!R159C51:R&row&C51"
so that with each loop th ...
|
Select - Highlight Record
Fri, 12 Sep 2008 07:44:04 -0700
I'm trying to copy data from Excel to Access via an Excel Macro. My plan is
to place the data on the clip board and open an Access form (datasheet
view(data-entry only)). I get this part accomplished, but I need to
highlight the entire row in the Access form before pasting. Is there a
command that will hi ...
|
Create Command Button Wizard
Thu, 11 Sep 2008 15:47:22 -0400
Hi.
When I try to create a command button in my Access 2007 wizard doesn't
starts.
The SendBoxMode Value Data set to 3 in the registry. I upgraded my Access
2007 from 2003.
What should be done for starting a wizard when I create a Command button?
Thank you in advance,
Sasha
...
|
