Search results

Thank you Paul for your patience with my ignorance. I think I got the idea, i.e. where to put the code and that I can stack it just as the other example shows. With an Arctic Cold Front and snow in the forecast for the weekend, I will have plenty time to get this working.

Hallo Paul, I looked at the code on your web page. I assume “Some Control” stands for a control/ field name. But, I have several required fields. The code suggested by gemma-the-husky seems to allow me to just list one control/ field after the other. How would I solve this problem of several...

Hallo gemma-the-husky I would like to try the code you have provided. The way I understand it, I only have to substitute my field names for “field1”, “field2”, etc. And, maybe expand the message text. Is this correct ? But the big questions is – where do I put the code? I...

Hallo Thanks for the help and the explanations which I really appreciate. I got the Conditional Formatting working. I do not know what happened when I tried it the first time but, my selections and the expression I typed did not stick. I was quite surprised when I tried again today and...

Hallo Thank you for the quick and detailed reply. It gives me a far better understanding than I had before. Now, I am finding that I cannot get the Conditional Formatting to work. The standard error message appears but no colour shows in the text field. Here is what I do: I...

Hallo I am confused as to which route to follow. I have a tabbed form with a number of required fields scattered over several tab pages. Therefore, I want to make it easier to determine where the required field that has been missed can be found. (1) The following link/ article...

Thank you everyone for the advice given. Creating a join query and basing my form on that query did the trick. I entered the expression into the unbound text box. And, the text box is now updated each time a new record is selected.

Thank you everyone for the advice given. I created a join query and based the form on the query. Then I typed the expression into the unbound textbox and now it works fine - each time a new record is selected to unbound textbox is updated.

Hallo, thank you for trying to help me. (1)Originally, I typed the expression directly into the text box and when I check the property sheet I find that it ended up in the Control Source property. (2)As suggested, I removed the expression from the Control Source property and entered it...

Hallo I have a Form “Call-Log” where I want to display the Contact name for the current record prominently in the upper right hand corner of the Form. This Form is based on the table Call_Log. The table Call_Log is linked to the table Contacts where the contact names can be found. I...

Hallo JR thank you for the link you posted. It's the "missing manual" so to speak. So far, I have been able to put the calendar on the form. I hope, I will can manage to bind it to the date fields and add the popup quality as well. I may be back with questions about the code needed to make it...

How do I get Microsoft Calendar Control 11.0, Location C:\Program Files\MS Office\Office\MSCAL.OCX installed into a MS-Access 2003 Form? Here is what I do: Tools menu/ Active X controls/ Calendar Control v. 11.0 Then I click Register On the next screen: File...

Hallo Simon I believe my question is poorly worded. Let me explain what I want to use the two fields for. Then it might become clearer what my worries are. The email field will be used for: (a)(Email) Mail Merge where MS Word directly accesses the data in Access (b)Batches...

Hallo Simon, can I copy and past this code as is and where would I paste it? I do not have a clue what it means or what it does - let alone making any adjustments. Also, I am wondering if there are any input masks for hyperlink fields to ensure the user will enter a complete address ?

Hallo, I am working on a relatively simple contacts database. However, I have not much experience with data entry into Access (since it’s a volunteer assignment this has been accepted). There are two hyperlink fields in my main table: Email address and Web Site. I have done some Google...

Hi, thank you for your help. I ended up deleting the two tables and putting three repeating fields into the contacts table. Not perfect but, at least that is something I can understand. No offense meant, but 1 or 100 lines of code is all the same to me - just like a foreign language. I had...

Sorry, the table I had created disintegrated when positing it. Trying again: Link Table: PK = Link Table ID Column # 1 = Contact ID (FK) data row 1: 01 data row 2: 01 Column # 2 = Contact Type ID (Fk) data row 1: Board Member data row 2: Donor

Hi, I did look at the link. It’s all programming code. Which more or less confirms what I discovered with the Google Search. When the List box is set to accept more than one choice, the value is Nil. One has to write an entire program to query those choices and convert the choices into...

Hi, I did a quick Google search for list boxes. It appears, it requires a heavy dosis of VBA programing to make use of list boxes - soming I cannot do (and I do not have the time to spend months learning how to program). Here is a clipping from a another forum that neatly sums it up: Q: Is...

Hi, I am creating a contacts database in ACCESS 2003. Currently, I have 4 tables: Contact Details, Call Log, Event Schedule, Event Attendance. The problem is with one field in the Contact Details table. On the data entry form, the field (a combo box) is called Contact Type. 1 person...