| Thread | Last Post | Replies |
|
| Group totals in header | 29 Apr 2008 22:50 GMT | 1 |
Is there a way to display group totals in the header? I am able to do it if the group totals are in the footer, however the header group totals always display "1 record". Thanks in advance.
|
| Multiple Replacements | 29 Apr 2008 22:44 GMT | 1 |
Can I do unique multiple replacements? For example, I have over 50,000 records and I need to replace several different text with other text. Can I do this in some SQL, code or query?....rather than doing it one at a time through the Edit menu.
|
| Programming date | 29 Apr 2008 22:44 GMT | 1 |
How can I make Microsoft Access give me a sign that the date that I put in a given field of a record, is equal to date of the computer ( in the future not in the moment that i put ). thanks =D
|
| Computer Change - Database Acting Up | 29 Apr 2008 22:01 GMT | 5 |
I've moved my database to a new computer. Now a couple of things are working right. I checked the References in the Module, but nothing shows up as missing, and as far as I know, the Windows OS and the Access versions are the same.
|
| Linking reference cells in two tables | 29 Apr 2008 21:15 GMT | 3 |
I have two tables, each with individual information about the same "Job". The information is linked through the "JobNo" fields. What's the easiest way to enter the JobNo in one table, and have it automatically insert it in the other? Right now, I'm running an AppendQuery often ...
|
| Datatype Mismatch Error | 29 Apr 2008 21:12 GMT | 1 |
I have created a database that monitors the QA vendor risk process. In the main form of the database the user performs a lookup for a specific vendor and the information displayed for that vendor is static. Additionally, there are approximately 10 tabs on the form. Each tab ...
|
| Simple Database | 29 Apr 2008 21:08 GMT | 1 |
I need to create a simple database with 2 tables for several people to use. They key will be the project number (colum #1) on both tables. I have never coded an Access application before and I have a few questions: 1. Can I run it on my machine while I write and test it or do I ...
|
| Memo field Formatting | 29 Apr 2008 21:06 GMT | 3 |
Is it possible to format text in a memo field to be a bulleted series of steps? For example: * Step 1 * Step 2
|
| Query | 29 Apr 2008 20:53 GMT | 1 |
I have a form that contains two fields [Status] and [Completion]. [Status] is a drop down field. If I select "Complete" or CompleteDeem", I want [Completion] to auto populate with todays date. Is there anyway I can put something in the Expression Builder for the default value? ...
|
| Q: index questions | 29 Apr 2008 20:47 GMT | 2 |
Hi all, Had two questions about indexes and queries 1) suppose I'm doing a simple group query and counting the groups, ie "select category, count(*) from table1 group by category".
|
| Negative Number - Brackets instead of negative signs | 29 Apr 2008 20:47 GMT | 3 |
I just had a quick question. I have set up an invoice db but in my calculations, when the result is negative, the result has a negative sign in front of the number. I would like to show brackets instead. Does anyone know how to format things this way.
|
| Save As HTML - automate - Access 97 | 29 Apr 2008 20:17 GMT | 5 |
Hi, Friends. I'm hoping someone will help me think through this problem. I want to automate the 'Publish to the Web' wizard in Access 97. When you select 'File' and 'Save As HTML' the wizard pops up to gather information
|
| Crosstab Date Range in Reports | 29 Apr 2008 20:17 GMT | 3 |
I am having some problems using Date Range on Crosstab to create a Reports. I specify the 'StartDate' & 'EndDate' for the Date Range in the Query Parameters Table. It prompt me for the Start & End Date. It works fine
|
| Importing Excel files into Access -- without having to change the Data Type to "text" one field at a time | 29 Apr 2008 20:04 GMT | 5 |
Hello - I have recently begun a job where we need to transfer files to Excel, make a few data manipulations, and then import the data into access. The problem is, the only way that I know to do it seems to take a lot
|
| Windows XP - Access 2003 Issue | 29 Apr 2008 19:33 GMT | 5 |
We 've identified an issue on new XP Professional Installations. Access databases running under such Installation do NOT function properly. 2 recent Installations get the screen error below when I try to diagnose what's wrong in Access.
|