Search results

Ok I managed to write myself a little function it's not perfect by any means but it works for most things (not UCC paths) It just cycles through the string passed in and creates each directory one by one. _________________________________________ Private Sub CreateDirectory(DirectoryPath As...

Ok, I have tried both of the suggestions above, thanks. I cannot put Double quotes around any directorys with spaces. All I have is a string with the directory path, so i'd have to filter these out.... which is exactly what I am trying to avoid :-) If i use a string of "C:\TEMP2000\A NEW...

Thats how i have been trying to do this. The problem I'm getting is that when I try to make a bunch of directorys in one go, if these directory names have spaces, everything goes wrong. I tried this, but it didnt work. ___________________________________ strShell =...

Hi. I am having a few problems making a directory. I have a string (the name of a directory to be created say for example this string is C:\TEMP2000\This is a Directory\ I would like to be able to create this directory from scratch. i.e "TEMP2000" & "This is a Directory" do not exist...

Thanks for the replies. What I was trying to achieve was to Embed a picture file somehow (suffering a small amount of bloating) but trying to bypass the servere bloating that Access likes to perform. For Example If i could store some pictures into a table but fool access into thinking they...

I have a module that I am using.. to cut a long story short, I need to be able to reference the form that calls the module. i.e. I have a form (ME) the form calls DoSomthing() I want the DoSomthing() function to change the caption of a label I figured the code in the module would go...

CreateControl - Trying to create somthing useful Hi all Is it possible to create a complete form (or edit a form) to create a complete all singing all dancing form. Say for example I wanted to create a form with a command button that executes a simple function for example...

For the first time ever I wish somthing I had was smaller than it is now. Why is is that whenever I insert a picture into a form the size of the database increases by.... wel lets just say a LOT e.g. I have a .JPG file that I am using for a background. .JPG file size is about 14Kb When I...

Hi all Is there an API or anything that I can do to open a normal Windows window ... i.e. the same as if you double clicked on the "My Computer Icon" also I need to open this window to a specific path I am using Windows NT. Is there anything that I can exceute using the shell command (i...

I think it is supported in 2000. Unfortuantly I have access 97 (cause i'm at work :-( ) I know there were copies of the code floating around, but the site I go to now asks for a subscription to get hold of it.

Does anyone have a copy of the AddressOf function? I can't find it anywhere?

I am trying to use a mousemove or mousedown event to catch where the cursor is on a form. Problem is when I save the X and Y variable it is never the same as I think it should be. maybe an example (Make imgMyImage on any old form) ______________________________________________ Private Sub...

Is it possible to catch the position of the mouse without using events like mousemove or mousedown etc.etc. I would like to catch the mouse position at regular intervals using the Timer event. Any help would be greatly recieved :-) thanks Homer

Wrong If you are coding your own database you can code in a kind of "Kick" function. If you make a table (call it KICK) with 1 field, you can update the first (and only) record in this table to TRUE or FALSE. Depending on what your database does you can write a bit of code into a module that...

I get this error message when I try to save the table Unknown function in 'GetNTUser' in validation expresion or default value on table1.field1 I have this code in a module (and no other modules or functions or anything) _________________________________________________ Option Compare...

I have a module with the function GetNTUSer in it. It would be really handy if I could set the default value of a field in a table to this, but whenever I try to, I just get an error message. Is it possible to set GetNTUser as the default value of a field? Cheers Homer

Hi I am trying to delete records from one table by matching a foreign key and a primary key across a link. i.e. _______________________________________ Table1 pk_Table1 Name Address Postcode Table 2 pk_Table2 fk_Table1 ADate SomeOther Information _______________________________________...

When You select "Edited Records" on a form, you get the nasty little circle with a line through it. What I would like to be able to do is test for this before any typing occurs. I guess the best place to put this code is in the "Current" or "timer" event. Problem is.... How do you test...

I have a multi user database with a table of accounts (say 1000 account) I have about 5 people working on these accounts and I have a form where they can go through the accounts change what they need and carry on. Problem is, when 2 people access the same record.... of course one of them...

Is it possible to trap a printer error message.. I make a lot of multi user databases on a network and people kinda forget to set there printer up or end up sending stuff to wierd places. Can you trap the "Error printing to LPT1" error messge etc. then I can stop my database updating records...