Recent content by Marrick

This code is very handy for setting the default value for the next record... controlnameX.DefaultValue= """"controlnameX"""" But I have never understood why 4 sets of quotes are required on either side of the control name. Any enlightenment on this feature much appreciated

I have a series of popup forms opening from a switchboard which almost completely disappear sometimes when opened- all you see is the forms close button.As this has never happened in earlier versions of Access I must be overlooking a property? This is an Access 03 database running in Access 07.I...

Thankyou very much for your time and help - problem solved

Object Variable not set...... Thankyou for your response.The code below works fine the first time round, but fails with the above error thereafter Private Sub Combo0_AfterUpdate() Dim strMyPath As String Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlWkSht As...

When running Excel macros from Access for the second time I get the error ' Object variable not set...' The code breaks on the tagged line : .Application.ActiveCell.Offset(-2, -3).Range("a1:c1").Select **** .Range(Selection, Selection.End(xlUp)).Select****...

Bulk Email Access to Outlook Thankyou for the response - no joy with recommended website,however have found some code which I will share when I have sorted out a problem with an undelying parameter query

Would be very grateful for some guidance as to how you would use the SendObject command (if possible) to email more than one address from Access to Outlook. Thanks in advance...

What I thought was a small problem has become a real irritation! I have a deep tab control in the detail section of a a form containing a large number of fields.There is no way the tab control can be made smaller. The form - header section above contains all the search combos and navigation...

I would be very grateful for some help The following code actually works,it prompts the user of an Access runtime App to enter the path to an XL workbook Function mcrtoKo On Error Resume Next Dim REF As String REF = InputBox("Enter full path") DoCmd.TransferSpreadsheet _...