Search results

I have created a UDF that works a treat. However, the values are not automatically calculating. I don't use excel much and can't figure out a way to re-calculate this formula when the sheet has been updated. I have found a manual method of ( ctrl, alt, shift + F9) but this needs to be...

New formula field. mid({yourtextfield},6) or 7 depending on which character you want the text to start from.

OK, so you could split the criteria up then in that case. Firstly select your datetimefield and choose between currentdate - 365 and currentdate. Then you could create a new formula which will flag any records that meet the following criteria. if time({datetimefield}) >= time(17,00,00) then...

Apologies, I lazily read this to be 5pm to 7pm of the same day. Will the report be based on 5pm yesterday to 7am today? In which case, choose you selection criteria against the date/time field and then formula and use this. {Datetimefield} in DateTime (currentdate-1,time(17,00,00)) to...

By the way, if anyone else wants to do this, here is how. "c:\Program Files\Microsoft Office\Office\msaccess.exe" "mydbpath" /wrkgrp "mywrkgrppath" /user = "user" /pwd = "password" /compact copy /y path1 path2 You can also change this to ignore the compact if the ldb file exists. still stuck...

OK I'm back again. When using /repair in my batch file, it halts the remainder of the script until you select OK for the message telling you the repair was successful. Is there a way to tell it to ignore this message and continue, or get it to select OK automatically so it can continue with...

create a formula field and add the following hour(yourdatetimefield) Now you should be able to choose this field in the selection criteria and use "is one of 5,6,7," or "between 5 and 7".

Got it now!

Hi all, I'm attempting to create a batch file which I have successfully managed with databases that does not contain user security. What the script does is compacts the db and saves a copy to a named location. I can get it to open the db with my work group file but how do I pass it the...

Hi, Is it possible to create a rule that is exclusive to a subfolder without it running for the whole inbox, and without having to manually change the (run rule in this folder) option each time. If a mail comes in from a certain person, I want a rule to run for only 1 subfolder, and that's it...

try adding chr(10) to the end of your sentance where you want to start a new line. eg, "Attached is your booking sheet." & chr(10) & chr(10) & "If you cannot open the booking sheet etc....... would add 2 lines hope that helps

As I mentioned before, try chr(34) instead of " eg chr(34) & nameofperson & chr(34) it works for me ok.

chr(34) at each end of the name should sort out the code

you could add a button to clear the contents of the box using vb code, and refreshing the form. eg, me.combobox1.value = "" me.refresh me.requery

if you have anything above access 97 then you have a conditional formatting option. This is your solution. Otherwise, you will need to vb code it.

You need to create a parameter field for each, then select the fields in your selection criteria and point it to the parameter field. This will diplay prompts for the user running the report based on the values held within the database.

yep, should be pretty easy. It's just the path to the executable (exe) for example (from root) c:\>cd program files\next folder\etc\etc >crw32.exe

Either create a macro and choose "output to", or code it using Docmd.OutputTo This should do the job

I had this issue a few years ago. I think your database is corrupt. You're best to open a new database and go to File, Get External Data. You can then copy all tables, Queries, Forms etc across from the corrupt db.

when you say file 1,2,3. Are these treated as tables by crystal? Basically, all you need to do is edit the link from file 1 to a left outer. This ensures it keeps all values from file 1 and only the matching records from the joining table.