Recordset trabalhos

Utilise MS Access in order to create an ABA (Australian Bankers Association) file export. Recordset pre-exists in current MS Access database. Development needs to achieve ability to output recordset to an ABA file format. Destination folder can be either hard coded or via Windows Common Dialog box. VBA source code will be required. Successful ABA file verification will be required to validate project completion. File format information: Basic - Detailed -

This is a legacy vb 6 project that I am updating a bit. I have to check CCountryRegion and Country/Region in the...the database, it will not allow it even though the fields are text and not PK. What I need is when the user clicks the save button that it will go through the fields in the table Customers and let the user know via a msgbox that the record exists. I am using a random number generator but it could possibly allow duplicates. It would then exit sub at that point and cancel the update of the recordset. It needs not to be a slow loop or bof eof..has to be fast in case the database grows large. So basically I have two text boxes. txtCountry and txtBCountry the txtBCountry is for the CCountryRegion field and obviously the other is for the Country/Region field in Custom...

I need a quick php html with JQuery Ajax script created that will do the following: 1) take 2 dates f...array with the dates we created to the php script that will return the text either a)"YES IT WORKED", b)"NO IT DID NOT WORK", or give an error because the php file is unreachable. 4) The Ajax Script will then display the return value in on screnn, then loop through the array and post the next date to the php file and wait for the result. 5) When the Ajax Script is done going through the recordset it will display "JOB COMPLETE" and quit. Should be super easy for someone that understands JQUERY, AJAX, So it should not cost much to do. I need this done asap, I would learn to do it myself but I just do not have the time. Be ready to work on thi...

...must be optimized for fast display and concentrate display on subjects face only using some sort of face detection script. The photo gallery page can be called directly or called from other pages through a script which triggers a predefined sql query clause. For example, if a button called "My Favorites" is clicked from the home page, it will call the Photo Gallery page but showing only the recordset that applies. Under each thumbnail there must appear the following: Name, Profile Id, Age and Occupation. Each thumbnail must have a rollover layer that will display: trigger icons: Add to favorites, Send Wink , Block Profile links : full size picture, Go to Profile Detail page popup: send Quick Email popup form. The gallery page must include a “sorty by&rdq...

I have a page on my website that runs a SQL query and displays data (see attached screenshot) but I only want to write to the browser a certain number of records (50,100, etc) at a time. Basically, I want to page through the recordset on the SQL Server and only return to the browser the number of records in the page size.

I want a piece of code in T-SQL that must be able to run indside a NATIVELY COMPILED STORED PROCEDURE - Accepting the limitations that may bring. Input will be a recordset, and output will be a recordset with an Id (int- identity, int - Frequency band, and a float (frequency intensity). The signal will be 1-2000Hz. I wish to have implemented the algorithm described in: Page 507

I have a page that dynamically displays time based on actual time and date. It is only 1 PHP page but depends on 3 tables to work. Lines 42-65 are the problem. I want it to read the data from the tables instead of the way I have manually coded it. The 3 tables are: *bell_schedule-A table that has the start and stop time by period in a day. It lists every possible schedule. *bell_schedule_weekly-A table that manages what day of the week (Mon=1, Tue=2, etc) the bell_schedule should follow. *bell_schedule_dates-Exceptions to the bell_schedule_weekly. On the exception date a new schedule needs to be followed. I use the day number the date follows to determine if it should follow the exception's schedule. The task I am hiring you for is to clean up my if, elseif statement so tha...

Need to read an asp xml response and write it to windows variables via JavaScript for all records in a set Sample output <recordset> <record> <Primary_ID>1</Primary_ID> <Open_Balance>430.62</Open_Balance> <Cash_Balance>608.67</Cash_Balance> <Bonus_Balance>1227113</Bonus_Balance> <Message>Paid</Message> <ExpDate>09/06/2016</ExpDate> <Saved>-109852</Saved> </record> </recordset>

...that shows the hierarchical organisation of the graphical regions. I want to be able to completely understand the data structure of the regions on the site. There are one or two levels of categories. 3) Dataset for all records in one section of the property site, which has 80k records. The script that you write in 1) should be the script that does this work. You will need to deliver the initial recordset, and I need to be able to run the script so I can validate the output and run the script again myself. Because you will need to deliver 80k records, you will need to solve any problems to do with rate limiting yourself to delivery the 80k records. You will need to understand the T&C of the site yourself to ensure that you do not break them with any activity. 4) 4 weeks of ...

...thats it. pretty simple. here is a snippet of the code... Sub DownloadQuery() On Error Resume Next Dim cn As , rs As , r As Long Dim db As Database ' connect to the Access database Set cn = New "Provider=Microsoft.ACE.OLEDB.12.0; " & _ "Data Source=C:UserstmontGoogle DriveKokuaDTForecastProd ;" ' open a recordset Set rs = New With Sheets("config") configrow = 1 Do While .Cells(configrow, 1) <> "" If .Cells(configrow, 2) = "Y" Then qryname = .Cells(configrow, 1) With Sheets(qryname) qryname, cn, adOpenKeyset, adLockOptimistic, adCmdTable If = 1 Then If > 0 Then For i = 1 To .Cells(1, i).Value = (i

The list of companies is attached 2379 companies is attached. All of the collected details must be relevant to the country shown on the list. Fields required are: - Phone number - Address (broken appropriately into address 1, address 2, city, country, postcode if applicable) - website If you are interested in this project please provide 2 examples from the recordset.

The list of companies is attached 2379 companies is attached. All of the collected details must be relevant to the country shown on the list. Fields required are: - Phone number - Address (broken appropriately into address 1, address 2, city, country, postcode if applicable) - website If you are interested in this project please provide 2 examples from the recordset.

A small transport company took me a software to optimize loads of container. I need an ActiveX that performs optimization. The component has to optimize space. Everything else I got it. The ActiveX must provide these features: A property object rstContainers (type ADODB recordset) A property object rstBoxes (type ADODB recordset) A function Optimize that optimizes the process. See the attachment for all information.

I want to export data from access to excel through vba. vba based on SQl, array, recordset, array, looping.

I want to export data from access to excel through vba. vba based on SQl, array, recordset, array, looping.

...and estimatelineitem record sets generated from our stored procedure. This stored procedure now includes these addtional record sets. 2) Add ability to update items, customers and Estimates (when QBO id & SyncToken are included in record sets). 3) Add query capability to retrieve a list of customers, Items Accounts & Estimates a) SELECT statements are passed to SP in a Query recordset b) Each query is sent to QBO c) Each JSON Query Response is parsed and sent to the appropriate ListQuery Stored Procedure as a table valued parameter(s). This could be a single stored procedure that handles different types of queries (if that is possible) or it might need to be a different stored procedure for each record set type (one fo...

...of customers. It is built upon the QuickBooks Online SDK. This project requires the following modifications to this application: Add a button that will: Connect to connect to SQL server Call Stored Procedure (Supplied by us) Retrieve 3 recordsets for three QuickBooks Online entity types: Customer, Item and Account Each row in each recordset representing one QuickBooks Online entity. Create JSON add request for each record in each recordset Send add requests to the QuickBooks Online server Retrieve response from QuickBooks Online Insert response into SQL Database. Display a status on the web page indicating the result of the operation. This project will result in an application that will be used for testing purposes. This is phase 1 of a multi...

i have created an online shopping cart from a template and modified it depending on my project needs , i have some option that i have no time to do , since the project is due tomorrow and i have to write a report . the first one i want every table in my project to display 10 rows each page (recordset paging ). the second thing : i need to complete the checkout process , since it was a template i modified it but i keep getting errors , i want the user when checking out to go through the shippment and info page where it displays the username and address provided in the database , if the user did not provide an address .. he will be asked to provide it when checking out , then on the next page he confirms the order and address , when he presses the confirm button , the order d...

Hi, I am wanting to build an asp.net web application which will call data from a database and which will be updated via a web interface. Similar to outlook, I want a drag and drop function to be able to move records to folders, basically the movement will cause a sql command to trigger to update the records.

Create a C# ASP.NET WCF service to host 8 Crystal Reports and display a PDF of the report data in a web browser. The Crystal Reports are all current reports that are in use now in a Client Server application. These are ttx defined reports that are being populated with an ADO recordset. This is what I need: 1) Use existing ttx defined reports for project. I will provide both the reports and ttx files. 2) Populate and fill reports with DataTables 3) Each report may contain parameters and formula fields to set features in the report. The reports will be populated from the calling program. No database connections will be used by the Crystal Reports in the WCF 4) Ability to call individual reports in the WCF Service, and send the DataTable, parameters and formulas to disp...

I have written a plugin that contains a cron job. The cron job now needs to make an http request to fetch a table of data once a day. The resulting table of data needs to update a mysql database containing the old data. The php code is already written below and I have written php code to iterate through the recordset, I just need someone with the time to patch it all together and test it. Small job but too time consuming for me ;-) need a pro who would find it a breeze...

I have data that represents volume of 6 categories per day. On the attached excel book, on the crosstab tab, there is an example of the stacked bar chart I need to display dynamical...categories per day. On the attached excel book, on the crosstab tab, there is an example of the stacked bar chart I need to display dynamically in Classic ASP. The "crosstab" data was generated through MS Access for display purposes only. We have a stored procedure that generates the data you see on the rawdata tab - we need to convert that into the barchart dynamically. Summary - convert a recordset of 186 rows of data into a stacked barchart showing 6 categories per day using Classic ASP. Due to our application security setup, we cannot use ASP.NET. I am open to using JavaScript ...

I have a list of items that need printing to a dymo label printer. These are created via a loop in a recordset and I have separated each one with <div style="page-break-before:always" ></div> but this does not appear to work with the dymo. I am looking for someone to right me a piece of code to send these individually to the dymo - each item includes the image and the BXX - I may need to add additional fields as well at a later date... Here is an example from DYMO that I assume can be used as a starting point.

I have a list of items that need printing to a dymo label printer. These are created via a loop in a recordset and I have separated each one with <div style="page-break-before:always" ></div> but this does not appear to work with the dymo. I am looking for someone to right me a piece of code to send these individually to the dymo - each item includes the image and the BXX - I may need to add additional fields as well at a later date...

...paramIn is null ---- var myvar = db.get_sql_value(myselect_statement) - returns a string value from the datatbase e.g. "SELECT COUNT(*) as productsInDb FROM products" ---- var myvar = db.get_sql_value_int(myselect_statement) - which gives result as integer ============================================================= details we need a function which fills an recordset object from sqlite database: ("SELECT * FROM products", crsProducts) then the crsProducts is filled with the products data e.g. 20 rows with 5 columns we need the following methods: 1) which is true when rows were found 2) - moves to the next row and returns true if there was a next row and false if there are no more rows 3) crsProducts

...from VBA) * stored procedures with the following prototype specifications: i. accepts the following simple data types (int, bool, string, double, double[]) ii. separate procedure with the following return types a. returns int b. returns bool c. returns string d. returns double e. returns double[] f. returns Table (i.e. Recordset) 3. Create 2 MS Access forms (Loan appl, collat reg) that are equivalent to provided MS Word documents i. One of the forms will require to be implemented via wizard (because of multiple fields) ii. Demonstrate loading picture to form (picture to be stored on path, NOT in database) iii. CRUD and search functionality for objects created from forms 4. Create 3 ...

...from VBA) * stored procedures with the following prototype specifications: i. accepts the following simple data types (int, bool, string, double, double[]) ii. separate procedure with the following return types a. returns int b. returns bool c. returns string d. returns double e. returns double[] f. returns Table (i.e. Recordset) 3. Create 2 MS Access forms that are equivalent to provided MS Word documents i. One of the forms will require to be implemented via wizard (because of multiple fields) ii. Demonstrate loading picture to form (picture to be stored on file path, NOT in database) iii. CRUD and search functionality for objects created from forms 4. Create 3 Access reports (dis...

For the development of a website we are looking for ongoing support from a compan... 4 & 5) Re the last 2 forms, 4&5, we will replace this example form by 2 with similar appearance, one for selecting hotels and one for selecting services, but the principal of selecting a checkbox which automatically updates the database will be the same. Note that these 2 forms are generated by a repeat recordset, not manually, so ajax needs to work for each line although set once. Before starting, we would like the selected freelancer to indicate which jquery ajax script will be used, if possible with example, so we can agree. This is important as the same script will feature in many pages from now on.

I have a car classified ad site that I recently added model listings to the car detail pages. My problem is if the car model is more than one word the model listings are not showing. You can see an example of a working page here: All of the 'Chevrolet' models show on the left Here is an example of a non- working page: The 'Chevrolet' listing are not showing on the left. Again, this is only a problem if the model name is more than one word. The site has rewrites using ISAPI rewrite and I suspect the rewrite may be causing the problem, so you may need to be familiar with ISAPI rewrite

I have a car classified ad site that I recently added model listings to the car detail pages. My problem is if the car model is more than one word the model listings are not showing. You can see an example of a working page here: All of the 'Chevrolet' models show on the left Here is an example of a non- working page: The 'Chevrolet' listing are not showing on the left. Again, this is only a problem if the model name is more than one word. The site has rewrites using ISAPI rewrite and I suspect the rewrite may be causing the problem, so you may need to be familiar with ISAPI rewrite

I would like you to b...send the filled in Excel file back to the browser. The source code should be simple to modify afterwards, e.g to add more data or change/add formattings. The data is a hierarchical set of rows and columns. You don't need to calculate anything, just iterate rows and columns and set values to cells. You may use your prefered server compatible components for Excel operations (ExcelLibrary, OpenXml, Recordset,..?) and json parsing () but please inform what you will be using and what licencing the components use so that we can make sure that they fit in the architecture. I will send you multiple actual json files and an excel template file so you can test with real data. Attached is a sample result after combining data to an empty template.

I would like you to b...send the filled in Excel file back to the browser. The source code should be simple to modify afterwards, e.g to add more data or change/add formattings. The data is a hierarchical set of rows and columns. You don't need to calculate anything, just iterate rows and columns and set values to cells. You may use your prefered server compatible components for Excel operations (ExcelLibrary, OpenXml, Recordset,..?) and json parsing () but please inform what you will be using and what licencing the components use so that we can make sure that they fit in the architecture. I will send you multiple actual json files and an excel template file so you can test with real data. Attached is a sample result after combining data to an empty template.

I have a update record set form in php mysql, it works fine and uploads 5 files into a table I need to fix the form so if any of the file upload buttons are blank, it does not update the record with a blank record. page attached that needs to be updated

I have a working website form with 6 file upload fields A insert recordset and a edit recordset for 1 table in a database I need to make the file upload work correctly in the insert record form and the update record form. One field is an image, the other 5 are documents ( pdf word etc ) rename file if the file already exists on add/update and resize image to 454px wide Attached are the 2 forms for your reference, please quote upload form so I know you have read the brief or your bid will be ignored I am after a fast turnaround, this should be a quick job

...business account holder. Account holder can decide to have it bill under 1 account, or each members’ spending is separate. I need an option for this in the system. When it comes to billing the member for drinks, I wish to insert a few lines of code for SMS reporting. Please leave a // comment line where I’ll insert code. I suppose that when the card is swiped, the database should have pulled a recordset of the member’s information, and one of the fields will hold their mobile number. * Cards can get lost – a function to reprogram a member’s new card should be present, after reprinting it. 2) (Asp.net,aspx, codeBehind in C#) Web interface – This is a simple interface that allows a member to log in, and check their information. It could eve...

...file This file can be placed inside addon folder. I will put some html content inside it. 2. {addon_gmaps_searchresults} Tag will be used on searchresults page. It will display google map with markers that show location of properties in current page searchresults recordset, based on latitude and longitude data for those listings. 3. {addon_gmaps_searchresults_draw} - Tag will be used on searchresults page. It will display google map with markers that show location of properties in searchresults recordset (full set of records for that search, not just results for first results page), based on latitude and longitude data for those listings. Maximum number of searchresults to show on {addon_gmaps_searchresults_draw} map setting will be applied here. So if in admi...

...can contain 1 or more view templates) in XML + HTML5 + groovy, save view templates for future use Tech reqs: Programming language: grails 2.3.x / groovy, JavaScript, HTML5, jQuery + jQuery UI Design should be completely encapsulated in CSS files. UI basics: 1. start screen, where I can access to: connections repo, recordset templates repo, reports repo 2. in connection repo I add/edit/delete connections 3. in recordset templates repo I add/edit/delete recordset templates and view results in basic table view 4. in reports repo I add/edit/delete reports and run reports to get data 5. in report add/edit screen I should be able to add/edit view templates for report This tiny project can grow to middle or maybe very big project in future, so I'm als...

...can contain 1 or more view templates) in XML + HTML5 + groovy, save view templates for future use Tech reqs: Programming language: grails 2.3.x / groovy, JavaScript, HTML5, jQuery + jQuery UI Design should be completely encapsulated in CSS files. UI basics: 1. start screen, where I can access to: connections repo, recordset templates repo, reports repo 2. in connection repo I add/edit/delete connections 3. in recordset templates repo I add/edit/delete recordset templates and view results in basic table view 4. in reports repo I add/edit/delete reports and run reports to get data 5. in report add/edit screen I should be able to add/edit view templates for report This tiny project can grow to middle or maybe very big project in future, so I'm als...

...functionality. I should be able to: 1. add connection to jdbc datasources, test and save them for future use 2. write SQL or groovy code templates to retrieve recordsets from connections from p.1, save code templates for future use 3. Add input params to code templates from p.2 so user can choose them in runtime: date, checkbox, listbox, multiline listbox/combobox 4. Combine templates so output recordset from one template can be used as input for another template and so on 5. View results (recordsets) in default. table view 6. Export table view to excel and PDF 7. Be able to code custom view templates in HTML + groovy code templates, save templates for future use Tech reqs: Programming language: grails / groovy, JavaScript, Html5, jquery This tiny project can grow...

I have an internal query which needs to be created to filter out records from a complex set of data, shouldn't take too long for an expert. All the source tables are relationally linked, I just need a SQL statement created which will (very quickly) pull out a recordset for downstream use.

Project consists to create an application in Android and IOS to integrate with a existent site, including layout, like an Address Book. - APP should be developed in PhoneGap, and compatible with IOS and Android. - Database should be PhoneGap native. - Recordset from site will be JSON Webservice pattern. - All communication must be HTTPS. If connection with the server is not active, the address book must be showed with the latest data recorded. Documentation Attached.

I am looking for a solution within the hour; please do not bid if you cannot provide that. Thank you. In classic ASP, I pull a recordset and build a string array that I want to pass to a Google Charts graph. Header/field name row and the dates on each line need single quotes, and I need brackets around each row. When I pass to JavaScript, I lose the square brackets and single quotes. The string I create in ASP: [['SNAP','A','B','C','D','E','F'],['2013-09-17',19,4,14,10,5,19],['2013-09-18',19,8,12,10,5,19],['2013-09-19',19,5,11,10,6,19],['2013-09-20',19,4,14,9,5,20],['2013-09-21',20,3,15,12,6,21],['2013-09-22',20,3,15,12,6,21]] The result of...

I have data that represents volume of 6 categories per day. On the attached excel book, on the crosstab tab, there is an example of the stacked bar chart I need to display dynamical...categories per day. On the attached excel book, on the crosstab tab, there is an example of the stacked bar chart I need to display dynamically in Classic ASP. The "crosstab" data was generated through MS Access for display purposes only. We have a stored procedure that generates the data you see on the rawdata tab - we need to convert that into the barchart dynamically. Summary - convert a recordset of 186 rows of data into a stacked barchart showing 6 categories per day using Classic ASP. Due to our application security setup, we cannot use ASP.NET. I am open to using JavaScript ...

...requires a REAL programmer. I need an interactive web browser control to be created. This control must be able to be inserted into an Access 2013 form but it will also be used later in some .net desktop work I am planning. The goal is as follows: 1) I have a database of links or keywords. When opening the browser I need to highlight links / words on the page which I have supplied in the recordset. 2) I need an "on hover" event which highlights the tag which is currently being displayed 3) I need to be able to right click on a highlighted tag and a popup menu needs to appear which uses the highlighted text as reference in order to get a better understanding of what I am looking for I recommend you download the demo version of visual web ripper at or view

I have an existing SP that passes a recordset back to my app. The app then processes the recordset by looping through it and calcluating totals. I want to take the app processing and move it to the SP and just return back the total. Attached is the SP and the app code. Need this done today

...within the route of the website. For better search engine optimisation I would like the URL to indicate the following: I am aware that in the rewrite rule you can set the pattern to include the product category, the sub-category and then extract the product name which is stored in the permalink field of the database, and using a recordset to extract this and display it in the URL. Kindly provide a quotation to do three main categories each with three subcategories and each with three products. So a total of 27 products. I will provide FTP details to the server and MySQL database. The quotation must include a tutorial with step-by-step process and comments. And lastly the quotation must also include an hour to chat over

...be sortable by name, date and price. (all mySQL table fields). I also want the user to be able to select how many records are displayed on the master page - ie: we have 1000 products. Want user to be able to show 20, 40, 100, 500 or all records on the page. I require recordset paging, so user can move through these pages. Detail page - when user clicks on item on master page, i want the item to show on the detail page. But i also want the user to be able to click a next/previous button, to move through the detail page recordset. I will be using ecart 5 on this page to add the item to a shopping cart. I want a 'back to master page' button, to take user back to the master page, to the page that current product is displayed on. I am using an extension for pagi...

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

...procedures that we can integrate in to an existing application in order to display a map. Procedures include: subMWCreateLayer(EventID, LayerType[cctv, guard, incidents,stafflocations],sourcedata) Create a shape file named eventID_LayerType if one doesn’t already exist. If one exists, delete it and re-create it. The shape file created should contain a marker for each entry on the sourcedata recordset. The sourcedata will be a normalised query returning : longitude, latitude, elevation, reference, title, note, glyph. subMWLoadMap(EventID, graphiclocation, topx, topy,botx,boty) Check if a map has been created for the event, and if so load the map in to a mapWINGIS window placed on a form. Once the map is loaded, Load and overlay the graphic from the graphic location...

Creation of a PHP script to reside on my website that will accept a query request for a MYSQL server and return a standard recordset of the request. Will require creation of query based on values provided by the requestor, accessing the database and running the query and then providing the returned recordset to the requestor. The php code should have some basic checking to make sure no harmful code has been imbedded in the query. A vb6 routine should be written that actually requests data from the script and then receives the recordset. I will provide a small program as a starting spot with some sample working values....