Search results

Ah, thank you! I knew it was something idiotically simple I was missing; just couldn't for the life of me see what it was. Thanks again

Ok, this really should be the simplist job of all but my I'm having a mental block and simply cannot get my code to work. I have a master table, TblFileData, that contains all records. The salient columns in this are fldCode and fldName, fldType and fldDepartment I have a listbox on a form...

Ah, thanks Gemma; that also works wonderfully. I've actually changed my code to yours since, despite both working, yours is a little cleaner.

Thanks guys, I have it working well now. In case anyone else is trying to do the same thing, here's my final code: Private Sub btnWipe_Click() FileBusyFlag = False On Error GoTo FileTrap Kill Me.FilePath MsgBox "File Wiped" On Error GoTo 0 GoTo NextThingToDo FileTrap...

Hi there, and thanks for the heads up. Yes, these are all Office files (so Word, Excel or Powerpoint). I'll try to investigate these methods a little more, but do you have any examples of them in working code I could look at? I'd like to get a handle for how these can be fully manipulated.

Hi All, I'm not sure if this can be done or not, but I have a database project that includes - via VB - some file manipulation in the background. This all works perfectly, but there is a problem if the file to be manipulated is currently open by a user other than the one trying to make the...

Ah, fantastic, thank you! Your code works brilliantly and is exactly what I was after. I fully agree that, for stability reasons, it is far better to have the VB scan for the file code then jump to whichever record has that code, rather than trying to load a physical record row number. Thanks...

Hi All, Ok, I'm hoping this is fairly straightforward, but I've been hunting around online and going throguh the inbuilt help files in Access 2003 for about an hour now but simply can't find the answer. Ok, I have a folder on my PC that contains a set of files whose names all begin with a 5...

Yeah, that's exactly what I was thinking. It means adding extra unbound boxes for the user to be working on before the final save, but is safer I guess since the table data isn't being directly manipulated. Just wondered if there was a cleaner way with less code. Oh well, not really a...

Hi All, Ok, simple layout. I have a form with a unbound textbox on it called txtData. This has a control source of the field fldData in the table tblData. This field in the table contains alphanumeric data. All nice and simple so far. Now the textbox is set to be unenabled when the form is...

Ah! You utter star, JR. Thank you. Not only is my lookup working now but I also now understand why it was failing (I was missing out the '" & at the start and "' at the end to present the data). Regarding the [Code] and [Name] thing, those are fields in the table 'TblFileData'. [Code] is a...

Can anyone point me in the right direction of this, please? I've tried adding Me.Name.Value = DLookup("[Name]", "TblFileData", "[Code] = Me.Code.Value") to the OnClick event on my listbox of search results, to try to populate the Name box on the form with the correct details, but this just...

Hi All, I've been struggling with this for a few hours now and can't seem to get it to work. I'll use a simplified example, but the actual requirements are exactly the same: Ok, I have a table called tblData. This contains three fields; ID (the primary key), Code, and Name. Now I also have...

Thank you! That is exactly what I was trying to do. Have tipped your scales accordingly :)

Hi all, I have a small search engine written in VB with Access forms. The engine works perfectly and produces a list of all files (filtered by dropdown boxes on the form) in a particular folder. Now what I want to do is have a series of three separate text boxes - unbound - on the main form...

Can anyone help with this?

Sorry to be a further bother, but did you get the chance to look at this? I'm still struggling to make the engine able to search both folders as an option, and still can't get rid of the extension from the search results. *** Update *** I've tried playing around with the VB code and managed to...

Thanks for your continued help; it really is hugely appreciated. I've attached the current build. Note that this ia very rough and ready version (it will eventually be a lot more user friendly). Also, Folder1 and Folder2 are simply test folders on my hard drive that contain a variety of...

I've been wrestling with some of my issues for a little while now, but can't get things to work. Firstly, I'm trying to remove the extension being returned as part of the filename in the search box. I know this is the relevant line: fName = Mid(varItem, FolderLength + 1) But I can't get a...

Absolutely. Once I've managed to solve my three issues, I'll happily repost the edited version of the database for anyone else to take a look at :)