Access 97 Mdb Not Working, Can I Find Out Missing Dlls ?
Feb 28, 2007
Hello
Could someone please help, At the company i work we use an access 97 application, which was made by an old tech who does not work here anymore
It is just an mdb file, 97 format, with forms, tables, sql etc
Normally i can just install access 97 and it works on everyones computer, apart from one..
It loads up some forms, however when editing, and a subform if clicked on and change, when saved an error comes up
"OLE SERVER ISNIT INSTALL, REINSTALL IT" THEN IT CRASHES
seems to be just on this one object
the codes fine because it works on everyones else, it there a way i can find out what dll files are need for this mdb to run ? anyone got any ideas
i dont have office devoloper, so i cant make a installer for it
i have tryed install access 97, office 97, office 2003, and works but this ole or object never seems to be installed ?
any help would be great, i cant work this one out
View Replies
ADVERTISEMENT
Dec 27, 2014
I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
View 1 Replies
View Related
Jan 1, 2006
I think this would be done though a query but i am not sure, any help or examples would be useful on this on.
Question:
Is there a way of getting access to find missing numbers. for example if some one enters 0 - 5 then access will pull the following numbers 1,2,3 & 4.
I am not sure if this is possible so any help would be good.
Alastair
P.S. HAPPY NEW YEAR TO ALL.
View 5 Replies
View Related
Jun 13, 2006
I have two tables T1 , T2 each have one field Invoice Number in T1 and
Invoice Number in T2 , lets say in each table in each field : T1 : 1,2 and 3
T2 : 1 and 2
So if I want to find records in T1 which is not in T2 what can I do?
View 3 Replies
View Related
Jul 11, 2006
I have two tables. The first one lists all of the courses that a student has taken. The second table list all available courses. I need a query that will tell me which courses the student has not taken. I tried using the find unmatched query to no success. Any help will be greatly appreciated.
View 5 Replies
View Related
May 24, 2006
Hi hope you can help me out,
I have a query which combines several linked tables, the query has about 10 columns, I need to show only the records which have one or more empty fields.
Some records may only have one missing field others may have several.
Any ideas?
Many thanks,
Ed
View 1 Replies
View Related
Aug 13, 2007
Hi.
i.e..............
Table A has records 1,2,3,4,5,6,7,8,9,10
Table B has records 1,2,3,4,5,6
How do I create a query that returns values 7,8,9,10 for Table B when I compare Table A and Table B?
What sort of query do I need? I tried the "Unmatched query" but this did not get the result I wanted.
Thanks for reading.....
Frank.
View 6 Replies
View Related
Jul 15, 2012
I need to write a query to find and match all numbers recorded against a list of numbers (1 - 200) and to identify those missing or not matching.
View 1 Replies
View Related
May 5, 2013
I am trying to create a query to find missing sequential numbers in a text field. I am using this specific field as a case number which is designated as two letters, the # sign, two digits indicating the year, a dash, and then a four digit number; For Example: AB#13-1234.
The reason for this query is to tell the user of this database that a specific case number has yet to be entered and needs to be. The case numbers are unique and will never be referenced more than once.
My table name is "MainDataTbl" and the field i'm trying to find the missing case numbers is titled "CaseNumber".
View 9 Replies
View Related
Jul 19, 2006
When I click a button on my [Student] form it opens the [Family] form. I created a find button, but it can't find anything when I use it. Now, if I open the [Family] form directly then the find button works like a charm. What's wrong?
View 1 Replies
View Related
Jul 9, 2014
I have a form ("Contacts Form") that I use with a few subforms on it. One of the subforms is "sbfrmCompanys" that has information on the contacts company. One of the fields in sbfrmCompanys is "Organization." Users used to be able to use the "find" feature to search for an organization's record, however the "find" feature suddenly stopped working. Now, when a user searches for an organization that I KNOW is in the company table, a dialogue box appears that says Access has finished searching and no records were retrieved. This cannot be so because I know for a fact the particular value I am searching for is in the table.
View 7 Replies
View Related
Nov 9, 2013
I'm using a split form with the datasheet on the left.
When I use the 'Find' in the Navigation buttons at the bottom of the form, it refuse to find text in a particular text box.
The text box is a memo field and is enabled.
Example:
I have text in the memo field which is a title of an episode - "The Outcast."
When I start typing "the" it finds this text in the memo field. But when I type the entire title it the finds the text in another field. ie "out."
I've tried the 3 different Search setting in options. When I use the Find command from the ribbon it work ok as long as I select the text box to search in first.
View 1 Replies
View Related
Apr 18, 2007
I converted an old Access 97 "mdb" to Access 2002 SP3.
I then added an option button within a frame. The problem is the new option buttons properties does not include "Option Value". How do I get this property to show up within the properties?
View 4 Replies
View Related
Aug 1, 2014
I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible?I have a query QryMainReport:
Start Date/Time
End Date/Time
Employee
At the moment this is what the format of my report looks like (I removed other unnecessary fields):
StartTime----------EndTime---------------Employee
12/06/2014 01:00--12/06/2014 03:00------John Smith
12/06/2014 04:00--12/06/2014 06:00------Jane Doe
13/06/2014 02:00--13/06/2014 05:00------John Smith
13/06/2014 08:00--13/06/2014 08:00------Jane Doe
I would like to do as a report. (Dates would always be from Sunday to Saturday). I am not sure it is possible to do that. I suppose first it would mean:I would have to do a query to separate the times from the dates?I would have to find a way for Access to find the unique dates and unique names?Does it mean I have to use cross tab queries?
View 2 Replies
View Related
Dec 17, 2005
Hello,
when I open a db created in access xp in access 2003 I get this error the first time I open a form:
Quote: Your Database or Project contains a missing or broken reference to the file 'DAO350.dll' version 5.0
* ... you mus fix this reference.
When I open it in code to look at the refs it isn't there and neither are ANY DAO's.
HOW can I remedy this?
THANKS
View 3 Replies
View Related
Aug 22, 2006
:confused: The View>Toolbox menu item is grayed out on an Access 2003 database I am using yet it is visible if I start a new database. So the problem seems specific to the db - can anyone help me out?
View 2 Replies
View Related
Nov 14, 2006
I started access today and all my icons and menus are gone from the interface. I am forced to right click on all my queries and tables to perform any action. All I have at the top of my window is the usual "Microsoft Access" caption. Absolutely nothing else. Other than that, Access is fully functional provided I can use the right click commands. Has anyone encountered this? Help!
-Nino
View 14 Replies
View Related
Oct 7, 2005
Hi all
This is an ongoing problem I have had for 4 weeks now.
I have made a a system thats acts like a clock In/clock out Out system.
the structure is somthing like this
ID
Username
tblDailyLog
TimeIn
MorningBreakOut
MorningBreakOut
LunchOut
LunchIn
AfternoonOut
AfternoonIn
TimeOut
All fields apart from ID (autonumber) and username (String*255) are Date field (there are a few others like DateOfTimesheet etc but they arnt important here)
When a user arrives in the morning they make a record which they use for the day
They then have a form with a whole bunch of buttons which simply updates the correct field. For example they click the "Sign in for the Day" button and it updates the correct field with the current time.
Everything was going fine until people noticed that every now and again a sign in time dissapeared.
I have hacked myself to death trying to solve this problem but still the updates go Astray.
Now each time a time is updated the process goes somthing like this
1. the user opens their timesheet for the day (the RS is SNAPSHOT and no locks)
2. User Hits a sign in/out button
3. The record source is changed to "" and all buttons hidden (to ensure the record isnt locked and to make sure you dont do two things at once)
3. The table is updated with the new time (using some dynamic SQL)
4. The table is repeatadly checked using a DO loop to make sure the the correct time went in.
5. when the returned time value of the field matches the varaible used to update it, the form is returned to normal and the user carries on his/her merry way (if it never matches the screen should crash but this never happens).
6. A New record is added to another table called "tblbugfixinglog" which records which field was updated and when. This is so that I have two records in two different ways (figured if one went astray I could pull it back off the other)
7. Another new record is added to yet another table called tblSQLRecord, which simply logs all .RUNSQL statements that are executed.
I thought that the two extra tables (and the check that the record had been updated) would help me track down where the records are going missing, but this isnt the case.
Now it appears that some records arnt being added to tblBugFixingLog and to tblSQLRecord either and some of these tables are getting quite a few #ERROR's in them..
None of the tables are related to any other and i've no idea how #ERROR lines are appearing in a table that has 1 function... to recieve new records ... no editing, no viewing, no deleting.
Does anyone have any idea how these updates/inserts can go missing or create #ERRORs.
I've built plenty of Databases in my time and have never come across this.
__________________________________________________ ______________
This is the function I use to add a record to tblBugfixingLog and tblSQLRecord
Private Sub AddBugLog(ByVal TimesheetNumber As Long, ByVal FieldUpdating As String, ByVal NewFieldValue)
Dim TempSQL As String
TempSQL = "INSERT INTO tblBugFixingLog (TimeAndDateOfEntrySERVER,TimeAndDateOfEntryPC,Fie ldUpdated,NewEntry,UserID,TimesheetNumber,Computer AssetNo) VALUES (" & _
"#" & Format(ServerGetTime(Environ$("LOGONSERVER"))) & "#," & _
"#" & Now & "#," & _
"'" & FieldUpdating & "'," & _
"'" & NewFieldValue & "'," & _
"'" & GetNTUser & "'," & _
"'" & TimesheetNumber & "'," & _
"'" & fOSMachineName & "')"
' MsgBox TempSQL
DoCmd.RunSQL "INSERT INTO tblSQLRecord (Username,DateAndTime,Screen,TheSQL) VALUES('" & LoginInfo.sUsername & "','" & CStr(Now) & "','Add Bug Log function','" & CleanData(TempSQL) & "')", False
'CleanData is a function that removes ' and " from the SQL string so i can easily add the SQL string into the table
DoCmd.RunSQL TempSQL, False
End Sub
Public Function CleanData(ByVal DataToClean As String)
Dim TempData As String
Dim i As Integer
TempData = ""
For i = 1 To Len(DataToClean)
Select Case Mid(DataToClean, i, 1)
Case "'"
TempData = TempData & "`"
Case """"
TempData = TempData & "`"
Case Else
TempData = TempData & Mid(DataToClean, i, 1)
End Select
Next i
CleanData = TempData
End Function
__________________________________________________ ____
I have no idea how this can create #ERROR lines in the table when it is just added to and nothing else.
Does anyone have any clue to what may be happening here.
(Oh yeah and no matter how hard I try, I can't replicate the problem.... works for me every time no matter how harse I am to it!)
Please save what little hair I have left and give me some hope
Cheers
Homer
View 1 Replies
View Related
Sep 24, 2003
Hi all,
It's my 1st posting! Need help on how to get Unbound OLE objects (i.e. lines, pics, et.) reflected when publishing my Access report into MS Word. So far, only the data are exported. Appreciate your help.
System Info: Intel Celeron 700MHz, W98SE, MS Access 2002
View 4 Replies
View Related
Mar 8, 2014
I've got an Excel sheet with +700k rows and 20 columns that I wanted to import to Access. All fields are text except the field that I want to use as a primary key, but I planned to import that as a text as well.
When I used the import wizard, I set all fields to import as text except for three that I set to memo. The wizard didn't say there was any error after importing the data, but when I checked the table, I noticed there were *a lot* of records where many fields where blank. Some fields where completely unaffected by this problem throughout the entire table, but in the rest of them, there is data missing in many records, and when there is data missing, it is not always the same fields that are missing. I have been unable to find any pattern that explains why sometimes the records were imported correctly, and why sometimes they were not.
View 2 Replies
View Related
Sep 14, 2005
Hi,
I've created a database in access 2003 with the default file format being Access 2000. Everything works fine on my computer and many others, all of whom are running different versions of access (2000, 2002 & 2003).
I have not had any problems with this database until recently and in the last few weeks we have had 2 users, both of them being Access 2000 users who have had the same problem.
The problem they are having is that when they click on any of the switchboard items, the buttons depress an then come back up again when the cursor is moved away, but nothing else happens - no action, no error message - nothing!!! Its the same for all of the buttons on the switchboard.
Does anyone know what is causing this? I have another computer with Access 2000 on it and this works fine, as it does on several other computers runiing Access 2000, I just cannot understand why it is not working on these 2 particular machine.......
Many thanks in anticpation.
Steve
View 3 Replies
View Related
Dec 7, 2005
i am trying to use access 2000 database onto to access 2003. When i try to click design mode to change something it gives me this message:
You dont have permissions to modify.
If i run it on access 2000 it runs fine.
Someone please help.
View 5 Replies
View Related
Apr 26, 2005
Hi.
I am having a hell of a time trying to make my order and invoice processing database to work properly with useful functions. Is there any online resource from which I can download a working example of such a database in order to use as a case study and examine how everything relates and how complex order forms are created? :confused:
Thanks.
View 2 Replies
View Related
Nov 11, 2005
My access installation opens databases reasonably well. I can create databases, add tables, etc. However, I cannot:
1) Add a command button or data-related fields to a form: the "command button wizard" stops responding on the first screen. If I click "Cancel", the button depresses, but the wizard doesn't close.
2) open the "Linked table manager": Access crashes
3) import an Excel spreadsheet: Access crashes
I suspect these might be related.
I've tried these with various databases, some on my local C drive. I have also tried these with various excel files. Not being able to add data items to forms is particularly irritating -- I don't want to build my own front end (that would sort of ruin the purpose of using Access, except that it happens to be a database already on my desktop).
One other thing -- when I start up a database, it always gives me an initial "Installing components" message. This occurs similarly for other MS office applications as well. I don't know whether this is related. I do have admin rights on my local machine, and have tried the "Repair MS Office" function in the Control Panel.
I don't necessarily expect an "answer", though some advice on how to proceed would be great.
Thanks in advance,
update: Access 2002, Win XP box
View 2 Replies
View Related
Aug 18, 2004
I'm beginning to think it is a windows issue and not access issue. I have a couple of users that weren't able to click on the form shortcuts on thier desktop. They had been able to use them earlier in the day, but later double clicking them would not bring up Access. I had them use Window's explorer and try to click on the MDB file to bring up access, but that also didn't work. But launching Access directly, then open existing files, would open up the database for them.
Rebooting let them use the shortcuts.
Any idea what might cause this? They have been using the application for a couple of months without mishap until today.
Has anyone seen this behaviour before. If so, how did you fix it?
David
View 1 Replies
View Related
Jun 1, 2006
Ok, so I made a registration website with FrontPage and published it. The registration page has several text boxes and a submit button. I was testing it out and entered a few dummy names. The conformation page popped up and said everything was ok. So I'm assuming the data successfully uploaded into the Access DB that I linked it to while in development.
My problem is when I go to the folder where the DB resides there so no data in the tables. I'm thinking that maybe when the website gets published a copy of the DB is moved somewhere and I'm looking in the wrong place? This is the first time I have made a webpage or used FrontPage so please excuse my ignorance, hehe.
View 1 Replies
View Related
