I must be missing a reference somewhere, but I have a form with several calculated fields in it, with the control source as =DateDiff.... They were working fine last week, but now all it displays is #Name?. What happened? I've looked at my references and none appear to be missing. WHich one do I need to add to make this work again? Thanks for you help.
View RepliesI am getting a missing reference warning - I have found the reference on google and downloaded the file but now do not know what to do with it. Underneath Tools the references are greyed out so I cannot check or uncheck anything. i have checked on another machine and the .ocx files are stored in program Files - VideoSoft but this computer does not have a VideoSoft folder. I am totally confused since it all worked about three weeks ago...
Help?
When i open the database i get an error message saying there is a missing reference. I cannot get into Tools - references to tick/untick boxes as the references is greyed out. Why would this be?
View 2 Replies View Relatedmissing or broken reference to the file ‘plugin.ocx’ version 1.0, and also in file 'msoutl.olb version 9.2’
It says I need to fix these references to ensure the database or project works properly.
(The references shown as MISSING in the Visual Basic Editor are:
Microsoft Active X Plugin
Microsoft Outlook 11.0 Object Library)
Clicking OK lets me into the database and all seems to work fine. However, the last thing I want is for the whole thing to fall over and become corrupt so any assistance would be greatly appreciated.
Hi everyone,
Im building a database as part of a group project for uni. Its almost finished but recently on first opening the DB and clicking on a button on the form we get the following message boxes:
Firstly:
Your database contains a missing or broken reference to the file ‘OWC10.DLL’ version 1.1.
Click ok
and get...
Your database contains a missing or broken reference to the file ‘MSCHRT20.OCX’ version 2.0
When i click help it talks about deleting references but im not sure how to do this as im no expert by any means! :rolleyes:
I think this problem may have arisen because our accountancy department computers use access 2003 and the rest of the uni uses xp and we have been working on them both - oops! :(
Anyways i was wondering if anyone could point me in the right direction to fix these problems?
Thanks in advance.
Mark
Not sure if this is a access or windows problem but I thought I'd see if anyone has an answer. I have a database that I built to track certain requirements and generate reports and preformatted letters. On the win2k machineeverything works just as planned. When moved to the server, that same machine still has no problems. However when I move to a winxp machine (still using office 2K) the database statrts into the control panel like normal. Problem is as soon as I try to open the first form I get an error that the database is referencing a broken or missing file "outlctlx.dll". The only real code I have is the mousehookmod which to the best of my knowledge was written by Terry Kreft & Ken Getz. This is the only other thing I can think may be calling that dll, but can not find the call reference. Any help or suggestions would be appreciated.
Narack
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
Please help, how can I refer to the field of a subform in Visual Basic when the (main) form is open?
A)
Private Sub supplierID_AfterUpdate()
Forms![invoices]![KombináltLista4].Requery
End Sub
B)
Private Sub supplierID_AfterUpdate()
Forms![details1 Segédűrlap]![KombináltLista4].Requery
End Sub
These don't work. (The main form: INVOICES; the subform:DETAILS1 Segédűrlap; KombináltLista4 is the name of a combo box)
The version B work, when I open the form and the subform together, but of course I'd like to work only on the form (where the subform is displayed as well, but I can't refer to it...)
THX
I created a new database and i am getting an error.
Your ILFdatabase database or project contains a missing or broken reference to the file 'SearchCtrl.ocx' Version 1.0
Can anyone help?
I need to change the reference "Microsoft Access 9.0 Object Library" in Access 2000 with the "Microsoft Access 11.0 Object Library" but I can't de-select it 'cause it's used by the program. Another problem is that I tried to import the 11.0 copying the file and when I select it from the panel control it seems to import without problems, but when I search it in the list, the 11.0 doesn't exist.
How can I import it?
Heya,
In your opinion, what is the best Microsoft Access 03 Reference book for learning?
Mateo
Hi, I have been designing a database on my computer which seems to be working fine; 2 more users in the company should be able to use the database.In order to see if everything was working properly on other computers, I have put a copy of my db on the server and tried to open it on the other users computer station. Unfortunately, the reference library that I have been updating during the design of the database doesn't seem to apply to the other computers. I have been trying to update it on the other machine but the references on the tool menu in open module is not available.
I didn't expect this to hapened and I am not sure what to do, what would be the apropriate method to make the library available to the other computers?
Is there a way to insert a calendar on a form from which a user can select a Month year and day similar to using the calendar on Outlook or Lotus Notes to set up or view appointments or meetings?
View 5 Replies View RelatedHi,
I have created an mde that was installed on more than 30 computers. All of them work fine but one who gets a message saying that there is a broken or missing reference. How can I repair this knowing that I cannot access the references in a mde?
Thanks!
Hi,
I have an SDK that I normally use with VS.NET. I cannot seem to add the .dll as a Reference in my MS Access 2003 database. Is there something I am doing wrong, or a workaround to get it to work? I have .NET 3.0 installed on the PC.
Thanks,
Hi,
I have a form (frmSWL) with a subform container on it (subfrom1) which has a source object called frmSite. How do I reference frmSite from another form so I can apply a filter to it??
I am trying:
forms!frmSWL!frmSite.Filter = "......."
, but it is not working.
Thanks,
I'm trying to achieve something that I'm sure someone has figured out long ago. I have a DB that currently only shows the zip code for certain records. Is there a way that I can have the DB take the current zipcode, reference a zip code table, and then return both the zip and city/state?
Thanks
Hi guys/gals
My primary key, RefNumber, is a sequentual Autonumber field. I want to creat my own Custommade autonumber field, but the catch is:
My autonumber field should have any of the following (selectable by the user from a combo box from a Form) attached in front of the number: DPR,DPZ,DFE,DGL,DMI,DGJ or DPE.
ie: the autonumber is at 14. The user selects DFE, but this is only the seconde choice made of DFE.
So the end product should be: RefNumber = 14
.........................................DistrictR efNumber = DFE2 or DFE002
Help please?
Thanks in advance
Hello, I have been struggling with this for a while, and I'm hoping I can get some help. The problem I have relates to three tables. I pulled the tables off to the side to show the current relationships between them; Please see attached.
Here is my setup. I created a form that has all the fields in tblEntry, and a combo box whose record source is [EmployeeID] in tblEmployees.
The problem, when the user selects from the combo box, I am getting an entry for the field [EmployeeID] in tblEntry, but I am not getting an entry for [CategoryID] from tblCategory. Basically, I want the user to be able to select one thing and to get two entries: [EmployeeID] and [CategoryID].
Can anyone help me?
Thanks.
I have StartDate and EndDate fileds where I enter the date and time the employee starts and finishes his shift (in dddd dd mmmm yyyy hh:nn AM/PM format). However there is a penalty issue that starts at 7.00 PM.
How do I set up a non changing reference for 7.00 PM that I can reference to make a calculation.
For example I need to calculate penalties for when the employee works hours past 7.00 cutoff time.
I would appreciate any assistance to solve this problem
Thanks
I have StartDate and EndDate fileds where I enter the date and time the employee starts and finishes his shift (in dddd dd mmmm yyyy hh:nn AM/PM format). However there is a penalty issue that starts at 7.00 PM.
How do I set up a non changing reference for 7.00 PM that I can reference to make a calculation.
For example I need to calculate penalties for when the employee works hours past 7.00 cutoff time.
I would appreciate any assistance to solve this problem
Thanks
I am writing a query to calculate a running value, looking at the result of the line above and adjusting the running value in relation to new criteria. Make sense ?
For example
I have a number of dates which each have a value (a) against them dependant on the value in (a) I want to reward it in different ways and store the result in (b), I then want to look at (b) in the result of the above line in acessing how I will reward the next record.
Basically I want to read the value of the result of the line above when calculating the next line ? So it is basically cumulative through the query.
ps just found this forum so sorry for postiong a question first but any guidance appreciated.
Which ones are the best?
View 1 Replies View RelatedWell, thanks to SJ McAbney I have a nice chart on referencing subforms from the main form and what not. I'm still having trouble making it work, so I am sure there is something that I don't understand here.
Private Sub cmdNewCat_Click()
Me.frmNavSNewCat.Visible = True
Me!frmNavSNewCat.Form!txtCatParID = Me.txtCurrent '<---This is the one the debugger highlights.
Me!FrmNamsNewCat.Form!txtCatName = ""
Me!FrmNamsNewCat.Form!txtCatNote = ""
End Sub
When I click the cmdNewCat Button, I get this error:
Run-time error '-2146500594 (800f000e)':
Method 'Form' of object '_SubForm failed
Anybody know what I'm doing wrong?
Hi,
I have designed a report and the underlying query has a parameter that pops-up whenever the report runs. I want to print the value of that parameter in the report header. If I just reference it exactly how it is in the query, while the report runs, it asks for the value of the parameter again! Once with the underlying query and once with the report... How do I ask for the parameter value just once and get the data records filtered using that value as well as print the parameter value?
Classic example of use: I want the report to print records upto a certain date. The date is the paramter value. I want to filter the records based on this date and print the date in the header.
Thanks!
I am using Office 2003. I tried entering this line of VB code :
Dim Db As Database
but got the following error :
Compile error : User defined type not defined
checked the net, which said to open the module window, go to Tools>References and check the DAO 3.06 box... but it said in Office 2003 i dont need to do this...Anyway i tried looking at the references but DAO 3.06 is not even there... pls tell me what to do