Search results

I tried to log onto my home computer last night (I have Windows XP Home edition) and couldn't get past the logon screen. It seemed like I was caught in a loop because the computer kept going back to the screen where you can choose the Safe mode--along with some other choices that I don't...

I have a form that is pulling data from two different tables... we'll call them Table A and Table B. Most of the fields on my form are from Table A, but there is one field on the form from Table B (it's a Memo field), that I've included as a combo box. While the combo box field works okay on...

Good afternoon, Now I'm not sure whether this probelm is with my report or in my query, so I am posting in both areas. On a form in my database I've included a look-up field that reference data from anoher table (i.e. the main data on the form comes from one table, and the "look-up" reference...

I think I already know the answer to this one, but here goes anyway: I want to change a field in my report into a Combo Box but in previewing the report, all of the data doesn't show up in the Combo Box field. So, my question is: Can I make it grow? The "Can Grow" option doesn't appear in...

Good morning, We just switched to Access 2003 (from 2000) last week, and now none of my reports will open. Everything else works fine, I can open tables, queries, forms, etc., but I can't even open a report in Design mode. Has anyone else had this problem? Is it an Access 2003 quirk or am I...

Good morning, We just switched to Access 2003 (from 2000) last week, and now none of my reports will open. Everything else works fine, I can open tables, queries, forms, etc., but I can't even open a report in Design mode. Has anyone else had this problem? Is it an Access 2003 quirk or am I...

Good evening all, I have an Activity Date field in a query and was wondering how to show all activities that happened both on and after that date? In the Activity Date field of the query grid, I’ve typed in [Enter Date] in the criteria cell. So, for example if I wanted to know everything that...

How do I change a date entry in a text field to an entry that more resembles an actual date? I've inherited a 2,300 record database where dates have been entered into a text field. The format for these dates is yyyymmdd, or 19960101 for January 1, 1996. Is there an easy way to change the data...

I have a report that includes main headings, and may include 10 sub-headings that will be listed underneath each one. I want to be able to print this report and include only those sub-headings that are populated, leaving out the blank spaces for those sub-headings that are not populated. I...

I have a main form that displays departmental information, and a sub-form within it that will be used for the data entry of departmental business records. In testing my forms, for some reason whenever I try to enter data into the sub-form portion of my form, I get a message that reads "This...

I've designed a report that, when printed, sorts into various categories. A category can be a single page long, or several pages long. Whenever a new category starts, it also starts printing on a new page. I've also designed an "approvals" portion that I want to appear on the last page of each...

I am trying to join multiple text fields and have used: =[Field-1] & " " & [Field-2] & " " & [Field-3]. Now this works, but my problem is that each of the fields that I want to join has multiple columns, and I only want to show selected columns for each one. Any ideas on how I can do that...

I'd have a field in a database that will only have YES or NO values in it (it is not a checkbox). I'd like include a total count of the YES values in a report I've developed. I've tried both the COUNT and SUM operfators (?) but to no avail, I guess they only work with numeric fields. What else...

I've developed a number of pie and bar charts where I also need to track volumes and percentages for each area shown in the chart. I've entered calcs in a number of different ways yet all I get are error messages. For example, I have a pie chart that shows each of the 12 functional areas from...