Search results

If you have set the tab order correctly then it should be the first field. Check that the order is correct. In design mode select the view menu and you will see tab order. Chech that the order is correct. Failing that then you can use me.fieldname.setfocus But you shouldn't need to. Steve

I am using access 97 and am having a minor problem with a list box. I have a multi select list box that as each item is selected places that into a text box. This is only there to allow the user to input the data without typing. I am using the following code: Private Sub lst1_AfterUpdate()...

Do a search in this forum for cascading combo boxes. There are plenty of examples.

can u use Me.txtdiff = DateDiff("d", [Date Entered], [Deadline]) would give you number of days... you can use "y" for years ... etc

Set the format of the date field to dd/mm/yyyy And set the input mask to something like 99\->L<LL\-0000;0;_ that should do what you want Steve:D

Thanks for your help I have set it up to grab the valuses from a table and bind the values in a hidden column ... does the job and is probably the best way of doing it ... Thanks for all your help ... think it was a monday morning mental block not thinking of doing it that way. Cheers Steve:D

the values are coming from a frame ... 1-5 they have no relevance to the combo box as such ... just wanted to know if there is a way of selecting an option button in the frame and displaying and equivalent text in the combo box ... Think that it is looking increasingly likley that i will have...

No .. just a single bound column no others ... If it helps the combo box is a Value List

Think this may be me going daft but: I have a combo box already set up and i want it to update to a name in that list when one of the option buttons in the frame has been clicked. I tried to link it throught the value's but it just throws a number into the combo box and not the word in...

It is to do with the primary key field of the grades table ... When you type data in through form 1 you do not assign a value to the field in grades ... think it is the referential integrity problem. Had a quick look and have just swapped around the autonumber field to make that your primary...

Query Problem?? Not sure if it the cause of your dilemma because you havn't told us where the error is occuring but... Your form1 is base on a query but the query does not link the fields so you get the wrong grades for the students ... Each student has 10 different grades. Also if you input...

Try Dcount Not sure I get it correctly but it seems to me that you are just wanting to do a count to see if the Job Code Exists. You could try something like. If DCount("[JobCode]", "tblJobCodeInformation", "[JobCode] = [Forms]![frmShortageTicket]![txtJobCode]") Then ' Job code exists...

Have you tried If me.sfrmBreakdown.Form.Dirty Then instead of If Forms!frmtimecard!sfrmBreakdown.Dirty Then That seems to work for me. Steve

You could try Make a button called cmdClaerAll and use Private Sub cmdclearall_Click() Dim c As Control ' Enumerate Controls collection. For Each c In Me.Controls Select Case c.ControlType Case acTextBox c.Value = Null Case acOptionGroup...

Strange I have just tried it .... Just created a text box and set the format to scientific also set the decimal places to auto. Seems to work fine May be that if they are bound to a field in a table you have not set that correctly.... If they are unbound i am not sure.

I have a bit of a problem combining a dcount ... I have =DCount("[Ethnic group]","[qryDOH]","[Gender] = 'Male' and [Ethnic group] = 'Black'") but i want the selection bit to include something like ... "([Gender] = 'Male') AND ([Ethnic group] = 'Black' OR [Ethnic group] = 'Asian')" Hope...

(trainees attended divided by all trainees) * 100 Not really relevent to access really tho.

thank you rich .. new it would be easy.

Sure that it is easy but. I have a piece of code to apply a filter but i can't seem to find a way to remove the filter afterwards without exiting the form or using the records menu at the top. Is there a piece of code that i can use to remove the filter. Thank you Steve

Sorry .. The border style that can be set to transparent is on the main form that holds the sub form. Basically have a look at the main form and then at the properties of the sub form container.