Search results

Hi You may find the answer amongst this lot http://www.allaboutsymbian.com/archive/t-42665-p-2.html I had a similar issue - mainly down to the version of TT you use (according to this thread). Haven't fully tested my N70 as I continue to use my old 7610 (very reliable) for SatNav Good luck

I've put approximately 20 charts onto separate forms (all based on different queries). It's quick slick when I access each chart but it takes approximately 4 seconds for each of them to close which is infuriating. Any tips on speeding up this aspect of my database???

Yes it is Wayne

Further investigations reveal that with no current event code, this problems still occurs. Any ideas would be appreciated.

To shed more light on the problem, I can edit the combo by simply adding a number, click on another control and the combo contents will lose the digit that was added - and strangely the On Not In List event isn't triggered.

Thanks for the reply Rich. It does appear that the OnCurrent code prevents the NotInList event from firing consistently. However I need to get the contents of the combo to display everytime I scroll through the records - the OnCurrent requery is the easiest way to achieve this. Are there any...

I've got a casacading combo box with the following code (see below) as the NotInList procedure. The only problem is that it fails to fire on occasions. The only other code that I think may be contributing to the problem is a 'requery' of the same combo that has been inserted into the...

I've designed a report which contains 3 columns. On occasions there is not enough data to fill all 3 columns, leaving a column label at the top of the third column with no data below it. Looks unprofessional. Is it possible to hide the column label when the column doesn't contain any data...

Have a look at an 'AutoLookup query' in MS Access Help

Double check that you've used correct names for your subform and the field in your footer that you are attempting to total.

When you open a form based on an underlying query, Microsoft Access runs the underlying query for the form before it runs the Open macro or event procedure. Have you tried putting the code in the 'On Load Event' instead.

I have a main form with 1 subform. Relationships are set up between them with a ‘PurchaseOrderNumber’ (one side, an autonumber) as the parent field linked to the equivalent PONumbers on the subform (many side), the child. (RI is set between the tables with all cascades ticked). I want other...

Thanks mate - that's exactly what I did. Thought that it was a little long winded and perhaps there was an alternative method out there.

I’m struggling with the following cross tab query: ID Date Product Net Weight 1 1/11/05 Prod A 1000 2 1/11/05 Prod A 3000 3 2/11/05 Prod B 1500 4 2/11/05 Prod C 1200 Product Type is grouped according to the individual...

The date field is the primary field for the underlying table and I sort it so formatting in this way would mess up the table. I suppose I could always sort the query using a calculated value based on my date field but I'm struggling anyway to 'format' this syntax - further help would be...

I've possibly just discovered the problem - at the point where the date was 01/08/05 it returned the value for 08/01/05. I hope the solution is in the formatting of the date - any assistance would still be appreciated.

Hi I'm on the verge of successfully using a DLookup function (with the help of previous posts) in a query in order to obtain the value (volume1) of the previous record based on a primary field which happens to be a date (iddate). The following results in sporadic success: Expr1...

Thanks for the reply, but I've successfully created hyperlinks to other office documents. Why is there a problem with advancing a Powerpoint show when following such a link (I can view the first slide but then it doesn't progress the presentation.)

I'm attempting to run a Powerpoint presentation from a hyperlink in Microsoft Access. I've successfully created hyperlinks to other Office files but Powerpoint refuses to advance any slideshow when I link to it in this way. I used the following code which enables the user to select files from...

Sql Being new to SQL I'm struggling on where to put - strSql = "Select * from tblFileLocations where username='" & environ("username") & "'" I've attempted to insert it into a query (SQL view) but with no success.