Recent content by sozzer

This has baffled me for months now IE9 on Vista is missing "Use software rendering instead of GPU rendering" in Internet options > Advanced. The Accelerated Graphics group is not there. The pc supports gpu rendering (hd3450) - and it works - and I can change the behaviour via the registry, so...

Thank you - so simple! A

Hi all This might be a contender for the VBScript forum, but it's Access related so thought i'd try here! One of my colleagues has been kind enough to pass me the below code, which stops Access 2003 JET4 SP8 warning messages popping up when launching an mdb. (fantastic piece of script!) It...

Cheers guys! That deserves a couple of stars...

I'm in the process of building an application that will allow people to record time spent doing tasks on, and then allow us to automatically generate reports against forecast etc. Basically, about 45 users in different locations are likely to have the db open all day, all of whom will have a...

Why not just store the entries in a table and use ORDER BY to sort?

cos you're in a 'mode' where you can create records and access creates a record ready for you so can always see a 'blank record'. Check it out in a table.

For what I'm trying to do on a whole Excel is a better venue for me to use" You sure?

if you're not gonna change it much, i'll go with mintjulep's suggestion. If you want to make the xlt an xls at the same time, no probs...

To approach this from maybe a different angle, what OS are you running?

Are you using the subform name or the subform control name? You need to use the control name.

Me.calControl.Value = Date works for me but i am using v11. A

Doh! Simple but effective. Have a star for pointing out the obvious to me!

Not sure you're refrring to your form correctly. See this link which may help: http://www.mvps.org/access/forms/frm0031.htm

In the After Update property of the each combo box, do this (example is cbo1 setting rowsource of cbo2) Dim strSQL as string strSQL = "SELECT tblExample.* FROM tblExample WHERE tblExample.fldExample = '" & me.cbo1.value & "'" Me.cbo2.RowSource = strSQL Of course, this uses multiple queries but...