You just broke a rule dear !!! You should have taken a look at the title of the thread. But I guess thats what happens when you post on two threads one where you have to answer in yes/no and another where you don't.
I like watching hollywood movies and sometimes our own bollywood products too !!!
Okay,... Now you may (possibly... don't freak out yet) either have bad registry entries or corrupt dll's
:-O :S :X :sad: :sweat:
and you are getting this message from Access right? Not Visual Basic 6.0!
Yes, it occurs when I open a particular database in MS Access...
Does any other database open on your computer with Access?
I just tried another which I last worked with in February of this year (without a problem), and it's also giving me an error when I clicked on 1 of the items in the switchboard menu..."Your database or project contains a missing or broken reference to the file 'Dao360.dll' version 5.0. *To ensure that your database or project works properly, you must fix this reference., so I click the ok button...then it goes to the database as if nothing was wrong in the first place".
Are you running a 64 bit version of windows?
:-/ ...No
If you are able to open a database or create a new one are you able to get to references with that one.
I am able to get into the reference box when I opened a mdb template...I am selecting all the references...but when I clicked ok, I got an error message box with the message 'Error loading DLL' with an OK button...:-/
And finally...
It highlights that line. Is that line all by itself, or is is part of a procedure...
Public Function resetCharSet()
'code here
End Function
I am not knowledgeable in VB nor in MS Access, so kindly excuse my ignorance.
I received an MS Access database which is unable to open on my computer (for whatever reason), but is able to open on 5 different computers. At first I thought it was an MS Office version difference issue, but 2 of the 5 computers has the same MS Office version as my computer.
I therefore looked at the files the database is trying to locate before opening, and saw that it was looking for a .DLL file by the name of DAO350.DLL, after much searching, I came up empty-handed. There were no such file on my computer, so I downloaded it from the internet, but that didn't seem to make any difference.
Then the MS Visual Basic Compile tool came up, and displayed the following error: Compile Error: Can't find project or library
So I click the 'OK' button, and this function is highlighted in yellow: Public Function resetCharSet()
Since I do not know what to do, I closed the MS Visual Basic Compile tool, and a message box came up: This command will stop the debugger
So I click the 'OK' button, and MS Access displays an 'Action Failed' message box with the following information: Macro Name: AutoExec
Condition: True
Macro Name: RunCode
Arguments: resetCharSet()
Error Number: 2950
And the only button on this message is 'Stop all Macros'. …
I am not an MS Access Expert, so kindly excuse my ignorance.
I received a database which is unable to open on my computer (for whatever reason), but is able to open on 5 different computers. At first I thought it was an MS Office version difference issue, but 2 of the 5 computers has the same MS Office version as my computer.
I therefore looked at the files the database is trying to locate before opening, and saw that it was looking for a .DLL file by the name of DAO350.DLL, after much searching, I came up empty-handed. There were no such file on my computer, so I downloaded it from the internet, but that didn't seem to make any difference.
Then the MS Visual Basic Compile tool came up, and displayed the following error: Compile Error: Can't find project or library
So I click the 'OK' button, and this function is highlighted in yellow: Public Function resetCharSet()
Since I do not know what to do, I closed the MS Visual Basic Compile tool, and a message box came up: This command will stop the debugger So I click the 'OK' button, and MS Access displays an 'Action Failed' message box with the following information: Macro Name: AutoExec
Condition: True
Macro Name: RunCode
Arguments: resetCharSet()
Error Number: 2950
And the only button on this message is 'Stop all Macros'. So I click this …
The TIMEDIFF function would be calculating the difference between 2 set of times... unless you mean to say to calculate the difference between the 2 times...but it isn't comparing 2 individual times...there are 2 lists of times that needs to be compared...
I was trying to research my problem, but wasn't getting any results to satisfy me.
The problem is:
I am storing data in a mysql database (the server time is stored as well), I am also uploading data into this database from a file that was downloaded from another server (I have no access to this server). I have to generate reports doing a comparison but the dates are not matching up, and I am therefore not getting a proper report...the thing is that the lowest level of search criterion is the time, the level before that in the date (which works like a charm), but the data isn't accurate.
My question is:
Can I compare these 2 times to get an approximate result...taking into consideration the time goes down into seconds and milliseconds, etc...
I am working in Oracle10g and I have been trying to run the following query, and am getting an error:
Query:
SET VERIFY OFF
VARIABLE emp_salary NUMBER
ACCEPT empno PROMPT 'Please enter a valid employee number: '
SET AUTOPRINT ON
DECLARE
empno NUMBER(6):= &empno;
BEGIN
SELECT salary INTO :emp_salary FROM employees
WHERE employee_id = empno;
END;
/
Error:
empno NUMBER(6):= ;
*
ERROR at line 2:
ORA-06550: line 2, column 19:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively-quoted S
EMP_SALARY
----------
SQL>
If the error shows up distorted...the asterisk is located under the semi-colon in the error... Could anyone guide me accordingly?
I remember I had a similar problem, and did all the changes suggested here, but the script actually only worked after I restarted the machine (my machine was relocated...so it was a complete restart)...
"When any individual determines to achieve something in life, to reach any particular goal, they should not break down even if they are not able to achieve it in the first try." --Maydhya Maraj
I only saw the dress in the pic there by GrimJack....and yeah, it is a really ugly dress...on both persons...even if the most beautiful women wore it, it wouldn't make a difference...the dress is hideous!!!
