| Thread | Last Post | Replies |
|
| Using a macro how do i hide cells and colunms | 09 Mar 2005 23:53 GMT | 2 |
I am setting up a matrix spreadsheet and would like to hide colunms when they are not needed. I am listining all the possable configerations in rows and when the options are not needed i would like to enter a N in a cell to hide a complete colunm.
|
| Number format changes when query converted from Select to Make table | 09 Mar 2005 23:52 GMT | 2 |
I have a query which calculates a percent using expression builder and it works fine as a select query. If I change the query type to Make table or append query the format or what I can see is inconsistent with the results from the select query.
|
| newbee - error 3001 Invalid Argument running append query | 09 Mar 2005 23:46 GMT | 3 |
error 3001 Invalid Argument running append query I run an append query fine, then out of the blue it wants to give me this error. I noticed when I changed my access query to simply a select query, I do not
|
| Application defined or object defined error | 09 Mar 2005 22:15 GMT | 11 |
I am linking Access database to a new SQL database and I do OK until I get to Tools, Database Utilities, Linked Table Manager to updated the new link. I keep getting the applicaton error or it will say that a particular table does not exist but when I go to the other database it ...
|
| How do I get Access to release space for deleted records at run ti | 09 Mar 2005 18:51 GMT | 1 |
I have a query that is more than 2 gigabytes. So I get an error. I cannot reduce the size of the query. Once I get the append query dumped into an access table, I loop through it in code and delete unwanted records. And then I do another query and dump into the same table and ...
|
| Can a function return more than one value ? | 09 Mar 2005 18:21 GMT | 1 |
I have a report that prints monthly percentages and then a quarterly percentage. I have a function that calculates the monthly percentages. I'd like this function to pass back not only the percentage but also the dividend and
|
| stock program | 09 Mar 2005 18:07 GMT | 1 |
hello, good moorning, I made a program in excel but I want to do the same program in acces because the possibilities that offers, let me explain what my program do, when a sales employee sales something he needs to put a code in a cell, then he press a registration button with a ...
|
| FORM DATA PRINTING TO EXCEL | 09 Mar 2005 17:43 GMT | 1 |
HERE IS THE PROBLEM I HAVE A SIMPLE ACCESS DATABASE AND WHAT I WOULD LIKE TO DO IS AFTER ADDING DATA BE ABLE TO HIT A CONTROL BUTTON THAT WILL SEND DATA FROM THE CURENT RECORD (ONLY) TO A EXCEL TEMPLET AND THEN PRINT FROM THE EXCEL TEMPLET AS IT ALREADY HAS ALL THE LABELS AND ...
|
| reports that hyperlink | 09 Mar 2005 15:35 GMT | 2 |
I don't have Access yet but... Can it hyperlink an email address and picture to a company employee listing report?
|
| How do I search for files in subdirectories? | 09 Mar 2005 13:35 GMT | 1 |
I have an access table with a file names of images (*.bmp or *.jpg) in a column. I want to use the file name from the table and search for it in subdirectories so that I can display the image.
|
| UNION QUERY | 09 Mar 2005 13:08 GMT | 1 |
I have a Union Query that makes the Union of 3 tables THeader TDetail TFooter
|
| Pros and Cons of Office Developer 2K | 09 Mar 2005 11:29 GMT | 5 |
I am trying to get a handle of the Pros/Cons of using a runtime Developer program so I can explain it to my boss. I have several DB programs in the past, but I am looking at using the office developer to create a runtime of future versions. I have been hearing that using this ...
|
| How do I make a link in MS Word 2000 to an Access Report? | 09 Mar 2005 11:25 GMT | 4 |
I have an access database and I built multiple reports. How can I make a link in MS Word to the reports? Thanks!
|
| How do i change the starting value of an AutoNumber field | 09 Mar 2005 08:32 GMT | 2 |
I have set up a new table and want to change the number in the AutoNumber field. Help only provides directions pertaining to an existing table.
|
| format with bullets does not work | 09 Mar 2005 08:28 GMT | 2 |
When I highlight my section to be bulleted in Microsoft Word 2003 all lines indent but only first line shows bulleting. What is the problem?
|