| Thread | Last Post | Replies |
|
| I HAVE NO IDEA | 13 Sep 2007 01:57 GMT | 3 |
WHERE CAN I FIND THE POP3 NUMBER??
|
| Add Code needed! | 12 Sep 2007 23:52 GMT | 2 |
- - If I have four text boxes on my form tbA,tbB,tbC,tbD what code do I need for tbD to add the other three totals into tbD
|
| @ symbol in access 2007 text field format property | 12 Sep 2007 23:12 GMT | 1 |
When I import a worksheet from Excel 2007 into Access 2007, the text fields all have an @ symbol in the format property. Can anyone tell me what the @ symbol means? I haven't been able to find any format references to that particular symbol.
|
| look up data | 12 Sep 2007 22:27 GMT | 1 |
I want to be able to pull data (multiple fields, i.e. last name, first name, ssn, etc) from one table to another based on a selection from a look up list????
|
| Null Values in a Query | 12 Sep 2007 22:26 GMT | 1 |
I have a query that counts the number of times a person sells a spcific unit number. What I want it to do is assign a zero value to anyone who does not have that unit number sold in a one month period. How do i do that?
|
| Microsoft Graph 97 Chart | 12 Sep 2007 22:25 GMT | 7 |
We've upgraded our app from Access 97 to Access 2003. The app crashes (compiled version only) whenever a user opens a form containing the Microsoft Graph 97 Chart control. It works in the uncompiled development version. I only have Access 2003 on my machine, so I am wondering A) ...
|
| if first letter is not a \ | 12 Sep 2007 21:37 GMT | 2 |
I need help with an if statement in a query. if the first letter of the field "photo" is not a \ then call the function "fgetUNCPath" else do nothing
|
| Basic Database Design Question | 12 Sep 2007 21:32 GMT | 5 |
I'm setting up a new database with access 97. It will include several daily extract files (excel format) from several old mainframe machines. I have several ideas on how to do this, but none of them address the
|
| Union query garbles ID field | 12 Sep 2007 21:30 GMT | 3 |
I can't figure out why this happens. In some of my union queries, an ID field gets garbled and displayed as a non-western character, or a box shape of some sort. It's like it's encoded? Does anyone know why this might happen? I can post back with table & query descriptions.
|
| Emailing from a query | 12 Sep 2007 21:21 GMT | 3 |
I need to send emails from an access database, but I want to send them from a query so that I only email the cetian people. Access says that it can't send an email from a query. Any ideas?
|
| Query with criteria | 12 Sep 2007 21:06 GMT | 2 |
I am creating a query of training classes whihch includes a field called grades. I only want to display the grades of below 74%. I thought I would just type "Between 0 and 74" and it would give me only those people with those grades. Have I labeled something incorrectly?
|
| Update and Create New Records | 12 Sep 2007 20:27 GMT | 14 |
I'm working on a database that has a table linked to about 16 other tables in a one-to-many relationship. What is the best way to update and create new records in my situation? If been trying to create a form for this, but the wizard crashes before
|
| 6 Character String to Date field | 12 Sep 2007 20:26 GMT | 6 |
I've looked through the posts but I can't find a suitable answer. I've got a field that is a 6 character string (September 12, 2007 would look like 091207) and I would like it to be some sort of field and type that is searchable in a query (ie find records that are between this ...
|
| Emailing from a query. | 12 Sep 2007 20:21 GMT | 1 |
William5271 had the same question I do: I need to send emails from an access database, but I want to send them from a query so that I only email the certian people. Access says that it can't send an email from a query.
|
| Command Button | 12 Sep 2007 20:09 GMT | 2 |
I'm trying to create a command button that by default will lock records in the form, and will only allow edits after it is clicked, to avoid unnecessary mistakes. In other words all records are locked until the user clicks command button to edit.
|