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 RepliesI'm trying to create a form without the standard navigation arrows on the bottom of the form. Is it possible to hide these? I want to use my own navigation buttons instead as they will be more intuitive to non tech users.
appreciate it
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 .
View 2 Replies View Relatedi have just taken over
I have just taken over some database which have a load of tables and queries that I suspect are no longer requirer. Is there anyway to see when a table or query was last USED in a database??
Any help is appreciated
We have a split access2010 application in which the BE is 1.6Gb compacted. It reached 1.8Gb recently, then I compacted it and it returned to 1.6Gb-ish, but some of the FE functionality then virtually ceased to run. Some (very stressful) hours later I discovered that some of the table indices were missing, and when I re-added them the FE functionality returned to normal.
Is it a known thing that compacting can have that effect? Obviously I can see the logic of removing indices to free up space, but with such potentially significant performance consequences I'm amazed that compacting doesn't include an explicit warning about the possibility.
I am using Access 2007, and I mistakenly created a duplicate table in Relationships. And, I have not been able to removed it or delete it.
View 6 Replies View RelatedI have 4 or 5 tables. Most of the fields are exactly the name but they all have at least 1 to possibly 5 or six fields that are not in the other table. Additionally there are some duplicates within the individual tables as well as across tables.
i.e.
I have a
Student Table - with all the info on the student as well as a column called student that identifies them as such however it does not have the columns parent, donor, appeal, designation.....
Parent Table - with all the info on the student as well as a column called parent that identifies them as such however it does not have the columns student, donor, appeal, designation.....
Donor Table - with all the info on the student as well as a column called donor that identifies them as such however it does not have the columns student, parent, appeal, designation.....
Appeal Table - with all the info on the student as well as a column called appeal that identifies them as such however it does not have the columns student, parent, donor, designation.....
-A person can be within one of these tables more than once but with all the same information.
-A person can also fall into all of these parameters so they could be on every table with the same information in addition to the missing columns,=.
Question 1 : what is the best way to dedupe and delete the individual tables (they all have account numbers)
Question 2: I was thinking create a new table with all the columns available, however how do i dedupe across tables while populating the additional columns from each?
I understand the principle of renaming the above of using the navigation pane and selecting the object but what is happening in my case is that when I select the specific table/query I wish to rename, the text is highlighted as per normal but the instant I move the cursor onto that cell that whole panel highlights in red and then reverts back to the original state of just the text in that panel (now highlighted).
I do not know if this is related to the problem but I have a text box with the "code" =Count([tblEntries].[CageNo]).
This was working perfectly okay but both this and the renaming appeared to happen about the same time. I have opened other Access files and the same re the renaming occurs. I have secure security running and do not think this could be the problem but anything is possible.
I am not able to disable NavigationButton when i login navigation form using login form. I am using MS access 2007 - 2010.i am using below code but getting error.
Forms![Navigation Form]!NavigationButton13.enable = False
Error
Run-time error '438'
Object doesn't support this property or method.
Any other method to disable NavigationButton.
I have a report with 2 access tables (1 Master table and another a daily feed table)
The Master table keeps a log of all incoming records. (once append it to this table, should not show in future reporting)
The Daily feed information within the last 48 hours. (uploaded from an excel report into access temporary table)
When the daily feed table gets completed, I append the records and updated them into the Master to avoid duplication.
When I upload the daily feed table and I match it against the Master table to find duplicates, how can I delete the duplicates from the Daily Feed table?
This is my code to find duplicates:
SELECT CMPreport.ID, CMPreport.MbrName, tblMaster.ID
FROM CMPreport LEFT JOIN tblMaster ON CMPreport.ID = tblMaster.ID
WHERE (((tblMaster.ID) Is Not Null));
I have been trying to figure out how to make a main menu that link to certain tables I have. I want the links to go to the tables/forms so that they can be edited, but I don't want the user to be able to enter design view. I have attached an image of what I want to have below.
View 3 Replies View RelatedI have two tables in my Access database. Table 1 has three columns, First Name, Last Name and Phone Number. Table 2 has just 2 columns, First Name and Last Name. What I would like to do is write a VBA macro to consolidate Table 2 into Table 1 and insure any duplicate First Name-Last Name combination is removed.
Table1
Code:
F.Name L.Name Tel.N.
John Smith 12345
Larry Miller 12344
Tony Woods 12333
Table2
Code:
F.Name L.Name
Albert Black
Larry Miller
John Bush
Table1 Post-Macro
Code:
F.Name L.Name Tel.N.
John Smith 12345
Larry Miller 12344
Tony Woods 12333
Albert Black
John Bush
When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables.
The memo field in the table is set to Rich Text and so is the text control on the form.
Below is an example of the data I'm copying from Outlook email:
Fire Alarm Activation
Actual/Smoke Present
False
Planned Drill/Testing
Evacuation
2. Utilities/Power/Communication Failure
Now, below is what it looks like in my table or output in a report:
<ol>
<ol>
<li><strong>Fire Alarm Activation </strong></li>
</ol>
</ol>
<ul>
[Code] ....
How can I copy and paste and remove the html tags?
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?
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:
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 RelatedI 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!
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.
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
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...
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?
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"
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 RelatedI'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?
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 RelatedI 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.