I missed that inital CDate on the original post, but it was in there. It still doesn't work. I've been running this application since 2003 and haven't had any issues until a couple of months ago when the users were pulling data when the jobs on the server were running.
Any other suggestions...
I have a query that pulls data from a table that has 5.7 million rows. The query has a date field (DTM) among several other fields that I pull. The DTM field has a criteria string that looks like this:
Between [forms]![frmMain]![StartDate] And CDate([forms]![frmMain]![FeederEndDate])
It is...
It fires when an entry is made into the eventlog table. The eventlog receives its entries from many different events in the field. However, my trigger only captures breaker operations. The trigger is fired after an INSERT into the eventlog table for each row. Yes, this is a SCADA system.
I...
...NUMBER;
CURSOR cur IS SELECT id, tag, short_name FROM lakdba.breaker_tags;
CURSOR cur2 IS SELECT breaker FROM lakdba.gens_not_acc;
--**************************************************************************
------------------------------------------------------------------------------...
A style I created called Main Topics. This style is applied to both the FORMS and REPORTS label.
Thanks.
jodom
LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!
Samaba,
Word 2003 and Adobe 7 Professional.
Once I was satisfied with the document in Word, I clicked the "Convert to Adboe PDF" button on the Toolbar.
On my first response, I forgot to check the change converstion settings. I'v since corrected that. Now I have Main Topics as a bookmark and...
Samaba, thanks for your reply.
I did what you said. I created a Style called MainTopics and formatted to my liking, I did the Paragragh, Outline Level and selected level one. I applied it to 3 places. My TOC in Word looks fine, but on conversion to adobe, it acted like it didn't even...
Using Word 2003 and Adobe 7 Professional.
I have written an application and want to create a help guide for the users. I want the words FORMS and REPORTS to be main headings in the Table of Contents in Word. They both have several subheadings. I've done this part and it works correctly. When I...
Aubs
I was having the same issue that Carina was having. Your suggestion Try "un-ticking" the option "Windows in Taskbar" found in Tools-->Options-->"View Tab" worked.
Thanks
jodom
LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!
I'm studying to take the IZO-007 exam. However, I originally had the Oracle OCP Introduction to Oracle 9i: SQL Exam Guide, but it had a lot of obvious mistakes. Now, I've purchased the OCA/OCP Introduction to 9i SQL Study Guide by Sybex and this book has mistakes also, but it seems so much...
foolio12, I used this whole format and it worked. Thanks for your help.
=Format(CDate(CDbl(DateDiff("n",[FIRST_TC],[COMPLETE]))/(60*24)),"Short Time")
jodom
LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!
...way, I can just use DURATION on the report instead of typing in the whole thing. I tried, using your suggestion (Format(CDate(CDbl([DURATION])/(60*24)),"hh:nn")), but the problem is, ACCESS converts the last part "hh:nn" to "Short Time". Another thing, I'm assuming that DURATION is a date...
I have a database that is being converted to XP. I have a field on a report that is called DURATION. DURATION is the difference between COMPLETE and FIRST_TC in minutes. In ACCESS 97, on the report I formatted the field to (=Format([DURATION],"hh:nn")). This forces the minutes to be converted...
This isn't a module; however, it passes the values to a module. The ON_ENTER's refer to bound controls in a record that are on the form.
**And Yes, Me.NET_MWH_TLQ.value is the same as NET_MWH_TLQ, thanks for that.
**ctrlTemp.Text is the same as ctrlTemp
**ctrlTemp.Properties(1) is the same...
Using Access 2000, Windows 2000
I have created a form with 5 buttons on it to open forms. Four currently work. When I added the 5th button today to open the form (just like all the rest) it goes straight into the ON_ENTER code on the form.
When it gets to this point in main code that calls the...
Using CR 8.5 Developer. I have several reports that I am needing to deploy on user's machines that do not have CR (they shouldn't). Anyway, the reason why I purchased this reporting software was because I was told by numerous people that it was extremely easy to deploy and view on other...
Are you prompting the user for the employee number?
If you are, are you then wanting to pull back employee information on that employee based on what the user entered, yes or no?
-j
synapsevampire, the RecordSelectionFormula works because I am using the same criteria for other reports. However, the other reports are single table reports.
Ken, I am using CR v8.5. After reading your response I have since recreated the report in stand-alone CR and imported it into VB's...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.