Recent content by tombirch

Hi You can use the datediff function to find the difference between two dates. Both number of days, hour and minutes. But to get your result in a format like 2 days, 4 hours and 21 minutes remaining. you need to use the Mod function. The function below returns a string that you should be able...

Try this one. It will return only the normal ascii caracters (ascii number 32 to 126 and 160 to 255. Function adjust(var) as string Dim y As Integer, xst As String dim nystr As String, i As Integer if isnull(var) then exit function For i = 1 To Len(var) xst = Mid(var, i, 1) For y = 32 To...

Thank you very much for your help. Your tip op importing into a new database worked fine, and fixed the problem. It turned out that for a database with collatingorder for Danish/Norwegian "Æ" is not equal to "AE", but equal for collatingorder "General". I tried...

In my danish version of microsoft Access 2000 I have an odd problem: If I type the following in the imediate window I get a true result. print "Æ"="AE" true Is is possible to disable this language setting? so that I get a FALSE result? It is very important for my data that...

I have experienced the same problem sometimes. And usually the problem seems to have occured because of an error somewhere else in the code. So maybe you have an error somewhere in your code. Try to compile your code first.

Thanks for your advice. I have tried using the shell function but I don't know the path for the browser for all the PCs the database will be used on. Is there a way to extract the path for internet explorer from the registry?

Hi I want to add a menu item to my custom menubar that opens a webpage. Does anyone know the code to do this? Regards Tom

Hi In a code I am trying to run several queries that update tables in my database. So far I am able to run the queries using docmd.OpenQuery but this gives me no way to handle errors, and it also pop up a window asking me if I will allow the update to take place (which I don't want) I have...

You can use the shellwait function found on this address: http://www.mvps.org/access/api/api0004.htm This will wait until the shell program has finished before the code continues. TomBirch

You can use the Access visual basic editor buid into access to go through the code. You can make the application run a line at a time by just clicking next to the line where you want to start checking. When that line is called in Access the code window will pop up with the line highlighted. By...

Well my code is a bit complicated as the error occurs when I am filling a treeview object. It is a multiuser database, and I am not deleting records in the code, but I use the recordset of the form where the treeview object is located, and this is where the deletion is taking place. So far I...

I am getting an error in my code when looping through a recordset , because a record is deleted. Does anyone know how I can check if a record is deleted? Tom

I find it much easier to build my sql sentenses for code by simply creating a new query from the database window. This makes it much easier to check if the sql is okey. After you have designed and tested the query, goto to menu:view - SQL then select and copy the sql statement by pressing...

Just wanted to tell you that you are not the only one who has had this problem. It happend to me yesterday. I got the exact same message, and I wan't able repair it. If you have made a lot of code in the form you might be able to save this. I managed to save all the code behind the form by...

Have you tried to repair/compressing the database? You can do this without opening the database itself.