Recent content by Vespertin

Thanks for the response - combo is not the way forward - actually the default value is text...so a text field is more appropriate to use. So on a datasheet form I have a record where text field [status] is "On Loan" when the user starts a new record the default value of [status] will then...

Hello Is it possible to create a combo for a datasheet form that displays a specific value based on the value of the last record. For example - instead of having the combo display the values 01, 02, 03, 04, 05 the combo will only display 02, if the last record was the value 01. likewise if...

hello all, I got an unbound textbox and I'm trying to make the default value based on a bound column of a combo control. The syntax I'm using is =[Description.Column (2)] in the default value property of the text box but I keep getting Name? error. Can anyone help where I'm going wrong...

hello can anyone advice the best way for a form to refresh automatically say every 5 minutes when the form is open? Thanks for any advice you can give.

Plog That worked perfectly, thanks for your help, really appreciated.

Hi, in a standard query I know you can order results by ascending and descending A-Z but in my query there is a field [category] which always has one of 3 values, "Ordered", "Saved", "Bought". Can I order them exactly as below? "Ordered" "Saved" "Bought" Is it possible to customise the Order...

Thanks paul - appreciate your help. I understand the update event of each control and the forms current event - but I can call all 3 from a form level function - could you explain that a bit more? Its just another area for me to research.

hello everyone can anyone advice on syntax for an If Statement. I have a button on my form, to enable the button the user has to select a date in [txtBegDate] and click a tickbox [TickConfBox] when both these things are done, the button will be enabled? Thanks for any help anyone can...

Hello I have a query, what I'm trying to do is have the query order peoples names, so that when I run a query, all records of lee are followed by all records by john, than maria etc.....I know I can A-Z after I run the query but is there a way of doing it in design view? Using Access 2007...

thanks that did the trick!

Hello, I have a continuous subform (usersub) on my mainform (frmMenu) with a command button - i'm trying to set the link criteria on the button to open another form (frmtasks) based on the (studentname) field in my subform and (studentname) in (frmtask). both fields are text and there is only...