Forms :: Subform Black Bottom Edge

Jul 25, 2013

I'm finishing off a database project and would like to do some final tidying up. I'm using subforms on some forms and these subforms show a black line on the bottom edge, I would like it to be white so it blends in with the back and the user doesn't know it's a subform.

Is there any way to do this?

View Replies


ADVERTISEMENT

Forms :: Black List For A Subform?

Oct 14, 2013

I want to create a black list for a subform

For example,when I enter a number to the subform,if the number be in blacklist,it become red color!

View 1 Replies View Related

Forms :: Open A Subform And Display Last Bottom Record

Jun 27, 2014

I got a form / subform relationship.how to locate the bottom record, when the user after some queries input at the main form. I desire to display the bottom end record (EOF), instead of some sorting and display the last record at top of the subform!!

View 11 Replies View Related

Forms :: Subform Scroll Bar Scroll To Bottom?

Apr 25, 2013

I have a form and in the form is a subform. When I add a record with the following code, the subform detail scrolls in such a way that you can't see the record you just added...only a single blank new record. Can you set the scroll position so that I can see all the previous records including the one I just added?

Private Sub Add_PROJ_RECORD()
On Error GoTo Err_Add_Click
Me.PROJECT_DATA.Locked = False
Me!PROJECT_DATA.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.PROJECT_DATA.Form.PROJ = PROJ_COMBO
Me.PROJECT_DATA.Form.SPEC = SPEC_COMBO
Exit Sub

View 2 Replies View Related

Forms :: Some Fields Have Gray Font Instead Of Black

May 7, 2013

I have a form that some fields have gray font instead of black. All of the properties seem to be the same as the other fields. The issue has to do with the 'Manage Sales Order' Form in the 'Products' Database.

Customer ID
Payment Type

View 8 Replies View Related

Forms :: Blank Space At Bottom Of Form

Feb 20, 2014

I have a continuous pop up form which, at the most, will contain about 10 records. The ten records take up less than half the screen space - but there is a bottom half to the form - even though there is nothing there. How can I get rid of the unused space on my form?

View 2 Replies View Related

Reports :: Omitting Black Fields From A Report

Aug 21, 2013

I've created a report based on emergency contacts however some fields are blank as there isn't a "contact" and rather then have lots of empty fields all over the report is there anyway to omit them based on whether they are populated or not? there might be 2-3 records that have "every" field filled the rest are varied as to how many contacts they have.

View 14 Replies View Related

Modules & VBA :: Filter On A Table Shows Up Black

Apr 1, 2014

Ive created a table in Access but when I click on the filter option, it comes out blank.Im using VBA code to populate the table from SQL server.All other column work fine.There is data in that column.

View 2 Replies View Related

Reports :: Access 2007 - Report Printing Black And White On Color Printer

Jan 21, 2014

I have a lovely report that includes a small color photograph. I'm sending the report to print on my HP Color LaserJet, but it is printing in black and white.

I can't find anything in the Properties that specifies whether this prints in color or black & white.

How to print this in color?

View 5 Replies View Related

Selecting Top AND Bottom Values

Dec 22, 2005

Hi all! I have a tough problem I was hoping I could get some help with:

I would like to create a recordset based on the "middle" 50% of the data. I need to chop 25% off the top of the data, AND 25% off the bottom of the data.

Any ideas?

View 3 Replies View Related

Graphs With Minutes Along The Bottom

May 19, 2005

I have some machine data to display showing running speeds. This is logged every minute when the machine is running but not when stopped.

how do I display a bar graph with a timescale along the bottom of minutes showing gaps when the mchine is down. :confused:

View 2 Replies View Related

Bottom Border For A Label?

Apr 9, 2014

I've got a label in a report which I'd like to have a bottom border only. Looking in the property sheet I don't seem to see this option (nor in the ribbon). Is there a way to do it other than with a line control? I'd like to have it attached to the actual border of the label . . .

View 1 Replies View Related

Choosing Bottom 3 For Multiple Entries

Nov 6, 2006

I have a database with information on carriers, lanes, and prices.
I need to choose the cheapest 3 carriers for each lane.
The lanes are either 3-digit zip code to 3-digit zip code or state to state
(410-300 or CA-GA, etc.)
So for each of these lanes, I need to find the 3 cheapest carriers all
in one query.
So the resulting table should look like:

Lane Carrier Price
..........
TN-FL Schneider $50
TN-FL JB Hunt $66
TN-FL Dart $78
646-303 JB Hunt $77
etc.....

Except of course in columns :) Any ideas on how to do this? Thanks in advance!

View 2 Replies View Related

How To Make Legend Go On Bottom Of Graph

Sep 9, 2015

In the tutorial whose link I have shown below: URL....The graphs that I create from the tutorial always have the legend on the right side. I would rather have the legend running along the bottom of the graph. I have two questions :

1. The graphs that I have already created, how can I get the legend to move down to the bottom of the graph? What command can I use?
2. When creating new graphs how do I make the legend go on the bottom of the graph and not the right side.

View 3 Replies View Related

Remove Navigation From Bottom Of Tables

Dec 2, 2011

I have imported a table into a form and would like to know how to remove the navigation options from the bottom of the table, I know you can do it for the form but can you do it for a table contained in a form.

View 10 Replies View Related

Sort By Date With Blank Dates At Bottom?

Sep 7, 2006

Hi

I have created a query which sorts store information by potential opening dates...however, some of the stores are so new there are no potential opening dates as yet.

I would like the stores with blank opening dates to appear at the bottom but when sorting by ascending (which is what I need) these blank dates appear at the top... is there any way around this?
thanks

View 5 Replies View Related

Reports :: How To Get Rid Of Solid Line At The Bottom Of Field

Mar 19, 2015

Ok, I have pesky solid line at the bottom of one field (bottom of the field with 6.80 in it..

I cannot figure out where it has come from or how to get rid of it!

Here's the properties for that particular field...

When I delete the column it appears somewhere else...

View 3 Replies View Related

Reports :: Display Total At The Top Of Column Instead Of At Bottom

Mar 15, 2014

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 scrolling down to view the various individual entries.

No matter how I try the =count(x) always shows an error. Is it not possible to display the total figure at the top of a column instead of at the bottom?

View 1 Replies View Related

Reports :: Formulate Statistics At The Bottom Of Report?

Dec 21, 2013

Is there a way of formulating statistics at the bottom of a report?

Heres what i have.

The report pulls Rank, Last Name, First Name, Assigned weapon, Weapon qualification date. After 6 months i use conditional formatting to highlight the soldiers qualification date red. Im in the military that's why im tracking all this, but I need figures to report to higher, and at the bottom i would like it to show, "#Qualified", "#UnQualified","% Qualified", "% Unqualified", "#Expired","%Expired"

View 1 Replies View Related

Reports :: Extra Spacing At The Bottom Of A Report?

Jul 16, 2013

I have a sub-report and the last row is highlight, however, there seems to be extra spacing after the last row. I removed all report/page header/footer so all what's left is the Detail section but I still have this white space after the last row.

View 5 Replies View Related

Reports :: Can Grow Field At Bottom Of Page Gets Cut Off

Nov 7, 2013

I am using MS Access 2003.I have a report whose Detail band contains a zero-height Comment field positioned at the bottom of the other single row of fields. It has Can Grow = Yes, so it sits waiting to grow if there's any data in this Comment field.

However, when this report prints, if the Comment field just "happens" to straddle two pages, it gets positioned only on the first page and gets cut off in the process. (See attachment 2.) Ideally, the entire field should display on the second page instead.

If I adjust the margins in Page Setup, I can fix this on this particular report. However, depending on the data being reported, these new margin settings can create a problem for the same report with different data. (All depends on where the Comment falls.)I'd like the report to work consistently, no matter the data or margins.

View 1 Replies View Related

How To Display Totals At Bottom Of Query Or Report

Sep 11, 2014

I have some columns with hours. I want to simply display the total below each column. I would like to do this in the query results and in the reports that I create.

View 1 Replies View Related

Hide/disable Record Info At Bottom Of Form

May 9, 2006

Apologies if this is an obvious one but is it possible to hide this:

"Record:1 out of 34" and the arrow buttons at the bottm of a form(s)?

I would rather use my own Next Record and Previous Record buttons so it would dieal to disable/hide these arrow buttons.

Many thanks for your assistance in advance,

Paul.

View 2 Replies View Related

General :: Open Datasheet With Last Record At The Bottom Of Page?

Sep 18, 2014

Is there a way to have a datasheet open with the last record at the bottom of the page? I now have it opening to the last record, but it has the last record at the top and can't see the records before it without scrolling.

View 2 Replies View Related

Modules & VBA :: Position Cursor To Left Bottom Of Control

Jul 22, 2015

I recently found a neat little module which allows you to duplicate a right click & bring up pop up menu ( say by left clicking on a field). I find this very good for creating a nice little menu system in which I can reproduce the nice features of Access menus (I'm using Access 2002) but with a lot more flexibility.

So, I have a line of labels across the top of the form which are my top level menu items - when I click or mouse over these I want to have the pop up menu appear directly under the label. I can position the pop up menu manually by SetCursorPos(x,Y) but as my forms are Pop Up and can move this has proved to be a pain.

What I am after is something that will allow me to work out the coordinates of the left bottom of the label and then position the cursor there then drop the menu. The difficulty I'm having is converting or understanding the position of the label (me.label1.left etc) and relating that to what SetCursorPos needs.

View 4 Replies View Related

Reports :: Grid Line On Bottom / Last Record Of Report

Oct 25, 2013

I created a report that only has gridlines around the outside border of the entire report (rather than around each record). I want the grid line style on the last/bottom record to be solid so it boxes in all the records. When I change the "Gridline Style Bottom" for the records, each record has a bottom gridline rather than an outside box around all the records.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved