Search results

I am struggling with a form issue, and I thought I would see if anyone might be able to take a look. the zipped up db is at my geocities site: pagejumping.zip If you add a candidate, and then give them some addresses and phones, its all good. You can tab through nicely (from salutation...

I tried to put some text into the controltip text of the properties of a command button. I tested it out and nothing happened. I have the status bar text, but I want the text tip that hovers when I mouse over. I looked all over and found stuff on putting it in code. Not what I wanted...

I actually found that I did not have all of the joins defined in the relationships. I need to have ALL of them defined. Then I split up the query. I have 1 query for applications, and one for activities. Then I put those together into 1. Now my report is great! :D

I have a database in 3rd normal form ( or pretty darn close) I have all of my reports working well, but the main report is having issues. This is for candidates applying for jobs. This report will come from a form where the user chooses the candidate that they want to report on. I have the...

the bad part of my advice is that you have to hard code the choices into the backend. This means that if the county list updates, you will have to update the code. Here is why. The code that I would think would do this, looks at the list box (onchange/afterupdate) to see what choice was made...

I'm sorry I probably won't be too helpful, but it seems that this shouldn't be too hard. I would think that this could go into code on the form's back end. It might go in the form current, or before insert. You might have to play with where to put it. I would put some code that would be...

ps, you said I was lucky... I am using test data lol. I know better than to go live when troubleshooting the creation of an app. :D

Thanks. I actually got some code to work. I just have to test the heck out of it now. I want to lock the primary checkbox, because I don't want the user to be able to change it. They have to consciously make the decision that they are changing the primary address used in mailings and such...

I am so close! It works great at checking the current box and all, it is just not deleting the other check that was checked ( on the other address record for that candidate) Private Sub lblclick2changeadd_Click() On Error GoTo Err_lblclick2changeadd_Click Dim Msg, Style, Title Msg =...

I got that code working : Private Sub cmbAddressTypeID_AfterUpdate() On Error GoTo Err_cmbAddressTypeID_AfterUpdate If DCount("*", "tblAddress", "CandID = anCandID") = 0 Then Me.lblclick2changeadd.Visible = False Me.chkPrimary.Locked = False Me.chkPrimary = True ElseIf DCount("*"...

1) I found that the onload and current do cause problems. When there is a dcount in there, something funny happens. If I click next on the navigation bar, the records go up and up and up. Like there is no end. Even though a record ( candidate record) had no address records to it. Now I just...

Thank you, Pat and Alexei. I don't know if the onload is not needed, but the example you attached works perfectly I will try to implement this and see if I have any problems on my db. If need be, I will attach what I have. Since you were so great at this problem, maybe you will understand...

I have this normalized database, and I don't understand why setting up the forms is so hard for me. I have the main candidate entry form. This is to enter in candidates who apply for a job. I have a tab control with a page that shows if the candidate type is 1 of a few types ( in code)...

I had thought about that second method, but I kept coming back to one issue. I don't want a lot of things stopping users as they work. These users know what they want to enter. I thought of this. What if the checkbox would check afterupdate if it is the first address, and if it is the second...

ok, I will go into more depth. I have been working on just informing the user with a label that would be hidden until more than one address is checked as primary for one candidate. It is being recommended, however, that I lock down the control, so that the user can't just walk away. here is...

Here is the issue that I need to resolve here. On my candidate form, I have subforms for addresses and phones. A candidate can have more than one type of each. What I have here is a checkbox for the primary address on the form, in the table. I need to lock down some code that will only allow...

Well, I have look around everywhere and it seems that there is no fix. There is no way around this. I am going to have to make the forms single, and then use navigation buttons. From there, I will just have to make an add record button, and I do plan to have a quick report for this candidate...

:confused: I have a form for candidate entry. Then I have a subform for their application. Then I have a subform in that for the activities that pertain to that application. Here is a screenshot of what I am trying to debug: http://www.geocities.com/misscrf/images/continouscomboissue.jpg...

Hi, I'm back. I got an answer to my tabbing question. On Error GoTo Err_txtZip_Exit Forms![frmCandidateEntry]![frmPhoneEntry].SetFocus Forms![frmCandidateEntry]![frmPhoneEntry].Form![cmbPhoneTypeID].SetFocus Exit_txtZip_Exit: Exit Sub Err_txtZip_Exit: MsgBox Err.Description...

I looked at your post, and I have seen others. I think I like the idea of doing an on exit code from the last tab stop field, to the first tab stop field on the next subform. Problem is I can't seem to figure out the right code for referencing a field from one subform to another.... Here are...