ASP.NET, SQL Server, WPF, C#, VB.NET

I have a placeholder  value that prints a row of text across the columns on 
 
every spreadsheet for each department.    I want to comment out the code so 
 
it deletes the row at the end of every sheet for ea dept without harming the 
 
procedure that prints an Excel repport.   I found 3 instances of 
 
[placeholder] in my procedure.   Here are the 3 references in order found. 
 
Can you tell me what lines to comment out or should I comment out all of the 
 
lines? 
 
The #3 macro is the one wh ...

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

I have creaded a command button to run the following to export my reports and 
 
save them each with a name in one of the fields.  It works but it comes up 
 
with an error at the end because it tries to go to the next record and one 
 
doesn't exist.  I need it to either stop at the last record or stop when the 
 
field is blank. 
 
DoCmd.RunCommand acCmdRecordsGoToFirst 
 
DoCmd.RunMacro "Macro4", 100 
 
The following is the setup of Macro4: 
 
OpenReport 
 
Report name:  Inventory 
 
View:  P ...

Lady only 24-Hrs +91 9810577227

How do I create a macro that will run a make table query?

I have a query with a field that has 118 different values. I need to 
 
filter by each of the 118 different values and export the results into 
 
separate excel workbooks. 
 
I would love a macro that does this...but I only have written macros 
 
for excel. 
 
Any ideas? 
 
Thanks! 
 
-Kim

I have a field that for a number of reasons needs to be entered as FirstName 
 
LastName in access. I have a second field which is the field that I use to 
 
sort. Is there a way to automatically take the first field data, convert to a 
 
lastname, firstname format, from which I can stick into that sort field. 
 
Usually, this would be quite easy with macros in excel, but I'm at a bit of 
 
a loss in access. Is this easily doable? 
 
Would appreciate any help, thanks ever so much!

Hi, 
 
I hope someone can help me, whit my problem. 
 
There is an number field (User ise typing a price). I need a macro to 
 
check if typed number is between 0-2000 or 2000-5000 or 5000-10000. 
 
If it is between 0-2000 then = typed price + 1000 
 
When 2000-5000 then = typed price + 1500 
 
When between 5000-10000 then = typed price + 2000 
 
Form 
 
......................................................................... 
 
(Examle) 
 
Typed price                  2200 
 
Price 2                        3700 
 
Thanx for any help.

I have some code that I want to use to "pause" my macro, and in the macro 
 
designer I see where I can set a RunCode to call a function, but where 
 
exactly do I put the code for the function so the macro can call it? 
 
the simplest of frustrations... :) 
 
- Amanda

I have a macro that calls a query that I need to update. The Edit Mode on the 
 
macro is set to 'Edit' but no changes can be made... would someone please 
 
advise what else I should check on ? Thanks!

Hi, 
 
Please Help 
 
I am working with an Access database that was developed using Office 97 and 
 
was converted to the 2002-2003 Access file format.  On this one form there 
 
are 26 text boxes (representing yearly pay periods) and on the “On Lost 
 
Focus” event for each text box the person who developed it set it to run a 
 
macro (that person is since long gone so I'm stuck with this now).  The macro 
 
simply calls a function to validate the data that was just entered in the 
 
text b ...

Using this RunApp command line to launch the medai file, I have created a 
 
macro to run a media file: 
 
"program files\windows media player\wmplayer.exe" 
 
"C:\Documents and Settings\harrimi2\My Documents\My Music\annoyingThing.mpg 
 
Using the same macro, how can I exit the medai player after the file has 
 
finished?

Dear all, 
 
By using TransferText Action running inside the macro, the text file will 
 
have text qualifiers like this: 
 
"7412","000000","000000000","7612","29000","100","100","0000","000000","00000",0.00,0.00,5246380.38,0.00,"","",0,"" 
 
Is it possible to elimiate those text qualifiers like this? 
 
7412,000000,000000000,7612,29000,100,100,0000,000000,00000,0.00,0.00,5246380.38,0.00,,,0.00, 
 
Thx for yr help!

I have set up a macro to grab a cell from Excel and store it in a table. It 
 
is the only value in that table. I now want to set up a macro that takes that 
 
value, and applies it to a filter. I have tried using the ApplyFilter macro, 
 
but have not been able to get it to function. I don't think I've been setting 
 
the "Where condition" properly, this is how I have it set up now: 
 
[assignshipment#]![Shipment #]=[importshipment#]![F1] 
 
assignshipment# is the query, Shipment # is the cloum ...

Hi 
 
I have lots of macros in a database and I would like to try to set a 
 
property in code rather than manually opening each one. Eg if the 
 
property 'Table name' of a macro step how do i set it thru code. Is it 
 
possible... 
 
For Each prp In 
 
CurrentDb.Containers("scripts").Documents("macro1").Properties("macro 
 
steps??")... 
 
Im lost here ? 
 
mike

I have a loop within a loop in a macro. It is working, however this causes an 
 
error if it loops more than the allowed 20 times.  I am not a coder, but may 
 
have to do this with code.  Can someone help with code?  Or maybe I am just 
 
doing this all wrong.  Need to run report for each monthly period for each of 
 
5 or more waste types. 
 
Parameter inputs on a form: 
 
FromDate = 1/1/06 
 
ToDate     = 3/30/07 
 
Set ProcessedDates for 1st month  (1/1/06 - 1/31/06) 
 
Count records in Wast ...

Hi I have typed this macro in my access database and didn't work. I just want 
 
to know how would I do if I get any nymbers or 0 value for the feild  avarage 
 
failed size. 
 
(([Average Win Size]/[Average Fail Size," "])*((([Winning Trades]/([Winning 
 
Trades]+[Failed Trades]))*100)/(100-(([Winning Trades]/([Winning 
 
Trades]+[Failed Trades]))*100))))

I have a macro which use several RunCommands with different command arguments 
 
Two of command arguments are disabled (greyed)-- OutputToText and 
 
OutputToExcel when running application. But, They are available in the debug 
 
mode. Is there any special permissions or settings required to run these 
 
commands? We noticed this issue starts to happen since we use InstallShield 
 
WindowInstaller project to install this application. 
 
-- 
 
Software Developer

Hi again :) 
 
Is it possible to create a macro that imports a file without VBA? What 
 
I specifically want it to do is to let a user specify what file he/she 
 
wants to import. From what I have noticed the macro "generator" forces 
 
you to have the path and file name predefined, is there anyway to 
 
bypass this and just let the user browse through and search for the 
 
file he/she wants to import instead? 
 
On a side note, the OutputTo action allows the user to specify the name 
 
and dire ...

A2003 
 
All my forms are maximised OnOpen - Dcmd.Maximise. 
 
I have a Menu Form (Auto resized and centered) which can be called up from 
 
the Toolbar. When the Menu is opened, it minimises all open froms. 
 
Any way to stop this and  leave the open forms maximised?

I have an template in my autocorrect. When I try to use the autocorrect in 
 
the template it does not work.

We use an OLE called DtPicker. 
 
It is always defaulting to Oct 18, 2005 (the start date of using Access). 
 
How can I make it default to todays date? 
 
-- 
 
A MACKENZIE, CMA, MBA

If I execute a Macro within another Macro will it return to the original 
 
macro once complete? 
 
Macro runs a Query, a macro, a Query, a Report. 
 
Thanks for your help? 
 
-- 
 
A MACKENZIE, CMA, MBA

There are few handful of us left but I'm trying to use the SendObject 
 
to send an email using non-MS email applications.  Anyone know where to 
 
start? 
 
JG 
 
--

Hi, 
 
I've created an AutoExec macro, that, eventhough I deleted the macro it 
 
still loads upon opening my Access project. Any ideas as to how to 
 
disable this "ghost macro" completely? 
 
Tom