Search results

Thanks for this - works perfectly.

Thank you for that, I will try that tomorrow. Does anyone have an option with SQL? I'd like to be able to keep it all in SQL if at all possible as I'll be handing the code over to others and don't really want to have it all in different places.

Hi all, I'm currently looking to change the ending of all filepaths of imported files whenever I run the import. I want to change the path ending from .txt to .doc. So basically, the link/path to the file should be got, the ending changed from .txt to .doc and then the path (with the .doc...

Sorry that I keep on not being clear. I know how to filter a form using text/combo/date fields, but my problem is sorting a date field ONLY by month and year, not by dd/mm/yyyy. Using the date picker is too specific as I don't need/shouldn't filter by day. So to clarify: I have a user who wants...

Sorry for lack of clarity - I'd like to be able to filter a sub-form to show only those reports within the month selected.

Hello all, I've seen a lot of similar issues to this raised, but I've not found a proper response to this question. I'd like the user to be able to search a subform only by month and year. We have lots of reports with different days, but none of them are pertinent to searching. I don't mind if...

Sorry that wasn't clear - I meant that when I run the import it only adds the filepath to the first record in the import set and leaves the others blank. Spikepl - whilst I appreciate your help and appreciate that you're trying to help me learn, I'm afraid I'm still not sure what to do. I've...

I've had a work on it and finally managed to get it to add the correct path for the document, but unfortunately it does this only adds this data for the top import. I'm sure it's something very simple, but I'm not quite sure what it is: Private Sub bImportFiles_Click()On Error GoTo...

Thanks for that - it's good to know not to bother with the hyperlink data type, but could you tell me how to store the full path as text? I can't work out how to import the path data into the record automatically.

Hello all, I'm new here and not very experienced with access, so I hope you'll forgive me for posting a question without first posting advice (and also for my wonky use of terminology!). I'm currently working on a way to import data from many word documents into a table - I've got this working...