Search results

I have reports that total the figures in a column and displays the total at the bottom of the column. I would like to display the total at the top of the column since the length of the column continues to grow and I would like to see that total before scrowling down to view the various...

I have several reports on access 2010 that lists items and at the bottom in the report footer gives me a total for the columns. Is there any way that those totals can be put at the top of the columns such that the person reviewing the reports can see the totals first, then scrowl down to see...

I understand the conventional wisdom of not storing calculated values on the table, but I have a need to do do so. On my Input Screen I have a generated Certificate # derived from 5 single value fields keyed onto the screen. This certificate # is unique to those 5 single-value fields which...

I have a simple data entry form where I can key the "row", "COLUMN", SPACE "a" and space "B" onto an access 2010 table. Is there a way that if I key the same four fields, e.g., A5AB that I get a message back before updating telling me that combination already exists? thanks in advance for...

in Access 2010 I , early on, had an input field that if left blank would pop up the following window when the enter button was hit: ________________________ Microsoft Access / The Chamber # is required / /...

I have three access 2010 tables, each standing alone with their own navigation pane, etc. Is there a way that I can put all 3 tables into one navigation pane? What I need is to build a Switchboard where each of the 3 tables are my choices . thanks

my database has 3 tables. I have created a report that accesses data from table 1. I then copied the report and want to change that copied reports' source of information to come from table 2. How do I change its source? It should be easy, but I am having a hard time.\\\ thanks

I am trying to set up a report and I need to separate the check box from the label. For example, the label reads CASH and has a check box. I want the label CASH to be the header and the check box to be underneath, but I can't seem to separate the two. How do I slide the check box down to the...

Greetings. I am wondering if Access 2010 has the capability of automatically filling in a field from info keyed into previous fields. For example, I want a confirmation number issued which is made up of all the characters keyed in the previous three fields. For example, assume the previous...

I have searched and read how to add a field to a report in access 2010 using the Field List, but I can not get it to work. I have selected the field I want ant 'dropped' it onto my report. It displays two of the same field in the header, but how do I then create the space below that title for...

In Excel, you can hold or freeze in place the names of all columns as you scrowl down the page or report. Can such be done in Access 2010? thanks

I have inserted code into the BeforeUpdate event that tells a user if a particular field, which has been skipped, is required. The code works fine, but when you click the "OK" button so that you can proceed to input the required field, you get (1)a window that tells you "You can't save this...

Being a novice I could not understand what I was reading as advice on how to make changes neccessary to exit the Access 2010 software, not just the database, thru the Switchboard. So I finally came up with a procedure I hope will help folks: 1st = Create a Macro -click on Create at top of...

When I click on the Exit button on my Access 2010 Switchboard, it exits that DB, but leaves Access open. Is there a straightforward change I can make such that when I click on the Switchboard Exit button, I am taken out of Access? I have looked at a number of suggestions, but am unable to get...

I have a two table Access 2010 database. The 1st table is preloaded with 80 apartments, space A and space B. This means that someone can rent apartment 50, space A & B or simply apartment 50, space A or apartment 50, space B. So I have a table that looks like: Apartment...

I have read the procedure for opening an Access 2010 table exclusively and seen what the Access Open screen is suppose to look like, but I don't have such a screen. When I clike on "OPEN" in the FILE column I get a regulare Windows Open screen which does not have the opportunity to choose "open...

I have an Access 2010 Table with a data entry form and two inquiry screens. I have to install these on a user's computer who also has Access 2010. The user needs for the Data Entry and two Query screens to be icons on his Desktop such that when he clicks on any of the three he sees only that...

I have a table with 15 fields. Using a form with corresponding 15 fields, assume I key into 10 of those fields the first time I enter data for a particular customer. Some time later (days, weeks, etc) I will need to key data into 2-3 of the empty fields for that particular customer. When I...

-Access 2010 -I have created two Tables, A & B -Data is always entered into Table A first -both tables have Field X -when a value Y is entered into Field X of Table B, can VBA code be written that can check Table A to ensure value Y is present in that table's Field X? I am obviously a newby to...

I have Access 2010 and on it's Database Window, which contains all the ribbons there is a Navigation Pane. At the top of that Pane it says "All Tables", but it never actually lists the 3 tables and related views I have developed. It only handles one table with related views at a time. How do I...