Search Result

why is
not an integer constant expression?

I have a wpf project in microsoft expression blend 4, and i need to pause the storyboard at a especific time, and resume it later. without any user control button or something like that =)

I have a query set up with a list of records with check box fields, Text boxes and one text field with numbers.

I used this expression to get the sum total of [Text box with numbers] per total records by counting [Text Box A]

=Sum([Text Box with numbers])/Count([Text Box A])

80/21=3.81



Now I want the total of [Text box with numbers] per records with [Check Box A] checked....

I've made a textbox control (txtText) and added a custom state ("Error"). I tried using
This works the first time after the project is built. However, when i click inside the textbox, which gives it focus and switches to the "Focus" state, the above code does not work again even though it returns true. What could I be doing incorrectly?

Hello,

I am using MS Access 2003 and trying to set a textbox's ControlSource in VBA code.


this following works fine

Task.ControlSou rce = "[ActivityQuery_C rosstab].[Task]"

However, if i try to set the control source using an expression like:

txtCost.Control Source = "[ActivityQuery_C rosstab]![Total] * [ActivityQuery_C rosstab]![CostOut]

...

Ok I have been customizing this DB for a long time. Basically it is an invoice form, so... I have the tax rates hard coded for calculation. My business is in three states, so I have three different tax rates. Here is my VBA code for this section.
...

Hello,

I am a novice Access developer and my boss asked me to build a database and I said yes. Now I realized the bite is way too big and I'm trying not to choke ;-)

And what's worse, he does not want me to use VBA (thank god, one less thing for me to tear my hair out about). So I am struggling to figure out how to do this:

Count the number of days between two dates and not count holidays and weekends.
...

I looked today for some link that explained what Regular Expressions were available for use in a SQL WHERE clause (using the Like operator), but was unable to find anything related.

I was able to find records where the Product_Code matched "P" & "L" or "P" & 4 numeric digits by specifying "P[LP][0-9][0-9][0-9][0-9]". This works perfectly, but I feel there ought to be a way of saying "[0-9]"...

Hi,

Here is my problem:

I have a report which lists Application numbers, Offer numbers and Firm Replies numbers for a subject i.e. Geography as 3 rows. My column headings also list subjects so you can see the Joint Honours combinations. As not all Subject combinations are possible there are many null fields. For example Geography with Geography. With a rather large IIf statement in a text box I can create a row total,...

Greetings all.

i am trying to write an expression in a query to return a library fine calculated from the due and return dates of a book. i have the expression below, which was working fine when i had [DueDate] instead of [CalcDate], but was also only showing a fine on one record.

Fine Due: 1+(([ReturnDate]-[CalcDate])*(0.01*[DollarValue]))

Any records which did not have a value in [ReturnDate] would...