Data No Longer Visible In Tables
Apr 30, 2013
I am using an application that uses an Access database, and I believe the original database was created in the 97 version. The application queries the database and allows a person to view the data in the database to select a particular instrument to test. When the MS Office was upgraded by our IT we are no longer able to view the data in application. The fields, rows, and columns appear, but the numbers and letters are not visible. The data is really there, but can't be seen.
I have attached a screenshot of the view that shows the white columns and rows.
View Replies
ADVERTISEMENT
Mar 1, 2006
Several years ago, my colleague and I built some databases (using Access 97, if it matters). We are both responsible for the maintenance of them.
Recently, the hard drive in my PC crashed, and the IT group replaced it. Now, when I open one of the databases, I cannot see all of the Forms, Tables, etc. Thinking the database had been corrupted, I asked my colleague to open it on his machine. Everything was there, and can be viewed from his PC.
All was well until my hard drive was replaced. Has anyone seen this before? Any help will be greatly appreciated.
View 1 Replies
View Related
Mar 4, 2005
I am receiving the following error while trying "get external data from Access to Excel". The purpose is to set up a pivot table from my access data. The error is as follows:
"This data source contains no visible tables". Can anyone explain why I would recieve the error, when I have tables in my Access database?
Thanks,
todd
View 2 Replies
View Related
Dec 10, 2012
I have recently been modifying an existing Access 2007 database, everything seems to be working correctly, except that the main table holding most of the data is acting strangely.
If opened in database view, it is completely blank - no column headers, no data. Record count is correct and I can step through/select records, but there's just nothing visible at all.
The data clearly still exists as it can still be viewed in forms / queries / reports.
Only thing I can think of is that I have deleted a bunch of outdated queries & reports and it's possible that one or more of them may be cross-referenced with the table in another query, but still can't see why that should be causing this problem.
View 2 Replies
View Related
Aug 11, 2013
I have made a form with a main form and two nested subforms. The main form and subforms display data to be edited - fields in which data can be added, but no new records need be added. I and two other users have used this form for about two months. Now when we go to enter data, we can still navigate the form but our changes to the fields in question are no longer saved.
View 2 Replies
View Related
Apr 6, 2007
hey guys i was just wondering if anyone knew the code to make a table visible via changing a combo box. i know for a form its simply
Form_formname.visible=True
View 2 Replies
View Related
Jun 8, 2015
I come across a strange database condition every once in a while where if I create a new table, either by wizard or with VBA, the new table is not visible in the navigation pane. To make it visible, I open 'Custom' in the Pane and then open 'Object Type'. The table is then visible.Is there some setting or command that forces Access to show the new table as soon as it is created?
View 3 Replies
View Related
Jun 14, 2006
Hello,
I have a form with twa txtboxes named mytxt and txtresult.
The txtresult gets its data from a module (GetInterval).
I have written this statement:
If IsNull (Me.mytxt) then
Me.txtresult) = Null
I get an error as if that control cannot contain null values.
I have done the same with another sample, simply changing the record source of my txtresult to a field of my table and works?
can anyone see the problem?
I have also tried in with this code but still nothing:
If Len(Trim$(Me!USER & vbNullString)) = 0 Then
Thanks.
View 3 Replies
View Related
Oct 17, 2013
I have a combobox on my form called TypeOfBusiness, with fields including Corporation, Education, Industry, Non-Profit. In order to make a second combobox called IndustryClassification appear when Industry is selected from the TypeOfBusiness combobox, I have used the following code:
Code:
Private Sub Form_Current()
If Me.TypeOfBusiness = "Industry" Then
Me.IndustryClassification.Visible = True
Else
Me.IndustryClassification.Visible = False
[Code] .....
It works just fine. However, when a user selects both, say, Industry and Education, the IndustryClassification combobox will not appear. What code I can use to ensure the IndustryClassification box will appear regardless if another box is checked in addition to Industry? I am wondering if it has to do with the Column attribute.
View 14 Replies
View Related
Mar 24, 2015
I have a Main Form with a Sub-Form, the sub-form is base off a query. on the sub-form i have 8 controls, one of them is "Status' and "Process" and "Review" My Main Form have a Refresh command that refreshes the data in the sub-form.
What i am trying to do is make the "Process" Control only visible is "Status" is a certain status and "Review" visible if "Status" is something else. what i have done works correctly On Open. I run into and issue on the refresh command. I get Run-time error '2165' "You can't hide a control that has the focus"
Code:
If Forms!Main_Form.[Name subform]!Status = "Ready" Then
Forms!Main_Form.[Name subform]!Process.Visible = True
Forms!Main_Form.[Name subform]!Review.Visible = False
ElseIf Forms!Main_Form.[Name subform]!Status = "Reviewing" Then
Forms!Main_Form.[Name subform]!Review.Visible = True
Forms!Main_Form.[Name subform]!Process.Visible = False
End If
I have done similar with a main form and making sub-form visible or not based on a control on a main form and that has worked perfectly. I am not sure how the control is getting focus and cause the error.
View 4 Replies
View Related
Aug 22, 2014
I have 30 fields on a form that houses codes that are 1 to 2 digits in length. Some of those codes are used way more often than others so I decided to build a VBA script to apply the most common codes to the fields based on entry in 3 other fields and applied to a button. The code works great but one of the fields (the 6th one) is behaving oddly. I have tried multiple criteria for code and it is ONLY the 6th field being the pain. The code is applied to the field but it is invisible until that field gains focus by either clicking on it or tabbing to it. I checked the fields format to others of the 30 and all of the settings are exactly the same. There is not anything set in any of the events and there is not any other code pointing at those fields.
View 3 Replies
View Related
Feb 16, 2007
My question is how can I make data in a form visible or invisible just by a button. In other words, if I have a group of buttons, based on the button selected I would want certain data to appear.
I know that this is possible, I have seen it done but just cannot find out how to do it or what this is called to look it up in Helps.
Thanks,
****
View 5 Replies
View Related
Jul 22, 2013
I have a report with 4 subreports. The report contains calculated fields that use the totals field in the different sub reports.
My issue is when one or more of the subreports does not have data in it. The sub report dissapears while in print preview, removing the totals row and ruining the calculated fields in the main report.
How can I keep the sub report visible even if no data is displayed? Or have it invisible but have the calculated fields still reference.
View 5 Replies
View Related
Jul 14, 2014
I've inherited an Access 2000 database that is used to enter and print various types of data. I am using Access 2010 and when I open it I am in a forms view for the main user interface. I want to see and/or edit the objects that make up this database but I can't find a way to see them. The navigation pane is not visible and using F11 doesn't open it. How can I see the database objects?
View 14 Replies
View Related
Sep 12, 2004
I have a form with four subforms set up in a tabs on the form. In the subforms I have a copuple of command buttons which enable/make visible fields when they are clicked (see previous posts but for eg) - if a height and a weight are added in two separate boxes a calculation is done and then a command button pressed to make visible the (label) which shows the mass index the patient falls into. My problem is that the label is then retained so if I click out of the form and re-enter with a new patient then the height and weight boxes are clear but the label from the previous patient remains.
I tried to put the code
Private Sub Form_Load()
If PtWeight = Null And PtHeight = Null And Text60 = Null Then
Label106.Visible = False
Label101.Visible = False
Label177.Visible = False
Label122.Visible = False
Label123.Visible = False
End If
End Sub
in both the open and on load event of the main form (not the subform) but it doesn't help. Any ideas?
(When should code be put on the main form and when on the subform?)
View 2 Replies
View Related
Jan 14, 2006
I created a DB program for my last job that resided on a stand alone PC. It has the Access generated user level security (so there's a "secured.mdb" file) and can only be opened via the desktop icon. In the past, when I copeid the db to a flash drive, took it home to work on it, it always said I didn't have permissions to run it unless I placed it in the right spot on my computer where I've got it set up with a secured file and the desktop to open it.
Yesterday, I noticed that I can now open it anywhere, including my laptop, and it just opens. My concern is, I don't trust the business where the program is being used to not take it and call it their own (I trust the management team, however).
ANy ideas why it no longer looks for the user level security now?
I'm running XP Pro on both machines, Access 2002 on the desktop and 2003 on the laptop.
Thanks.
View 10 Replies
View Related
Sep 29, 2005
Not exactly sure if we has anything to do with sql server so sorry if it isnt strictly relevant.
I have a database on sql server and am using an access data project as the front end. Have finsihed this and is working fine till I try and use it on another computer on the network. It still connects to the database fine (well on most machines on the network not sure why not on the others) but the problem is access functions in my reports and forms seem to have stopped working and show up as ?#name
Examples of the kind of functions I am talking about are
=Format$([DateFrom],"Long Date")
=[SumOfMinutes]60 & Format([SumOfMinutes] Mod 60,":00")
any suggestions?
View 1 Replies
View Related
Oct 24, 2005
I'm using Access 2000 along with Oulook 2003. Since we changed email servers, the send report no longer works. The addresses no longer appear to be valid. I can manually put all the names in every time an email is sent, but that is defeating the purpose!
I even tried changing the addresses to what an outsider would use rather than our internal name list; (milko@valspar.com instead of Mary Ilko) but this didn't work either.
Here's the code:
Private Sub cmdMailApproval_Click()
OnError GoTo Err_cmdMailApprovalClick
Dim stDocName As String
stDocName="rptForApprovalReport"
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport stDocName, acViewPreview,, "[Batch#]=forms![frmInbound]![Batch#]"
DoCmd.SendObject acSendReport, StDocName, acFormatSNP, "FirstName Lastname",,,"Pre SHip Approval", "Please see the attached."
DoCmd.SendObject
Thanks in advance for your help!
Mary :o
View 1 Replies
View Related
Apr 6, 2006
I have a replica database in Access 2000.
I changed a form in the design master that had nothing to do with the date or a date field. Everything appeared fine.
Now I updated the replicas, and an error is happening on all replicas as well as the design master. Any reference to Date() or Now() causes errors.
If it's a field on a form it has an #Name error. If Date() or Now() is on a report, a popup to enter parameters appear for the date. This database with these codes have been working for years.
Is it safe to say it's no longer recognizing Date() or Now() ?
Any ideas on a fix?
View 2 Replies
View Related
Nov 7, 2006
I recently upgraded to Access XP (2002) and now my application will not respond to F11 to get into the development window. This application has two mdb files. One is the database (with security), and the other one has the forms, queries, reports and links to the tables in the first mdb.
View 12 Replies
View Related
Jan 8, 2008
I developed a database in 2005 and used the 'Left' function in many of the queries to obtain the the correct text for output to reports. The database worked extremely well for a year and a half.
I have not accessed it for the past year. Recently I opened the database for use with a new project and I keep receiving the error message:
! Undefined function 'Left' in expression.
I haven't changed any of the expressions and do not understand why this funtion no longer works.
Any ideas?
Thanks
View 5 Replies
View Related
Apr 5, 2006
Situation: I have written a fairly straight forward nested query which aggregates sales & activity data (num_calls, date, etc.) by customer specialty (CODE_ESP_ACC1) in a single query. The SQL I have written to achieve this is as follows:
SELECT Q002.GP, Sum(Q002.Num_Calls) AS Total_Calls
FROM (SELECT Q001.CODE_ESP_ACC1, Count(Q001.ACT_ID) AS [Num_Calls], Iif([Q001].[code_esp_acc1]="MG" or [q001].[code_esp_acc1]="MF",1,0) AS GP
FROM (SELECT [06 Act 2005 Hosp - IM].ACT_ID, [06 Act 2005 Hosp - IM].TER, [06 Act 2005 Hosp - IM].ACC_ID, [11 Physicians with main specialty].CODE_ESP_ACC1, [06 Act 2005 Hosp - IM].DATE
FROM [06 Act 2005 Hosp - IM] LEFT JOIN [11 Physicians with main specialty] ON [06 Act 2005 Hosp - IM].ACC_ID = [11 Physicians with main specialty].ID_ACC
WHERE ((([06 Act 2005 Hosp - IM].POSITION)=1))) AS Q001
GROUP BY q001.code_esp_acc1, Iif([q001].[code_esp_acc1]="MG" Or [code_esp_acc1]="MF",1,0)
HAVING (((Q001.code_esp_acc1) Is Not Null))) AS Q002
GROUP BY Q002.GP;
This works absolutely fine. I can save this query and run it many times without problems. However, if I then re-enter SQL edit view, Access reformats it as follows:
SELECT Q002.GP, Sum(Q002.Num_Calls) AS Total_Calls
FROM [SELECT Q001.CODE_ESP_ACC1, Count(Q001.ACT_ID) AS [Num_Calls], Iif([Q001].[code_esp_acc1]="MG" or [q001].[code_esp_acc1]="MF",1,0) AS GP
FROM (SELECT [06 Act 2005 Hosp - IM].ACT_ID, [06 Act 2005 Hosp - IM].TER, [06 Act 2005 Hosp - IM].ACC_ID, [11 Physicians with main specialty].CODE_ESP_ACC1, [06 Act 2005 Hosp - IM].DATE
FROM [06 Act 2005 Hosp - IM] LEFT JOIN [11 Physicians with main specialty] ON [06 Act 2005 Hosp - IM].ACC_ID = [11 Physicians with main specialty].ID_ACC
WHERE ((([06 Act 2005 Hosp - IM].POSITION)=1))) AS Q001
GROUP BY q001.code_esp_acc1, Iif([q001].[code_esp_acc1]="MG" Or [code_esp_acc1]="MF",1,0)
HAVING (((Q001.code_esp_acc1) Is Not Null))]. AS Q002
GROUP BY Q002.GP;
... and this no longer works (syntax error in FROM statement).
To save you sifting through the SQL, the error is caused by Access replacing the soft brackets () aroung the outermost FROM statement with an object identifier-style hard bracket []. - specifically, the outermost SELECT statement now reads
SELECT Q002.GP, Sum(Q002.Num_Calls) AS Total_Calls
FROM [
instead of
SELECT Q002.GP, Sum(Q002.Num_Calls) AS Total_Calls
FROM (
and the alias for the subquery reads
]. AS Q002
instead of
) AS Q002
Changing the Access alterations back to my original fixes this problem - so the problem is more an annoyance than a disaster. However, I have no idea why Access is doing this to my query, nor how to prevent it from doing so. Does anybody have any experience of this behaviour in Access and any ideas of how to fix it?
Help! Replies appreciated.
View 1 Replies
View Related
Feb 24, 2015
I have been using this export function for the longest time and today it is giving me an error:Object invalid or no longer set.
Code:
On Error GoTo Err_cmdTest_Click
'Must 1st set a Reference to the Microsoft Office XX.X Object Library
Dim dlgOpen As FileDialog
Dim strExportPath As String
Const conOBJECT_TO_EXPORT As String = "EXPORT"
[code]....
View 5 Replies
View Related
Jul 4, 2014
I have a large spreadsheet with one column of information which is longer than what access accepts as long text. So when I convert the spreadsheet to access all the large boxes of information are shortened so that I am losing a lot of information.
View 1 Replies
View Related
Feb 24, 2015
I have been using this export function for the longest time and today it is giving me an error:
Object invalid or no longer set.
Export code:
Code:
On Error GoTo Err_cmdTest_Click
'Must 1st set a Reference to the Microsoft Office XX.X Object Library
Dim dlgOpen As FileDialog
Dim strExportPath As String
Const conOBJECT_TO_EXPORT As String = "EXPORT"
[code]....
View 10 Replies
View Related
Jul 27, 2014
i wish to combine multiple fields (there are no fixed number of fields, they vary depending on the data, so i guess union queries are out of the question) into one large field. For example:
TABLE 1:
PNumber
PName
C1
C2
C3
1
AAA
0.1
0.2
0.3
2
BBB
0.4
0.5
0.6
So i wish to combine the fields C1, C2 and C3 into a larger fields containing all the data. So considering the example above, it should look like this:
TABLE 2:
PNumber
PName
C1+C2+C3
1
AAA
0.1
1
AAA
0.2
1
AAA
0.3
2
BBB
0.4
2
BBB
0.5
2
BBB
0.6
I plan on entering data into TABLE 1 using a form and running a query, or some code etc so that it looks like TABLE 2.
View 14 Replies
View Related
