Search results

Having Null Trouble :-) I am trying to create a function that will pass out either.... The string that is passed in or "Null" (as a string) problem is, i am having trouble passing Null into a function if I try to pass in a Null String access really doesnt like it :0( example...

Is there a nice easy way to check if an object exists on a form? For example, could I check to see if a label called lblMyLabel exists?

Hi All Please find attached an example DB with a module allowing for easy animation on a form. Only 1 line of code is needed in the On_Timer event on a form. AnimateFrames NameOfform,NameOfImage(s),NumberOfFrames e.g. animateFrames me.name,"MyImage",6 Inspired by GHudson :-)

unfortuantly, there is no "Install New Fonts" options :-(

Hi I'm at work, trying to make some forms look half decent. Problem is there is a distinct lack of fonts on my PC I have tried downloading new TTFs and copying them into the winnt/fonts directory, but these fonts still dont appear in the font list of access (or anything else) am I doing...

Cheers mile, much appreciated, look out for my next post (inspired by ghudson)

Hi all I have a sub that I cant get the syntax right on. I am trying to get this to execute from a module but I am having trouble referencing the object on the form the sub should be called like this call an(me,lblMyLabel,False) '(to hidethe label) call an(me,lblMyLabel,False) '(to show the...

Hi all this should be simple, but i'm having a brain attack! I need an input mask on a form that restricts the user so only the 1st day of each month can be entered as a value i.e 01/05/03 or 01/11/04 ..... you get the idea I tried "01"/00/00 Guess what.. it didnt work :-D

Hi all This is probably very easy to do. I need to be able to view the results of an SQL SELECT statement like a built access query i.e sub MySub() dim TempSQL as string TempSQL = "SELECT * FROM tblTable WHERE name = 'ME'" docmd.runSQL tempSQL end sub problem is, you cant use .runSQL with...

Here a change Can anyone play a .MID file or somthing thru the INTERNAL speaker? I fancy annoying my boss by playing stupid tunes at him while he uses a database I designed.

Sorted I managed to hack together a module to use. (I hacked apart some .Mdb file on this forum. I think it was called setprinter97.mdb modGetDefaultPrinter ________________________________________ Option Compare Database Option Explicit Public Declare Function acb_apiGetProfileString Lib...

Hi All i am trying to retreive the default printer name using prtDEVMODE. All I need to return is the name of the default printer (e.g HP Laserjet III) ..... and nothing else really. It's just as a nice user friendly kick up the a*s to make sure users have their printers set up correctly...

wish i could.... problem is I need the warnings on. I turn them all off once I have finished deleloping...... To cut a long story short. I am sitting in the middle of a quiet office developing different databases and annoying about 20 people each side of me :-) fun eh!

Hi On the database I am coding up at the moment, I need a compact Database button. Simple as it sounds, the ol' SENDKEYS trick won't work for me, cause on "Tools...Startup" I have all the menu's switched off. Obviously now Sendkeys just makes a couple of feeble beeps. Is there another way to...

I cant turn the speaker down. (Wish I could jam a screwdriver through the speaker) BEeeeeeepp!

Hi. is there any way to stop Access Beeping every time a msgbox or "You are about to import loads a records" message appear. I still need to see the warnings but the beeps are driving me crazy. Unfortuantly too, I am at work so i can't run REGEDIT to disable the speaker. Is there any other...

ok, i just worked out what you were going on about I use the query at the top and get a recordset that I can use. p.s. maybe I should have said I have NO idea about DAO or ADO. Anyway I think i'm alright now i did it the way you suggested and can filter my way through the record set now...

I can paint a picture (ironicly) of me sinking __________________\o/________ :-) Ok, first of all What I need is a list of duplicated (and a seperate list of non duplicated) account numbers. This list must be in the form of an array, or somthing that I can use. A simple table or...

Cheers, but can you give me a bit of code in the middle, just so I can list all the duplicates I get making the connection and moving through the file but I have no idea on how to manipulate with two tables somthing like.... rst.movefirst Do until rst.eof 'If...

Ok heres the thing. I have 2 tables tblTempImport tblArchive (both have a field called "AccountNumber") Both table structures are identical (good ol copy and paste) What I have in these tables are lists of Account Numbers. A file is imported into tblTempImport and then transfered into...