Search results

Wicked. Unfortunatly i'm using Access 97 (at work so that aint changing) Cheers for the info though, filed for future reference :cool:

Hi Can anyone shed some light on the best way to solve this problem. I have a table (lets Call it tblMyTemporaryMadeUpTable) It has 1 text field (Lets call it MyField) I also have some data in this field like so ________________________________ MyField AABAAB BBABBA ABACCAB...

No problem. nice to give something back to the board for once in a while :-)

Hi Here a quick IP checking function I knocked up for ya. It may not be the most compact piece of code for the job, but it should work for you see sample attached. the IP validation function is in a module for you, so you can use it anywhere. The function makes sure the IP address contains 4...

Hey wadda y know. It works for UNC paths :-) for some reason (and if i'm gonna assume anything it should be in the negative) i assumed that it wouldnt work with UNCs :cool:

Hi all thought you might all be interested in a little sample db i put together There are 2 functions of intrest. 1. AddNewFile (Add a new file and places it into a table without any ballooning) 2. ExtractFile (extracts the file back onto a drive) Personally I use these functions for...

No problem. Happy to help :cool:

Hi I know its easy to catch keypresses, but how do you catch the cursor keys. Am I correct in assuming they dont give any ascii value like other keys?

Hi all. does anyone know how you can make a list box or a combo box that will allow for lists that may contain multiple lines... i.e. I have some Data.... Bound Column ListText 1 Hopefully someone Can work out 2 How to...

Hi all is there (and I know there is) a way to disable objects from being clicked on with the right mouse button? I have tried a few ways, but funnily enough they don't work I tried _______________________________________________________ Private Sub OLEInstructions_MouseDown(Button As...

Hi all I have an bound OLE Object Frame. Embeded in this frame is a Micros*ft Word document. Is there a way that I can open this document in Word using VBA code, instead of right clicking on the object frame and selecting "Document Object/Open"?

Hi All Has anyone else had trouble making a graph that allows a time line. Let me explain I have some data .... say for Example _________________________________ DateOfSomthing ValueOfSomthing 01/01/01 1 02/01/01 2 04/01/01 3...

I have a feeling this is a question for mile-o How do you create add-ins for Access 97? does anyone have any information on this at all?

I Write a little stand alone database (cause I cant use vb and obviously I have access :-)) All I do is have one form on startup to run the code and then it quits. Make a form Add a label named lblstatus Add a button named cmdclose (and make it invisible) (The testpath and ssleep functions...

Cheers for the info, a handly insight into one of my many grey areas. At the moment I use a BE on a shared drive on a server. On the server I also keep a hidden copy of the FE (I rename it to .DAT to confuse people more :-)) On top of the FE and BE I also code an installer that copies the .DAT...

Hi I'm having problems with a split database. The tables are linked using Link Tables and it is starting to run a bit slow. I thought it would be handy if you could test the speed of the network to see. Maybe somthing like a Ping where you can test how long it takes to run a set of...

Oh right I gotya. I thought i would be able to handle it within the function. cheers

I'm not trying to pass a null value i'm trying to stop a function crashing when I try to pass in a string that may or may not contain a null value.

Still having Null trouble Can anyone get this to work. I'm having a stupid day :-) (obviously i will be passing variables into the function in reality) ________________________________ Function testnull(sString As String) As String If IsNull(sString) Then sString = "" testnull = sstring End...

I have to pass "Null" into the String as I am using it to create some SQL for a docmd.runSQL statement. The field comes from a list box (That could be set to Null) The SQL would have to read somthing like this SELECT * FROM tblAccount WHERE Accountnumber = '123456789' or if the Accountnumber...