Search results

Hmmm, Thats a good question... I'll just have a wack at it. If it were me I would probably keep track of what control has the focus in variable and when the button is hit set focus to the last one that had the focus and run your code on it... At the top put Public SelectedControl As String...

No it isn't Well, installed Access 2K at home and found that it is not available....

Docmd does not work for a remote form I dont think... I would put the code back into formA in a Public Sub and then call it from formB like On FormA Public Sub MyFunction() 'Do your code here that does what you want End Sub On FormB On a Push button or whatever [Forms]![formA].MyFunction

If you test the field from a recordset IsNull(rs("MyField")) Is it not different when the variable is a string - If varMyField = ""

More than likely its because I forgot the hard coded Quotes StrSQL3 = "Select * From EnrollmentInformationTable WHERE EnrollmentInformationTable.EmployeeSSN = " & chr(34) & [Forms]![updateform]![temp] & chr(34) & " AND EnrollmentInformationTable.EmployeeLastName = " & chr(34) &...

Not sure if that is clear or not - Can someone please tell me if Printer.Orientation is available in Access 2000 ?

Should be.... StrSQL3 = "Select * From EnrollmentInformationTable WHERE EnrollmentInformationTable.EmployeeSSN = " & [forms]![updateform]![temp] & " AND EnrollmentInformationTable.EmployeeLastName = " & [forms]![updateform]![name]

Well ran into a ? - Form.Printer.Orientation - works in Office 2003 but not in 2000 Dim vFM as New Form Set vFM = New [MyForm] vFM.RecordSource = SelectSQL vFM.Visible = True DoCmd.Maximize vFM.Printer.Orientation = acPRORLandscape ',<<Is this available in...

Good eye. I should have seen that...

Whats the error you get? It might be that your import sepcification is now gone. Post back with more details.

Revisions Made and sent....

If you are meaning a field's value from the selected record you could bound the control to that field. Click on the control and hit properties and then go to the "Data" tab. Is that what you are looking for?

At least no-one goes un-answered.... cpuSmoker

Usually get that error when you are missing a reference. Search the forums for "Missing Reference"

DB is finished - I emailed it to ya!

Yeah I am aware of the flaws in the code I wrote. I deffinately like your way better. Just wasnt sure of how to use it. Like if there was an extra space somewhere mine would throw the rest of the charactor set off and return it as being different. Thanks man!!!

Is step 3 a standard DOS function? If so how do you use it? I would have created 3 varibles and looped through the charactors one at a time writing the different ones to the 3rd variable. Something like this (THIS IS JUST ROUGH NOT TESTED~!!) Call it with MsgBox...

just a guess not 100% on this DoCmd.GoToRecord acActiveDataObject, , acNext have you tried taking "acActiveDataObject" out of it DoCmd.GoToRecord , , acNext

Need to talk with you 1st. Give me a call at uhhh (I'll Email it to ya!)

email sent