Hello folks,
Alright I’m back. So I just gonna lay it out there. I am former Marine Infantryman, and not the brightest bulb in the drawer. So I’m working on a project for a non profit call center that helps homeless veterans find assistance through the various originations that exists. I have attached what I have so far. I am curious if some one with a little more experience could help me with the remainder of this project....
VVSD
Last Activity: Jun 15 '10, 01:58 AM
Joined: Jun 12 '10
Location: San Diego, CA
-
NonProfit project can't be completed by jarhead
-
i have a table named clients, which stores all the clients information. The current form is called clients, after entering their information i hit submit, and it enters the data from the form into the table. I want it to also open up a new form named "open clients" with the information i just entered... -
Ok one more question for the day, I have the following code
for my submit button on my client intake...Code:Private Sub Submit_Click() On Error GoTo Err_Submit_Click DoCmd.GoToRecord , , acNewRec Exit_Submit_Click: Exit Sub Err_Submit_Click: MsgBox Err.Description Resume Exit_Submit_Click DoCmd.Close acForm, Me.Name, acSavePrompt End SubLast edited by MMcCarthy; Jun 13 '10, 01:33 AM. Reason: Added code tags - see the # icon on posting windowLeave a comment:
-
No problems that I can find yet. My mistake, I didnt explain the situation very well. thanks for your help. :)...Leave a comment:
-
I understand that, but I am talking about the possibility that it is seleceted, and it updates the veterans fields with the caller info, then is changed to loved one. I want it to clear the fields if loved one is selected so I used the code:
...Code:Private Sub Combo58_LostFocus() If Me.Combo58 = "Veteran" Then Me.firstname = Me.ContactFirstName Me.lastname = Me.ContactLastNameLast edited by MMcCarthy; Jun 12 '10, 11:26 PM. Reason: Added code tags - see the # icon on posting windowLeave a comment:
-
sorry I am back. so what command could i use to leave the veteran fields empty if loved one is selected in the combo? thanks :)...Leave a comment:
-
Awesome, thank you so much for your help. i got it figured out, I'm sure ill be back soon with more questions. Thanks again have a great weekend.
VR,
MikeLeave a comment:
-
Coding Drop down box to copy information
Hello every one, Im attempting to creat a database for a non profit veteran org. The data base is going to be used in a call center, where they take the callers information and the veterans information. However some times the caller is the veteran. I have a drop down list with values of "veteran;lo ved one" if veteran is selected i am trying to have the name values from the caller section on the form copied down to the veterans info section....
No activity results to display
Leave a comment: