Search results for query: *

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

...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 sComment As String * 30 Open...

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

...As Recordset Set rst1 = Me.Recordset While Not rst.EOF aax = rst![Author] ' Get record from recordset MsgBox aax rst.MoveNext Wend rst.Close ************************************** Example Two:(does not work either) Dim rstTitles As ADODB.Recordset Set rstTitles = Me.Recordset rst.Open...

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

Hi Matrixknow You could check this out yourself by writing this code on a button:- For a = 30 To 100 MsgBox Chr$(a) & vbCrLf & a Next a You can change the values of 'a' to whatever you want, but try the above first. I use it to find various ascii codes Cheers James

...leave, then no records are returned, which is correct, but, If I detect that nothing has been typed in text2.value (Leave) , I then set str2 to = "*", which I thought would mean all records for this field, but it doesnt work and still returns no records. if isnUll(str1) or str1 = "" then...

Thanks Remou, for having a look at my problem, however I have just this minute solved it. I stated above expression is "*" & "Sign off(Incomplete)" & "*" what I should use is as follows:- expression is [Title] like "*" & "Sign off(Incomplete)" & "*" It works now. Just a stupid mistake on...

...format those records that contain the phrase (Incomplete) in red and Bold. I have tried using in the conditional formatting dialog expression is "*" & "Sign off(Incomplete)" & "*" but it does not work. Is what I want to do possible and if so, can anyone show me what Im doing wrong Many...

Hi CautionMP Absolutely, fantastic, works perfectly thanks James