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

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

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

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

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

Hi All I am having a problem with multiple filtering, which I cannot fathom, any help you be very gratefully received. Basically I have a form where a user can select up to 4 filter criteria from 4 text boxes(Each text box is for a specific field), he can select just one, or any number of...

Hi There Im havving a little problem with conditional formatting. Im not sure if its just me!! Basically on a continuous form there are some records that contain (Incomplete) in the field name. ie records: Testing Project Stress Project Finalization Project Release Project(Incomplete) Sign...

Hi All, Could someone please tell me what is wrong with this statement, I cant see what Im doing wrong and its driving me loco. Basically I have a string called ba which is being tested in a loop when the string has "(s)" and "bytes" in it then code should be executed. so when the string...

Hi All, A quick question re transfering text. Basically I have a "continuous" form that has a number of records that has been filtered by the user so that they see only what they want to see. what I would like to do is have a button that would export the records on the screen to either a text...

Hi All, I have a number of text files which are the results of a dir of certain hard drives in the system. What I would like to do is strip off the amount of bytes used and the amount of bytes free for each drive. Basically what I need to be able to do is open each of these files and navigate...

Hi All, Im fine with filtering records on a form where the record field has a value I can filter on, however, I'm having a little problem with filtering columns of records on a form where I would like like to filter "excluding" either NULL or zero length strings. I would like to do this as in...

Hi all, I have a problem in trying to accurately calculate the age of people. The information I have is their date of Birth and obviously the day the calculation is run (i.e. today’s date) In the reports upbound field I make the:- control source = CInt((Date()-[date of birth])/365) The...

hi All, Ive got a question about menubars, I have had a good look through tek-tips and read many articles, but am still at a loss. Basically I want to be able to get rid of all the menu bars that contain icons, which is fairly easy. But what is troubling me is I want to get rid of the menu...

Hi All, Im trying to be able to set a sub form to ALLOW DATA ENTRY from a button on the main form, but I can see no way of doing it. Does anybody know how to do this The Main form is called Firedrills and the Subform is called FireSub. From the button I have tried the following, but they do...

Hi All, I have a problem with filters and sub forms, I just cannot get the code to work. when I use the filter on the subform as a stand alone form the filter works, the Button code I use is:- as1 = "[Staff Number] like '" & Pubstaffno & "'" DoCmd.GoToControl "staff number" DoCmd.ApplyFilter...

hi all, I have read trough the articles inthe forum re multiple filters and cannot seem to see what Im doing wrong, its so frustrating, Ive been staring at it for over an hour. basically I need to filter on a STAFF ID and a LEAVE TYPE, and Im suing the following code:- ab = Me![Staff...