Recent content by Zigzag

With so many different version releases since building my application on Access 2003 and the incompatibility of my application with Access 2013 and Microsoft dropping support in April 2014. I’m considering investing in Sage key. From what little information I’ve managed to find it will do a...

Hi All, Sometime within the last 6 months I stumbled across a nice chart/graph posted as an axample. It had a sliding pointer with all the bells and whistles (very professional) and if memory serves me correct it was related to power factor correction or something simlar. Does anyone...

Your welcome.

My approach (in simple terms) to this would be as follows... 1, When the room has been selected load an unbound object with the picture/image of the room. 2, Using the mouse move event capture the X,Y Position and compare it to pre set zones for different items around the room (you will need to...

Cheers vbaInet!

Access 2003 Developer Extensions can not be purchased as a stand alone piece of software. You need to purchase Visual Studio 2005 Tools for Office. You don't create dbs as runtime, your db does not change. Runtime is the same as normal Access just with no design options. You would need to...

Try checking it here....

For the relink code try this http://www.mvps.org/access/tables/tbl0009.htm dont miss this GetOpenFileName

Dave I dont have any evidence of this other than experience, but not locally!!! I usualy run and test on an external hard drive so I don't get a false impression of performance, so it might not apply to a local setup. I think it might fall into the same ethos as 'keep the BE name short' ...

In my experience placing FE and BE in the same folder tends to slow down the application. Keep the frontend and backend in seperate folders.

Are your mdb files created with A2003?

If memory serves me right!!! Access 2003 Developer Extensions can not be purchased as a stand alone piece of software. You need to purchase Visual Studio 2005 Tools for Office. A2007 runtime is free to distribute but I havent tested if it will run an A2003 DB?

You don't need to install Visual Studio 2005 to get Access 2003 Runtime but you do need to own it to distribute access runtime. Access runtime should be on one of the discs that came with Visual Studio 2005 Tools for Office called 'Access Developer Extensions 2003'. After installing it you...

Adding to what Dave has posted.... I would create a new table that holds 'assumed time zones' and link each employee to a time zone. If the clock time falls within the time zones it would asume it as a clock in or clock out accordingly and create the new table based on these rules.

My question would be 'How do you identify which record is clock in and which record is clock out? Until you can determine that its going no where.