Search results

Me too :) I think I'll have to create a company policy to make people not use commas. It must be acting as a delimiter or something.

Ah ok, that is a shame, but I appreciate your help all the same. So it seems my syntax is correct then. That's cool. Thank you :)

Hi David, They are a Norbuild file. The program is a dongle-protected one, but you might beable to download a demo version from here It makes graphs for sound insulation tests (we're an acoustic consultancy) I can open most files from a double-click in my listbox, but where there've been...

I think I've seen it, and maybe even tried it but I don't think it worked for my .nbp files. But by all means I'm willing to give it a go if I haven't tried it.

Hi all, I have the following code: Private Sub lstboxProjectFiles_DblClick(Cancel As Integer) Dim strWholePath As String Call getextension(Me.lstboxProjectFiles) If getextension(Me.lstboxProjectFiles) = "nbp" Then strWholePath = Me.ProjectPath & "\" & Me.lstboxProjectFiles...

Hi, I have a similar problem, in that certain file types of file will not open with the wonderful examples given freely in this forum so far. Ghudson's FindFileandFolders() example which uses the ShellExecute command is most promising but doesn't yield the result. The...

I've done it :) There's a section of code in the function called "FillDir()" 'Add the files to the folder. strFolder = TrailingSlash(strFolder) strTemp = DIR(strFolder & strFileSpec) Do While strTemp <> vbNullString colDirList.Add strFolder & strTemp <----------------------...

Thanks for the reply DCrake, regarding my code, I thought that all you'd need would be the code I placed a link to in my previous post... I've used that exact code. When calling it, I used the following command in the strQuotePath_Lost_Focus event: me.lstboxQuoteFiles.recordset = "" Call...

Just to keep all informed, I've used Allen Browne's code for doing this and it works a treat. Wish I'd found his website sooner. LINKY Now the only niggle with this code is that it shows the whole directory path before the file name, rather than just the file name. This is only annoying...

I've just come accross this and I have a question, as I'm trying to read a list of files from a directory into a listbox. I have a question for you... How do you set the listbox's RowSourceType to "DirListBox"? I only have Table/Query, ValueList and FieldList available. I'm using Access 2007...

ah okay. Well I greatly appreciate your help David, really do. Si Edit: I did a google search and found in the UtterAccess forums, this page I think it might explain the issue down at the bottom of the page - Application.FileSearch has been removed from the Object Library in version 12.0

We're MS Partners and as such, have 10 licenses for 2007. So I'm using that. I can't add the DAO 3.6 Reference, as it says there's a naming conflict with an object library I have selected. I have Object Library 12.0, - 11.0 is not available.

I've turned it on, but I'm still getting the error

Hi David, Thank you for the code, I've been looking through it, and have been trying to work out what it all means. Only understand a few bits at the moment. Anyway, I've copied the code into my form, and I've made the same table as you had, so it references that too. I've edited a couple of...

Thank you loads! (in advance of looking at the code) And thanks so much for taking the time to do code for me! I will download this file at work, as I don't yet have Access on my machine at home.

I look forward to it, thank you!

Argh! I can't understand where to place the code to tell the listbox to list the files that are contained in the textbox "QuotePath" or "invoicepath" etc. I'm thinking I need to place it within "Private Sub QuotePath_LostFocus()" in the Else statement after the line "strQuotePath =...

Thanks CDrake! I have just been looking at your code and got my little check to work with the following code: Option Compare Database Public strQuotePath As String Private Sub QuotePath_AfterUpdate() 'Set variable to equal nothing strQuotePath = "" 'Read QuotePath into variable...

Hi all, Ok, so I've read about DIR so far (in the help file and the odd google search too). Haven't been able to find anything in the Access Help Files about FollowHyperlink Currently, I'm only just beginning to get around to writing the code (my main job is Acoustics consultancy, which...

Many thanks Mailman, I appreciate it. I shall do just that.