I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter some problem as stated
beside the code as follows:
'Calculate the average value of a given value.
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim varBookmark As Variant
Dim numAve, numDaysAvg As Double
Dim intA, intB, lngCount As Integer
Set db = CurrentDb
Set rst = db.OpenRecordset("SGX Individual Historical", dbOpenTable)
Do While Not rst.EOF
intA = 1
intB = 0
varBookmark = rst.Bookmark
n...open two different Access reports
I was wondering if i can get some help here. I have two different reports
that i want to open when a user clicks a button to view the reports for
printing. Is there any way of popping them up at the same time in VBA?
Thank you in advance
>I was wondering if i can get some help here. I have two different reports
>that i want to open when a user clicks a button to view the reports for
>printing. Is there any way of popping them up at the same time in VBA?
>Thank you in advance
Yes. Call the DoCmd.OpenReport command twic...Sort by Credit Card Type on EDC Detail Report
What do I have to do to get my EDC Detail Report to show different credit
card types, like Visa, MC or Amex. Now under Tender Type, it just shows
Credit card...well...I kinda knew that. How do I fix it?
add tender types for each credit card type rather than just "credit card".
then z out. all transactions after this change will reflect what you want in
"tl" <firstname.lastname@example.org> wrote in message
> What do I have to do to get my EDC Detail Report to show different credit
>...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...IsOutLookClient() returns wrong value
IsOutLookClient() returns wrong value when both web client of crm and outlook
client are running on the same workstation
It looks like the same cookie(used for determining what client is running)
is used by the sessions of each client.
Look for "LightClient" in IsOutlookWorkstationClient() in global.js
Oeps...I seem to have made a wrong assumption...
Between the to clients IsOutlookClient() seems to work ok...
But in outlook client the IsOutlookClient() function gives false for
me...after I have opened a page from the Microsoft Crm folder structure...
On another workstation it...Outlook 2007 Search always returns no matches
Any search I do in Outlook 2007's new search box returns no matches.
I watched the Indexing Status as it progressed, and now it says "Outlook has
finished indexing all of your items"
But, searching on anything, even the word "The" or "a" returns no results.
I'm searching all Outlook items. I'm on an Exchange Server via VPN.
Anyone have any suggestions?
I uninstalled Office and re-installed and the problem went away...
"Tom" <email@example.com> wrote in message
> Any search I do i...custom field for projects with tasks past due
I am wondering how/what formula would be needed for creating a custom field
at the project level to show when a project has at least one task that is
past due. I have a custom field at the task level (IIf([Finish]<[Current
Date] And [% Complete]<100,1,2)) that will show when an individual task is
overdue, but I want to add a custom field to the Project Center > Summary
view to show when a project has any overdue tasks. The PM can then drill
down from there into the project and see exactly what tasks are overdue.
Once I figure out the formula for this I want to assign ...changing values of one field based on another
How can I best change the values of one field in a table based on
values of another field of the same table. We have an existing table
of thousands of entries and I would like to use the following logic to
populate a new boolean field.
If field1 = "Done" Then BooleanFieldCompleted = True
I have some Excel VBA experience but limited Access. I dont want to
do this manually! Any assistance appreciated.
In general, you'd use an Update query. However, in this case I don't see why
you'd need such a field.
Why not just create a query with a computed field that returns True...Publisher 2007 frequently crashes
I'm having some difficulty with Publisher 2007. Whenever I try to open a
particular file, the program crashes. I get no error message, except that
Publisher needs to close. I've run Office Diagnostics (twice), with no
results. I can open other Publisher files. The file that I am trying to open
is an internal website for the company I work for. This file began acting
strangely a couple of weeks ago - it wouldn't insert a duplicate page for a
while, but I found a workaround, so I didn't worry about it. However, now I
think that it may be a part of a larger probl...Add PowerPoint 2007 to Office Basic
I have Office Basic installed on my laptop and need to add PowerPoint. What
is the most recommended, easiest and least expensive way to do this?
...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...Archiving Projects in Project Accounting
Has anyone found a way to archive closed projects?
...running reports from MS CRM prompt for username and password
When running a report from Microsoft CRM client it prompts for username and
password. When given it's runs the report correct
question: if MS CRM 3 is configured correctly is it normal that when trying
to generate a report in MS CRM prompt for username and password?
No, ideally it should pass the users AD credentials to the reporting IIS
server (single sign on). If you were to close the browser and run a different
report does it still prompt for credentials?
I've noticed this does also depend on the hostname. For instance if the
reporting server uses a differe...Input to custom reports
I'd like to be able to input values to a custom report like the Year. Is
there any way to package a custom report and provide input to it? Every year
the user has to go into the custom report and change the Year restriction.
Alternatively, (this is a payroll report), is there any global variable or
some other back door that I can use to get the current year in a custom
report? Given the report writer may not be the ticket what would the
recommendation be to create custom reports that require input? VB.NET?
Using VBA you can allow for input in the custom reports. B...Outlook 2007 Calendar -> Outlook 2003
In the past I could forward appointments and birthdays from one PC to
another, if both PC's had Office 2003. I just tried forwarding a birthday
from Outlook 2007 to Outlook 2003 and it doesn't work. I get the email in
2003. Open it, open the calendar item, then click on Save & Close. No
error message. But it's not there. Neither in the current month or for
next year. I forwarded it as a reoccurring item, that's the only way it
will let you do that.
Has anyone else been able to do this?
Or, is this a backward compatibility issue?
It's odd.... this works fine for...compact database in VBA access 2007
I have recently upgrade to office 2007 from office 2003. To compact a
database from within the database itself, I used the follwing code.
Unfortunately it no longer works in access 2007. Is there some similar code
that will work?
Public Function FncCompactTheCurrentDB()
CommandBars("Menu Bar"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
On Thu, 28 Jan 2010 17:34:01 -0800, SL <SL@discussions.microsoft....MFC project with my classes
I have got a project that uses MFC. I want to expand the functionality
of the project by adding a few of my own classes to it. But I don't
know where should I create objects of my new classes so that I can
access them, I know the WinMain function resides in CWinApp class and
my project has a class inherited from the CWinApp class, but where
should I define my own objects I can't figure it our. Can anybody help?
> I have got a project that uses MFC. I want to expand the functionality
> of the project by adding a few of my own classes to it. But I don't
> kno...Report to show Item Class Distribution Amounts
We would like to create a report, using Crystal Reports, that would show the
following: dollar amount break down of the Sales Distribution accounts (COGS
and Sales) per item class based on a date range. What is the most accurate
way of going about this? We could only think of this method: (in short) sum
the Ext Price based on SOP30300.CSLSINDX and SLSINDX and hope it matches the
SOP10102 summed distribution amounts. Any advice would be appreciated.
Thanks in advance.
With the SLSINDX you would use the Extended Price and the CSLSINDX you would
use Extended Cost. You would probably ...Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and
when we try to create a text box in a document, (both an existing document
and a blank document), publisher crashes. Office is fully patched.
I ran Office Diagnostics from the help menu and no problems were found and
the issue persists. Any thoughts on how to resolve the issue?
See if selecting a different printer as default helps.
How to view error signatures if an Office program experiences a serious error
Mary Sauer MSFT MVP
http://of...How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the
values of all changed cells to the original saved ones.
Any help would be appreciated.
this would require quite some VBA code as you somehow have to store the
original values for example on a separate hidden sheet
"Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im
> I want to add a reset button to an excel spreadsheet that will
> values of all ...How do I convert a concatenated value into a know value
I am trying to get the results of a multiple input table, which get
concatenated, read out as usable values
eg. If the concatenated values are for example *llbbt* , I need this t
be read as Simon, or *lbttd* must result in Fred etc...
I will attact the spreadsheet.
Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54116
Message posted from http://www.ExcelForum.com
You are probably better off by describing your problem, most regulars won't
Peo Sjoblo...MS Access 2007 code not running
I have created a brand new database in Access 2007 and linked some VB
code to run on Form_Load. This code worked perfect with no problems
the day I created it. Now today I opened the same form and it is not
running the Form_Load code anymore (and yes it is still there, I did
not delete it). I got frustrated so I copied and pasted the code to
Form_Current and several On_Change events and set breakpoints at the
beginning of all the events just to see if it was the Form_Load that
was not triggering, but NO events are triggering my VB code. Any
See this page:
http://accessjunkie.com/fa...isinteg reports configuring tstmgr failed : ecBadVersion
we have lost our mail after NAV did it's worst.
have performed eseutil /p and /d as suggested elsewhere
now get error from isinteg
Update - have now sorted this thanks
...Value is BLANK
In a form i'm working on i've asked this question before and i'm unable to
locate the replies, but in one cell I have a date to be enter and in the
other cell it takes that date and add 5 days to the date to give me a due
date. But if no date is enter then I want to to remain blank insted giving me
Say that the date is to be entered into A1, then enter this formula into the
Please keep all correspondence within the Group, so all may benefit!
==================...Null value in form not trapped by beforeupdate event
I have a form in Access 2003 linked to a SQL Server 2005 table. When
I clear the value in a textbox (bound field is varchar and is
required), I want the before update event to run to tell the user the
value cannot be null.
When I press the tab button to move to the next field after clearing
the texbox, the before update event is not triggering and instead I'm
getting the following error:
You tried to assign the Null value to a variable that is not a Variant
data type. (Error 3162)
How can I prevent nulls before and this error from triggering?