Search results

Zip Function!!! Zip function is great! Thanks to the both of you :D

Trying to use the CopyDatabaseFile method to make an archive of my database but keep getting Run-time error '2046': The command or action 'CopyDaatabaseFile' is not available now. I have the ArchiveDatabase function stored in a module and am calling it from a for button. Any ideas please...

All I can say is MUPPET :o Thanks alot :D

Hi all, I am having a problem getting the notes on a student to display. At the moment I have to input the student ID into an input box before the students for displays or I don't get any notes displayed. This is what I have in the SQL statement for my ListBox. SELECT tblNotes.NoteID...

try this FormatDateTime myTime, vbShortTime

I thought of that but that would mean allocating each note a Unique ID. Because many notes can belong to one person this procedure will display all notes relating to that customer, when I only require the specific note the user requested. Thanks.

I've got a list box containing all notes entered for a customer. The user needs to be able to double click the relevant entry and be take to the corresponding entry in another form. This is the filter I've got at the moment (below). As far as I can see it should work, but it doesn't. :confused...

Doh! Why didn't I think of that... Thanks alot Mile.

Is there any way of extending the limit of a notes field past 255 chrs??

Mail Merge I recently developed this code for a client contacts db I am working on. Hope it helps! DoCmd.TransferText acExportMerge, , "NameOfYourQuery", CurrentProject.Path & "\MailMerge\MailMerge.txt" Dim objWord As Object Set objWord = GetObject(CurrentProject.Path &...