Search results

Thanks for the link. The information on this website is possible quite helpful for other things I'm struggling with as well. I still haven't solved my original question but continue to work at it. I am not saving images to the database, the images are loaded from a link and stored as normal...

Thanks for your suggestion Namliam. Yes, the folder "Completed Entries" exists and files are copied to that location using the code in the first posting. But there is more that needs to happen. I probably haven’t explained very well what exactly it is that I’m trying to achieve here. It is...

Thanks for your feedback. If I understand correctly you suggest to change the code as follows: That doesn't do the trick. I get an error message "Path not found" early on in the code on this line: I really want the picture to be copied to another folder, not to a subfolder in the one holding...

Thanks for that clarification Namliam. I've been a little bit successful with this, but not there yet. Can you give me a bit more help? What I have now is this: Private Sub btnCompletedEntry_Click() Dim fs As Object Dim oldPath As String, newPath As String Dim fso As New...

Thank you for your advice Royce. It is not exactly what I had in mind I think. If I understand correctly I'll still be comparing tables to see which pictures and details I have entered into the DB. What I'm trying to do is to move the completed pics to a new folder and subsequently delete or...

Thanks. I see what you're doing here but can't get it to work. There are a couple a variables that need to be defined. I assume the MyCurrDir needs a Dim statement Don't know what to do with the rst!min, vbDirectory. Here's what I have now: It stops at rst with the message that the variable...

I have a folder which holds 1000s of pictures organised in subfolders, for example: D:\~AI Database Print Scans\2009\family and D:\~AI Database Print Scans\2009\holiday And so forth. In total at the moment 17 main subfolders, each of which hold another 2-3 subfolders. I am putting together a...

Solved! I've downloaded a copy of the file (It's an .ocx file) a linked to it. I've put in a request to copy the file to the citrix server and will link to that one ones its done. Thanks guys for your spot-on suggestions.

OK. Tried the last suggestion first, i.e. disable the reference and see if the DB still works. Well, it doesn't, so the reference is essential. Unfortunately I cannot reselect the reference as it does not show up in the list anymore. The issue is probably that working in Citrix and I can't get...

A form in one of my databases became corrupted. I have recreated the form and it all works fine again but I thought it might be an idea to import all of this database into a newly created fresh one just in case some more minor corruption has sneaked into other forms. Well, did that and now I...

Thanks JANR, the DAO addition solved my problem. @vbaInet Error message was Complie error. member not found.

I have used the code below for about 4 years in .mdb databases. It's function is to highlight the selected record on a continuous form, worked great. I found it on this forum and I now hope other people I are using this code too and have experience with the problem I experience since I upgraded...

Ahh, now I understand what you meant previously. I should have understood what you meant in your first reply but didn't quite get it. And guess what! After doing exactly what you suggested it now works perfectly! Thank you very much John. You've been very patient and your pointers were very...

I have done a "group by" John, but that doesn't change anything. Am I perhaps missing something obvious or simple? Here's the SQL of the query: SELECT DISTINCTROW tblRecords.RecordID, tblRecords.ArchiveNumber, tblAreas.Area, tblRecords.Title, tblRecords.KeyWords, tblRecords.Authors...

Thanks for the reply john. No, I hadn't considered a totals qry. I don't see how a totals query would help but as I'm not a very advanced user that doesn't mean much at all. So, I have given it a try but the result is the same, ie duplicate records for publications marked for multiple areas...

I can't work out how to set-up a qry based on multiple criteria on a single field without obtaining duplicate records. DISTINCT doesn't do the trick here. What should be the approach? This is for a library database holding a collection of publications. For ach publication one or more special...

Thank you for your help Neil. unfortunately you go a little too fast for me. I have found some background reading on the Nz function and what it does but I am still not able to put 1 and 1 together. Did you understand that I don't want the query to return the records with 0 or Null, only the...

I have a database which contains hundreds of publications, all listed on the main (continuous) form. To make it a little easier for the users I thought I'd let them select the main 'areas of interest' by ticking one or more radio buttons (7).Tthe result should be that only those records are...

Excellent!! You've been a big help Paul. Thank you.

As already said above the solution I have found wasn't satisfactory. In fact, it doesn't do what I need it it to do. After reading up a bit on delete queries as suggested I see this is the way to go. I've build one that does exactly what is needed, but only when I run it from the query...