| Thread | Last Post | Replies |
|
| How do I update a chart based on criteria input? | 06 Oct 2006 03:22 GMT | 2 |
I hope this question isn't too basic. I created a report with a chart based on a query. I would like to update the values on the chart based on a date range and whether maintenance agreement was in effect. The form for the date range criteria works but for some reason when I ...
|
| Crosstab column totals | 05 Oct 2006 17:31 GMT | 5 |
I have a crosstab query TRANSFORM Count(Q_Tasks_SATRs_OS.ID_Tasks) AS CountOfID_Tasks SELECT Q_Tasks_SATRs_OS.Tax, Count(Q_Tasks_SATRs_OS.ID_Tasks) AS [Total Of ID_Tasks]
|
| Access 2007 opening problem | 05 Oct 2006 16:58 GMT | 5 |
Hello, this sounds a bit mad I know but, I can not open any of my DB's in the updated 2007 (b2tr) it just stays on the getting started page. Any ideas? Cheers
|
| Simple Expression - Fumbling Around | 05 Oct 2006 16:37 GMT | 4 |
This is probably pretty simple, but I am clueless. I am trying to write an expression so that a Sum on my report page will default to $100 when the Sum is lower than that. I really don't know much about writing expressions in general. I have this now:
|
| How do you print out details of the file structure of a database? | 05 Oct 2006 16:26 GMT | 7 |
I would like to be able to print out all the details of the database structure. For example: Name of Table Name of Field
|
| Keeping Excel Formatting | 05 Oct 2006 16:03 GMT | 1 |
I have imported an Excel worksheet as a table in Access. This table is used by two sub-reports in a main report. I can't seem to get the formatting right. Where I want 2 decimals displayed I get 4, and in some cases where I want 4 decimals displayed I get 4 and 3
|
| AutoCorrect | 05 Oct 2006 12:21 GMT | 5 |
I have used the TOOLS-AUTOCORRECT and clicked "Capitalize first letter of sentence". The properties of the field are set to allow autocorrect. When I type a name EG: smith in lower case, the s of smith does not Capitalize. Any help would be appreciated
|
| Joining Rows | 05 Oct 2006 03:50 GMT | 2 |
Hi all I am very inexperienced at Access and I am wondering on how to connect names. In one table I have the surname and first name and on another table I wish to combine them so the report shows i.e.
|
| Create an Access database 2003 & use in Access 97 | 04 Oct 2006 23:20 GMT | 2 |
As a new user before I start I wanted to check if I can create a database in Access 2003 and then use it in Access 97? All help appreciated!
|
| Access Autodialer Setup files | 04 Oct 2006 22:54 GMT | 3 |
Does anyone know where the information is stored when I change the options in the Auto Dialer in Access
|
| missing text when copying/pasting | 04 Oct 2006 18:13 GMT | 1 |
When I copy a table from access into excel by either ctrl C or right clicking, i notice that some of the text is missing. This especially happens when there is alot of text in a field, only the first few rows seems to get copied and pasted onto the spreadsheet? Is there a way I can ...
|
| Using OpenRecordset(...) | 04 Oct 2006 17:37 GMT | 3 |
I am a Access and Visual Basic novice and, as such, need some assistance. What I assumed would be an easy task is proving to be a headache for me. Problem: Obtain a MAX(xx) record from the database based on user input
|
| I told you to change the user name CALCUTTAUDOM\lib to whoreall\l | 04 Oct 2006 15:36 GMT | 1 |
Try to be calm and peaceful liberal as well. Please act accoridingly as because i myself is the best judge to know what actually had happened in the past but nor the kangaroo court neither anybody else. Thanking you,
|
| How to disable right-click menu? | 04 Oct 2006 12:59 GMT | 1 |
I wish to disable all the right click menu on the objects of a form to prevent user viewing the properties of the objects in the menu. Does anyone have any idea about this matter? Thank you
|
| Tables-Forms??? | 04 Oct 2006 11:56 GMT | 3 |
I hope someone can give me a suggestion here - because I have tried everything and I cant make this thing work. I have one table that has information about "stores" (address ect - what they sell - a description and so on) from this table I have created a form
|