Search results

Access wants a carriage return AND a line feed to create line breaks. Try =[First Field] & Chr(13) & Chr(10) & [Second Field] etc.

If Case Numbers is an AutoNumber, then it is not a text field. Try "dim temp as Variant" instead.

Email me directly at axis@lunatrix.com, and I'll help you figure out what's wrong.

Here's a function that I designed to work with addresses. It watches for things like RR or directional indicators like NE, NW, etc. It's not the most elegant code in the world, but it has worked quite well in a database where they enter dozens of addresses every day. Put the function in a...

Access works with variables pretty much like any other control. To assign the value of the combo box to the variable, put the following in the AfterUpdate property of the combo box: [Variable] = Me![Combo Box]. You can assign the variable to any text box using the reverse of above: Me![Text...

What about combining more than one field name in a single text box? For example instead of 2 boxes FName & LName, just put one box with the control source set to: =[FName] & " " & [LName]. You can do the same with address info: =[Address] & ", " & [City] & ", " & [State] & " " & [Zip].

How about something like this: In the AfterUpdate property for Field A put Me![Checkbox].Value = True Me![Date Field] = Date() This works if all of the fields are on the same form. Otherwise you'll have to use the Forms![Form Name]![Field Name] syntax.

In Access 2000 you can set the default cursor behavior under Tools/Options/Keyboard/Behavior entering field. Just click on "Go to end of field". If you don't want the cursor to jump to the end of all fields, select the particular field you want and in the "On Got Focus" property insert the...

I believe that COUNT is a simply function that does not permit criteria. Try using DCOUNT instead. There are good instructions and examples in Help.

use this sentax instead =[Forms]![Main Form]![Subform Name].[Forms]![Subform Field Name]

I have a form that lets users select criteria and creates a query that includes email addresses based on their input. I want to be able to take the email addresses and have them automatically transferred to an Outlook message form. I'm moderately knowledgable about VBA but can't figure out how...

just add together the fields. Example of a balance field control source: =[debit]+[credit]) make sure to use the actual names of the fields in place of [debit] and [credit]

Use the DCount function to count the number of records returned by the query. If the query comes up empty, a message box pops up saying no records found (or whatever you want it to say). Here's some simple code that you can put in before you open the report...

You don't want to look at the form, you want to look at the table. Essentially you create a query to search for the data you want, then use the DCount function to count the number of records returned by the query. If the query comes up empty, a message box pops up saying no records found...