Search results

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...

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...

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 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?