Recordset trabalhos

Hi, I need a statement to work with two tables Fig(1) to achieve the Fig(2) results Fig(1) Table A Data Table B Data 7 5 3 C 8 2 9 D A 1 5 2 C B 1 4 D 6 What I am wanting to do is have a SQL statement That will create a recordset having all of the records from Table A and showing the records from Table B at the top of the resultset Fig(2) Desired Result 5 - These were the results from Table B C - These were the results from Table B 2 - These were the results from Table B D - These were the results from Table B 1 - These were the results from Table B 7 3 8 9 A B 4 6 ## Deliverables 1) Just need the SQL Statement ## Platform SQL Server 2000, WIN 2000

...worksheet (bittel), insert a new row above the third one, populate each of the columns with what has been selected in the combo boxes, et al, reprotect the worksheet, and save the workbook. 2) CommandButtonSaveAndExit_Click() needs the same functionality as 1) above, plus the workbook needs to be saved and closed. 3) CommandButtonUpload2Server_Click() needs to produce a http post containing a wddx recordset of the ServiceDataSave worksheet to probably using Allaire/Macromedia's WDDX serializer and Softwing's ASPTear. (Is there a way to do this without using asptear? I would have to have an installer written that would install

...a custom module in VBA which interrogates a database table (in a local database) for local filenames and then FTP's those filenames to a FTP site specified within several hidden controls on an open form. As I am well aware, it is not terribly sophisticated to do this and I have tried to address this myself, but I am not a VBA person. I think it would need a recordset looping an internet transfer control until the end of the recordset was reached. Ideally it will establish an internet connection itself and report success or failure upon completion. Many thanks Maurice ## Deliverables 1) Complete and fully-functional working module in text form as well as complete documentation of all work done. 2) Complete ownership and distribution copyrights to all work purc...

I require an ASP Function (to be used as an include file) that I can pass and SQL statement to that will generate and XML file and email it to the notminated email address. The function should be like: GenerateXML(sSql, sTo, sCC, sBCC, sSubject, sMsg) Where sSql = the SQL used to generate the recordset sTo = the To email address(es) (could be like "address1" or "address1, address2" etc.) sCC = all CC email address(es) (could be like "address1" or "address1, address2" etc.) sBCC = all BCC email address(es) (could be like "address1" or "address1, address2" etc.) sSubject = The subject line sMsg = The message text The XML file should be in the standard XML format for transfer between businesses. The SQL will be run against an ...

I require an ASP function that will perform the following: 1. Receive an SQL query that will be used to generate a recordset. 2. Perform a mail merge from the query and print or email the resulting letters. 3. Save a copy of each letter printed or emailed to the client's directory. 4. Receive variables to be used for the email (From, CC, BCC and MsgText) 5. Receive a variable to over-ride the auto email function. The function will be: **GenerateLetter(strSQL, strTemplate, bolPrint, bolPrinter, strFrom, strCC, strBCC, strSubject, strMsgText)** **strSQL** = Mandatory variable. Contains an SQL statement as a string, that will generate the recordset. The recordset could have either one or multiple records. Each record requires a letter to be produced. One...

I have a site that displays recordset results one after another in a list. I'd like to change it display the results 3 in a row similar to this along with paging. Paging would be 1 page per 4 rows. Thanks. Jen P.S. I'll be extending this at a later on to include category search. If interested in that piece, please let me know. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Windows ASP ## Deadline information Quicker the better!

...single machine and work on their program and a server version where when the software is installed, either the ip address or server name on the network is entered and a path to the server is created so when the client logins in, they are authenticated. Once authenticated, the client will connect with the server database and connect them to their recordset. Right now if I have ten users login to the application, they can only access the 1st recordset. MUST SIGN A NON-DISCLOSURE AGREEMENT BEFORE BEGINNING ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Code is to be saved seperately electronically as well so I can seperate the new code from the old code since the old code is already c...

...geographical location, a building, a city, a company...) Sites are linked together in a table S_S A record in S_S indicates ASId is linked to BSid Links should be entered only once We need two TRANSAC Sql procedures : a) For a given site in the network, and a given distance d, we want to have the list of the sites 'connected' to the site SId and with maximum distance d from SId. This list must be in a recordset format (select Sid from xxx) and not in a string format (SId1, Sid2...). The distance is the number of levelsthat separate two elements in the tree b) A set of constraints/ triggers in the table S_S to prevent entering multiple entries and 'tree illegal entries' Illegal tree entries are those groups of entries that will result in a loop. For example A l...

I have an application written in VB6 that basically is a multiple choice test generator using an Access 2.0 database file. I want the user to be able to select the number of questions to answer and then have the software display the questions in random order. I wrote the same application in VB3 and it works great, but it does not work correctly in VB6. In VB6 the code below randomizes the questions, but it always generates the same ramdom order, instead of truly randomizing the order. What I need is someone to modify the code I have listed below so that it works correctly with VB6, as it did with VB3. Here is the code. Dim TestNum As String TestNum = InputBox("Enter Number Of Questions You Would Like Included From This Chapter.", "Create Random Test From ") If TestNum =...

I'm looking for dynamic animated FLASH bar and pie charts. FLASH MX or FLASH 4 Windows format file and related ASP display files. Would like to pass the FLASH file an array or ADO recordset from a database to produce an animated bar or pie chart that looks like Swiff Charts but does not have all the fancy options. **This link is for look/feel of the charts - the product has very advanced functions that I do not need.** This should be an easy project for someone that has created animated FLASH charts from other projects. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the

"Industrial Paper - Creating an Inventory Management System" > > Objectives: > * Create an inventory management system that interacts with a database > * Locate records using the Recordset object > * Add, change, and delete data using the Data control and recordset > * Create a menu system > * Validate input data ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform windows 98 or above

I need a stored procedure or query that will return the structure of a table in Oracle 8i or 9i. if the table is: fieldA varchar 10 fieldB varchar 20 the query would return a recordset with: fieldname fieldvalue size fieldA varchar 10 fieldB varchar 20 ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Oracle PL/SQL or stored procedure

I need an SQL to generate a recordset. I have three tables from which the data is coming from: Client; Policy; and PolicyAmount See Attached Database. For Each Record in the resulting SQL recordset I want to include: > client.* (all the client fields) > all the records in the policy table (fields FieldName and FieldValue) where the policy ID becomes part of the where clause and the FieldName becomes a column heading in the logical table. > all the records in the PolicyAmount table (fields ItemDescription, cost and where PolicyAmount_ET is NULL) where the Policy ID matches. See the table sqlOutput in the database. This is an example of what I want the SQL query to produce. However, this needs to dynamic as the columns are derived from the records in the two tables Pol...

...an SQL query that will be used to generate a recordset. 2. Perform a mail merge from the query and print the resulting letters to the servers default printer. 3. Save a copy of each letter printed to the client’s directory. **1. Receive an SQL query that will be used to generate a recordset.** The SQL query will be generated and passed to the ASP page via a QueryString. Eg: “?? & (sSQL) & “&TemplateFileName=?? & (TemplateFileName) **2. Perform a mail merge using the letter template file name specified from the query and print the resulting letters to the servers default printer** (this is for an intranet). The mail merge will be using **MS Word XP**. The recordset is to be generated using the SQL passed. The

I require two ASP/VBScript functions for encoding and decoding passwords. I need the functions to work like these two examples. **Example one - In a String:** sSQL = "SELECT * FROM tAdmin WHERE Login='" & sLogin & "' AND Password='" & **Encode(**("Password")**)** & "'" **Example two - From a recordset:** **Decode(**Rs("Password")**)** Code MUST be fully completed by the Deadline. Code MUST be well commented. I do NOT have access to add COM or DLL components to the server. The server is running Server 2000 with IIS5. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will ins...

...provide Access 2000 DB I need a Search form to search Company Address tbl. This tbl also has 2 Memo Fields. "Company Profile" and "Company Products and Services" User will enter criteria into txtBox. Multiple words may be entered by user Select from the following 1 - Search for all words 2 - Search for any words 3 - Search for exact Phrase User will select from cboBox which Field to search Result Recordset will display into ListView. ADO is a Must This is a VB6 Project. I will furnish the Access 2000 Db with tbl to Search. Search will ignore some characters in txtbox such as ' : ; - . Will also ignore carriage returns in field ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all w...

VB Application 95/98/2000/NT Compatible Two similar programs that only differ in functionality. Master Program: Read/Write Microsoft Access database fields which are associated with form fields in application, Display associated wav files and graphic files with each recordset. Two-level password security (require supervisor and user passwords for accessing application and main database). Ability to create multiple users with profile and password change features. Ability to log in a text file every time a user starts and ends application. Help menu (searchable). Client Program: Only read function available to main database with similar features to Main Program. However, able to read/write separate database with user-defined filename. This is for reference to master p...

I'm looking for a well-commented and easy to follow VB6 code to put into a program I'm working on. The code will take data from a recordset which I pull from a couple different databases, and place the data (if available) into editable fields on top of background image. (The image is attached and also at ) The user must be able to then print the page with the fields located in the correct areas. In other words, I have a form that I want users to be able to automatically +/- manually fill in, from data they already have entered into a couple of databases. I can do the pulling of the recordset, but need help getting the rs fields placed in the correct place on the form to allow printing. I am using VB6 and datareports

...calculator that comes with windows from your winform button embedded into the asp.net page. **Do not use a href='file:///.....'** in detail of my final working project: 1)page loads with 5 4-digit integers from a sql query. Programmer could use an array so they do not have to worry about the sql part of it 2)while iterating through the recordset or array each row has an embedded object, passing the current 4-digit integer of the recordset to the object. recordset finishes row and moves to next row until eof. 3) the object is an embedded winform, just a button, titled "call [4-digit integer]" 4)user clicks on button and whatever application is programmed from the winform is launched 5) 4-digit integer passed to the object is passed as an argument ...

I am on a project for a PunchClock software in Visual Basic for local companies and eventually for small companies from anywhere. The work you have to ...punchtimes informations for every employee, but it is using the Data Environment designer. You probably know that it doesn't give a lot of flexibility, so I need to make such a report in code and to be able to change the data source of the recordset called for the data report. This is the only task I need you to do for now, which should be simple for the person with the right knowledge. Thank you ## Deliverables 1) Make the code to create a Data Report without the Data Environment designer, thus allowing to change the Data Source of the recordset called for the Data Report during run-time. ## Platform Wi...

VB6 BEGINNER, Hi, I need help i am new to programming and have just completed my first database with the aid of a book but am having problems connecting ADO to ACCESS 2000 using the connection and recordset object i get an error message ARGUMENT NOT OPTIONAL when i call my dataopen function from my first form below is the code for connectstring() opendata() and my rota program. hope someone can help. cheers Andy. option explicit public goConn as adodb. new connection Public Function DataOpen(oConn As Connection) As Boolean = adUseClient ' Set the connection string by calling ' a function. = ConnectString() ' Set the mode of the connection = adModeReadWrite ' Open the Connection oConn

...learning curve for experienced developers. Complete documentation of the language is available in windows help file format and attached to this RFP. What I'm looking for is something similar to the Phakt model, but not as complex. The features I would like are as follows: * recordsets and DDL stored events * dates for recordset fields * simple data grid behavior (variable repeat region) * show if variables * simple SSI * recordset navigation (similar to the recordset navigation suite available from ) * insert/update record * login/secure page * should provide the option to save file as .shh or .shl * Must be compiled in MXI format for interaction with Dreamweaver MX extension Manager **I will provide Shorthand output code for each server be...

I have a record from which I need to create a hierarchical recordset to export to Excel. The format of the record is as follows: Product, Date1, AddAmount1, DeductAmount1, Date2, AddAmount2, DeductAmount2, Date3, AddAmount3, DeductAmount3... and so on. I want the record displayed in Excel as: Product Date Date2 Date3 AddAmount1 AddAmount2 AddAmount3 DeductAmount1 DeductAmount2 DeductAmount3 I am open to how this might be accomplished, and the Excel portion isn't necessary as long as a recordset is created that I can dump into Excel. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) ...

...that pulls a number of unique patient ID values. This then leaves me with a recordset (rs1) with these ID values. Now I want to pull all the data from another table in a different database, where the patient IDs are equal to the ones I have in rs1. Here is what I've got so far: Dim cnn1 As Dim strQry As String Dim rs1 As strQry = "Select patientID from Schedule where Date = 'date' & "" Set cnn1 = New = g_ADOstrCnn Set rs1 = GetRecordSet(cnn1, strQry) Set cnn1 = Nothing Set rs1 = Nothing The above works fine. But now I've got this recordset (rs1) that contains some variable number of patientIDs. Now I want to pull into a new recordset (rs2) all the addresses, etc. of each of the patientIDs in rs1. How do I do this

I am looking for the code (short, sweet, and well commented) to take a recordset (see example below) and print out a data report. The report will contain some client information at the top (e.g, name, address, etc.) then the rest of the page is blank. The next page will have record #2. The page after that record #3 from the dataset, and so on. The number of pages is variable from 1 to 100 or more. (The record set essentially is a list of folks being pulled from a medical schedule database. All the clients (aka patients) who have appointments will need their address and insurance information placed on the top of a form. Getting the patient info on the page, and then moving to the next patient on the next page is what I need to accomplish here.) I realize that using a detail window ma...

I need somebody to show me how to use the following code to build an array (I believe this is the best way to do this). I am pulling between zero and 50 times from a schedule database with the following code. Once I pull the recordset, I want to display the schedule, but can't figure out how to do it. What do I need to do this? You can put code in the data_report, but that's it. The code below will basically put one row into my data_report, but if there are 50 recordsets, only the last one appears. How do I have controls made on the fly to fit the number of records returned, without having to set up tons of labels at design time? Thanks Jon Private Sub DataReport_Initialize() 'get schedule Dim cnn1 As Dim strQry As String Dim rs As strQry = "Select * from Sched...

I would like a "View/Order/Sort/Layout/Format" of the MSHFlexgrid to be saved to a Access database. Must also include code to save the data in the Grid to the database using a recordset and the SQL insert command. The code should therefor be dynamic as the user should be able to add or delete rows from the grid. Also view the attachment. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. 3) Deliverables include the attached file detail. ## Platform Windows Me and higher Visual Basic 6 and MS Access 2000

...complete source code and explination of all work done. 2) Complete ownership and distribution copyrights to all work purchased. 3) Needs to be able to accept a recordset to use for population of the controls in the sub form. (Does not need to be data bound) 4) Needs to be able to manage all standard VB controls in the subform. (ie. text boxes, check boxes, combo boxes etc..) 5) Must provide me with the ability to create the layout of the subform - like a normal form in VB 4) When running must only create the number of subforms required to fill the screen and must be able to determine the number of subforms needed to fill the screen. The recordset may hold over 100,000 records, so it must only create the 10 or 15 subforms needed. ie.. needs to create and destroy instances o...

Hello. I am trying to develop stored procedure that will do the following: accept sql query, low limit and number of records as input parameters and return ref cursor as OUT parameter. Resulting recordset which will be accesible thru OUT REF CURSOR must contain "number of records" starting from "low limit" extracted from whole recordset returned by "sql query". I am using oracle 8i. Attached is what I am tried to do. But I don't know how to complete this procedures. Please help me if you can. ----------------- ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. ## Platform Oracle...

Payroll function on program does not accurately compute federal taxes. I have payroll, employee tables. On the Frmpayroll2 I need the function to return the correct values. It only returns the correct value for the first recordset, so I believe that I cannot meet the condition. I have tried elseif, if etc...still can't get it to compute accurately. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. . 3) Complete ownership and distribution copyrights to all work purchased. ## Platform VB6 ## Deadline information Need a programmer who understands US federal tax percentage method of witholding for income taxes. This is just one function on a form.

I'm looking for the vb code with which I can grab a recordset then fill a datagrid. I don't want to use any data controls. Also, no modules or complex procedures. The Whole project should be just a few dozen lines. I've included the type of code in the project attached. I know this is pretty easy, I just need to essentially see how to populate a datagrid with a recordset. The project should have a datagrid and a textbox. That is all for the sake of this project (I don't need any bells & whistles since I'm just using the code.) When the user clicks on a grid row, the program needs to pull all data based on the msgID and put it in the textbox. Don't worry, or waste, time with appearance of the GUI, just throw all the text into the txt box as, a...

...implementation has to authenticate against a SQL Server 2000 database (I will provide a COM which talk with the SQL Server) Also the activity of, upload, download, copy and delete will be log (via the above specified COM). The root of the user folder will come via the above COM. Also extra folders have to be added to the root with different security level. These folders will be provided as an ADO recordset. To have a picture of what am I talking about have a look at at the mapping part of the file system. This will make it clear than try to explain it. To speed up the process I do not mind if you propose to use any public code (or portion of it) like Also for first version I’m looking at supporting only class 1 (no locking), with class 2 at a later

...provides. I don't know if I did the right thing here, as I already have a table called StockCategory, and maybe it would be better to reference the supplier from there by maybe adding a SupplierID field in that table instead. Anyway to take the frmConsumables as an example, after having tried to code the drop-down box to show only consumables suppliers, I have learnt that currently with ADO, the Recordset Find method is limited to a single column find criteria. And so I can't try to use two or more columns (via AND statement) in the find criteria, to get the list of consumables only suppliers. I'm sure there must be a way around this?) 2. On the order forms there is a command button called Suspend order. The purpose of this is to hold the unfinished order, say if t...

Act...database(accounts) or in another bank database (Transfer money from bank1 to bank2). The purpose is to show the interoperability of XML. The 2nd bank stores the accounts in a database with the same attributes with the first bank. your bills by withdrawing money from your account. history. Display all the transactions a user has completed. ASP will be used to retreive the recordset from the database and send the xml document to the client whenever requested. I'm using the IIS web server. The deadline is for 14 september. Hope it helps. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code, with comments of all work done. Complete copyrights to all work purchased. ## Platform Windows 2000

I'm looking to build a recordset in VB6 that will pull all data for PatientID = 260 from 3 different tables, then sort the data by Date. I want to then be able to show the data sorted by date, as well as print the entire list of data (probably using VB6's datareport). I've included an example database with the three tables, SOAP, Notes, and Patient Messages. Each of these tables have the PatientID field. The Date field, however, is named differently in these tables. It is "EncounterDate" in the SOAP table, and "DATE" in the other tables. I tend to pick bids that show me a working demo (doesnt have to be pretty, though). Perhaps you could use a TREEVIEW to show the relation of these items based on date, and when clicking on the tree view it would pu...

...number of records and fields from Windows 2000 Server and populate a Microsoft data grid. Must have by or before Tuesday August 27th else it is useless to me. This should be pretty easy and quick as I can do this myself, however I have other commitments to tend to. I don't need a full blown app; just the sub routine. I am open to ideas but I imagine this project either using ADO 2.0 to copy a recordset to the client computer or maybe download the tab delimited text file to the client and then populate the datagrid. I want to know what method you choose first before you program it. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform W...

...simply need to be modified. This has already been done for one page... so you will probably simply have to follow the same format as I origionally used. Also an edit (update) option needs to be added, so users can change their information. ASPupload and ASPImage are already loaded on the server. 2) Add a "super search" page that will search (query) several tables (probably through a union query recordset)for the search word and return a formated list of links, descriptions, images. I have personally done all the modifications to date on this web site (so excuse the newbie hacking!!) but simply do not have the time (experience) to finish quickly. I expect that this whole project will only take an experience coder a few hours. This is the first (and smallest) of several e...

...on the two records. 5 of the 1st part, and 3 of the 2nd part. this will always be a dynamic value. for the end user is only going to enter in the SO #, and nothing else. we will rely solely on the data in the database to populate either a recordset of other means, that creates one label per part per part quantity. i don't have a problem opening the db, either directly or using a SQL statement to get the record selection. My problem lies in the ability to LOOP the individual record based on the Pqty to ship. i've tried to do this even with an ADO Recordset. the number of records that pulls in will always be based on a given Sales Order and how many lines are being released. i have no problem getting these records. i specifically want to use the RDC such that the c...

A program written in ASP/vbscript that saves certain key fields of an existing recordset in a file and when the file with those key fields is loaded, a new recordset will be created with all coulmns of rows including those key values in a database. Please see the diagram attached ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform ASP, WIN, VB 6.0

Charting component with atleast bar- & piecharting. The component should generate the chart as a gif image. The component should read the data from a ADO recordset. There should also be ability to add headers to charted items and functionality that gives coordinates of each bar (those will be used to create hotspot-hyperlinks). ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete/exclusive copyrights to all work purchased. ## Platform VB 6.0, component object model (COM) component

...question.... ===== Private Sub Command4_Click() Dim a As Integer If (OKtoadd = True) Then With Data1.Recordset .AddNew !ProductNum = IIf(Text1 = "", "N/A", Text1) !OrderQuantity = IIf(Text2 = "", "N/A", Text2) !Price = IIf(Text3 = "", "N/A", Text3) !ProductDescription = IIf(Text4 = "", "N/A", Text4) .Update End With OKtoadd = False = False = True = True a = MsgBox("Record has been added sucessfully!", vbInformation + vbOKOnly, ) ElseIf (OKtochange = True) Then Data1.Recordset!ProductNum = IIf(Text1 = "", "N/A", Text1) Data1.Recordset!OrderQuantity = IIf(Text2 = "", "N/A", Text2) Data1.Recordset!Price = IIf(Text3 = "", ...

I have an Access 2000/XP database. Every morning I generate a query based upon certain date criteria. I want to automatically open all urls that have previously been input into a table via a form that have been inputed on a certain date. The recordset I already have. I just need the automatic url opening coded. Example, I get in the office in the am, open the database and if it is the 20th of the month, I want all urls input into the form on the 18th to open/pop up. Thanks, RJ ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform Access 2000/xp on a Windows 98/2000

We have a lot of quotedata in database. Programmer must make some statistic analysis and draw a graphic. like here: make quite the same "Chart-Einst... ------------------------------------------- here is a list of indicators and how to calculate them: if just don´t understand german take this link for translation: ------------------------------------------------ Here is a recordset of quotedata from a stock: every line you see the data of a day. Recordset like that are in database (there are more but we just need high, low, open, close.)

...the name in the drop down box. Then I would want to use the drop down combo box and go to the next employee have that employee show up in the grddatagrid and get the amounts by range of dates for that employee. The amounts net and gross would appear on the datagrid1 and datagrid2. I do not want to use bound controls. Code only on this. Well, some of its working such as the first adoprimaryrs recordset will retrive this information, but I cannot get it to do this for any of the other recordsets. Two other minor fixes not part of the zip uploaded with this bid. They are simple and would not require much time, perhaps only suggestions on what to do would be acceptable for the other two fixes. ## Deliverables Complete and fully-functional working program(s) in executable form as w...

I had a connection to a sql, but it started presenting an error that says that a with variable or object is not established. i don't know if its of a reference or something i did the code is this. Public Function AbreCnx() As Boolean Dim NumErr As Double Dim strMsg As String Dim bolFinaliza As Boolean Dim rsT As Recordset AbreCnx = False If bolModo_Local Then Exit Function On Error Resume Next bolFinaliza = False bolDbNada = False AbreCnx = False Do Set CnxSql = New = "ODBC;DRIVER=SLQ SERVER;SERVER=" & strServidor & ";DABASE=;UID=GenesisCliente;PWD=userid;WSID=DESARROLLO 2;DSN=SQL2000" If = 0 Then NumErr = (0).NativeError If NumErr = 0 Then NumErr = If NumErr <> 0 Then bolFinaliza = True bolDbNada

I really need this application: A bookstore project which grabs 3 items out of one table from a database,allows user to select and scroll thru recordset and add to "cart", displays on a sepreate form(cart) and proceeds to a orderform which just uses password verification to populate the address email etc. Take a look at the code.. I am doing 2 classes at same time and Java is kicin my *(* I really need it in short time as well.. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Would like comments if possible on how it works ## Platform windows 2000, visual cafe version3 ## Deadline information I need by 7pm est tonight

...and execute a command to create a recordset of the records that are in the table tblCustomers. Create text boxes to display the fields. Write code to move between the records of the recordset (MoveFirst, MoveLast, MoveNext, MovePrevious). Write code to find and display a record according to Customer Id. Also, the user should be able to edit, delete, and add a record to the database. Also do these things. First one is a question. Second and Third is asking for code. Ok on the form frmExam there are 10 text boxes that are not part of a control array. You want to prevent the user from entering any characters except from numbers and the backspace character in all the text boxes. What is the best solution to the above problem? Write the statements to open a recordset nam...

I need sample code using VB and SQL Server 7 DTS to import a large text file to SQL Server 7. I have written source code to load the text file using an ADO recordset; however; performance is poor. I've been able to load the data much faster using bulk copy. However, I need to automate this process and the tool of choice is Visual Basic 6.0. I'm open to all sugestions. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform Windows NT 4.0

...ASP/HTML page developed in MacroMedia UltraDev with a recordset and a repeat region with two additional fields - one for quantity and one for select or not. When selecting products and quantities then on top of the page I need a total (total price and quantity) and on the selected product line total price to update automatically and instantly (if 2 selected in qty. then the line total equals product price times qty.). Could be VBScript or Java. When the user is finished ordering then the submit button will create order with specification in the database (order table). The order has to be connected / related to the customer table. The user is then taken to a new page from where he can print out the order with the selected products. The recordset contains product description...

I need a ASP page with a recordset and a repeat region with two additional fields - one for quantity and one for select or not. The recordset contains product and price (from product database). Also available - customer no. (from cust. database) When selecting a product and quantity I need a total on top of the page (price and quantity) to update. When the user is finished ordering then the submit button will create the order in the database (order database). Then I should be able to do the rest my self. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform W2k, Ultra Developer, NT hosting, ODBC / DSN