Search results

One interesting observation... DoCmd.OutputTo acOutputTable doesn't come up with the message that is annoying us, which must mean that it isn't necessarily a windows dialogue and is probably associated specifically with the Reports themselves. I have asked an Access Guru (good mate) to take a...

Christine, I have some similar code that outputs over a hundred reports to successive recipients (winzipping and password protecting before attaching them to the email). I have looked at suppressing this cancel box too. It is a windows message and doesn't appear to be associated with Access...

Silly suggestion... because I don't really know... but are you using an older version of Access than the version that created the mdb files? Secondly, and just an observation... I would never let my databases get to 1 gig in the first place... your buddy should compact more often. Finally...

Thanks very much for the reply Mikeflyer. As it goes, my Access guru has replied to a personal email, and it was a lot easier than I thought. Normally I would use a lot of code like the following: pathname = "c:\temp\ViewClientFile.bat" checkexist (pathname) 'calls a separate function to...

No one got the skills huh?!

Folks, I have a file transfer form on my database which works well. Sometimes the files get transferred in the wrong format (ascii versus binary transfer methods) We can't ascertain which format will be correct in advance (sometimes a bigger file requires a different method). Currently the way...

Format(Date(),"mmmm")

Check it on its own. dim test as string test = [Forms]![frmMainEntry].Form!fctlReviewRequests!ReviewID msgbox test If it comes up with a numeric value, then the reference is ok.

I obviously can't check your form values, but think the syntax looks ok. Private Function PlanFilter() Dim strFilter1 As String, strFilter2 As String, strFilter3 As String, Dim gstrfilter As String Dim Temp1 As Integer, Temp2 As Integer Temp1 = 20 Temp2 = 30...

lagbolt, Nice one mate... like the simplicity... cheers!! :) J.

Just noticed... I should be thanking jrjr for the suggestion Cheers buddy!! J.

Resolution to this problem Hey folks, Just thought that I would post the fix to this problem in case someone experiences similar problems. Basically I had an NT profile that had got it's knickers in a twist. I asked my IT people to fully delete and recreate the profile and alakazam... my...

Gents/Ladies, I have created a database with an "on-open" function that creates a temporary directory and certain program files on the local drive of a users pc. This directory is used for FTP and archiving of sensitive customer data, so when the database is closed it runs code that deletes...

-- replace this "c:\temp\filename.xls" with your excel filename. Private Sub ImportXLSheets() Dim WrksheetName As String Dim i As Integer Dim xl As Object Set xl = CreateObject("Excel.Application") xl.Visible = True xl.Workbooks.Open "c:\temp\filename.xls" With xl .Visible = True...

Hence the reason that I thought something odd might be happening with my Access set-up or historic vb code. Maybe I failed to clear down a recordset and set it to nothing... but this should be covered by compacting the database. Perhaps the code I just showed you is running every time I open...

Good idea... but unfortunately it doesn't help :(

On a shared network drive

I don't think that you can do a compact on close in '97?! .. .but I regularly compact/housekeep this database anyway, so that wouldn't cause problems.

New office, New pc's, new software on client, all the same... no differences. Here is a function that I ran once upon a time... is there any chance that this type of vb code could be stored in my profile and run everytime I open an Access Database?! Note: This code doesn't exist in the...

The error trapping would be the same for all users though?! We are running exactly the same VB and queries using a command button on a form. I have set up these queries originally. They work for all users, but there is a major difference in the speed with which the results are returned for...