General Forum

Greetings, I am currently trying to organize some data in a way that is straightforward to parse in my web application. Here is the query: select SN, Date, ActionDefID, Actiondef.SeqNum, Actiondef.SubSeqNum from dbo.ActionLog join dbo.ActionDef on dbo.ActionLog.ActionDefID = ActionDef.ID_ActionDef join dbo.serials on...

Does anyone know where i could get the source code of a Point of Sale system i would like to compare it with the one i have

Hi, I have created a test database on the production server. But I want to point that test database to the test server. I am using SQL Server 2000. Any help would be really appreciated. Thanks

I have a Word document to which I've added several fillin fields to prompt the user for information. The AutoOpen macro runs when the document is opened so that the calculated fields are updated based on the info provided by the user. I would like to have the fillin dialog boxes set up so that when the user presses Enter, it activates the OK...

hai, i am working with a asp.net project, suddenly i got this error. error message: The compiler failed with error code 1. how can i rectify? uma

Hi, I need to display a message " NO EMPLOYEES TO REPORT" after the Top Title in a SQLPLUS report when no rows are retrieved by a select statement. So how do i go about? Regards, Nithasha.

Hi, I got the following error on doing a vacuumdb : NOTICE: RelationBuildDesc: can't open obo_switching_sql: No such file or directory ERROR: _mdfd_getrelnfd: cannot open relation obo_switching_sql: No such file or directory I can do a \d on the table, but can't select (same error as above). I tried the following without success...

Hi folks, I got a requirement in my project where in when my application is activated another window should get activated and upon it my application should be present. Both should be in restored state not maximised. To accomplish this, in the activated event of my MainForm I first activated the other window and then activated my window. I've...

ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /admin/database.asp, line 180 I am currently getting this error? I'm using an access database.

Hi there I am currently creating a Maintenance Form, which can change the status of an employee from Active to Inactive. However when I created the form I want their current status to be displayed. For instance, there is drop down box containing the name of the employee and next to it there is a drop down box with either Active or Inactive in...

i did have some date functions in place in a query in the criteria to show only the records which have the date in the next week....it never particularly worked im sure theres an easy solution can anyone help?

Hi everybody. I was just wondering how did editors were protecting their source code from decompilers and reverse engeneering. I heard one method of source code protection was by obfuscation: http://en.wikipedia.org/wiki/Obfuscated_code Does every editor use Obfuscation? How does large software editor like Microsoft protect their...

Hi everybody,I’v a question in a Vb.Net 2003 program,How can save or(insert) all the rows that I fill in a datagrid to be saved in itis datasource(table)at one time ,because my insertion code just save and insert the row where the curser is on it.So,IS there a solution. With thanks, here is my code, Imports System.Data.OleDb Public Class Form7...

Hi I need to write a Postgres function which executes a cursor. Query of this cursor however is created on the basis of parameters passed by user. if(user_Input = 'a') l_query := l_query||a_from_clause ||'where ename = '||user_Input else if(user_Input = 'b') l_query := l_query||b_from_clause||'where ename = '||user_Input

I am working on a Microsoft Access database for a drug rehab clinic and this is what I need to do. I need to beable to take DaysSpent and multiply by cost per day to get CostOfStay. What is throwing me off is there are two pricing catagories(ProvService) and I cant figure out how to multiply by each pricing catagory. Note:when...

Hi there I am currently making a sub form. The form will have a combo box and a option group. The combo box contains a list of four employees. The option group has to radio buttons labeled Active and Inactive. These radio buttons will show the status of each employee. However, how can I show the current status of each employee. For example, If...

I'm working on a large database project. In this database, there is a table named 'books'. User can sort with title, author or date. Because this table is large I don't want to use datasets to do paging. I would like to have a new field with auto numbered values whenever I sort with any field, so that I can page the items properly. The database...

Hello, I am working on desgning a database however I am stuck at one point. In my customers information section you can create workorders, there are 2 subforms, one for labor, one for parts. The one for parts cannot calculate sales tax properly (it is for a state that does not tax labor). It is figuring the sales tax on each individual part item...

Hello, on my database I cannot figure how to adjust to following expression =nz()+nz()+CLng((nz()+nz())*nz()*100)/100 to not calculate sales tax on labor. What adjustments should be made? Thank you

hello any body want help me to develop my web version 2.0 concept

i have a form with three Option groups and one combo box and i am trying to filter it out to the subform that i have on the same form. here is the code, everytime i try to click on Apply Filter. its not working. my filter is not showing on the subform. Dim strmarket As String Dim stradvertisers As String Dim strheading As String...

Hi! I'm using C# as script to launch an IE windows using the Interop SHDocVw.dll's ShellWindowsClass.Navigate(...) function. Now I want the 1. newly launched window to be opened maximized. and 2. If this window is minimized then restore it. Is there any class in Interop SHDocVw.dll, through which I can achieve this? Presently the opening...

I am attempting to get a total of production per each shift of work, which there are 3. The below expression works fine for Shift 1, but Shift 2 and 3 are showing blank values. I rearranged the expression, but then Shift 2 and 3 show the same duplicated value as Shift 1. =IIf(="1",(Sum())/((Sum(+)*))) =IIf(="2",(Sum())/((Sum(+)*))) ...

I need to compare data sets that have been updated with newer versions. Is there a way to compare the old data set to the new one and determine what tables differ? The environment is DB2. Thanks for your help.

hello All oracle gurus i need help on the above topic. any help will be much appreciated thx :)