Recent content by meddling

Now I was able to display the name how I wanted. But there is just ONE problem. The information is not being saved on that field. I have a FirstName field, a LastName field and the third field is the DisplayName. Under the design view, on the DisplayName field, i replaced what was on the...

I am thankful for both of your replies but I do not know what dRahme is refering to. I am not a MS Office Wizard. I'm not sure what query he is talking about. Is it the query tab where you wanted me to add that Fname information? I do know how... When he said try combining the LastName and...

I am developing an Access Database and I am having some trouble displaying NAMES a certain way. I have a LastName field and a FirstName field, then i created a DisplayName field, and I wanted it to display the following: "LastName, FirstName". How do I do that? I tried to convey that on the...

I figured it out... The line below was supposed to say the Main Form as opposed to the button form NOT: [Forms]![Direct Deposit]![EmployeeID] YES: [Forms]![Employeefrm]![EmployeeID] THANK YOU SO MUCH FOR YOUR ASSISTANCE!!! IT WAS INDISPENSIBLE!!!

Yeah... I'm gonna double check everything again... I'll get back with you... Thanks for all so far...

I have 3 tables that I will use as forms. I wanted to display the main table including 2 buttons that would open the other 2 forms. On Table 1 I have a EmployeeID field, set to Autonumber, Indexed (no duplicates). One Table 2 (which would correspond to the first button) I have more information...

was the last expression supposed to look something like this? =[Forms]![Direct Deposit]![EmployeeID_EmployeeID] or =[Forms]![Direct Deposit]![EmployeeID] here's how i wrote the first one i added to the code: stLinkCriteria = "[EmployeeID]=" & Me![EmployeeID] I beg that you can help me work...

I removed it. Still doesn't work. I can enter information but it does not save the information. I have left the line you told me to add to the code. Is that correct?

I did everything just the way you said it and it didnt work. I get this message that says "You cannot add or change a record because a related record is required in table 'Employee'. You haven't mentioned anything as far as how I set up the relationship betweens those tables. Could you clarify...

I have 3 tables that I will use as forms. I wanted to display the main table including 2 buttons that would open the other 2 forms. On Table 1 I have a EmployeeID field, set to Autonumber, Indexed (no duplicates). One Table 2 (which would correspond to the first button) I have more information...

I have 3 tables that I will use as forms. I wanted to display the main table including 2 buttons that would open the other 2 forms. On Table 1 I have a EmployeeID field, set to Autonumber, Indexed (no duplicates). One Table 2 (which would correspond to the first button) I have more information...

Hey there! I thought about using subforms, but I didn't want all the information ALL in one page. I wanted part of it displayed when you open the database and 2 little buttons corresponding to the 2 other forms. I do have en employee field in the other 2 tables, set to number, not indexed...

I am trying to create a fairly simple database and I'm having such a hard time. I have 3 tables that I will use as forms. I wanted to display the main table including 2 buttons that would open the other 2 forms. On Table 1 I have a Employee field, set to Autonumber, Indexed (no duplicates)...

I hope I can illustrate this well enough in plain english and I appreciate your help ahead of time! I am designing this database where I have 3 main tables. First table is to register all my employees, Second table is to register the organizations we do business with, and the Third Table, I...