display on form

i have table 1is perdiem primary key is empnbr table 2 is Employee with 
empnumber. I want to display the name of the employee on the form when  their 
empnbr is input. When i created the form i used efirst and elast from the 
employee table and it displays correctly.
Problem is it will not add records in the form view. I have looked at 
allowaddtions allowdeletes etc and all say yes. What am i missing?
0
Utf
2/18/2010 5:04:01 PM
access.forms 6864 articles. 2 followers. Follow

1 Replies
856 Views

Similar Articles

[PageSpeed] 26

Perhaps something in this link will help. http://allenbrowne.com/ser-61.html

jmm1954 wrote:
>i have table 1is perdiem primary key is empnbr table 2 is Employee with 
>empnumber. I want to display the name of the employee on the form when  their 
>empnbr is input. When i created the form i used efirst and elast from the 
>employee table and it displays correctly.
>Problem is it will not add records in the form view. I have looked at 
>allowaddtions allowdeletes etc and all say yes. What am i missing?

-- 
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

0
ruralguy
2/18/2010 7:18:59 PM
Reply:

Similar Artilces:

Additional lookup for contacts on opportunity form
Hi, I try to customise CRM 3.0 without any training - therefore a question for which I need some help. On the opportunity form exists a look-up (potentional customer) for contacts/accounts. I'd like to add an aditional one to the form (to replace the decision maker). I tryed to create a new field on the opportunity entity but there's no field-type "look-up". It's also not possible to create a new relationship to the contact entity (both system entity's). Does anybody of you know how I can do this? (if yes - please explain it more detailed...). Thanks Joerg Look...

Forms 07-27-07
Hi, A VB Code is used that has the following line: Me.Visible = False (Me refers to the forms names frmBirthsearch) After this line a second form (form2) is opned based on a query that reads two dates from the frmBirthsearch using the line code: DoCmd.OpenForm "frmBirthdates", acViewNormal at this point frmbearthsearh is hidden. What command shold I add after this in order to close the frmbirthsearch? ...

Displaying MS Excel Chart control in ASP.NET Application
Hi, We are working on an ASP.NET (VB.NET) application. In one of th screens of our application, we need to show a graph and for this we ar using MS Excel Graph control. We have the graph prepared in Excel. Th application would feed in certain values into certain cells of th excel file and the graph would be drawn by the graph control based o these cells. We need some help on how exactly to display the excel graph contro directly on the screen of ASP.NET application. Thanks for the help oursm -- oursmp ...

Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for a general word forum and could not find one. Please point me to one if one exists. I am trying to create a form where I want to specify what items need to be filled in. (Review minutes from design reviews). I want to make certain fields mandatory like the date, attendees and check list used and want to block saving of the document with a warning until they are filled in. Is there a way of doing this? Also as a part of the review actions are filled in to a table. depending on how many actions there are the table...

Error 2455 Closing Access 2007 database with form open
I have a form with a subform that is requeried when you select a new key for the main form from a combo box. Everything works fine - usually. But sometimes if you have the form open when you close the database down you get the following error message (twice) in a pop up. You say OK (twice) and the database closes OK "2455 you entered an expression that has an invalid reference to the property form/report" If I close the form before the database I never get the error. If I do not touch the form before you close the database I don't get the error. If I update a field by t...

Display Report Header/Footer
Can somebody please give me the telephone number of the smartass MS VP who came up with the bright idea for the Ribbon so that I can call her and have her tell me how to display the Report Header & Footer in a report? Obviously, I must be an idiot because I can't figure out how to do it with this simplied, intuitive, help-ya out m***** fu***** ribbon. Oh stupid me, its under 'ARRANGE'. How idiotic of me to think that it'd under 'DESIGN' since I'm 'designing' a report as opposed to 'arrangeing' a report. "microsoft"...

obtaining data in text form from a table
Hi all, I like to be able to obtain the dates in a text format from the table below. ie Test2 8-Feb Test5 4-Feb,8-Feb Test6 4-Feb,5-Feb, 9-Feb Do I need to do this by macros and if so, any help would be appreciated. Table Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb Test1 Test2 8-Feb Test3 Test4 Test5 4-Feb 8-Feb Test6 4-Feb 5-Feb 9-Feb Vlookup should do what you want, as in: =vlookup(a2,Table,2,false) Adjust the ranges t...

forms and column lengths
Is there a way to have excel do an auto "carriage return" to the next row when you have reached the specified maximum number of characters in the row above?? Hi there's n o bulit-in feature for this -- Regards Frank Kabel Frankfurt, Germany "Blair" <Blair@discussions.microsoft.com> schrieb im Newsbeitrag news:C1D2CAAD-C4E9-492A-ADF4-CBDB659514A3@microsoft.com... > Is there a way to have excel do an auto "carriage return" to the next row > when you have reached the specified maximum number of characters in the > row > above?? ...

OWA Premium Client Not Displaying Correctly
Hello, I wonder whether anyone has seen this problem before because i would really appreciate any help on this one please. I have six Exchange 2003 servers in my organisation and there are two Exchange servers in three sites. Four of the Exchange servers are running Windows Server 2003 and Exchange Server 2003 [With Exchange SP1]. The front-end server is running Windows Server 2003 SP1 and Exchange Server 2003 SP2. Users with mailboxes on those four Back-End Exchange servers do not have any problems using OWA. The two Exchange servers on my site are using Windows Server 2003 SP1 with Exc...

Enable/Disable a Form Control Based on Security Group Permissions
How do I enable or disable a control in a form based on a user’s security group membership? For example: If I have a checkbox on a form (call it box1), I want box1 to be enabled if the user who opened Access is a member of a security group called “Breaker Test Admin.” For members of any other group (except of course “Admins”), box1 should be disabled. Thank you, for your help! On Mon, 02 Jul 2007 18:57:13 GMT, "BenS" <u35527@uwe> wrote: >How do I enable or disable a control in a form based on a user�s security >group membership? For example: If I have a checkbox on a ...

Trying to Create a pop-up form
Due to size limitations on my main form, I am trying to create a form that, when I select a button, it pops up like a dialog box with the main form, Frm_Escheat, in the background I've created a qry which is the record source on my pop-up form. In the criteria of the query is: [Forms]![Frm_Escheat]![statecode] where [statecode] is the field from the Master Form. So, my "pop-up" form is activated when I select the button, but my problem is that it just goes to the pop-up form without the main form showing in the background. Thanks for your help. It would probably hel...

Auto Fill a Textbox in Form
What is the simplest way to auto fill a textbox (in a form) with the maximum values of more than one field in the last record entered, in the same table? Can the =DMax function be used for this? I have tried =DMax(“[field_1]”, “[field_2]”, “[field_3]” , “table_1”)+1, but this doesn’t work. Is something like this possible with two or more feilds with DMax? Thanks -- Message posted via http://www.accessmonster.com See MinOfList() and MaxOfList() here: http://allenbrowne.com/func-09.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allen...

user forms #5
Hello, I have created a user form (click on New Employee). How do I get the information entered in to this form to appear in the correct columns in the Payroll data sheet? And how do I get the combo boxes to display the drop down information from the sheet called input. Regards Runner77 -- Runner77 ------------------------------------------------------------------------ Runner77's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30388 View this thread: http://www.excelforum.com/showthread.php?threadid=500502 ...

Adding GAL users into a custom form
Hi, I have created a custom form, and am required to add a series of approvers. What I am trying to achieve is: * Add users from my GAL into a text field, so that when the form is sent, they do not get initially CC'ed the form. Is this achievable, and if so, how do I do it (if you could help by including any appropriate code, that would be great). Regards, Rick ...

display result of formula
How do I make a cell which contains a formula display the result of that calculation rather than the formula (it is formatted as "number" and I have tried "recalculating") Peter Peter Chadbund expressed precisely : > How do I make a cell which contains a formula display the result of that > calculation rather than the formula (it is formatted as "number" and I have > tried "recalculating") > Peter Change the cell format to 'General'. Redo the formula. Change the cell format to 'Number' and apply your display preferenc...

User Form Formula ?
Hi On a user form I have 2 Text Boxes in which to enter cash figures Excluding TAX - on the worksheet these 2 figures enter columns E & G - in column K I have the formula =IF(SUM(E3+G3)=0"", SUM(E3+G3)*17.5% - If I create a new Text Box on the user form could it generate the Tax as the formula above and then on clicking Add Iformation Button it would enter column K thus doing away with the formula in column K on the worksheet which is sometimes altered by mistake. Any help much appreciated Cheers ---- Mully Yes, you could add TextBox3.Text = Format(CStr((Val(Tex...

How to change form detail section height?
Hi All, This ought to be simple, but it's stumping me. I have a form (Access 2002) with a form header and footer and detail section. I have a combobox and label I want to have appear and disappear based on the setting of a check box. I also want the detail section to shorten up when I hide the controls. When hiding the controls, I set their 'Visible' properties to False, then set their 'Top' properties to 0 to get them out of the area to be shrunk. Finally, I set the detail section's 'Height' property to a smaller value. To bring them bac...

Display all messages?
Is there a way in Outlook 2002 to display all messages from all folders in one list? We have managed to end up with duplicate messages in multiple folders, and the best way to clear them out would be to see all messages together in one list sorted by subject or author. I can do that where I work with Lotus Notes, and I hope I can do that with Outlook, but I haven't found it. Thanks, Jack Jack B <jbruss@wi.rr.com> wrote: > Is there a way in Outlook 2002 to display all messages from all > folders in one list? We have managed to end up with duplicate > messages i...

How come an HTML image won't display?
The image in the following HTML paragraph will display a logo for most people her. But for one person, she just gets a red-x. This happens only very intermittently. She can usually see images OK. <p class=MsoNormal><font size=3 color="#1f497d" face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><img width=275 height=92 id="Picture_x005f_x005f_x005f_x005f_x005f_x005f_x005f_x0020_1" src="cid:image001.jpg@01C99288.6B9B30B0" alt="KTB_usa_Megatron_logo_RGB"></span></font><span class...

Form Problem 01-07-08
I have a form setup with several items bound to certain fields in the database. How do I stop my form from adding a new record each time the form opens. I only want the record saved when the user hits the save button. Hi, on the form's data tab on the property sheet, set the Data Entry property to No. Jeanette Cunningham "CribbsStyle" <cribbsstyle@gmail.com> wrote in message news:48c1d1e7-0e2f-4819-b30b-da5e4fe5cbc8@r60g2000hsc.googlegroups.com... >I have a form setup with several items bound to certain fields in the > database. How do I stop my form from adding...

HTML email forms reformat to plain text
I use Outlook 2000 in IMO mode. I am attempting to save email messages as forms using the Forms/Publish Form As process...publishing the forms to the Personal Forms Library. The email message forms are composed and published in HTML format. But, when I open them they are converted to Plain Text. Any thoughts/solutions?!? Thanks. ...

How to prevent form from closing
Hello everybody, I use a modal popup form to enter data in a db on which there a 2 buttons "save and close" and "cancel". I'd like to prevent the from from closing through the "X" button on the top left corner with unwanted/incomplete data. Do do that I trap the use of these buttons in before update event so in the else case I put a warning msgbox (vbOKonly) and cancel = true to prevent any other event. So far so good. After this event an extra message of Access advises me that the record can't be saved and if I want to close anyway the form...

Should I base my report on a form or a query?
I've created a database for a project at work that will track production and piece work. I've started with two tables: Employee Data and Weekly Data. These two tables contain the information that supplies my Form (also called Weekly Data) with the data it needs to pull from. This form allows supervisors to enter in daily production data for each employee. They enter in the employee's clock number and it automatically generates the employee's name (which is pulled from the Employee Data table.) The code I used in the employee's name text box is: = [Clock Number].Colum...

Closing and re-opening forms on exit
Is there any method that when i exit a field on a form, that i canon the exit button tell the form to close and automatically reopen again. I use an "Udate" command in the form, and i need to write the date before i go to the start of the form again -- Many Thanks Kevin On Sun, 21 Oct 2007 17:02:00 -0700, Kevin wrote: > Is there any method that when i exit a field on a form, that i canon the exit > button tell the form to close and automatically reopen again. > I use an "Udate" command in the form, and i need to write the date before i > go to the start o...

Display Images in Outlook Automatically.
Hi, I want to send an email newsletter. I don't want the images to be blocked when the subscriber opens the email as by default all the images are blocked if my email address is not in the address book and user needs to right click on it to download the images. I want to avoid this situation. Please let me know how to do this. Regards, Naveen Bhatia You can't control that from the mail item. It's an end-user setting in the Outlook client "Naveen Bhatia" <naveenb@trisoft.net> wrote in message news:%23Y%23ZEyBxFHA.916@TK2MSFTNGP10.phx.gbl... > Hi, >...