Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mavog
  • Order by date
  1. mavog

    Trace IP address of mail sent from Outlook

    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
  2. mavog

    deleted files come back on w2k server

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

    deleted files come back on w2k server

    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! :)
  4. mavog

    multiple tabel queries

    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...
  5. mavog

    Combining 2 tables?

    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?
  6. mavog

    date and time stamp a new record

    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?
  7. mavog

    date and time stamp a new record

    works a treat! thanx
  8. mavog

    date and time stamp a new record

    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?
  9. mavog

    concatenate problem

    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...
  10. mavog

    is this possible? Access2002 and excel

    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?
  11. mavog

    3 fields into 1 excel cell

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

    3 fields into 1 excel cell

    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?
  13. mavog

    lost focus from subform not working

    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...
  14. mavog

    check if database open as readonly

    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 :)
  15. mavog

    keep focus in subform when dirty

    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?
  16. mavog

    mouse scroll disable

    Hi, how does one disable the mouse scroll button so that users can't scroll through records on a form, but will be forced to use the 'find' button?
  17. mavog

    allow editing in subform

    hi , can any1 tell me how to change a read-only subform in a read-only main form to allow editing in the subform if a button is clicked?
  18. mavog

    make undo button visible if anything changes

    thanx - the first option is the one that works well enough for me, but i'll keep it in mind if it needs that little bit extra
  19. mavog

    make undo button visible if anything changes

    Hi , is there an easy way to make an 'undo changes' button visible but only when there are changes made in any fields on a form?
  20. mavog

    Can you open access forms from a website

    Hi aageorge, dunno if this will help but Access 2002 has a web page wizard.

Part and Inventory Search

Back
Top