Recent content by The Real Yoda

What I want to do is select a criteria from a drop down box and then use that selection as my criteria in which to search by in my query (that is located in my Microsoft Database). e.g. Football Teams In my combo box I have a list of football teams Manchester United Tottenham Hotspurs Arsenal...

I am using Visual Basic to query the Access tables. what I want to do is make the drop down in the VB programme have a filter effect on the access tables. Does anyone know how to do this?

I already have a Visual Basic form present with a combo box listing various options e.g. car types. What I want to do is query the database for all the car details that a user selects (e.g. if the box listed ferrari, Ford, TVR etc and the user selects ford then the database will display all...

Yeah!!! It needs to be an animated gif file. If you search my username you will find a query about animated gifs(If you go to a specific web site). Goto that website and you can then download the activeX control. Hope this helps Matt

Thanks Very Much!!!! I Have Actually Managed To Solve It Another Way By Creating A Query And Using The Max/Min Value. When used without the ID it provides the result that I am after. I have tried your append query method and that seems to be just as good (Cheers Drew!). Many Thanks Yoda...

Basically I have a table with Results In It Like This Cert ID Job ID 131 86 131 86 131 86 213 20 213 20 What I want to do setup a way that access looks in this table and deletes any duplicate records. (So the table shows the records like this)...

What I Want To Do Is Have A Command Button With A Label (e.g. click me to win). Only when you try to click it, the command button moves in another direction (random direction). An thereby preventing you from clicking it. It could also come into good practise in other ways, but I just want to...

Basically what I want to do is copy a specific file from one destination to another and then rename it. How Is This Done??

DON'T WORRY I HAVE DONE IT!!!

Ok, At the moment I have a common dialog box that allows the user to preview th path to which he/she will allocate a file type. Once they have selected a file of their choosing they then select Open, and the file type path is then inserted into an invisible field. Once the field has the...

Create A Table With The Field Content In It. Then Link That to your main table. Once this is done make the make the fields look like a label on your maintenance screens. If linked correct then when changing the fields the headings (field headings) will appear to change as well (due to them...

I am using Access 97 though!!

How do I create a form that allows the users to assign unique pictures to an individual record? Cheers Yoda

Look Up The IsNull facility: This example uses the IsNull function to determine if a variable contains a Null. Dim MyVar, MyCheck MyCheck = IsNull(MyVar) ' Returns False. MyVar = "" MyCheck = IsNull(MyVar) ' Returns False. MyVar = Null MyCheck = IsNull(MyVar) ' Returns True. [This message...

I am creating a database to manage my music, DVD and Video collection, and what I want is to be able to set a picture for each individual CD,DVD or video tape. The only problem is that I can't seem to get the picture to insert into the database/form without access going into MS Paint. Does...