Search results

<phew!> Okay... I guess I wasn't clear on my question...<whoops!> Ok, here is my question. What I want to do is: Select an option from a drop down or combo-box By selecting from the combo-box I want to create a new record in a table that is NOT being accessed by the form I am using. Let me...

No no no...I appreciate your help! I was just 'trying' to say that my question has two parts. Part one you took care of... I'm sorry I didn't acknowledge that in my post... But it was the question, "How to assign employees to projects?" You gave me the answer on that one! MANY MANY THANKS...

3 Different Locations - One Great Taste I did check it. The thread you sent me to had no answer to my question. I posted there then realized that that was probably a dead thread and I should move it to another position. So yes, it is in three locations, but only one is gonna get noticed. And...

Ok... I have Three tables, I am going to give an example and hope someone can help. Table #1: [tbl_Employee] Table #2: [tbl_LINK_EmployeeProject] Table #3: [tbl_Project] Ok, in Table #1, I have three fields. #1) Employee_ID (This is an autonumber field, primary key) #2) Employee_Name...

Many-to-Many / Front-End / Add New! I posted the same basic request on another forum and got nowhere. Let me see if my wording asks the same question and whether anyone can help me here or not. Ok... I have Three tables, I am going to give an example and hope someone can help. Table #1...

Many-to-Many I did create a Many-to-Many relationship by creating the LINK table. Now I need to know how to drop a new record into the LINK table carrying the Project_ID from the currently open Project and the Employee_ID from the drop-down/combo-box as the two entries. Can someone help? I...

Ok... I have Three tables, I am going to give an example and hope someone can help. Table #1: [tbl_Employee] Table #2: [tbl_LINK_EmployeeProject] Table #3: [tbl_Project] Ok, in Table #1, I have three fields. #1) Employee_ID (This is an autonumber field, primary key) #2) Employee_Name #3)...

Thanks I haven't had a chance yet to try it out... But that looks right! Thank you so much...

WOW! This new setup is sweet...! Ok...on to my query... I have a form...[frm_Request] I have a two text boxes...[txt_FolderName] - [txt_FolderLocation] I would like to do the following... Have the user enter what name they want their Folder to be in the [txt_FolderName] text field. Then...

I have a three listboxes: Listbox_1 Listbox_2 Listbox_3 They are on a form that lets me pull up recipes. Listbox_1: Is populated with every style of cooking (Romanian, English, American, etc.) Listbox_2: Is populated with the mealtimes preferred with these recipes (lunch, dinner, snack...

Can someone do me a favor? I want a line of code that will do the following: 1) Close the open database (it is a front end for arguments sake). 2) Goto a specified location on the server (using a mapped network drive and if you can, what is the coding to go without the mapped network drive)...

Ok... Here is my conundrum... I am creating a db that lets Role-Playing Gamers put together an adventure with a few clicks of the mouse and a printout versus the hours that it normally takes. So, with my explanation upfront here goes... I have a table... [tbl_Themes] <ThemeID> - Autonumber -...

Ok... I have three text fields...unbound... I labelled them correctly... txt_ProjectNumber txt_ProjectEngineer txt_Firm Now, JUST in the testing phase, I open the form... I goto criteria in the Query in questions... And I build the criteria... I point the criteria to the individual text boxes...

I have never used Access for labels... However, I HAVE used WORD... You oughta try word using a MailMerge... Works wonders...And you can put the spaces wherever you want them...

Here is my connundrum... In my report, there is a section called Design Details...Well, if the record/project is a City Project then there are certain fields used...if it is a Contract Project, then again, only certain fields are used... Some fields are shared between, Like for instance, both...

I have created the code to turn certain fields invisible based on a single field... Now my problem is I have HUGE blank areas where those fields are invisible...How do I make those blank spaces go away...? Can anyone help me...?

I figured it out... No need to answer now... Thanks anyway...

Here is my code... I want the fields to NOT JUST disappear, but I want they space they take up to go away as well, as if they had shrunk...How do I do this... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim Sweep As String, Keep As String Select Case PSRTYPE Case Is =...

Put it in a section of it's own? Do you mean under grouping/sorting...? If I create a group I have to name it... If I name it, it is considered an expression, and therefore needs to be filled with a variable... OR If I don't name it but assign it to a variable, then the report will sort by that...

And that is what I did... But I was considering having another field update the [PSRTYPE] field, and then it won't recognize the afterupdate (if done from VB) so I was trying to find another solution... I went ahead and did it like you said, that was my original experiment, and I left it so that...