Search results

When I try this I get error Method 'Quit of object'_Application failed. My code is quite long, I'll try and chop it down and post.

I tried that and got error.. Method 'Close of object'_Workbook' failed

Hi All, On the click of a button on an Access form I create an Excel spreadsheet and write records to different tabs. This works fine if I don't touch Excel while it's running. If I close the excel sheet being created while it's running, if I try and click the button on the Access form to...

Worked a treat! Thanks :D

Yeah I replaced Private with Public and I still get the error. Public Sub txtProjectName_Exit(Cancel As Integer) .. .. End Sub This is where I try and call the method.. Select Case Forms!frm_mainform!frm_search.Form.Frame0 Case 4 txtProjectName_Exit End Select

Hi All, I was wondering if you can call a textboxes onExit event from another form? On my form a user enters a search criteria into a text box and when they exit the textbox the results are displayed in a listbox. This form is a subform on my main form. I want to be able to call this onExit...

Galaxiom, I'm getting a little confused, I'm still pretty new to this. What do you mean about the AddDentist method not referring to the form? I was trying to call the AddDentist method when a button was clicked on the form. Is this not a good way to do it? I don't pass arguments to the...

That's it working :D Thanks!!!!!!

I was originally going to do that but my function AddDentist returns a value, the ID of the dentist in the sql server table. So I had... MainForm (Form).. Private Sub btn_Save_Click() Dim intDenID As Integer RecordDentistDetails intDenID = Dentist.AddDentist End Sub Dentist (Module)...

Thanks for your posts. Galaxiom...Yip it is a public function in class cDentists Public Function AddDentist() As Integer pr2-eugin...when i type 'dentist.' in the Dentist module I get the list of methods and properties I created in cDentist (AddDentist, name, address, dob etc) but when I do...

Hi All, I've been playing around with creating my own class in VBA but I'm having problems calling its methods. My class is pretty basic, its called cDentist and the properties are just Name, Address, DOB etc and one method AddDentist. AddDentist will add the details to a sql server table...