Search results
-
B
Opening to correct record
Hi I have this code set up in order to close one form and open another form, at the correct record: Private Sub FirstName_DblClick(Cancel As Integer) Dim stlinkcriteria As String Dim stdocname As String stlinkcriteria = "[ContactID]=" & Me![ContactID] stdocname = "frmContacts" DoCmd.OpenForm... -
B
Desperately in need of help
Hi I am in the process of finishing off a database and was wondering whether I could seek some assistance to problems which are driving me mad. I have has some very helpful responses from the forum and I am very grateful for them. I have 2 remaning problems and would be so appreciative of... -
B
Help with linking forms. Thanks!
Hi When I change from my company screen to the contact screen, i have managed to get it to opne the contact form with the contact details from the previos screen. This is in my code to do this: stLinkCriteria = "[ContactID]=" & Me![ContactID] stDocName = "Contacts" DoCmd.OpenForm stDocName, ... -
B
Data disappearing
Hi Can anyone help with these 2 small problems? 1. I have data in an address subform on a contacts page. All is well until I change it to 'data entry:yes' (in order to add a contacts details) and then all the data disappears... 2. On the same form, I have a drop down box with company names... -
B
Combo box turns into numbers
Hi I have a combo box which shows a list of company names from a company table. All works fine until i choose not limit it to the list (so I can add to it, when I add a new company), and then it shows numbers instead of company names? Anyone know why this does this? At the moment I can add... -
B
Filtering forms with check boxes
Hi I have a form with 10 check boxes. All put a value into different fields as they relate to different criteria. I need to filter via numerous combinations of check boxes (i.e. to find out which contacts have had a certain letters sent etc) and setting up reports for each one would not be... -
B
Linking address tables
Hi I wonder if anybody can help with this problem. I am setting up a basic contact list, with 3 tables - contact, address and company. What I want to do is be able to add numerous addresses to the company table/form. Then, when I add a contact, I can go to the contact form and select an...