Search results

Are you importing to a table that's already in your DB? If so, make sure all column Names in the spreadsheet are identical to those in the table and you shouldn't get extra columns. Just one other thing to check, make sure there is no 'duff' data in the spreadsheet by selecting all the last...

I think I may have misunderstood, do you mean "columns" or "rows" at the end of the data? IMO

Create a delete query with the condition 'IsNull' and run it after the import IMO

DoCmd.OpenForm "YourForm", acFormDS IMO

Put this code in the Double Click event of the field... Private Sub YourTextField_DblClick(Cancel As Integer) Dim X X = fHandleFile("mailto:" & Me!YourTextField, WIN_NORMAL) End Sub and change the 'YourTextField' to the Name of the field. Wouldn't it have been better to post...

Create a query that counts certain Values and use DLookup in the report, see my example Here IMO

I could do with a nice cold beer! LOL. Let me know how it turns out. IMO

Do you use OutLook? If yes, this code won't produce that annoying little msg Private Sub YourButton_Click() ' (Or On Open of your msgbox) Dim EmailApp, NameSpace, EmailSend As Object Set EmailApp = CreateObject("Outlook.Application") Set NameSpace =...

Just another thought, couldn't you get the message to send an email to the user? That way you'd end up with the email message box (OutLook), an email and your message box! They'd have trouble missing all three! IMO

I've tried it a couple of times and both the timer form and message popped up over the top of Excel when the countdown finished, maybe it depends on which Windows version is being used. Sorry it wasn't a great help, let me know if you succeed IMO

"Field Value Is" "Less Than" Date() IMO

Here you are, it's in A2K, let me know if you need 97. Just set the timer for 1 min and open another application. IMO

Try setting the reminder form properties to Pop Up = Yes and Modal = Yes and minimize the Access window in the On Open event... DoCmd.RunCommand acCmdAppMinimize MsgBox "BLAH" including a message box and restore it in the On Close event... DoCmd.RunCommand acCmdAppRestore this may do the...

Here you are. Don't forget to set a reference to Microsoft DAO 3.6 Object Library. IMO

To print each record on a separate page, set the ForceNewPage property of the detail section to After Section. IMO

Here Solutions9.mdb and Soltn90.hlp are the ones you need. IMO

I've no idea what it's like but you could try here http://www.accessreportwizard.com/arw/default.asp?CF=ARW IMO

Gald you like it, but we can't forget Mile as he coded the original, I just played about with his code. IMO

In design view goto the forms properties and select "On Open". From the Dropdown in the properties box select "Event Procedure". Now Click to the right of the dropdown to open the code window. Between the lines "Private Sub Form_Open(Cancel As Integer)" and "End Sub" type in code like this...

In the forms OnOpen event, have the fields invisible and in the AfterUpdate event of the ComboBox make them visible. IMO