Search results

I am trying to go to a selected record in the database and e mail it to someone else. How do I do this? Thanks...

I have a database that has been in use for about a month. There is a subform attached to a form and all has gone fine until now. Now when try to enter information in the subform, get the following message that I cannot figure out what's wrong. You Can't Assign a Value to This Object *The...

I want to add a command button that will let the users look for a record by FirstName + Last Name at the same time. The name field is separated not all together. Also I want to lookk up the name as anything close. i.e. Sue, Susan, Susie, etc. Say I want to find Sue Smith. I want the command...

Here's my problem: I have OrgName field in a form. The subform on this form has the actual CtrName field. The CtrName field is only filled in if it is different from the OrgName. When pulling the query for labels, I need the query to pull the correct name (address/city/state/zip will be same...

I have 3 fields, FirstName, MI, LastName. Is it possible to do a find for i.e. Rose Smith and not just Rose or Smith - and then than to scroll through 35 Rose's or 60 Smith's to find Rose Smith specifically? Thanks so very much for your help !!

I have a columnar report that is based on a simple query for name, address, title, etc. Right now, the report is sorting by last name ( I didn't ask it to, it just happened). The powers that be have decided that it's important to have the list sorted by title with each title having a weight...

I am completely stumped and was hoping you could help me. I know I've done this a couple of years ago, but for the life of me I can't remember how I did it now! I have a master dbase that has a table with Name, Organization, Organization addy, phone, email as well as home addy, phone, email...

I need to add another field to a table that has already been created, saved and been in use for a while. I need a field called ContactType - no problem - added it fine. I used the Lookup Wizard to create the appropriate names, either CCP or NAC. Saved the table and went to Forms to add the...

I have 3 databases, NAC, CCP, Master. These weren't created by me, I'm coming in behind and trying to make sense of this. The President of our company wants the NAC and CCP dbases to link to the Master for name, address, phone, fax, email and contact type. All other pertinent information will...

I have created 4 databases for different users in the same office on same network but for different uses. In two of the databases, the labels work perfectly well every time. However, in the other two databases, the first time the 5160 Avery labels are created, they run fine. However, the next...

We imported data from Excel into Access. The dates that were 2003 and 2004 in Excel changed to 2002 when the Access database was opened. This has happened twice. It takes a great amount of time to correct this. Can anyone tell me what happened? I didn't do these imports and don't know if...

I am putting a contract into my access dbase. The variables are no problem, just using fields. However, the basic text that doesn't change is in as a label and is "left" justified. On my original word doc, I used right and left justification which made a very clean looking document. How do I...

Ok, this is an easy one for you *but obviously not for me* I have a field called ClassDate. This is the first day of the class. On the certificate I want the last day of the class to show. I've used =DateAdd ("d", 4, [ClassDate]) and it's perfect. However, instead of formatting mmmm dd...

I can get the long date in properties and it prints out as Saturday, March 2, 2002. However all I want is March 2, 2002. How can I do this? Thanks