Search results

First, let me apologize if I should offend anyone in my reply. I realise that both the Doc Man and Pat Hartman are more experienced than myself. I am going to provide a bit more detail for clarification purposes. Yes, I had the Basic Info setup first. If I truly need that as a parent table...

No. That only works part of the way.

I have been struggling with this idea for over a week. I think that I may have a one-to-one table setup. I can't quite get it to work the way that I want though. This will track EMS personnel. The idea that I have is to list the Basic Info for each person ONCE -- with their last name...

splitting U.S. address for a small number of records I just had to do this for a database that someone else had started. Pat's absolutely correct, it is a bear of a problem. If your data is consistent, then it will make your life MUCH easier. I will share what I have learned. I worked from...

You're welcome! I'm glad that particular topic was covered in the FAQ section because I have to look it up as well!

What I posted should still work, if the unbound text field is called [text32] then that is the field to use in your VB code.

Try this thread, which covers your syntax question. http://www.access-programmers.co.uk/forums/showthread.php?t=66115

You should be able to apply the same formatting to the field exported to the e-mail as on the form. If not, then use an unbound text field where you create the result you want -- like this =Left([phoneno],3) & "-" & Mid([phoneno],4,3) & "-" Right([phoneno],4)

Um, did you really mean text field? I don't think you can sum a text field, so a character '1' may not be <= a numeric 50 If that does not work, try a new post in the VBA section, just include a brief explanation that you may have started this post in the wrong section.

Just got a message from my boss -- NOT to install Service Pack 2 to Windows XP on ANY of our pc's because there are many problems with it. Is it possible to uninstall it? Otherwise, I suggest you check on more details regarding Service Pack 2. Good Luck!

For what it's worth, I had a similar problem -- but in my case the user had spaces in FRONT of the item. It was hard to notice when in a form looking at one record at a time. But, was VERY noticeable when I looked at a report. So, in that case, a find '*whatever*' found it!

You can not update all queries. For example, if a query is based on 2 tables, a Parent and a Child of one to many, then a query with data from both is fine for display or finds, but cannot be updated. The problem is that a change to a field on the parent side would not update to all of the...

To get the sum in the subform for MSN, if the fields are MSNTotal, create an unbound text box with the data source as follows =Sum([MSNTotal]) To get the total left, you have to reference that text box on the MSN subform. So, if the MSN subform is called frmsubMSN and the sum text box is...

I will take a stab at this. If your field is boolean and was called contactme, then something like = IIf([contactme],1,0) Should work. Basically, if [contactme] is True or Yes, then you want a one, otherwise it is a zero. Then, you do a Sum of that field.

In the report, add the field with which you want to break in the Sorting and Grouping section. Make sure to check that you want a Group Footer. Now click on the Group Footer for that field, and change the Format to Force New Page After Section. Note: You don't have to have anything in the...

Import File Specifications Start with the file you want to import, and create an Import File Specification for it. Then, you can create a macro with a step to Transfer Text using that file specification, supplying the name of the file to import (source) and the target or destination. Note...

Check your record source for those calculated fields. The #Name? error is basically telling you that it can't find at least one of those fields in order to do it's calculation. If your subform is based on a query, then your fields in your calculation should be based on the query, also.

Sometimes you can also set the default sort order as descending , if the form allows that. Works great for a form where the primary key is an autonumber field.

Search for records about a running sum. Then, substract the running sum from the original amount.

Now, create an append query using the unmatched query as the source.