Search results

this works great! is there ayway to actually send it? that code opens the mail w/ the text but doesn't send

it recognises the email addresses...the SOB tells me it wont accept more than one :)

er that's not really my concern. im just trying to determine whether or not this 'exclusive open' mode applies only when the person w/ the db open has it in design mode...

apologies. the line that wont work is: EmailSend.to = "braSndon.paquette@lnd.amedd.army.mil; carolySn.rodgers@lnd.amedd.army.mil;jane.Swild@lnd.amedd.army.mil" the same format fails w/ cc/bcc

ok, so using the code i got from another post in this forum.... Dim EmailApp, NameSpace, EmailSend As Object Set EmailApp = CreateObject("Outlook.Application") Set NameSpace = EmailApp.getNameSpace("MAPI") Set EmailSend = EmailApp.CreateItem(0) EmailSend.to...

so if i, or anyone else, isn't in design mode, it wont lock it like that?

alright, i know this question has been addressed DOZENS of times before, but I've yet to see a definitive answer. i screwed with securities at one point or another but abandon that path. however, now my database randomly opens exclusively, meaning no one can use it... why is this? the...

wow. for some reason it just clicked that i could use several relationships. ack, this is gonna involve some redoing :) thanks again M

lol you must think me a horrible designer based on that! that wassomething i scrapped together in a few minutes, my table is nothing like that :) except for all my data stored in the same table. i've still failed to see a need in my development for a relational database (although i do...

This works great, and in addition to solving this problem this will let me fix quite a few things with my db! thanks mile!

i just saw the syntax error after looking at you working code. there is no . between column and (0) let me try this!

here you go. made in access 2002 and converted.

i can try :) gimme 5 min.

k i'm getting syntax errors with =[cboRatersName].[Column].(0) where in the helps can i find reference to this/ a search yielded nothing...

er i dont nkow that this is working. the row source of cboRaterName lists all the necessary columns with only the name showing. i then reference the other columns as txtRaterTraining's ctrl src via =[cboRatersName].[Column].[Army] with all that done i still ge the #Name? value did i...

oh so the row source of the ratername combo box should have the columns i want to reference? ie grade and ratertraining? and then i can reference them via the syntax you listed? i didn't even know that was possible :P thanks miles i'll post how it turns out!

really that's what i'm doing. qryRaterInfo is the source for all of the txt boxes. When i try to set their control src to a field from the query, it just gives me the #Name? value in the txt boxes. running the query works fine but using it as a control source for txt boxes doesn't work. the...

so i have a combo box with a list of names sourced from my personnel roster. upon selecting a name, it references a query that holds the fields name, trained, and grade. it then populates a trained and grade txt box the criteria on name is Forms.frmPersonnel.cboRatersname i get the feeling...

the problem is that an afsc is made up of 4 elements. prefix, afsc, skill, and suffix. i need a box that stores the full afsc, but i can't use a cbo box with all possibilities (there are just too many) so the only reasonable approach , as far as i can see, is to store a calculated result... i...

ok, for some reason i just now understood namlians previous post about unbound boxes, so i unbound the txt box that received the values, and it appears to work fine. now why doesn't it work with a bound box? how can i store this data in my table?