Search results for query: *

Hi Tony, As I said, the 24 hours was the problem. Once again thanks. Barbara

Hi scriverb, My Hours and Minutes were stored as Short Time, but this didn't work and are now Integer which still doesn't work. In the table 1 hour looks like 100 but on screen look like 1:00 The table is called tblRecharges and the field is called RechargeTime. Thanks. Barbara

Hi TonyJollans, Sorry for the delay in responding, been on holiday. The 24 hours bit is what I've been trying to overcome. Thanks for trying anyway. B

Sorry Bill, Realised too late that that I didn't edit copying one of your suggestions. Honestly, not trying to take the credit for your great work. Barbara

Hi Michael Red, glad to see you back to normal today, posting good answers. Maybe you, FlexOLex and jmeadows7 might be interested in a method I posted earlier in the year at http://www.wpower.fsbusiness.co.uk/ The file to look at is AlternateRecordColour.zip Bill

Mr BillPower, What a great explanation, I've always found charts difficult in Access, but now! Thankyou so much. Babara

I've done a thorough search of this site looking for an example of how to add lieral time. I've seen examples of DateAdd and DateDiff but neither do what I want. I want to add time together. I am using Access 2000. For an example I would like the ability to add: 1hours 20 mins 2hours 20 mins...

Hi mpastore, You make it seem so easy. jommyjet, what's the problem with saying thanks to mpastore. Babs

Hi, I've just Upsized an Access 2000 DB using the Upsizing Wizard. Everything went well, with no problems converting, but when I open a Table, which I now assume is in an MSDE Database, I can see all my existing Records, but can't Add or Delete Records. Has anyone any idea what I am doing...

Is someone with your skills really unemployed? Great posting!

Hi jsaliers, I've used your Idea and it works, Thanx, A * 4 U

Hello SBendBuckeye, Thanx for the above, didn't know AppendChunk/GetChunk existed, sorted out a problem I've been having. A * for U Barbara

No, access doesnt have this facility, you will have to write your own code. Do you have any experience writing code? What version of access? Can you take a note of the Driver, DSN, Server etc that you connect to when doing this manually and post that info?

Hi We've a bit of an underspend in our IT budget at work, I just wondered if anyone could let me know if i went out and bought Acc2002 to replace Acc2000, how would i the programmer and the company benefit and why? It would be great to hear some user's opinions, rather than Microsoft's. The...