Search results for query: *

hello i have a report 1 one group. In this report i have an average total worked out fine. Here comes the beep.... I need 2 display the average total for totals above £3500 and average total for totals below £3500. for example given the following data:- 1000 2000 3000 4000 5000 6000 I...

what do you want help with, scheduling the queries to run or is the queries themselves? Please give more info and i will try to help?

I am using the below code to access extended information from a CDO person object. The code works fine, until i reach a user in the everybody group who's name in active directory is spelt differently to the displayname in the AD (which maps to the ADSI property fullname.) Is there another way...

THANKS FOR THE TIP, BUT I'VE BEEN TRAWLING ALL THE SITES FOR DAYS AND CAN'T FIND ANYTHING.

If you are using DAO, Sometimes the recordset gets in a mess and locks itself. So what i do is before I attempt to do an update. I send any errors to an update_err error_handler. on error goto err_Update_error Then in my error handler I call: DBEngine.Idle dbFreeLocks then i resume to the...

I am using the below code to access extended information from a CDO person object. The code works fine, until i reach a user in the everybody group who's name in active directory is spelt differently to the displayname in the AD (which maps to the ADSI property fullname.) Is there another way...

Hi i am trying to populate an ms Hflexgrid with a DAO recordset. for this project ADO is not an option, so therefore i can't make use of the Msdatashape provider. Having a lot of trouble trying to work out which props/methods to use. I know that if this is possible with DAO, i am going to...

Hi i am trying to populate an ms Hflexgrid with a DAO recordset. for this project ADO is not an option, so therefore i can't make use of the Msdatashape provider. Having a lot of trouble trying to work out which props/methods to use. I know that if this is possible with DAO, i am going to...

Hi i am trying to populate an ms Hflexgrid with a DAO recordset. for this project ADO is not an option, so therefore i can't make use of the Msdatashape provider. Having a lot of trouble trying to work out which props/methods to use. I know that if this is possible with DAO, i am going to...

compact the database. If it lets you. If not reboot the machine where the database is stored, then delete the .ldb file and try again.

As a quick fix you can create duplicate fields in the recordsource, and alias them with fieldname_2:[field]. you can then use these fields as bookmarks.

You need to loop through the ItemsSelected property which is a hidden collection of all the selected items. It is collection of variants. so therefore should be accessed like: dim varitem for each varitem in me.listbox.itemsSelected '***Here you should either run a delete query e.g...

use '&' not '+'

Every time they scan a new barcode use the dcount function return the count of records in the subset and also return the number of records that match the barcode. DCount() - you can read about it in the Access Help Files

you can simply put this code behind a delete button: if you are in Access 97: dbengine(0)(0).execute "Delete from tblbudgetcode where _ budgetcodeid=" & me.Listboxname.value if you are in Access 2000: Currentproject.connection.execute "Delete from tblbudgetcode where...

email me at wonderhands77@hotmail.com i've got an example you might like to see.

I know of a package called webferret which is recommended by a lot of top developers.

set the default value in the property palette to False

You can do it using bookmarks, i have written an access 2000 class module to allow you to do it quite simply. you can mail me at wonderhands77@hotmail.com. If you like.