Search results for query: *

Hi all I am trying to test wether or not a form is 'dirty'. ie wether or not changes have been made. From there i ask the user if they would like the changes to be saved. Below is the code i use but I keep getting an error message "You entered an expression that has an invalid referance...

oh ok I thought you were using somethng else other than a microsoft email program. In that case I think all you have to do is make sure it is set as your default program for emails. From memory I think that setting is found in explorer under options. It will prob also be found under control...

Got it all working and Perfect! Thanks Neil and Don. You have both been very helpful, now i just have to sit down and try and understand how the code actually does it! Thanks again wah

I am using Novell Groupwise and had the same problem. Which email prog are you using? wah

Hi Neil Thanks for that bit of code, I'm sure i will be finding uses for it in the future! But it only returns the folder path and not the actual file name.... Is there a way the user can see the required file within the folder then the full path (including filename) be returned? Cheers Ben

Hi Neil It is a bit more complex than that. What i want is the user to select a .doc letter that they have saved somewhere on the server and then a mail merge will be performed on it. At the moment they have to type in the actual file path into a text box, but i would like something a little...

Hi Keren Did you end up solving this problem? If so how? Cheers wah

try this: in VBA behind the on click property for the button chuck in "me.textbox.value = now()" You may be able to use date() but i think i have heard around the traps that it cant be used in access2000... cheers me.

Cracked it! While trying to use the application i accidently pressed the \ key. This brought up a whole new menu which allowed you, among other things, to save data to a file in a whole range of formats! Thanks for all you help Frink. wah

hi i'll have a look into that divert to file using the printer thingo. Another thing i have since found out, the software was developed in 1986 using SMART Software. Cant seem to find much info out about them but still trying! thanks for your help wah

have no idea! The front end seems to be custom developed. I managed to crash the thing while i was having a fiddle and it dumped me into dos, which is where i found the db files. I couldnt see any option to print to file etc, only to print to printer or view on screen. thanks wah

Hi all I have an application circa 1991. The interface is very basic and the only way you can extract records is to print them out. There is thousands. I have managed to locate two files called streets.db and dispmis5.db. I am assuming these files contain the data i need. I have tried...

the Datediff function might do the trick. wah

hmmm... so what u r saying is that you have resolved the error (name of the control) but are now having problems with populating the image controls so to speak? When you create a image control, it asks you to select an image. What I do is create a simple jpg that says 'No photo available' so...

Off the top of my head it means that it doesnt exist. What you need to do is refer to the name of the control. 1. look at the form in design view 2. select the required autonumber control 3. right click this control and a menu will appear. From this select 'properties'. 4. a box should...

oh yeah the line Me.ImageBoxFront.Picture means - me = current form ImageBoxFront = name of the Image Box control on the form Picture = the property of the image box that tells the db where the photo is. cheers wah

okies this is the idea behind my method. Just say you have a boat, lets say a 'Noosa Shark Cat' with a DB autonumber of 17. And you have a 'Haines Hunter' with an autonumber of 78. Each vessel in the DB can have up to three photos - side & front profiles and a misc shot. The area you dump...

Hi Russel If you have an autonumber then you can use that as part of your file naming syntax, as this will mean each photo will have a unique filename. In the example below I am assuming you only have one photo per boat, but it easy enough to accomodate for more. This is roughly how i would do...

Is it possible to have the user dump the required image in a predefined directory? Then if you give the file a name following a specific syntax the db can automatically look for it. If it finds it then display, if not then dont do anything.... cheers

Is it possible to have the front end on the server and each user will have a shortcut pointing to it? Thats what i do and havnt had any probs with the DBs (which use subforms). cheers