Search results

Cheers!! You were right Milo... I did start prefixing my tbls, qrys rpts etc.. but not my txt or cbos. That will teach me! Thanks again. Mike

Still getting an error. It must be me going mad. All i want to do is insert a bit of code into an 'add new' command button so that it defaults to a specified field on the form. I have tried the following and neither of then work. Me.specifiedfield.SetFocus...

I have a quick question to extend on this..... What command would i need to SetFocus on a particular field once create new record command has been executed? Cheers

Classic!! This has made my day :D Someone please put this person out of their misery

Pat, cheers!! Thats what i'll do, i'll put team and dept into tblcallskills. Mike

I'm not very good at explaining but here goes. I have 2 main tables and 2 reference tables. 'tblmain' holds info on staff..EmployeeID is my pk. The info held is name, staff number, team name (drop down box) and department (drop down box), extension number etc..in this table i have 2 foreign...

I need to report on historical data that is stored on an access database. The reports are by team and by department. However if a member of staff in the interim has moved team/department how can i ensure that if i query historical data i retrieve the information as it was at that time before...

No worries mate.. Thanks for your help Mike;)

IMO For some reason it won't work. If i take out those two lines of code and leave in: me.mycontrolname = "" It still moves the focus to the next control in the tab order. :confused: :confused: :confused:

Dunno mate, i had to ask IMO coz i couldn't get the focus to reset on the same control without it moving to the next control on the tab order when i pressed 'ok' on error MsgBox?!?!?!?!?!? It works anyway. Mike

IMO This seams to work perfect... If Me.MyControlName = "0" Or Me.MyControlName = "20" Then Else MsgBox "Must be 0 or 20" Me.AnotherControlName.SetFocus Me.MyControlName.SetFocus Me.MyControlName = "" End If

IMO Almost! It's emptying the control no matter what is put in. Mike

IMO Works perfect thanx! What about emptying the data from the control on exit of the msgbox?? Is it possible?

IMO Sorry my last post was a bit vague, i'll explain. I have a control on a form that the only numbers that can be input in is 20 or 0. Therefore i need code which i presume will be an if statement like the one you have stated above that will create a msgbox "Number must be 20 or 0" and when...

IMO I'd like to use this code also however. when i press ok on the message box i can't get it to setfocus on the same control..it goes to the next control in the tab order. Cheers

Hello all... I have created a report based on a query. The query has a parameter included so that i can specify certain criteria. I also want to add a chart to the report based on the same query so that it gives a visual variation of the results. (Chart wizard). When i insert the chart it...