Recent content by JamesBBB

Hello all, I have a issue which I cannot resolve and I'm hoping someone can help me. In Windows explorer it is possible to add additional details in your file view, for instance I have a number of video files and have selected the following additional details, "Frame Height", Frame Width" and...

Hi There, Could someone help me with little problem with Access 2003, I have a database with address details and sometimes I need to search on a post code (zip code). The way I have done this is to set a public variable with the post code which is then passed to a query as criteria. On the...

Remou Apologies, I have entered the code in SQL mode on the query and it works perfectly Absolutlely superb Many thanks for that Really appreciated James

Hi Remou, Thankyou so much for such a quick repsonse, please forgive my ignorance, I can see exactly what the code is doing that you have supplied, however, how would I apply it in the queries critiera fields or should it be run as an sql statement from a button on a form. I was trying to...

Hi All, I have a problem with a query and I just cant seem to work out what to do, I really would appreciate some help. (Im using Access 2003) I have a text field that contains numbers such as 01 02 03 etc, however some of the values in the field contain numbers such as 010, 011, 012 etc. What...

Hi JBinQLD Absolutely Fantastic, I cant thank you enough many many thanks James

Hello I have a little problem here which I just cant solve, if anyone can help, I would be very grateful. Basically within my database I have 3 columns, One is [Series No] (Number) and the second is [Episode No](Number) and the last [Series Ref](Text). What I want to do is update [Series...

Hi All Another poser, I would like to read a recorset, however I dont want to start at record one, Basically I want to read the first 20 records, display the first 20 records, and if the user wants to continue , he can click a continue button and it will display the next 20 records and so on...

Golum Absolutely Spot on perfect Many thanks James

Hi All, I wonder if someone could help me please, I am writing a database for my music collection and the player I use is called coolplayer.exe, a very small mp3 player that sits in the system tray. However, what I would like to do is check when coolplayer is running so that I can show or hide...

Thanks Guys the help is invaluable, I will research and test and let you know how I get on Many thanks James

Hi PHV, I hope this post reashes you. SOme time ago you posted a solution to reading MP3tags from within VBA, the code being You may try something like this : Dim sTagIdent As String * 3 Dim sTitle As String * 30 Dim sArtist As String * 30 Dim sAlbum As String * 30 Dim sYear As String * 4 Dim...

Hi all, I am trying to write a small procedure to check if an application is running. I have found some code that MS states runs in VB but I cannot get it to run in Access 2003. This what I've found for VB, which i tried placing in the modules section Declare Function GetModuleHandle Lib...

Hi All This is a little difficult to explain. The object of the excerise is to allow a user to display anumber of records on a continuous form and each of these records contain a filename. After the user has filtered out just the records they need on the form (via Filters) then they would copy...

You could also have a look at this link http://www.planet-source-code.com/URLSEO/vb/scripts/ShowCode!asp/txtCodeId!9193/lngWid!4/anyname.htm Cheers James