Search results

I am wanting to set up an Update query that will display the current day (eg Monday) I have managed to set up the date and time but not sure how go about showing the day. Any help is appreciated. Thanks

I know this is probably very easy but I just can't think how to do it. I want to be able to exclude any records in my query that have certain codes (4 codes) I can get the query to work excluding only 1 but it will not work with any more. Anyone any Ideas I have tired <> "Code1" or <>"Code2"...

We want to work out whether we have met our deadlines or not. Currently we have a Fix By Date field and a Date Completed field. We want to be able to work out the number of calls that were completed within time against those that were not, ideally we want to display these figures as a...

Thanks for your help it works a treat!

I am wanting to work out the number of months in between two dates that are input into my form. The date format is dd/mm/yyyy. How would I go about this? Any ideas would be appreciated! Thanks in advance.

I have tried this but it still displays the image with the white background is there anything I need to do in word?? Thanks for your help!

I am wanting to use an image which has a transparent background on a form but each time I place the image on the form it puts a white or balck background on the image instead of having it transparent as it should be. I have tried all of the various image formats jpg, gif, tif, png etc but none...

Thanks I will do it that way instead. Thanks for your advice!

I have set up a procedure that exports a query with a large amount of data in it and is taking some time to export so what I would is to display a message box saying something like "Export is running please wait..." which has no buttons on it and will automatically disapear once the export is...

I am having problems with the format of one of the number fields in my Table it was originaly setup as currency format with Auto decimal places. This was working fine but I am now exporting some of the data into a Text file (after calculations etc) so this can be read in by another program...

Does anyone know if it is possible to send and Assign Tasks from Access using the Redemption.dll work around? I have managed to get this working for standard email messages but not with assigning Tasks. Anyone any ideas?

I have managed to get this working with a standard email message but I still can't get it to work with a Task properly. It will send the Task but it will just not assign it to the recipient. Anyone any ideas as I am going round and round in circles now! Any help would be most appreciated!

Help! Outlook Redemption I have got a helpdesk database that emails tasks via Outlook (2000), using Citrix. This has been working fine until we installed the latest office service pack and then we got all of the security messages from Outlook when trying to send the email. I know that we...

Is it possible to reference a text box on a report to a field in a query? I am wanting to use a total from one of my queries in a report. Thanks

Brilliant works a treat thanks again for your help it is much appreciated!

Thanks for that it works but leaves me with the wrong data I want to be left with everything after the - Sorry I probably didn't make myself clear if the field says Construction - East all I want to be left with is "East" at the minute I am being left with "Construction", it is probably really...

I am setting up a report and I want to be able to remove everything in the field before the - symbol. For example the field shows the business unit and section: Business Unit - Section All I want to do is remove the business unit (everything before the -). Would I be able to use Trim? If so...

Thanks I will give that a shot and I will change the Time name to txtTime.

Thanks for the replies I haven't had chance to try them out yet as I am unsure how I will tie this in with the code that I am using, this is what I have got so far: Private Sub FixWithin_Click() If FixWithin = "Critical" Then FixByDate = Now Time = "1 Day / 8Hrs" End If If FixWithin = "Urgent"...

Thanks for that I will give it a try!