Search results

  1. H

    Updating Field (But only part of it)

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

    Updating Field (But only part of it)

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

    How do I store an IP adress?

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

    How do I store an IP adress?

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

    Second Error does not get trapped

    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:
  6. H

    Using (kinda) embedded pictures etc without ballooning... a solution

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

    Help, trying to make directorys

    No problem. Happy to help :cool:
  8. H

    Catching keypresses (cursor keys)

    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?
  9. H

    Multi *HEIGHT* list/Combo boxes?

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

    Can i disable the right mouse button?

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

    How do i open an OLE word object

    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"?
  12. H

    Trying to make a timeline Graph

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

    Coding Add-ins for Access 97?

    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?
  14. H

    Network Speed.... Can you test it

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

    Network Speed.... Can you test it

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

    Network Speed.... Can you test it

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

    Passing Null As Parameter

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

    Passing Null As Parameter

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

    Passing Null As Parameter

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

    Having Null Trouble

    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...
Back
Top Bottom