Search results

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

Cool.. Thanks for your help :)

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?

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

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

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

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

Checkout the TextStream Object.. It contains a ReadLine method

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.

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

Yeah but it revolves backwards :p :D

*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

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#)

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

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 " &...

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

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

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?

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

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