Search results

  1. Z

    what if I only want to read the first line of an email?

    Ok, after a bit of playing i've come up with the following method that works.. position = 0 Do Until (Split(Mailobject.Body, vbCrLf)(position) <> "") position= position + 1 Loop MsgBox(Split(Mailobject.Body, vbCrLf)(position)) The Split function breaks Mailobject.Body up into...
  2. Z

    To Query or Not To Query

    Cool.. Thanks for your help :)
  3. Z

    To Query or Not To Query

    Wait I think it just clicked.. User table: ID, Name, PosID, DepartmentID Position table: PosID, Position Safety Partner Query: Select * From Users Where PosID = 7 That work?
  4. Z

    To Query or Not To Query

    Doesn't that just create an extra step of referencing though? hmmm, ok.. I've found that I mainly ignore the position information for 90% of the users.. its only the 10% that count.. i have the following Positions that are important... Safety Partner - Group Safety Advisor -...
  5. Z

    To Query or Not To Query

    Hmmm.. Bare with me here.. There are certain positions that have multiple people (i.e. there are multiple 'Safety Advisors') How would I handle this.. I'm failing to see how having a seperate table to hold the positions helps.. Currently my User table has the following fields: ID, Name...
  6. Z

    To Query or Not To Query

    For my database, various role names can change every now and then. In order to combat this, i'm thinking of creating a query for certain positions. What I mean is: Production Manager is a pivitol role, since it gets referenced to for approvals and placed in emails etc. If this title...
  7. Z

    Can't pass string >255 characters to Word document

    What code are you using to send the text field data to the word file?
  8. Z

    what if I only want to read the first line of an email?

    Checkout the TextStream Object.. It contains a ReadLine method
  9. Z

    Calander function and login problem

    What you want to do is in your login form set ServerID to the value corresponding to the details used to login.. Since ServerID is a global variable, once set, it can be referenced throughout your database, even once you close the login form.
  10. Z

    a Form_BeforeUpdate(Cancel As Integer) question

    I usually handle this by setting a global flag varialbe.. Call it something like whichButton. Then for your button, in its onclick action, set the flag to a number corisponding to the button being used.. Then in your BeforeUpdate, just have a switch statement that handles the various possible...
  11. Z

    Help needed to filter a report

    Yeah but it revolves backwards :p :D
  12. Z

    Help needed to filter a report

    *sigh* works now :p cheers for that link, should prove useful since i pull my date from a activeX calendar.. damn americans breaking my code :p
  13. Z

    Help needed to filter a report

    No luck.. If I put the date between 1/11/09 and 11/11/09 I should get only 1 record, but I get all of them.. This is the WHERE clause that the report is getting, seen from the reports properties (Date_Start Between #26/11/2009# And #1/11/2009#)
  14. Z

    Help needed to filter a report

    hmm, this does strange things.. I have the WHERE clause of the docmd statement to be "((tbl_Change.Date_Start) Between #" & Me.frm_Reports_Date1 & "# And #" & Me.frm_Reports_Date2 & "# )" This opens up the report, but the records displayed are not the ones defined by the WHERE clause...
  15. Z

    Help needed to filter a report

    I've got a report that i'm trying to filter using two dates.. My form has two text fields that allow you to enter the dates, I then use the docmd.openReport Where clause to open the report based on the selected dates "(((tbl_Change.Date_Start) Between " & Me.frm_Reports_Date1 & " And " &...
  16. Z

    Question regarding query table access

    Hey, I have a split database that multiple users will be accessing, and am looking at ways to maximise performance. I was wondering if somebody could tell me how often a query accesses the tables it is linked to. ** The following may be way off base and completely stupid, so if im going in...
  17. Z

    Question about table access

    Ok, this maybe a really stupid question.. Operating on a split database.. If I have a table with a bunch of values, say Department names for example. If I create a query and fill it with the contents of the Departments table, does references to that Departments query access the backend at...
  18. Z

    Help with designing some tables

    Sorry, I was just trying to simplify my case.. I should be able to modify what you gave me yes. :) How would I go about refrencing all the secondary contacts? as in if user1, user2, user3 were the secondary contacts, how would i extract them to build a list?
  19. Z

    Help with designing some tables

    The family case was just meant as a simple example.. the real situation is a factory with different departments, and i need to be able to assign a manager, and then a group of contacts that are only there for notification.. In my db, if a change is raised and requires approval before it...
  20. Z

    Help with designing some tables

    Hello, I currently have a database thats working ok, however its not as efficient as it could be, and certain changes (which will be happening more often in the future) cause a lot of hassles, so i'm looking to redesign this certain area. I must admit my knowledge of table design and...
Back
Top Bottom