Recent content by mavog

There might be a way to trace OWA through the IIS logging but I'm not sure how. Outlook should be trackable throught Eventlog - for example Set-EventLogLevel -Identity MSExchangeTransport\SmtpReceive -Level expert hope this helps, Mark

P.S I've also checked the file attributes and rights

Hi All, anyone ever seen this happen before? When I delete a file off a network drive it will reappear when i refresh the explorer.Also tried to delete it via dos window. I've defragged the servers disk several times.Can't think of anything else at the moment. suggestions? thanx in advance! :)

Hi All, i have 2 old tables imported into a new database that i want to append to 2 new tables in the new db. the 2 old tables are "Client" and "History". Client has a 1-many relation with History. I want to discard most fields of the old but i do want to keep the...

Hi , I want to combine 2 tables ,wCompany and wCompanyOLD. wCompany has the latest data but wCompanyOLD has 6 additional fields, but only a few companies have data in these fields. How does one copy these 6 fields into the new table (wCompany) if the Company name is the same in both tables?

thanx zevw, but the user has come back and wants to keep the date it was entered - don't ask me why they don't want to keep when it was edited?

works a treat! thanx

Hi all, could anyone point me in the right direction. I want to add a time and date stamp 'field?' to a record when the user adds or modifies a record. This should be visible in a form and/or report. Is there something built into access already?

Hi All, I've come across a little problem wit concatenating memo fields(address). They are truncated to a text fields ,which only holds 255 characters.Any ideas on how to keep all the txt? Here's the code i'm using: Private Sub btnSQL7_Click() Dim SQLstr As String 'concat into ETE...

Hi all, the db allows users to click a button that exports a report to excel. They would like the report the set the cell's property to wrap-text. Any1 know how to do this?

Thanx for the help, but how do I create a query that concatenates fields?

Hi, could anyone tell me how to do this: I have 3 fields in my table that I want to export/concatenate into 1 excel cell in a spreadsheet. Unforunately I have no idea how to go about this. Does anybody have any suggestions for me?

Hi, gotta little problem here with a subform. I've got a button that is enabled for some users to click and edit records in a subform. I want to confirm undo/save changes but somehow the lostfocus event is not activated. I display the save and undo buttons on the dirty event and this works fine...

The way that i've done this is by opening a form read-only DoCmd.OpenForm "formName", acNormal, "", "", acFormReadOnly, acNormal otherwise there are form properties like Allowedits, allow additions and allow deletions hope this helps :)

Hi, does any1 have an idea how to do this? I have a form with subforms in it.When I allow edits the undo/save changes works as long as the user doesn't move focus between form and subform. Is there a way to keep the focus on the subform until the changes have either been saved or undone?