Search results

Which means that the contract expires on 25 Jul 06, not on 31 Jul 06... PS Next time, post your thread in the appropiate forum. RV

Aleksandra, whether or not you use an API (assuming there is one), you'll still need to understand VBA code and how to adapt / implement / rewrite it to your application. You'll have to sort that out yourself. There are no simple examples neither can you easily implement any samples within 5...

Have a look at: http://www.lebans.com/customscrollbar.htm RV

BG, have a look at the Orders form in the NorthWind sample database. Should help you to get started. RV

FIRST QUESTION Try this: SELECT Indices.Month, Sum(IIf(Indices![SP 500 Index]>=0,1,0)) AS BullDJWA FROM ( SELECT Indices.Month, Sum(Abs(Bull_DJWA!BullDJWA-1)) AS BearDJWA FROM Bull_DJWA ) GROUP BY Indices.Month; SECOND QUESTION That's because you didn't join your tables in your query...

See sample. I suggest you read up a bit more on Access, events and VBA ;) RV

Base your report on a query. Use the Format function in your query to format your date. RV

Have a look at the TransferSpreadsheet and the TransferText Methods in Access Help. RV

The article you found actually does not apply to your problem. The article applies to instances where you use Automation. It also only applies to Access 97 and below. I'd say that your script bypasses your switchboard hence the code in your event hence your window will not be hidden. Can't...

What you need is a bit of VBA code. I've included a quick and dirty sample that should help you getting strated. You'll need to sort out a cleansing routine (remove all empty Visit rows after month has ended) yourself. RV

James, please do not double post: http://www.access-programmers.co.uk/forums/showthread.php?t=110586 You've been supplied by a couple of links that should get you started ;) RV

An INSERT statement, either in VBA or in a static query, will do just fine. Include a condition so only those records on your form having the check box ticked will be included in yout statement. RV

Not necessarily, no. RV

Create a "Tax" table with your Tax Rates, ValidFrom Date plus ValidToDate. Change your unbound tax field into a bound field, based on a list box. Set up your list box so that it only shows "valid" taxes. Valid as in taxes whereas the ValidToDate is null. You'd have to add a "Tax" column to the...

JC, it could be that you're restricted to manipulate your data structure. You better liaise with your IT department. As for llkhoutx's remark, you should not manipulate your data structure other then directly from within SQL Server (or whatever database is used). RV

Close :) Correct syntax is Iff (InStr(columnname, " ") = 0, columnname, Left(columnname, Instr(columnname, " ")-1)) RV

Use a combination of the Left and the InStr function: Left(columnname, Instr(columnname, " ")-1) RV

It doesn't. Your first condition is also met within your second condition. If you want to search on a specific Equipment Type, you do need to do an exact search using your first condition. If you would like to be able to search on Equipment Type using wildcards, you could put a check box on...

You can't use HasData the way you try to.... According to Access Help: I'm not quite sure what you're after but seems that you're trying to return a sum of 0 (zero) if your subreport doesn't return any values for your month column. What you need to do is to base your reports on queries. Use...

You need to pass link criteria, similar to what you did in the On Clivk event of your Add Insurance button (which, by the way, you don't need ;) RV