Recent content by Spica

Thanks. That was much easier!

I have a function that translates HTML letter-codes into the real letters. E.g. Æ translates into Æ. For this I want to have a constant array with all the letters. Like this (this code doesn't work): const HTMLCodes(32 to 126) as String = (" ", "!", """", "#", "$", "%", ... ) Then I could get...

Thanks! It worked perfectly! I owe you one!

It isn't that simple... No, both the actor "Bruce Willis" and the role "Hans Gruber" must be in the movie.

I have a movie database with a searchfunction that have trouble making a query for. My SQL that doesn't work is this: SELECT DISTINCT TapeNr, Title, StartTime, EndTime FROM Movies INNER JOIN Actors ON Movies.ID = Actors.MovieID WHERE Actors.Actor = "Bruce Willis" AND Actors.Role = "Hans...

I have this query: SELECT TapeNr, Title, StartTime, EndTime FROM Movies INNER JOIN Actors ON Movies.ID = Actors.MovieID WHERE Actors.Actor = "Carol" The problem is that when there are more than one actor in a movie that has the name "Carol", the same movie exists more than once in the result...

No, I only want to rename the file

I have working code now Thanks everyone. I have code that works now. I used this one: Public Function GetUpdated() As Boolean Dim dbs As Database Dim cnt As Container Dim doc As Document Dim prp As DAO.Property Set dbs = CurrentDb Set cnt = dbs.Containers!Databases...

Does anyone know how to rename the current database file with VB? I have a database named "Movies v1.12.mdb" and I want to rename it to "Movies v1.13.mdb" with som code in the database.

I the Microsoft Access window you can set database properties in File->Database properties->Advanced tab (I have a swedish version so I'm not sure which the english names are). How do you fetch them from VB-code? I've tried CurrentDb().Properties("LatestVersion") but it doesn't work. Any ideas?

I would like to fetch some properties that are stored in a backend-database from the frontend-database. How can I do this? When I want to fetch a property from the same database this works: myString = CurrentDb().Properties("LatestVersion") But what do I exchange "CurrentDb()" with to get a...

I found some example code that does work: Private Sub getFile(sSource As String, sDest As String) Const adTypeBinary = 1 Const adSaveCreateNotExist = 1 Const adSaveCreateOverWrite = 2 Set oHTTP = CreateObject("Microsoft.XMLHTTP") oHTTP.Open "GET", sSource, False...

I would like to download a file from internet (pictures) and store them in my database. E.g. I should be able to give the adress "http://www.myhomepage.se/me.jpg" and then this file should be saved somewhere on my harddrive. Does anyone have any idea how this could be done?