Recent content by martinjward

Thank you for your suggestion, how does this work when I have a split database?

I have a process that will information into a recordset, to open the recordset naturally I need to get a handle on the current database. I an attempting to create a sub that does nothing but get an handle on the current database so that if I need to make changes (i.e. split the database) I...

DugTrain Go onto IBM developerworks & serach out resources using the COM programming language. I have a Access & Excel routines that uses COM to extract & process data in collabaration with VBA

My intention is to have the access DB running all of the time, so an example would be appreciated. Thanks in advance.

Hi I have a database that has a process that I wish to run every two hours, between the hours of 7am and 7pm. Does anyone have any pointers as to how I can do this? I am using Access 2007 on Win XP.

Is there anyway to / can anyone give me some pointers how to run process data on a interval (native within Access):confused: What I really want to do is create a module that call a couple of functions to be run every two hours between the hours of 7am and 7pm.

I have a HTC TyTN II (also known as a Kaiser and has other names depending on your mible network) - this is phone / PDA running Windows Mobile 6. You can record voice on it, watch films / listen to music as it has mobile windows media player. It also has pocket Word, Excel & Powerpoint (ideal...

I am calling a macro from a ribbon using XML. The macro calls a function to run however I keep getting the following error... 'Return without GoSub' and then a message pops up (see attached image) I have put debugger on the first line of the function, but it never gets there -therfore it...

I am trying to get a feel for how Access 2007 performs regarding the ammount of concurrent users using a database. I know there has been a lot of differing opinions about previous version and was wonder is the new version of Access (& I would guess Jet as well) is more stable with multiple users?

I am OK with that bit - what I am strugling with is updating the flag on the child records, based on the status of the parent record. To clarify,, If update the status of the parenet to record to (for example) complete, I wish to set the flag on the children to True (so not allow edits) so...

The flag is just a Yes / No field which will be refenced in the Current event of the form. If the flag is Tue then AllowEdits = False (i.e. lock record flag is true, do not allow edits).

I am creating an audit database where I have an Audit header record (parent) and multiple tests against the the header (child records) all linked to the audit header by a Primary Key, the Audit Number of the header. I wish to be able to prevent editing the tests by setting a flag on each test...

As you can see from below I have done that (using a find & replace, but still get the same prolem! Public Sub DayDifference(dtestartdate As Date, dteenddate As Date) Dim tmpdate As Date Dim dcount As Integer Dim datediffs As Integer Dim dcounts As Integer Dim finals As Integer Dim finaldays...

Yep, the variable is Daycount - the only place 'Dcount' apperas is in the notation, not in the actual code.

I am trying to write a subroutine (which resides in a module) to calculate the number of days, hours and minuites between to date times (I have searched forums and only found working days calculations , no working hours). I am trying to discount bank hols and weekends and this is what I can up...