Search:

I hope I am putting this in the right place since this covers off on both Outlook and Exel.

Here is the problem: I have an excel file for which every hour I am emailed an update for.

What I...

I have a database where I want to put in some VBA coding.


Basically I want to print a report - advance to the next record on the form - print the document - loop until all records are printed
...

That is the only part I really did not understand.. I was playing around with a if-then statment this weekend but I was messing up the first dlookup line.


also what is the differance between...

I am still a little lost.

I have a database being used by quite a few people. What I am wondering if it is possable is to set up a table with certian peoples NT login names. then set some of the forms so that only those NT...

Which high end vendor was this....The only reason they would be talking about Mfg dates is that little legal issue but all copied of office 2007 were pulled from the shelves and replaced so this...

True nothing can pervent you from pressing the button but you can disable the cmmand which comes from the button.

http://labnol.blogspot.com/2004/08/disable-print-screen-key-in-windows.html

Things just got more complicated as I have times exceeding the 24 Hr mark.... They are just showing a time because the date changed.... How can I get it to show

100:25:00
h:mm:ss

It depends on the suite you have. for example


2007 Office Home & Student


2. INSTALLATION AND USE RIGHTS. Before you use the software under a license, you must assign that license to a...

When you DL the file from DR. Did they give you the ability to pick if you wanted the 32 or 64 bit versions. The DL purchase from either DR or Microsoft Store is one or the other.. Both 32 and 64 are...

I hope this might be of some use to you all.

http://www.microsoft.com/student/office/en-us/default.aspx

This is for Office Pro Academic 2010 for $79.95 USD

But there is one drawback

You...

John,

Sometimes I have learned not to ask questions when something start to work... lol

John,

I think I solved the issue. I attacked the formula from the query insted of on the report and it worked great. I dont know why the report version did not function but it is working now.

Joe,

Just to let you know along with everbody else. 2007 is a discontinue line at the MS Store and is not available for purchase. Sorry

Thanks I noticed that just as I read your message....

as for the result..... I have tried that formula (the right one http://lounge.windowssecrets.com/public/style_emoticons/default/smile.gif )...

I have a report with the following fields

[signed on]
[personel]

both are formatted h:nn:ss

what I am trying to do is calc the percent of time which is spent in [personel] as it relates to...

There is no percent field. This is created in the pivot table.

I have a pivot table where I am trying to sort based on the Topbox Percent. I have tried the sort function but it sorts on the count not the percent column. I have attached so you can see what I am...

This is the way the information is tracked in other systems and as you can see from the query that the information is sometimes wrong comming in.

Security Essentials is just echoing a Windows Update error code. There’s an Online Help article that explains this in “Top support topics” (Error “0x8*******” encountered while virus and spyware...

That is where I get no choice. The main table will be holdingh a lot of records... the only good thing is that this function will only be used once a month or so... and only by me...

I am lost here...

I have attached what I am working on for you to see...

2 tables
[master data] - This is the table holding all the records
[agent] - this is the table I want to verify the...

I have created a query using the unmatched query wizard. The query works fine except that in the datasheet view of the query I can not modify any of the data. I am using this query to find all...

Sorry about that.



You are the man... worked like a charm.

but what is the differance between DCount and and sum(IIF

dont they sort of do the same thing?

I tried that but the it is only giving me the overall total in the query. I am trying to get it to count based on the groupings of the report.

I also Tried
...