Search results for query: *

Hello, I have a database table that I can query for store items. Each item in the table has an associated purchase date and an associated store. How would you suggest writing a PLSQL script that first sorts the data in the table by store, item and purchase date and then only prints out only...

Hello, I am receiving an invalid character error message when I attempt to execute the SQL below in my VBA application(db is Oracle 9i). Oddly enough, I can get this SQL to execute in TOAD without any warnings or errors. Any assistance would be greatly appreciated. Thanks in advance. -Cassie...

Hello, Please bear with me, I am very new to Tomcat installations. I am able to successfully install and configure Tomcat 5.5 on my laptop. To my understanding, there is a patch that needs to be applied to Tomcat 5.5 in order to execute servlets with the servlet invoker and compile jsp pages...

Hello. Help. I cannot figaure out what is wrong with this SQL. I am trying to display an average cycle time per site. I end up getting the same result for all sites. Thanks in advance. -Cassie select SITE, AVG(CycleTime) as AVG_CT from (select SITE, ROUND(DEC_DATE-VIS_DATE,2) as CycleTime...

Hello, The code below successfuly opens a remote database. Is there an option that I can add to the path that opens XP_Foo.mdb if it is password protected? Thanks in advance. Cassie <SNIP> Dim strAccDB As String Dim strAccLoc As String strAccDB = """" &...

Hello. Please bear with me. I am not very savy with wireless technology. Oddly enough, the problem that I am experiencing follows a pattern. After approximately 30 minutes of strong network connectivity, my network signal is lost (regardless of proximity to the access point). I'm quite...

Hello. I have a command button on a MS Word form. I would like to open a MS Outlook window with the MS Word form as an attachment. That's easy enough... Private Sub cmdSendOfficeReq_Click() Options.SendMailAttach = True ActiveDocument.SendMail End Sub The question is how can I...

Hello. Currently, the report footer of my report contains a chart. I am looking for a way to display just the chart on the footer (I do not want to see the report header here). Is there a way to print the report footer without my page header? Thanks in advance. Cassie

Hello. My dilemma: I would like to create a function that returns the UNIX system date with a julian day format (date +%j). Since it doesn't look like I can use: int jul; jul=system(&quot;date +%j&quot;); return jul; Any ideas on what I could use to make this work? Thanks in advance. Cassie

Hello. Is there any way to open a form when referencing the path of a database at the command line? Is there a switch available to do this? Thanks in advance. C:\Program Files\SomeDbFolder\SomeDb.mdb ?frmSomeForm? Cassie

Hello. I am looking for code examples to dynamically create a form in access each time a table is updated by a user. Records may be added or removed from the table. Does anyone have experience with this? Thanks in advance. Cassie

Hello. I would like to read in the system date of the pc and convert it to a julian date. Is anyone aware of a julian date class? Thanks in advance. cassie

Hi, Please bear with me, I have very little experience with C++. I have an external .dat file with a defined format. e.g. lastname (cols 1-15), firstname (cols 16-30), mid_init (col 31), etc... I would like to read in this file and assign a variable for each item read in. Can someone get me...