Search results

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.

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...

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...

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...