Search results

I respect your challenge, but actually I tried a number of times before deciding to annoy someone with the question.:banghead:

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...

Thanks for your help. I don't know VBA, but would like for the input form to be able to do what you suggest. In the meantime, by make a primary key on multiple fields on the Table still throws out the "Runtime error 2105. You can't go to the specific record" message. It prevents the keyer from...

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...

thanks Tooom, but that isn't working..

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 / /...

attached is a copy of the navigation panel of one of the tables' navigation pane. Is there any way to add the other two tables to this navigation pane?

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

oopps. the tables are Access 2010 tables

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

It is looking for the previous name of that field. I changed the name in the Table from 'space A' to 'front space'. It is a 'yes/no' field. I then tried to change a column title on a list from 'space A' to 'front space'. I want the list to layout as follows: front Space back...

thanks, but that causes a window to appear wanting me to enter a parameter value.

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...

Ling & John Things work just as you said. Thanks again for your time and guidance.

Thanks, Ling. Will keep you posted. Sanjo

thanks John, I have tried a couple of times using the exact same code on the Control Source for the Confirmation Number on the Reports, but to no avail. I will keep trying. Sorry, but I am an infrequent user of Access and lapses of time between the uses dim previous knowledge.

OK, after my "give up" statement, I saw Missinglinq's idea and used it. It works perfectly. That is, it creates a confirmation number from the Niche, Space A, Space B and Transfer fields, even with the last three being yes/no fields. !! Great. It would be really good if the confirmation...

John, thanks for your time, patience and advise. I don't think I can use the automatic fill approach to create the confirmation number so we will simply have to key it in.