Search results

Thanks for the reply. Problem is, these are not my spreadsheets and the company refuses to change sheet names etc. When you say "using automation from access", what do you mean? IMO

I'm using the following code to transfer a table to an existing excel spreadsheet DoCmd.TransferSpreadsheet acExport, 8, "Shipping Details", "H:\BIDataLoad\Supplier Orders.xls", True, "Shipping Details" The problem I'm having is, it creates a sheet called Shippiing_Details not Shipping...

Here's a great example from Candace L. Tripp IMO

Private Sub Report_Open(Cancel As Integer) If InputBox("Enter Password", "Password Required") <> "4062" Then MsgBox "Access denied" DoCmd.CancelEvent End If End Sub IMO

What sort of effects are you looking for? IMO

Thanks Pat, I thought as much. :) IMO

Oh well, it was worth a try :) IMO

Fuga, This code hides the Access Window and removes the DB from the TaskBar. You must have your forms set as PopUp = Yes and Modal = Yes. Option Compare Database Option Explicit Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const...

I knew I'd seen what you are looking for, and I've found it again. IMO

3rd Zip IMO

2nd Zip IMO

:o Helps if I post them!! IMO

Col, I don't know if this is what you're looking for. Written by Mark Davis. IMO

I have an Excel Spreadsheet linked to my DB and need to delete certain rows from within my DB, but I'm getting a 'Deleting data in linked tables is not supported by this ISAM' error. Is there a way to delete from the linked spreadsheet or am I going to have to restructure the DB to Import the...

You can put the code in the LostFocus event of the StartDate and EndDate controls aswell as the OnCurrent. IMO

Try this... Private Sub CmdEmail_Click() Dim EmailApp, NameSpace, EmailSend As Object Set EmailApp = CreateObject("Outlook.Application") Set NameSpace = EmailApp.getNameSpace("MAPI") Set EmailSend = EmailApp.CreateItem(0) EmailSend.To = "Email...

You're welcome IMO

You can place the same code in the Forms OnCurrent event and in the Subforms OnCurrent event, but, the Subforms Default View cannot be set to Datasheet or it will not work. IMO

You're welcome IMO

My second post should do the trick IMO